record insetion
| From: | Sriranganath | Date: | Mon, 14 Jun 2004 08:37:32 +0000 |
| Subject: | record insetion | ||
| Groups: | php.doc | ||
| Request: | Send a blank email to phpdoc+get-969361363@lists.php.net to get a copy of this message | ||
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
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