php+mysql留言板系统「完整代码及详解」

php+mysql留言板系统「完整代码及详解」

php+mysql留言板系统【完整代码及详解】主要页面input.html为初始页

insert.php为把输入内容送入数据库

show.php显示留言板内容

change.php修改留言板内容的界面

del.php删除留言板内容

change_ok.php修改留言板内容并送入数据库

数据库的创建

CREATE DATABASE GBOOK;

CREATE TABLE `gbook` (

`id` INT( 255 ) 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 页面

$mysql_server_name = "localhost";

$mysql_username = "root";

$mysql_password = "123456";

$mysql_database = "gbook";

$ip = getenv('REMOTE_ADDR');

$conn = mysql_connect("localhost","root","123456");

mysql_select_db("gbook");

$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);

$id = mysql_insert_id();

mysql_close($conn);

?>

留言成功

去留言页

show.php 页面

$mysql_server_name = "localhost";

$mysql_username = "root";

$mysql_password = "123456";

$mysql_database = "gbook";

$sql = "SELECT * FROM gbook ORDER BY 'id' DESC"; //排序后留言的在前面显示

$conn = mysql_connect($mysql_server_name,$mysql_username,$m ysql_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 = '女'; }

?>

()

">[修改] ">[删除]