开发工具为phpmystudy+DW CS6
基础知识:
数据库知识
unsigned
UNSIGNED属性就是将数字类型无符号化,与C、C++这些程序语言中的unsigned含义相同。例如,INT的类型范围是-2 147 483 648 ~ 2 147 483 647, INT UNSIGNED的范围类型就是0 ~ 4 294 967 295。
varchar
最大长度为n的可变字符串。
char
固定长度,最长n个字符。
tinyint
从 0 到 255 的整型数据。存储大小为 1 字节。
text
text存储可变长度的非Unicode数据,最大长度为2^31-1(2,147,483,647)个字符。
datetime
“yyyy-mm-dd hh:mm:ss”格式数据
数据库字段:
create table gbook(
id int unsigned not null auto_increment primary key,
name varchar(10) not null,
sex tinyint(1) unsigned not null,
email varchar(255) not null,
info text not null,
ip varchar(15) not null,
time_at datetime not null
)
文件目录:
主要页面有
input.html为初始页
insert.php为把输入内容送入数据库
show.php显示留言板内容
change.php修改留言板内容
del.php删除留言板内容
change_ok.php修改留言板内容并送入数据库
各文件源代码如下:
input.html:
<!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=utf-8" />
<title>留言板</title>
</head>
<body>
<form name="form1" method="post" action="insert.php">
<p>你的名字:<input type="text" name="name" size="20"/></p>
<p>
你的性别:<input type="radio" value="1" name="sex" checked="checked"/>男生
<input type="radio" value="0" name="sex" />女生
</p>
<p>你的E-mail:<input type="text" name="email" size="20"/></p>
<p>你的留言内容:</p>
<p>
<textarea rows="9" name="info" cols="35"></textarea>
</p>
<p>
<input type="submit" value="提交" name="B1"/>
<input type="reset" value="重设" name="B2"/>
</p>
</form>
</body>
</html>
insert.php
<?php
header("Content-Type:text/html;charset=utf-8"); //设置字符集
//客户端传过来的数据
$name = $_POST["name"];
$sex = $_POST["sex"];
$email = $_POST["email"];
$info = $_POST["info"];
$ip = getenv('REMOTE_ADDR'); //客户端IP地址
$conn = mysql_connect("localhost","root","root");
mysql_select_db("gbook"); //MySQL数据库
$sql = "insert into gbook (id,name,sex,email,info,ip,time_at)
values(null,'$name','$sex','$email','$info','$ip',NOW())";
$result = mysql_query($sql,$conn); //执行mySQl查询
$id = mysql_insert_id(); //返回上一步insert操作产生的ID
mysql_close($conn);
?>
<p>留言成功</p>
<p><a href="show.php">去留言页</a></p>
show.php:
<?php
header("Content-Type:text/html;charset=utf-8"); //设置字符集
//数据库信息
$mysql_server_name = "localhost"; //服务器名
$mysql_username = "root"; //数据库账户
$mysql_password = "root"; //数据库密码
$mysql_database = "gbook"; //mysql数据库
$sql = "select * from gbook order by 'id' DESC"; //排序,后留言的在前面显示
$conn = mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
mysql_select_db($mysql_database,$conn);
$result = mysql_query($sql);
while($row = mysql_fetch_row($result)){
// -- if语句判断男女 --
if($row[2] == 1){
$gender = '男';
}else{
$gender = '女';
}
?>
<table width="752" border="1">
<tr>
<td height="32px">
<p><?=$row[6]?> <?=$row[5]?></p>
<p><?=$row[1]?>(<?=$gender?>)<?=$row[3]?></p>
</td>
</tr>
<tr height="45px">
<!-- nl2br把<br />转换成换行符 \n -->
<?=nl2br($row[4])?>
<p>
<a href="change.php?id=<?=$row[0]?>">[修改]</a>
<a href="del.php?id=<?=$row[0]?>">[删除]</a>
</p>
</tr>
</table>
<hr />
<?php
}
mysql_free_result($result); //释放内存
?>
change.php:
<?php
$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "root";
$mysql_database = "gbook";
$id = $_GET["id"];
$sql = "SELECT name, sex, email, info FROM gbook WHERE id = '$id' ";
$conn = mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
mysql_select_db($mysql_database,$conn);
$result = mysql_query($sql);
$row = mysql_fetch_row($result);
?>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>留言版</title>
</head>
<body>
<form name="form1" method="post" action="change_ok.php?id=<?=$id?>">
<p>你的名字:<input type="text" name="name" size="20" value="<?=$row[0]?>"/></p>
<?php
// -----if语句判断男女 1为男 0为女-------
if($row[1]==1)
echo ' <p>你的性别:<input type="radio" value="1" name="sex" checked="checked" />男 <input type="radio" value="0" name="sex" />女 </p>';
else
echo ' <p>你的性别:<input type="radio" value="1" name="sex" />男 <input type="radio" value="0" name="sex" checked="checked" />女 </p>';
?>
<p>你的E-mail:<input type="text" name="email" size="20" value="<?=$row[2]?>"/></p>
<p>你的留言内容:</p>
<p><textarea rows="9" name="info" cols="35"><?=$row[3]?></textarea></p>
<p><input type="submit" value="提交" /><input type="reset" value="重设" /></p>
</form>
</body>
</html>
del.php:
<?php
header("Content-Type:text/html;charset=utf-8"); //设置字符集
//数据库信息
$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "root";
$mysql_database = "gbook";
$id = $_GET["id"];
$sql = "delete from gbook where id = $id";
$conn = mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
mysql_select_db($mysql_database,$conn);
$result = mysql_query($sql);
mysql_close($conn);
?>
<p><a href="show.php">返回</a></p>
change_ok.php:
<?php
header("Content-Type:text/html;charset=utf-8"); //设置字符集
$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "root";
$mysql_database = "gbook";
//客户端传过来的数据
$name = $_POST["name"];
$sex = $_POST["sex"];
$email = $_POST["email"];
$info = $_POST["info"];
$id = $_GET["id"];
$sql = "UPDATE gbook SET name = '$name',sex = '$sex',email = '$email',info = '$info' WHERE id ='$id' ";
$conn = mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
mysql_select_db($mysql_database,$conn);
$result = mysql_query($sql);
mysql_close($conn);
?>
<p><a href="show.php">[返回]</a></p>