建立guest 数据库
<?php
//将用户输入的数据库中的">","<","|" 用空格代替
//并在输入数据前加反斜杠防止出现危险操作
if(($REQUEST_METHOD=='post')){
for(reset($HTTP_POST_VARS);
$key=key($HTTP_POST_VARS);
next($HTTP_POST_VARS)){
$this=addslashes($HTTP_POST_VARS[$key]);
$this=strtr($this,">"," ");
$this=strtr($this,"<"," ");
$this=strtr($this,"|"," ");
$$key=$this;
}
//查询用户输入信息是否完整
//向数据库输入数据
if(($name)&&($email)&&($message)){
$query="insert into guests";
$query.="(guest_id,guest_name,guest_email,guest_time,guest_message)";
$query.="values(0000,'$name','$email',NULL,'$message')";
mysql_pconnect("localhost","zhengyi","zhengyi")or die;
mysql_select_db("mydb") or die;
mysql_query($query) or die;
}
//如果用户写的信息不全把它记录下来
else{$notall=1;}
}
?>
<!--start page-->
<html>
<head>
<title>留言薄</title>
</head>
<body bgcolor="yellow">
<center>
<h1>请留意见</h1>
<!-通知用户些详细信息->
<?if ($notall==1){ ?>
<P><font color="red">请添全所有的信息</font></p>
<?}?>
<form method="post" action="guest.php">
<pre>
姓名：<input type="text"
name="name"
size="20"
maxsize="50"
value="<?echo $name; ?>">
Email 地址：<input
type="text"
name="email"
size="20"
maxsize="50"
value="<?echo $email; ?>">
留言内容：
<textarea name="message" cols="40" rows="8" wrap="virtual">
<?echo $message;?>
</textarea>
<input type="submit" value="添加">
</pre>
</form>
<hr>
<?
//连接数据库
mysql_pconnect("localhost","localhost","数据库的权限用户名","数据库的权限密码") or die("无法连接数据库");
mysql_select_db("guest") or die("无法选择数据库");
//将已有的数据读出
$query="select count(*) from guests";
$numguests=mysql_query($query) or die("查询失败");
$numguest=mysql_fetch_array($numguests); ?>
<p>
<a href="guest.php?complete=1"><?echo $numguest[0];?>个客户</a>留下墨宝</p>
<?if($complete==1){
$query="select * from guests order by guest_time desc";}
else{
$query="select * from guests order by guest_time desc limit 20"; }
$guests=mysql_query($query) or die("查询失败！");
while($guest=mysql_fetch_array($guests)){?>
<table border="1" width="500">
<tr><td>
姓名：<? echo $guest['guest_name'];?>
</td><td>
Email:<a href="mailto:<? echo $guest['guest_email'];?>">
<? echo $guest['guest_email'];?></a>
</td><td>
<?
$dateformdb=$guest['guest_time'];
$year=substr($datefromdb,0,4);
$mon=substr($datefromdb,4,2);
$day=substr($datefromdb,6,2);
$hour=substr($datefromdb,8,2);
$min=substr($datefromdb,10,2);
$sec=substr($datefromdb,12,2);
$orgdate=date("1F dS, Y h:iA",mktime($hour,$min,$sec,$mon,$day,$year));
echo "时间：$orgdate\n";
?>
</td></tr>
<tr><td colspan="3">
<?echo $guest['guest_message'];?>
</td></tr>
</table>
<br>
<?}?>
</center>
</body>
</html>
|