求用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为把输入内容送入数据库

show.php显示留言板内容

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

del.php删除留言板内容

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

input.html

<html>

<head>

</head>

<body>

</form>

</body>

</html>

insert.php

<?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 = '女'}

<tr>

</tr>

<tr>

</tr>

</table>

<hr />

}

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)

<html>

<head>

</head>

<body>

// -----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>你的留言内容:</p>

</form>

</body>

</html>

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)

input.htm

<html>

<head>

<title>input</title>

</head>

<body>

女<input type="radio" name="R1" value="1"></p>

<p>您的EMAIL：<input type="text" name="T2" size="35"></p>

<p>您的留言内容：</p>

<p></p>

</form>

</body>

</html>

receive.php

<?php

$user='root'

$password='123'

$db='guestbook'

$table='gbook'

$ip=getenv(REMOTE_ADDR)

$sql = "INSERT INTO `guestbook`.`gbook` (`id`, `name`, `sex`, `email`, `info`, `ip`, `time_at`) VALUES (NULL, '$T1', '$R1', '$T2', '$S1', '$ip', NOW())"

$connect=mysql_connect('localhost',$user,$password)

mysql_select_db($db)

mysql_query($sql)

$result=mysql_query("select * from $table")

while ($arr=mysql_fetch_array($result))

{

if ($arr[2]==0)

$gender='先生'

else

$gender='女士'

<html>

<head>

<title>Receive</title>

</head>

<tr>

写到:</td>

</tr>

<tr>

</tr>

</table>

</body>

</html>

<?php

echo '<p>'

}

<html>

<head>

</head>

<body>

</body>

</html>

del.php

<?php

$user='root'

$password='123'

$db='guestbook'

$table='gbook'

$sql="DELETE FROM $table WHERE id=$id"

$connect=mysql_connect('localhost',$user,$password)

mysql_select_db($db)

$result=mysql_query($sql)

if ($result)

echo "删除成功"

else

echo "删除失败"

<html>

<head>

</head>

<body>

</body>

</html>

modify.php

<?php

$user='root'

$password='123'

$db='guestbook'

$table='gbook'

$ip=getenv(REMOTE_ADDR)

$connect=mysql_connect('localhost',$user,$password)

mysql_select_db($db)

$result=mysql_query("select * from $table where id=$id")

$arr=mysql_fetch_array($result)

<html>

<head>

<title>input</title>

</head>

<body>

<p>您的性别：

<?php

if ($arr[2]==0) echo '男<input type="radio" value="0" name="R1" checked>

女<input type="radio" name="R1" value="1"></p>'

else echo '男<input type="radio" value="0" name="R1">

女<input type="radio" name="R1" value="1" checked></p>'

<p>您的EMAIL：<input type="text" name="T2" size="35" value="<?=$arr[3]?>"></p>

<p>您的留言内容：</p>

<p></p>

</form>

</body>

</html>

modify_ok.php

<?php

$user='root'

$password='123'

$db='guestbook'

$table='gbook'

$connect=mysql_connect('localhost',$user,$password)

mysql_select_db($db)

$sql = "UPDATE `guestbook`.`gbook` SET `name` = '$T1', `sex` = '$R1', `email` = '$T2', `info` = '$S1' WHERE `gbook`.`id` = '$id' LIMIT 1"

$result=mysql_query($sql)

if ($result)

echo "修改成功"

else

echo "修改失败"

<html>

<head>

</head>

<body>

</body>

</html>

欢迎分享，转载请注明来源：内存溢出

原文地址: http://outofmemory.cn/zaji/6245513.html

求用PHP写一个简单基本的留言板代码，有点急

发表评论

评论列表（0条）