PHP留言板代码
input.htm
input receive.php
$user='root';
$password='123';
$db='guestbook';
$table='gbook';
$ip=getenv(REMOTE_ADDR);
$sql = "INSERT INTO `guestbook`.`gbook` (`id`, `name`, `sex`, `email`, `info`, `ip`, `time_at`) VALUES (NULL, '$T1', '$R1', '$T2', '$S1', '$ip', NOW());";
$connect=mysql_connect('localhost',$user,$password);
mysql_select_db($db);
mysql_query($sql);
$result=mysql_query("select * from $table");
while ($arr=mysql_fetch_array($result))
{
if ($arr[2]==0)
$gender='先生';
else
$gender='女士';
?>
Receive echo '
'; echo '
'; } ?>
新建网页 1 <继续留言>
del.php
$user='root';
$password='123';
$db='guestbook';
$table='gbook';
$sql="DELETE FROM $table WHERE id=$id";
$connect=mysql_connect('localhost',$user,$password);
mysql_select_db($db);
$result=mysql_query($sql);
if ($result)
echo "删除成功";
else
echo "删除失败";
?>
新建网页 1 <返回首页>
modify.php $user='root'; $password='123'; $db='guestbook'; $table='gbook'; $ip=getenv(REMOTE_ADDR); $connect=mysql_connect('localhost',$user,$password); mysql_select_db($db); $result=mysql_query("select * from $table where id=$id"); $arr=mysql_fetch_array($result); ?>
input 您的姓名:
您的性别: if ($arr[2]==0) echo '男 女
'; else echo '男 女 '; ?>您的EMAIL:
您的留言内容:
=$arr[4]?>
modify_ok.php
$user='root';
$password='123';
$db='guestbook';
$table='gbook';
$connect=mysql_connect('localhost',$user,$password);
mysql_select_db($db);;
$sql = "UPDATE `guestbook`.`gbook` SET `name` = '$T1', `sex` = '$R1', `email` = '$T2', `info` = '$S1' WHERE `gbook`.`id` = '$id' LIMIT 1;";
$result=mysql_query($sql);
if ($result)
echo "修改成功";
else
echo "修改失败";
?>
新建网页 1 <继续留言>