A
Anonymous
Guest
Code:
<body>
<form action="<?php echo $_SERVER['PHP_SELF'];?>" method="post">
<label>
<p>Welcome Friends</p>
<p>Guest's Name:
<input type="text" name="guestname" size="80">
</br>
</p>
<p>E-mail Address:
<input type="text" name="email" size="80">
</br>
</p>
<p>Message: </p>
<p>
<textarea name="message" rows="20" cols="80"></textarea>
</br>
</p>
<p> <input type="submit" name="Send">
</p>
</form>
<?php
$con=@mysql_connect('127.0.0.1','root','') or die ('Cant established any connection'.mysql_error());
mysql_select_db('jd') or die ('Unable to resolve database'.mysql_error());
if (isset($_POST['guestname']) && ($_POST['email']) && ($_POST['message']))
{
$guestname=$_POST['guestname'];
$mail=$_POST['email'];
$message=$_POST['message'];
$sql="INSERT INTO guest set guestid='', guestname='$guestname',postdate=CURDATE(),email='$mail',message='$message'";
if (@mysql_query($sql))
{
echo 'Message Posted';
}
else
{
echo 'Unable to resolve database'.mysql_error();
}
$view=@mysql_query("Select * guest");
if(!$view){
exit('Unable to display records'.mysql_error());
}
while ($link=mysql_fetch_array($result,MYSQL_ASSOC))
{
echo "<tr>\n"."</br>";
foreach ($link as $col_value)
{
echo "\t\t<td>$col_value</td>\n"."</br>";
}
echo "\t</tr>\n";
}
echo "</table>\n";
mysql_free_result($result);
mysql_close($connectdb);
echo '<p><a href="' . $_SERVER['PHP_SELF'].'?message=1">Leave me a message</a></p>';
?>
</body>i cant figure out whats wrong with this code... when i execute this.. it returns an error message like this:
Parse error: syntax error, unexpected $end in D:\apachefriends\xampp\htdocs\jade\insert.php on line 75
anybody could help...please guys...
Edited by Alexei Kubarev: added code tags. Please use them next time
