RE: [PHP-DOC] record insetion

Mon, 14 Jun 2004 07:39:36 -0700

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 [EMAIL PROTECTED]

 

Regards

 

Enrique GB

De: Sriranganath [mailto:[EMAIL PROTECTED]
Enviado el: Lunes, 14 de Junio de 2004 03:38 a.m.
Para: [EMAIL PROTECTED]
Asunto: [PHP-DOC] record insetion

 

I am not reaching this email id :: [EMAIL PROTECTED] 

 

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="" ?>">
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: '[EMAIL PROTECTED]' (Using password: YES) in /var/www/html/whatnew/a.php on line 3

 

Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]' (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

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

 

 

Reply via email to