RE: [PHP-DOC] record insetion

From: Date: Mon, 14 Jun 2004 14:38:42 +0000
Subject: RE: [PHP-DOC] record insetion
References: 1  Groups: php.doc 
Request: Send a blank email to phpdoc+get-969361375@lists.php.net to get a copy of this message
Once more, this is not the correct place to answer generel questions, for php mysql staff you can have a look at any of the result in a google search, surely it will be faster than asking here. And you problem looks that is MySQL permissions matter. If you just give permissions to the user may be you should do a "flush privileges" in the MySQL client (with a enough powerfull user) and then try again. And the general list is php-general@lists.php.net Regards Enrique GB _____ De: Sriranganath [mailto:sriranganath@ktkbank.com] Enviado el: Lunes, 14 de Junio de 2004 03:38 a.m. Para: phpdoc@lists.php.net Asunto: [PHP-DOC] record insetion I am not reaching this email id :: php-general@php.net plz forward this to concenred. Dear Sir, I am finding difficulty in inserting a record into a MySQL DB through PHP inpsite of all the privileges given to that database . Can u plz clarify it? Plz let me know what are all the processes that i have to start or include ..;;; in my files: Plz go through my code: and associated erors messages : <?php if (isset($_POST['submit'])) { $conn = mysql_connect("localhost:3308","user","password"); mysql_select_db("database"); $query = "insert into branch (sol_id,sol_desc,ip_address,email_id) values ('".$_POST['solid']."', '".$_POST['brname']."', '".$_POST['ipadd']."', '".$_POST['email']."')"; if (mysql_query($query)) echo 'Success'; else echo 'Failed'; } else { ?> <center> <form method="post" action="<?=$_SERVER['PHP_SELF'] ?>"> Sol-ID <input type="text" name="solid"><br> Branch Name <input type="text" name="brname"><br> IP-Address <input type="text" name="ipadd"><br> E-Mail <input type="text" name="email"><br> <input type="submit" name="submit" value="submit"> </form></center> <? } ?> after submitting the inputs; it is giving the following errors: username is the finfaq and database name is also finfaq Warning: Access denied for user: 'finfaq@localhost' (Using password: YES) in /var/www/html/whatnew/a.php on line 3 Warning: MySQL Connection Failed: Access denied for user: 'finfaq@localhost' (Using password: YES) in /var/www/html/whatnew/a.php on line 3 Failed When i try to insert directly into the table, it is allowing:. regards Sriranganath ----- Original Message ----- From: Sriranganath <mailto:sriranganath@ktkbank.com> To: phpdoc@lists.php.net Sent: Saturday, June 12, 2004 1:11 PM Subject: Record Insertion thr PHP Dear Sir, I am finding difficulty in inserting a record into a MySQL DB through PHP inpsite of all the privileges given to that database . Can u plz clarify it? Regards Sriranganath

« previous php.doc (#969361375) next »