Inserting records into MySQL

[hackersapien]

Hi!Guys,
I need help inserting records into mySQL.This is the code which I have for the form:

<form action="add.php" method="post">
<table width="75%" border="0">
<tr>
<td class="title">ISBN</td>
<td><input name="isbn" type="text"></td>
</tr>
<tr>
<td class="title">Author</td>
<td><input name=author type="text"></td>
</tr>
<tr>
<td class="title">Title</td>
<td><input name=title type="text"></td>
</tr>
<tr>
<td height="22" class="title">Price</td>
<td><input name=price type="text"></td>
</tr>
<tr>
<td class="title">&nbsp;</td>
<td><input type="submit" name="Submit" value="Add"></td>
</tr>
</table>
</form>

This is the code for adding the records:
<?php
@ $db=mysql_pconnect("localhost","","");

if(!$db)
{
	echo "Error:unable to connect to database server";
	exit;
}
mysql_select_db("test");

 $isbn=$_POST[isbn];
 $author=$_POST[author];
 $title=$_POST[title];
 $price=$_POST[price];

$query="insert into books values('".$isbn."','".$author."','".$title."','".$price."')";

$result=mysql_query($query);
if ($result)
	echo mysql_affected_rows()." client inserted into database";

?>
but everytime I post the form I get the following error:

Notice: Use of undefined constant isbn - assumed 'isbn' in C:\Projects\php-site\add.php on line 11

Notice: Use of undefined constant author - assumed 'author' in C:\Projects\php-site\add.php on line 12

Notice: Use of undefined constant title - assumed 'title' in C:\Projects\php-site\add.php on line 13

Notice: Use of undefined constant price - assumed 'price' in C:\Projects\php-site\add.php on line 14

Can anybody help me?

Cheers

[bogu]

When you read your var from POST or GET in your case, index is a string and it should be write betwen quotes like this:

$_POST['index']

I think this is your problem.

[xblue]

this is just php trying to guess your thoughts. I think it always did, silently, but recently it started talking about it a lot 😉 (i.e. the default error reporting settings have been changed).

isbn is a string, and therefore would have to be wrapped in quotation marks. php assumes that you meant it to be a string, and informs you that it is taking it as a string.

quote it yourself: $_POST['isbn'], and these notices should disappear.

this should not be related to an insert problem you may have, though. if you do, add some error checking.

$result=mysql_query($query) or die('Error: '.mysql_error().' in query: '.$query); 

[hackersapien]

Thanks for the help,I changed the code and all the errors have gone.Although I had to enclose the $price variable before it worked:
$price=$_POST['price'];

Cheers