PHP小实例-制作留言本
第一步：在mysql中新建数据库bbs 然后执行sql代码
CREATE TABLE `message` (
`id` tinyint(1) NOT NULL auto_increment,
`user` varchar(25) NOT NULL,
`title` varchar(50) NOT NULL,
`content` tinytext NOT NULL,
`lastdate` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;
运行成功后 如下图所示：
第二步：新建conn.php
<?php
$conn = @ mysql_connect("localhost", "root", "") or die("数据库链接错误");
mysql_select_db("bbs", $conn);
mysql_query("set names 'GBK'"); //使用GBK中文编码;
function htmtocode($content){
$content = str_replace("\n","<br>",str_replace(" "," ",$content));
return $content;
}
?>
第三步：新建add.php
<?php
include("conn.php");
if($_POST['submit'])
{
$sql="insert into message (id,user,title,content,lastdate)" .
"values ('','$_POST[user]','$_POST[title]','$_POST[content]',now())";
mysql_query($sql);
echo "<script language=\"javascript\">alert('添加成功');history.go(-1)</script>";
}
?>
<script language="javascript">
function checkpost()
{
if (myform.user.value=="")
{
alert("请输入用户名");
myform.user.focus();
return false;
}
if (myform.title.value.length<5)
{
alert("标题不能小于5个字符");
myform.title.focus();
return false;
}
if (myform.content.value.length<5)
{
alert("留言内容不能小于10个字符");
myform.content.focus();
return false;
}
}
</script>
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
}
-->
</style>
<form name="myform" action="add.php" method="post" onsubmit="return checkpost();">
<table width="600" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
