PHP any Mysql connection- new b
| From: | babu | Date: | Sat, 08 Jan 2005 16:10:47 +0000 |
| Subject: | PHP any Mysql connection- new b | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-205870@lists.php.net to get a copy of this message | ||
Hi all,
I am using php 3.0 and mysql and win xp.
i want to add users to database through php page.
adduser.php
<html>
<FORM METHOD="post" ACTION="add.php">
Real Name: <INPUT TYPE=text MAXLENGTH=70 NAME="real_name" SIZE=20><Br>
Username: <INPUT TYPE=text MAXLENGTH=70 NAME="username" SIZE=20><Br>
Password: <Input Type=text Maxlength=70 Name="userpass" Size=10><Br>
<INPUT TYPE=submit VALUE="Add"> <INPUT type=reset VALUE="Reset
Form"></form>
</tr></td></table></tr></td></table>
</body>
</html>
when i enter the fileds and submit ,the action is not performed, instead add.php file is opened.
add.php
<?
$ID = uniqid("userID");
$db = mysql_connect("localhost","root","halfdinner");
mysql_select_db (userpass);
$result = mysql_query ("INSERT INTO users (id, real_name, username, password )
VALUES ('$ID', '$real_name', '$username', '$userpass')
");
if(!$result)
{
echo "<b>User not added:</b> ", mysql_error();
exit;
}
if($result)
{
mysql_close($db);
print "User <b>$username</b> added sucessfully!";
}
else
{
print ("Wrong Password");
}
?>
is the problem due to mysql and php connection.i am using windows xp with apache2.
i followed the steps said by someone in the previous thread.that is adding libmysql.dll to system32
and so on. I cannot find php_mysql.dll in php.ini.
can some one help
Thanks
babu
---------------------------------
ALL-NEW Yahoo! Messenger - all new features - even more fun!