我才学Php,学了一个月,做的留言本,没有登陆,验证,用户管理功能。希望大家喜欢
del.php<?php
$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "";
$mysql_database = "saturn";
//建立链接
$conn = mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
//准备您的SQL语法
$sql = "delete from gbook where id = '$id' ";
//选取您要处理的数据库
mysql_select_db($mysql_database,$conn);
//进行查询
$result = mysql_query($sql); //结束并释放链接
mysql_close($conn);
header("location:show.php");
?>
<p>[<a href="show.php">回留言板</a>]</p>
del.php<?php
$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "";
$mysql_database = "saturn";
//建立链接
$conn = mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
//准备您的SQL语法
$sql = "delete from gbook where id = '$id' ";
//选取您要处理的数据库
mysql_select_db($mysql_database,$conn);
//进行查询
$result = mysql_query($sql); //结束并释放链接
mysql_close($conn);
header("location:show.php");
?>
<p>[<a href="show.php">回留言板</a>]</p>
<title>简单测试表单</title>
</head><body><center> <font size = 15 >留言本</font></center>
<form method = post action = input.php>
您的姓名:<input type = text name = name size = 28>
<p>
性别: 男<input name = sex type = radio checked value = 0>
女<input type = radio name = sex value = 1>
<p>
您的EMAil:
<input type = text name = email size = 26>
<p>
留言内容;<p>
<textarea name="info" cols="45" rows="9"></textarea>
<p>
<label>
<input type="submit" name="Submit" value="提交">
</label>
<label>
<input type="reset" name="Submit2" value="重新留言">
</label>
</form>
</body></html>
// .......................................................
$ip = getenv(remote_addr);
$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "";
$mysql_database = "saturn";
//建立链接
$conn = mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
//准备您的SQL语法
$sql = "INSERT INTO `gbook` ( `id` , `name` , `sex` , `email` , `info` , `ip` , `time_at` )VALUES ('', '$name', '$sex', '$email', '$info', '$ip', NOW( ));";
//选取您要处理的数据库
mysql_select_db($mysql_database,$conn);
//进行查询
$result = mysql_query($sql);
//抓取自动增加的项目的流水号
$id = mysql_insert_id();
//结束并释放链接
mysql_close($conn);
header("location:show.php");
?>
$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "";
$mysql_database = "saturn";
//建立链接
$conn = mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
//准备您的SQL语法
$sql = "SELECT name ,sex ,email , info FROM gbook WHERE id = '$id' ";
$result = mysql_db_query($mysql_database,$sql,$conn);
$row = mysql_fetch_row($result);
//print_r($row);
?>
<html><head>
<title>修改留言</title>
</head><body><center> <font size = 15 >留言本modify</font></center>
<form method = post action = modify_ok.php?id=<?=$id?>>
您的姓名:<input type = text name = name size = 28 VALUE =<?=$row[0]?>>
<?
if($row[1]==0)
{
echo'<p>
性别: 男<input name = sex type = radio checked value =0>
女<input type = radio name = sex value = 1> </p>';
}
else
{
echo'<p>
性别: 男<input name = sex type = radio value =0>
女<input type = radio name = sex checked value = 1> </p> ';
}?>
<p>
您的EMAil:
<input type = text name = email size = 26 value=<?=$row[2]?>>
<p>
留言内容;<p>
<textarea name="info" cols="45" rows="9"><?=$row[3]?></textarea><p>
<label>
<input type="submit" name="Submit" value="提交">
</label>
<label>
<input type="reset" name="Submit2" value="重新留言">
</label>
</form>
</body></html>
<?php
$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "";
$mysql_database = "saturn";
//建立链接
$conn = mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
//准备您的SQL语法
$sql = "UPDATE `gbook` SET `name` = '$name',`sex` = '$sex',`email` = '$email',`info` = '$info' where id = '$id' ";
//选取您要处理的数据库
mysql_select_db($mysql_database,$conn);
//进行查询
$result = mysql_query($sql); //结束并释放链接
mysql_close($conn);
header("location:show.php");
?><p>[<a href="show.php">回留言板</a>]</p>
<?php
//基本设定
$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "";
$mysql_database = "saturn";
//建立链接
$conn = mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
//准备您的SQL语法
$sql = "SELECT id , name ,sex ,email , info ,ip ,DATE_FORMAT(time_at,'%Y年%M月%D日%T') FROM `gbook` ORDER BY `id` DESC ";
$result = mysql_db_query($mysql_database,$sql,$conn);
while($row = mysql_fetch_row($result))
{
//print_r($row);
if($row[2]== 0)
{
$sex = "男生";
}
else
{
$sex = "女生";
}
?>
<table width="500" height="64" border="0" >
<tr>
<td height="35" bgcolor="#66FFCC"><p><?=$row[6]; ?>(<?=$row[5]; ?>)</p>
<p><?=$row[1]; ?><?=$sex?><<?=$row[3]; ?>>写道:</p></td>
</tr>
<tr>
<td bgcolor="#00CCFF"><?=nl2br($row[4]); ?><p>[<a href="del.php?id=<?=$row[0]; ?>">删除</a>][<a href="modify.php?id=<?=$row[0]; ?>">修改</a>]</p>
</td> <?//nl2br($row[4])php里边的支持手动换行的,和你输入是显示的格式是一样的。 ?>
</tr>
</table>
<hr><?php
}
mysql_free_result($result);
?>
# phpMyAdmin SQL Dump
# version 2.5.6
# http://www.phpmyadmin.net
#
# 主机: localhost
# 生成日期: 2007 年 01 月 03 日 17:06
# 服务器版本: 4.0.18
# PHP 版本: 4.3.6
#
# 数据库 : `saturn`
# # --------------------------------------------------------#
# 表的结构 `gbook`
#CREATE TABLE `gbook` (
`id` int(255) unsigned NOT NULL auto_increment,
`name` varchar(10) NOT NULL default '',
`sex` tinyint(1) unsigned NOT NULL default '0',
`email` varchar(255) NOT NULL default '',
`info` text NOT NULL,
`ip` varchar(15) NOT NULL default '',
`time_at` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=17 ;#
# 导出表中的数据 `gbook`
#INSERT INTO `gbook` VALUES (1, 'saturn1', 0, '[email protected]', '参见任意长度整数\r\n', '127.0.0.1', '2007-01-03 14:10:48');
INSERT INTO `gbook` VALUES (7, '你好', 0, '[email protected]', '整型数的字长和平台有关,尽管通常最大值是大约二十亿(32 位有符号)。PHP 不支持无符号整数。', '127.0.0.1', '2007-01-03 15:00:31');
INSERT INTO `gbook` VALUES (12, 'okcar', 1, '[email protected]', '终于做了几个简单的页面出来了,原来做这些东东也挺有意思的。fff', '127.0.0.1', '2007-01-03 16:51:47');
INSERT INTO `gbook` VALUES (4, '你好', 1, '[email protected]', '整型数的字长和平台有关,尽管通常最大值是大约二十亿(32 位有符号)。PHP 不支持无符号整数。', '127.0.0.1', '2007-01-03 14:21:29');
INSERT INTO `gbook` VALUES (10, 'saturn1', 0, '[email protected]', '参见任意长度整数(GMP),浮点数和任意精度数学库(BCMath)。 \r\n\r\n', '127.0.0.1', '2007-01-03 16:36:58');