今天做的php留言本

— 
— 表的结构 book 
— 
 
 
Create TABLE book ( 
id int(8) NOT NULL auto_increment, 
username varchar(50) default NULL, 
qq varchar(50) default NULL, 
email varchar(50) default NULL, 
title varchar(50) default NULL, 
content text, 
time varchar(50) default NULL, 
retime varchar(50) default NULL, 
recon text, 
PRIMARY KEY (id) 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 
 
 
 
— 
— 导出表中的数据 book 
— 
 
 
— ——————————————————– 
 
— 
— 表的结构 users 
— 
 
 
 
Create TABLE users ( 
id int(8) NOT NULL auto_increment, 
username varchar(50) default NULL, 
userid varchar(50) default NULL, 
password varchar(50) default NULL, 
email varchar(50) default NULL, 
PRIMARY KEY (id) 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; 
 
 
— 
— 导出表中的数据 users 
— 
 
 
上面的是sql 
 
添加记录add.php 
 
 
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
<html xmlns="http://www.w3.org/1999/xhtml"> 
<head> 
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" /> 
<title>添加留言</title> 
<style type="text/css"> 
<!– 
body,td,th { 
font-size: 12px; 
color: #333333; 
font-family: 宋体; 
} 
a { 
font-size: 12px; 
color: #333333; 
font-family: 宋体; 
} 
a:link { 
text-decoration: none; 
} 
a:visited { 
text-decoration: none; 
color: #333333; 
} 
a:hover { 
text-decoration: none; 
color: #FF0000; 
} 
a:active { 
text-decoration: none; 
color: #0000FF; 
} 
body { 
margin-left: 0px; 
margin-top: 20px; 
margin-right: 0px; 
margin-bottom: 0px; 
} 
.input1 { 
height: 20px; 
width: auto; 
border-top-width: 1px; 
border-right-width: 1px; 
border-bottom-width: 1px; 
border-left-width: 1px; 
border-top-style: solid; 
border-right-style: solid; 
border-bottom-style: solid; 
border-left-style: solid; 
border-top-color: #666666; 
border-right-color: #CECFCE; 
border-bottom-color: #CECFCE; 
border-left-color: #636563; 
} 
.con { 
height: auto; 
width: auto; 
border-top-width: 1px; 
border-right-width: 1px; 
border-bottom-width: 1px; 
border-left-width: 1px; 
border-top-style: solid; 
border-right-style: solid; 
border-bottom-style: solid; 
border-left-style: solid; 
border-top-color: #666666; 
border-right-color: #CECFCE; 
border-bottom-color: #CECFCE; 
border-left-color: #636563; 
overflow: auto; 
} 
.red { 
color: #FF0000; 
} 
–> 
</style> 
</head> 
 
<body> 
<? 
if($username!="") 
{ 
$ID = uniqid("bookID"); 
$db = mysql_connect("localhost","root",""); 
mysql_select_db ("wpsni"); 
$add_time=date("Y")."-".date("m")."-".date("d")." ".date("H").":".date("i").":".date("s"); 
$result = mysql_query ("insert into book (id, username,email , qq, title,content,time) 
VALUES ('$ID', '$username', '$email', '$qq','$title','$content','$add_time')"); 
if(!$result) 
{ 
echo "<center>出现错误：</center>", mysql_error(); 
exit; 
} 
if($result) 
{ 
mysql_close($db); 
echo "<center>用户 $username 留言成功！</center>"; 
} 
} 
else 
{ 
echo "<center>资料填写不完整，请仔细填写！</center>"; 
?> 
<table width="415" height="297" border="0" align="center" cellpadding="0" cellspacing="0" background="images/add_bg.gif"> 
<tr> 
<td height="35" colspan="2" align="center" valign="top"><img src="images/add_top.gif" width="489" height="35" /></td> 
</tr> 
<tr> 
<td height="232" colspan="2"><form id="form1" name="form1" method="post" action="add.php"> 
<table width="424" height="142" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#EBEBEB"> 
<tr> 
<td width="42" bgcolor="#FFFFFF">名字</td> 
<td width="359" height="25" bgcolor="#FFFFFF"><label> 
<input name="username" type="text" class="input1" id="username" size="20" /> 
 * </label></td> 
</tr> 
<tr> 
<td height="26" bgcolor="#FFFFFF">Q  Q</td> 
<td height="25" bgcolor="#FFFFFF"><label> 
<input name="qq" type="text" class="input1" id="qq" size="10" /> 
</label></td> 
</tr> 
<tr> 
<td bgcolor="#FFFFFF">Email</td> 
<td height="25" bgcolor="#FFFFFF"><label> 
<input name="email" type="text" class="input1" id="email" size="20" /> 
</label></td> 
</tr> 
<tr> 
<td bgcolor="#FFFFFF">标题</td> 
<td height="25" bgcolor="#FFFFFF"><label> 
<input name="title" type="text" class="input1" id="title" size="30" /> 
* </label></td> 
</tr> 
<tr> 
<td bgcolor="#FFFFFF">内容</td> 
<td bgcolor="#FFFFFF"><label> 
<textarea name="content" cols="45" rows="8" class="con" id="content"></textarea> 
* </label></td> 
</tr> 
<tr> 
<td colspan="2" bgcolor="#FFFFFF"><div align="center"> 
<label> 
<input type="submit" name="Submit" value="提交" /> 
  </label> 
<label> 
<input type="reset" name="Submit2" value="重置" /> 
</label> 
</div></td> 
</tr> 
</table> 
</form> 
</td> 
</tr> 
<tr> 
<td height="30" colspan="2" align="center" valign="bottom"><img src="images/add_end.gif" width="489" height="30" /></td> 
</tr> 
</table> 
<? 
} 
?> 
</body> 
</html> 
 
 
 
 
显示index.php 
 
<HTML> 
<HEAD> 
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0"> 
<style type="text/css"> 
<!– 
input { font-size:9pt;} 
A:link {text-decoration: underline; font-size:9pt;color:000059} 
A:visited {text-decoration: underline; font-size:9pt;color:000059} 
A:active {text-decoration: none; font-size:9pt} 
A:hover {text-decoration:underline;color:red} 
body,table {font-size: 9pt} 
tr,td{font-size:9pt} 
–> 
</style> 
<title>注册会员列表 – 读取mysql的测试</title> 
</HEAD> 
<? 
//连接到本地mysql数据库 
$myconn=mysql_connect("localhost","root",""); 
//选择test为操作库 
mysql_select_db("wpsni",$myconn); 
$strSql="select * from book"; 
//用mysql_query函数从book表里读取数据 
$result=mysql_query($strSql,$myconn); 
while($row=mysql_fetch_array($result))//通过循环读取数据内容 
{ 
?> 
 
<table width="356" height="166" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#FFFFFF"> 
<tr> 
<td width="42" bgcolor="#CACACA"><samp>姓名</samp></td> 
<td width="300" bgcolor="#E4E4E4"><?echo $row["username"]?></td> 
</tr> 
<tr> 
<td bgcolor="#CACACA">QQ</td> 
<td bgcolor="#E4E4E4"><?echo $row["qq"]?></td> 
</tr> 
<tr> 
<td bgcolor="#CACACA">email</td> 
<td bgcolor="#E4E4E4"><?echo $row["email"]?></td> 
</tr> 
<tr> 
<td bgcolor="#CACACA">标题</td> 
<td bgcolor="#E4E4E4"><?echo $row["title"]?></td> 
</tr> 
<tr> 
<td bgcolor="#CACACA">内容</td> 
<td bgcolor="#E4E4E4"><?echo $row["content"]?></td> 
</tr> 
<tr> 
<td bgcolor="#CACACA">时间</td> 
<td bgcolor="#E4E4E4"><?echo $row["time"]?></td> 
</tr> 
</table> 
 
<? 
} 
//关闭对数据库的连接 
mysql_close($myconn); 
?> 
</BODY> 
</HTML>

一	二	三	四	五	六	日
	1	2	3	4	5	6
7	8	9	10	11	12	13
14	15	16	17	18	19	20
21	22	23	24	25	26	27
28	29	30	31

发表回复 取消回复

相关文章

发表回复取消回复