PHP+MYSQL留言本(一)

2008-01-02

留言本最基本的功能就是:
1:用户写留言
2:把数据写入数据库
3:显示所有留言

下面就开始制作我的留言本
首先在PHPMYADMIN下建立一 guest_book数据库然后在该数据库下建立一个contents的表该表下建立两个字段
分别为 name 和 content
SQL语句如下:
CREATE TABLE `contents` (
`id` int(11) NOT NULL auto_increment，
`name` varchar(20) NOT NULL default ‘"no name"‘，
`content` mediumtext NOT NULL，
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=6

好了数据库建好了 ~~`下面开始写程序了
该程序包含三个页面post.htm(留言提交页面) index.php(留言显示页面) updata.php(把数据写入数据库的页面)
post.htm代码如下:
<html>
<head>
<meta http-equiv="Content-Type" c>
<title>留言本</title>
</head>
<body>
   <form action="updata.php" method="post" name="name1">
    姓名:<input type="text" name="user_name"><br>
    留言:<textarea name="post_contents" rows="10" cols="50"></textarea>
    <input type="submit">
   </form>
</body>
</html>
updata.php页面代码如下:
<?
$name=$_POST[‘user_name‘];
$content=$_POST[‘post_contents‘];
$conn=mysql_connect("localhost:6033"， "root"， "");
   mysql_query("set names utf-8"); //解决中文乱码问题
   mysql_select_db("guest_book");
   $exec="insert into contents (name，content) values (‘".$_POST[‘user_name‘]."‘，‘".$_POST[‘post_contents‘]."‘)";
   $result=mysql_query($exec);
?>

index.php页面代码如下:
<?
$conn=mysql_connect ("localhost:6033"， "root"， ""); //打开MySQL服务器连接
mysql_select_db("guest_book"); //链接数据库
mysql_query("set names utf-8"); //解决中文乱码问题
$exec="select * from contents"; //sql语句
$result=mysql_query($exec); //执行sql语句，返回结果
while($rs=mysql_fetch_object($result))
{
echo "<table><tr><td>姓名:".$rs->name."</td></tr>";
echo "<tr><td>留言:".$rs->content."</td></tr></table><br/>";
}?>

至于分页，页面转向等功能暂时不用上去.为得就是使程序尽量精简.麻雀虽小.但是留言本的核心功能全在这里了.
其中还需要再多说几句
$conn=mysql_connect ("localhost:6033"， "root"， "");
这一句很重要一开始我用的是 $conn=mysql_connect ("127.0.0.1"， ""， "");
怎么弄都不见数据进数据库去~~~~但是又没报错~~后来看了半天才知道原来哪个127的地方应该在PHPMYADMIN里看服务器名一击数据库端口是什么~~~还有ROOT那里就是mysql用户名了，后面的是密码
还有个问题就是汉字乱码问题
在$result=mysql_query($exec); 语句前面加上mysql_query("set names gb2312");或者mysql_query("set names utf-8");
可疑防止提交进数据库的汉字以乱码形式存放在数据库中以及防止从数据库中查询出来的包含汉字的数据以乱码显示
有时候尽管这样设置了后还是无法正常显示汉字~~~~
我就遇见了这样的情况，由于我是在本地调试的，每次都要把浏览器上的那个字符编码调到utf-8才能正常显示汉字
默认的编码总是ISO-8859-1 于是google了一下`~原来是apache设置不对.于是找到 httpd.conf 设置文件
把 default-character-set=ISO-8859-1 改为 default-character-set=utf-8
然后再 service httpd restart 重启appache 清除所有cookies与历史记录~~~然后问题就解决了

发表评论

网友评论

aabbcc
作者访客于 2008-11-08 14:07:43

澳洲留学中介北京留学中介法国留学中介韩国留学韩国留学中介合法留学中介荷兰留学中介荷兰预科留学服务留学公司留学咨询公司美国留学中介欧洲留学中介英国留学中介加拿大留学中介留学申请高中生留学|澳大利亚留学澳洲留学出国出国留学法国留学荷兰留学加拿大留学加拿大签证留学留学澳大利亚留学澳洲留学法国留学荷兰留学加拿大留学美国留学新加坡留学英国留学中介美国留学新加坡留学英国留学英国签证瑞典留学翻译公司翻译公司洁身器窃听器手机窃听器监听器手机监听器窃听器手机窃听器监听器手机监听器窃听器手机窃听器监听器手机监听器窃听器手机窃听器监听器手机监听器办证网上办证北京办证上海办证广州办证

onestoptown
作者访客于 2008-11-20 12:34:51

shoes online buy shoes sandal shoes slippers shoes ecco shoes rockport shoes.
steve madden shoes - puma shoes -
nike shoes
nike shoes replica
replica nike shoes.
air jordan shoes
replica watches rolex
replica watch - rolex watch - fake rolex watches.
oyster rolex
rolex watches -
replica watches -
replica rolex watches - rolex replica - watches online.
oyster rolex watch - quartz watch fake - nike shoes - nike shoes replica - replica nike shoes.
air jordan shoes - replica watches rolex - replica watch - rolex watch - fake rolex watches.
oyster rolex - rolex watches - replica watches - replica rolex watches - rolex replica - watches online.
oyster rolex watch - quartz watch fake -
best replica watches
rolex watches - replica watches - replica nike shoes - jordan shoes - watches online.
oyster rolex watch - quartz shoes fake -
nike shoeses

对讲机
作者访客于 2008-11-21 16:34:49

Replica Watches Jewelry Replica HandBags
作者访客于 2008-11-25 21:40:40

Replica Watches,Fake Watches,Replica Watch,Fake Watch,Wholesale Watches,Wholesale Replica Watches,Jewelry Watches,Replica Jewelry Watches.

Replica Watches, Replica Watches, Fake Watches, Fake Watches, Wholesale handbags, Wholesale handbags, Replica Handbags, Replica Handbags, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Designer Handbags, Replica Designer Handbags, Replica Watches, Replica Watches, Wholesale Replica Watches, Wholesale Replica Watches, Replica Watches, Replica Watches, Replica Raymond Watches, Replica Raymond Watches, Replica Audemars Piguet Watches, Replica Audemars Piguet Watches, Bvlgari Watch Replica, Bvlgari Watch Replica, Replica Rolex Watch, Replica Rolex Watch, Replica Rado, Replica Rado, Fake Concord Watches, Fake Concord Watches, Replica Gucci Watch, Replica Gucci Watch, Piaget Replica Watch, Piaget Replica Watch, Breitling Watches Replica, Breitling Watches Replica, Fake Montblanc, Fake Montblanc, Movado Replica Watches, Movado Replica Watches, Replica Franck Muller Watches, Replica Franck Muller Watches, Jacob

Replica Watches Jewelry Replica HandBags
作者访客于 2008-11-25 23:58:03

Replica Watches,Fake Watches,Replica Watch,Fake Watch,Wholesale Watches,Wholesale Replica Watches,Jewelry Watches,Replica Jewelry Watches.

Replica Watches, Replica Watches, Wholesale handbags, Wholesale handbags, Replica Watches, Replica Watches, Replica Designer Handbags, Replica Designer Handbags, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Replica Watches, Jewelry Wholesale, Jewelry Wholesale, Replica Handbags, Replica Handbags, Fake Watches, Fake Watches, Breguet Replica Watch, Breguet Replica Watch, IWC Replica Watches, IWC Replica Watches, Corum Replica Watches, Corum Replica Watches, Replica Concord, Replica Concord, Baume Mercier Replica Watches, Baume Mercier Replica Watches, Breitling Watch Replica, Breitling Watch Replica, Replica Mont Blanc, Replica Mont Blanc, Movado Watches Replica, Movado Watches Replica, Accutron Replica, Accutron Replica, Raymond Watches Replica, Raymond Watches Replica, Fake Chopard Watches, Fake Chopard Watches, Rado Watches, Rado Watches, Breitling Watch, Breitling Watch, Replica Franck Muller Watches, Replica Franck Muller Watches, Jaeger LeCoultre Watches Replica, Jaeger LeCoultre Watches Replica, Replica Tissot Watches, Replica Tissot Watches, Audemars Piguet Watches, Audemars Piguet Watches, Fake Breitling Watches, Fake Breitling Watches, Replica Baume Mercier Watches, Replica Baume Mercier Watches, Bvlgari Replica, Bvlgari Replica,

发表评论
用户	访客
标题
BBCode:
评论

下一篇 >

热门文章

更多>>

亮点推荐

更多>>