Inserting into database from web-page

Anon

Hi!
I need help. I have created a simple database with a table with only two fields. My problem is now to insert info into those tables. I have no problem getting the info or deleting it! I use the following code:

<form action="<?php echo $php_self?>" method="get">
<input type="id">
<input type="text" name="name">
<input type="text" name="joke">
<input type="submit" name="submitjoke" value="GO!">
</form>

<?php
else:
$dbcnx=@mysql_connect("192.168.0.22","root","");
if(!$dbcnx)
{
echo("Sorry, no connection");
}

if(!mysql_select_db("jokes",$dbcnx))
{
echo("Sorry, no db selected");
}

if(isset($deletejoke))
{
$sql="delete from jokestable
where ID=$deletejoke";
if(mysql_query($sql))
{
echo("Joke deleted!");
}
else
{
echo("problems!".mysql_error());
exit;
}
}

if($submitjoke=="submit")
{
$sql="insert into jokestable set
name='$name'
joke='$joke'
id='$id'";

if(mysql_query($sql))
{
echo("Data entered!");
}
else
{
echo("Sorry, data not entered!".mysql_error());
}
}

$result=@("select name,joke,ID from jokestable");
if(!$result)
{
echo("Sorry, no data available".mysql_error());
exit();
}

while($myrow=mysql_fetch_array($result))
{
$milaname=$myrow["name"];
$milajoke=$myrow["joke"];
$testid=$myrow["ID"];
echo("$testid $milaname $milajoke"."<a href='$php_self?deletejoke=$testid'>"."Delete joke</a>");
}

echo("<a href='$php_self? AddJoke=1'>Add Joke</a>");

endif;
?>

</body>

Thanks
Emile van Lill

Anon

Hi Emila,

You used the updaye syntax for a insert statement. The correct SQL for the insert is:

INSERT INTO jokestable(id,name,joke) VALUES('$id','$name','$joke')

And your mixing up columnnames. You use id and ID, there is a differnce you know.

I quess this will work,
greetZ,
Joris

mithril

Does the MySQL user account have INSERT privileges granted on the table in question? That may be the best place to start.

-geoff

emile

Thanx! I have made the changes and it still did not work. But discovered this morning what the actual problem was. I had to put $submitjoke equal to the value of the submitbutton in the form.

Would mind giving me just a short explanation about the difference between 'id' and 'ID'. Do you have to keep it the same as the fieldname in the table or is there another reason? Thanks for your help.
Emile

if($submitjoke=="SUBMIT")
{
$sql="insert into jokestable(ID,name,joke) VALUES('$ID','$name','$joke')";

if(mysql_query($sql))
{
echo("Data entered!");
}
else
{
echo("Sorry, data not entered!".mysql_error());
}
}