Need Help on Win2k with PHP and Mysql

nirmails

I am trying to use PHP to connect to Mysql under win2k
$db = mysql_connect("$localhost","$test","$password");

mysql_select_db("$test",$db);

and this is the error that I get..
please help..

Warning: Undefined variable: localhost in C:\mysql\data\test\test.php on line 23

Warning: Undefined variable: test in C:\mysql\data\test\test.php on line 23

Warning: Undefined variable: password in C:\mysql\data\test\test.php on line 23

Warning: Undefined variable: test in C:\mysql\data\test\test.php on line 25

webphp

Are you defining $localhost, $test, or $password anywhere? When you use the $, you are referencing a variable, so you would have need to define those before use.
Hope this helps,
Rick

nirmails

Hi Rick.. Thanks a lot, I figured it.. but now I have another problem.. How do I take an input and insert it into the database..

right now I am using this

$sql = "INSERT INTO tblmember (Fname,Lname,MemberNo,status)".
"VALUES '$Fname,$Lname,$MemberNo,$status')";

$result = mysql_query ($sql)
    or die ("Query failed");

but this is failing and it has a good reason to failing, coz I have all those $ variables which mysql can't interpret.. how does one insert data and getting an input..
Thanks

webphp

Where is your data coming from that you are trying to insert into the database? Is this the action to a form, if so, do you have the same names for your form fields and the variables that yo uare trying to insert? You might check around for a few web-based tutorials on Php. I'm sure there are some strong ones on this site, webmonkey.com also has a decent php tutorial for beginners. I'm sure it would have you off and running.
Rick

nirmails

this is my code...

<head><title>PHP Test</title></head>
<body>
<form enctype="multipart/form-data" method="post" action="<?php echo $PHP_SELF ?>">
FirstName<br>
<input type="Text" name="Fname" size="25">
<br>
LastName<br>
<input type="Text" name="Lname" size="25">
<br>
MemberNo<br>
<input type="Text" name="MemberNo" size="25">
<br>
status<br>
<input type="Text" name="status" size="25">
<br><br>
<input type="submit" name="submit" value="Upload">
</form>

<?php

if ($submit) {

$db = mysql_connect("localhost","test","password"); 

mysql_select_db("test",$db); 

$sql = "INSERT INTO tblmember (Fname,Lname,MemberNo,status)". 
	"VALUES ('$Fname,$Lname,$MemberNo,$status')"; 

$result = mysql_query ($sql)
    or die ("Query failed");

}
?>
</body>

webphp

You need to add quotes around each of the values you are inserting into your DB.
Instead of
...VALUES ('$Fname,$Lname,$MemberNo,$status')

try
...VALUES ('$Fname','$Lname','$MemberNo','$status')
assuming that all of your fields are varchars. If they aren't they may not require quotes (if MemberNo is an int, for example.)
Rick

nirmails

Hi Rick, Thanks a ton.. it worked perfectly.. didn't just strike me for so long.. thanks ..
John

Anon

Instead of printing "Query failed" try printing mysql_error()