input.htm
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='女士';
?>
xml:namespace prefix = body style="background-attachment />
=$arr[6]?>(=$arr[5]?>)
=$arr[1]?> =$gender?>&;lt;=$arr[3]?>&;gt; 写到: |
=$arr[4]?>
[删除]&;nbsp;&;nbsp;&;nbsp;&;nbsp;&;nbsp;&;nbsp;&;nbsp;&;nbsp; PHP?ID==$ARR[0]?>[修改]] |
echo '
';
echo '
';
}
?>
&;lt;继续留言&;gt;
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 "删除失败";
?>
&;lt;返回首页&;gt;
modify.php
$user='root';
$pass
word='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);
?>