网页留言板代码(留言板网页设计代码)

大家好，今日琪琪来为大家解答以上的问题。网页留言板代码，留言板网页设计代码很多人还不知道，现在让我们一起来看看吧！

1、数据库的创建 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为把输入内容送入数据库 show.php显示留言板内容 change.php修改留言板内容的界面 del.php删除留言板内容 change_ok.php修改留言板内容并送入数据库 input.html 留言版 你的名字： 你的性别：男生 女生 你的E-mail: 你的留言内容: 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,$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 = '女'; } ?> () ">[修改] ">[删除] } mysql_free_result($result); ?> change.php $mysql_server_name = "localhost"; $mysql_username = "root"; $mysql_password = "123456"; $mysql_database = "gbook"; $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); ?> 留言版 "> 你的名字："/> // -----if语句判断男女 1为男 0为女------- if($row[1]==1) echo ' 你的性别：男 女 '; else echo ' 你的性别：男 女 '; ?> 你的E-mail:"/> 你的留言内容: del.php $mysql_server_name = "localhost"; $mysql_username = "root"; $mysql_password = "123456"; $mysql_database = "gbook"; $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); ?> [返回] change_ok.php $mysql_server_name = "localhost"; $mysql_username = "root"; $mysql_password = "123456"; $mysql_database = "gbook"; $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); ?> [返回] 。

本文到这结束，希望上面文章对大家有所帮助。