简单的PHP留言本实例代码

发布时间：2020-05-24 21:45:11 所属栏目：PHP 来源：互联网

导读：对于学习php的朋友，开始做个留言板对于php+mysql的操作有个简单的过程。学会了这个基本上php开始入门了。

config.php

代码如下:$conn = @mysql_connect("localhost","root","") or die("数据库连接出错!");
mysql_select_db("gb",$conn);
mysql_query("set names 'GBK'");
?>

add.php

代码如下:include("config.php");
if($_POST['submit']){
//在这里的时候，忘记message里还有个字段lastdate没有写,导致插入数据不成功。找了好久才找出错误。
$sql="insert into message (id,user,title,content,lastdate) values ('','$_POST[user]','$_POST[title]','$_POST[content]',now())";
mysql_query($sql);
echo "成功";
}
?>

用户:

标题:

内容:

<br /> <BR><input type="submit" name="submit" value="提交" /> <BR></form> <BR> <BR>view.php <BR> 代码如下:<?php <BR>include("config.php"); <BR>?> <BR><table width=500 border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#add3ef"> <BR><?php <BR>$sql="select * from message order by id desc"; <BR>$query=mysql_query($sql); <BR>while($row=mysql_fetch_array($query)){ <BR>?> <BR>//NND。我在wampserver默认环境下，使用<?=$row[title]?>这种语法，就是读取不出内容来。非要用这种才可以。郁闷。又是好久才琢磨出来 <BR><tr bgcolor="#eff3ff"> <BR><td>标题：<?php echo $row[title];?> 用户：<?php echo $row[user];?></td> <BR></tr> <BR><tr bgColor="#ffffff"> <BR><td>内容：<?php echo $row[content];?></td> <BR></tr> <BR><?php <BR>} <BR>?> <BR></table> <BR> <BR>然后还有个数据库的SQL。 <BR> 代码如下:CREATE TABLE `message` ( <BR>`id` tinyint(1) NOT NULL auto_increment,<BR>`user` varchar(25) NOT NULL,<BR>`title` varchar(50) NOT NULL,<BR>`content` tinytext NOT NULL,<BR>`lastdate` date NOT NULL,<BR>PRIMARY KEY (`id`) <BR>) ENGINE=InnoDB DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ; <BR></p>                        <p style="text-align:right;">（编辑：安卓应用网）</p>
<p style="text-align:right;">【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!</p>
                    </td>
                  </tr>
                </table>
            </div>
            <div class="dede_pagess"><ul class="pagelist"></ul></div>
            <div class="ad-690"><script src='https://ess.0577qiche.com/d/js/acmsd/ad76.js' language='javascript'></script></div>
            <div class="g-box10">
            	<div class="t-2">相关内容</div>
<ul class="b-box12"></ul>
<ul class="b-box13"><li><a href="https://www.0791zz.com/html/kaifa/PHP/20200525/72320.html" target="_blank">php文件夹与文件目录操作函数介绍</a></li><li><a href="https://www.0791zz.com/html/kaifa/PHP/20200524/56468.html" target="_blank">php XPath对XML文件查找及修改实现代码</a></li><li><a href="https://www.0791zz.com/html/kaifa/PHP/20200523/29416.html" target="_blank">php resizeimage 部分jpg文件 生成缩略图失败的原因分析及解</a></li><li><a href="https://www.0791zz.com/html/kaifa/PHP/20200524/46605.html" target="_blank">PHP三元运算的2种写法代码实例</a></li><li><a href="https://www.0791zz.com/html/kaifa/PHP/20200528/77880.html" target="_blank">Yii中CArrayDataProvider和CActiveDataProvider区别实例分析</a></li><li><a href="https://www.0791zz.com/html/kaifa/PHP/20200525/65080.html" target="_blank">php 输出json字符串的简单示例</a></li><li><a href="https://www.0791zz.com/html/kaifa/PHP/20200523/32334.html" target="_blank">在WordPress中使用wp-cron插件来设置定时任务</a></li><li><a href="https://www.0791zz.com/html/kaifa/PHP/20200524/58839.html" target="_blank">asp.net Repeater控件的说明及详细介绍及使用方法</a></li><li><a href="https://www.0791zz.com/html/kaifa/PHP/20200525/70930.html" target="_blank">YII Framework的filter过滤器用法分析</a></li><li><a href="https://www.0791zz.com/html/kaifa/PHP/20200525/63430.html" target="_blank">php 容易被面试官提到的知识点（面试题详细介绍）</a></li><div class="cl"></div></ul>
            </div>
        </div>
    </div>
    <div class="right-1 fr">
    	<div class="g-box8">
        <div class="t-2">推荐文章</div>
            <ul></ul>
        </div>
    	<div class="g-box11">
        <div class="t-2">站长推荐</div>
            <ul class="b-box7"><li><a href="https://www.0791zz.com/html/kaifa/PHP/20200523/25820.html" target="_blank">nginx下安装php7+php5</a></li><li><a href="https://www.0791zz.com/html/kaifa/PHP/20200523/23205.html" target="_blank">php实现登陆模块功能示例</a></li><li><a href="https://www.0791zz.com/html/kaifa/PHP/20200524/48316.html" target="_blank">php利用单例模式实现日志处理类库</a></li><li><a href="https://www.0791zz.com/html/kaifa/PHP/20200524/44439.html" target="_blank">Laravel框架表单验证详解</a></li><li><a href="https://www.0791zz.com/html/kaifa/PHP/20200525/69969.html" target="_blank">PHP使用Redis实现防止大并发下二次写入的方法</a></li><li><a href="https://www.0791zz.com/html/kaifa/PHP/20200527/77555.html" target="_blank">PHP+sqlite数据库操作示例(创建/打开/插入/检索)</a></li><li><a href="https://www.0791zz.com/html/kaifa/PHP/20200523/26241.html" target="_blank">Yii列表定义与使用分页方法小结(3种方法)</a></li><li><a href="https://www.0791zz.com/html/kaifa/PHP/20200524/42536.html" target="_blank">php中mt_rand()随机数函数用法</a></li><li><a href="https://www.0791zz.com/html/kaifa/PHP/20200527/74744.html" target="_blank">php – cURL适用于我的REST API,但不是Guzzle</a></li><li><a href="https://www.0791zz.com/html/kaifa/PHP/20200525/69208.html" target="_blank">PHP教程：Yii2中简单的场景使用介绍</a></li></ul>
        </div>
        <script type="text/javascript">jQuery(".g-box8").slide({ titCell:"li",triggerTime:0 });	</script>
        <div class="ad-250"><script src='https://ess.0577qiche.com/d/js/acmsd/ad103.js' language='javascript'></script></div>
    	<div class="g-box3 u-3">
        <div class="t-1">热点阅读</div>
            <ul class="b-box2"></ul>
        </div>
        <div class="ad-250"><script src='https://ess.0577qiche.com/d/js/acmsd/ad77.js' language='javascript'></script></div>
        </div>
	<div class="cl"></div>
</div>
<div class="ad-960"><script src='https://ess.0577qiche.com/d/js/acmsd/ad78.js' language='javascript'></script></div>
<div class="footer">
<p>【免责声明】本站内容转载自互联网，其发布内容言论不代表本站观点，如果其链接、内容的侵犯您的权益，烦请提交相关链接至邮箱bqsm@foxmail.com我们将及时予以处理。</p>
<p>建议您使用1920×1080分辨率、谷歌浏览器Google Chrome、Microsoft Edge以获得本站的最佳浏览效果</p>
<p>Copygight © 2008-2022 https://www.0791zz.com/ All Rights Reserved. 安卓应用网</p>
<p><script type="text/javascript" src="//js.users.51.la/21280179.js"></script></p>
</div>
</body>
</html>