RE: [PHP-DOC] record insetion
| From: | Enrique GB | 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