RE: [PHP] Please help with code
| From: | Rick Emery | Date: | Mon, 01 Apr 2002 16:35:56 +0000 |
| Subject: | RE: [PHP] Please help with code | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-90973@lists.php.net to get a copy of this message | ||
You CANNOT execute the PHP script until the form is submitted. You are
attempting to do both at the same time.
Second, ALL your text fields muse be surrounded by quotes in your INSERT
statement.
Third, use NULL, not UNIX_TIMESTAMP() to insert a timestamp field.
In the following, assume the name of your script is "thisscript.php".
<?php
if isset($submit)
{
$link=mysql_connect("localhost","myid","mypassword");
if ($link){
print "link id is $link";
} else {
print "error connecting to database";
}
$query="INSERT INTO news (newsid,title, author, body, posted)
VALUES(\"$newsid\",\"$title\", \"$author\",
\"$body\", NULL)";
IF (mysql_query($query)){
print "Row added to table";
} else {
print "error adding row";
}
exit;
}
?>
<form name="form1" method="post" action="thisscript.php">
<p>
<input type="text" name="newsid">
</p>
<p>
<input type="text" name="title">
</p>
<p>
<input type="text" name="author">
</p>
<p>
<input type="text" name="body">
</p>
<p>
<input type="submit" name="Submit" value="Submit">
</p>
</form>
</body>
-----Original Message-----
From: Denis L. Menezes [mailto:menezesd@singnet.com.sg]
Sent: Monday, April 01, 2002 10:09 AM
To: php-general@lists.php.net
Subject: [PHP] Please help with code
Hello friends,
can someone tell me what is wrong with this code :
<form name="form1" method="post" action="">
<p>
<input type="text" name="newsid">
</p>
<p>
<input type="text" name="title">
</p>
<p>
<input type="text" name="author">
</p>
<p>
<input type="text" name="body">
</p>
<p>
<input type="submit" name="Submit" value="Submit">
</p>
</form>
</body>
<?php
$link=mysql_connect("localhost","myid","mypassword");
if ($link){
print "link id is $link";
} else {
print "error connecting to database";
}
$posted=time();
$query="INSERT INTO news (newsid,title, author, body, posted)
VALUES($newsid,$title, $author, $body, UNIX_TIMESTAMP())";
IF (mysql_query($query)){
print "Row added to table";
} else {
print "error adding row";
}
?>
It gives the link ID. But then gives "error adding row"
Thanks in advance
Denis
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php