搜索

首页  >  问答  >  正文

留言板 出错了 就是找不到错误在哪里 头痛

add.php文件内容

<?php
//导入连接数据库文件
include ('conn.php');
//检测用户是否提交按钮
if(isset($_POST['submit'])){
         $id=$_POST['id'];
         $user=$_POST['user'];
         $title=$_POST['title'];
         $content=$_POST['content'];
    $sql="insert into message(id,user,title,content,lastdate)values('','$user','$title','$content',now())";
    mysqli_query($conn,$sql);
//    echo "<script>alert('添加成功');history.go(-1)</script>";
echo"<script>alert('留言成功');location.href='liu.html'</script>";
}else{
    echo "失败";
}
?>


liu.html内容



    
        
        第一个 MYSQL 查询留言本</title><br/><script type="text/javascript" src="http://www.francescomalagrino.com/BootstrapPageGenerator/3/js/jquery-2.0.0.min.js"> ;</script><br/><脚本类型=“text/javascript” src=“http://www.francescomalagrino.com/BootstrapPageGenerator/3/js/jquery-ui”></script><br/><link href="http://www.francescomalagrino.com/BootstrapPageGenerator/3/css/bootstrap-combined.min.css" rel="stylesheet" media="screen"><br/><脚本type="text/javascript" src="http://www.francescomalagrino.com/BootstrapPageGenerator/3/js/bootstrap.min.js"></script><br/>         <?php include ("添加.php")?><br/>    </head><br/>    <body><br/>        <?php include ("add.php")?><br/>        <div class="container -fluid"><br/>    <div class="row-fluid"><br/>        <div class="span12"><br/>            <div class="page-header"><br/>                <h1><br/>                    第一篇MYSQL留言本<小>V1.0</小><br/>                </h1><br/>            </div>;<br/>            <div class="hero-unit"><br/>                <h1><br/>                    Hello, world!<br/>                </h1><br/>                <p><br/>                    这是一个可视化布局模板, 你可以点击模板里的文字进行修改, 也可以通过点击弹出的编辑框进行富文本修改. 拖动区块能实现排序.<br/>                </p><br/>                <p><br/>                    <a class="btn btn-primary btn-large" href="#">参看更多 »</a><br/>                </p><br/>            </div><br/>            <table class="table table-bordered"><br/>                <标题><br/>                    <tr><br/>                        <th><br/>                           ID<br/>                        </th> <br/>                        <th><br/>                            名字<br/>                        </th><br/>                       <<br/>                            标题<br/>                        </th><br/>                        <th>##                            内容<br/>                        </th><br/>                    </tr><br/>                </thead><br/>                <正文><br/>                    <tr class="success"><br/>                        <td> <br/>                            ID<br/>                        </td><br/>                        <td><br/>                            TB - 每月<br/>                        </td><br/>                        <td><br/>                           01/04/2012<br/>                        </td><br/>                        <td><br/>                            已批准<br/>                        </td><br/>                    </tr><br/><br/>                </tbody& gt;<br/>            </table><br/>            <form action="add.php" method="post"><br/>                <fieldset><br/>                     <图例>表单项</图例> <br/>                     <标签>姓名</标签><输入类型=“文本”名称=“用户”必填/> <br/>                     <标签>标题</标签><输入类型=“文本”名称=“标题”必填/>  <br/>                     <label>留言内容</label><textarea name="content" rows="5" cols="30"></textarea><br/>                     <hr><br/>                     <button type="submit" class="btn" name="submith">提交</button><br/>                </fieldset><br/>            </form><br/>        </div><br/>    </div><br/></div><br/>    </body><br/></html><br/></p><p><br/></p><p><br/></p><p><br/></p><p>  问题  :  没错提交 感觉都没走if  就到else了<br/></p><p><br/></p></div><div class='info mb-10'><a rel="nofollow" href=" https://m.php.cn/zh/member/107134.html"><img src='/static/images/user_avatar.jpg' alt="学海无涯"><span style="margin-left: 5px;">学海无涯</span></a><span class='pl-10'>2565 天前</span><span class='pl-10'>1306 <b class="kclbcollectb"></b></span></div></div><div class="course-list discuss layui-clear bg-white"><h3>全部回复(8)<span class="detail_answer"><span id="discuss-wenda">我来回复</span></span></h3><li class="layui-clear"><div class="discuss-img"><img src="https://img.php.cn/upload/avatar/000/000/001/2cc6bbfa68cfcad12a6c0aa604e961a1.gif" alt="似火年华"></div><div class="info f-left ml-10"><p><a rel="nofollow" href="https://m.php.cn/zh/member/4966.html" fid="" class="replyer-name">似火年华</a><span>2018-02-14 16:20:27</span></p><p class="content Overflow_line"><p>你确定你的sql语句没有写错么   $sql="insert into message(id,user,title,content,lastdate)values('','$user','$title','$content',now())";</p><p>values(" 这里错了吧</p></p><span class="detail_answer2" style="float: left" fid="235231"><div class="btn wenda-second-btn" name="似火年华" fid="235231">回复</div></span><i class="layui-icon layui-icon-praise wenda-praise-btn"><span>0</span></i></div></li><li class="layui-clear"><div class="discuss-img"><img src="https://img.php.cn/upload/avatar/000/000/001/bba031d4b127c478e80130d026189e12.jpg" alt="Sven.He"></div><div class="info f-left ml-10"><p><a rel="nofollow" href="https://m.php.cn/zh/member/113618.html" fid="" class="replyer-name">Sven.He</a><span>2018-02-12 12:48:15</span></p><p class="content Overflow_line"><p>你这样写肯定会到else的。 不提交 ,$_POST['submit'] 肯定没有内容。 </p></p><span class="detail_answer2" style="float: left" fid="235221"><div class="btn wenda-second-btn" name="Sven.He" fid="235221">回复</div></span><i class="layui-icon layui-icon-praise wenda-praise-btn"><span>0</span></i></div></li><li class="layui-clear"><div class="discuss-img"><img src="https://img.php.cn/upload/avatar/000/000/002/61caddcba0718324.png" alt="PHP中文网"></div><div class="info f-left ml-10"><p><a rel="nofollow" href="https://m.php.cn/zh/member/2.html" fid="" class="replyer-name">PHP中文网</a><span>2018-02-11 13:56:44</span></p><p class="content Overflow_line"><p>是添加失败吗????你看下  SQL语句    单引号是不解析变量的   其它的暂时没能从代码上看得出来</p></p><span class="detail_answer2" style="float: left" fid="235214"><div class="btn wenda-second-btn" name="PHP中文网" fid="235214">回复</div></span><i class="layui-icon layui-icon-praise wenda-praise-btn"><span>0</span></i></div></li><li class="layui-clear"><div class="discuss-img"><img src="/static/images/user_avatar.jpg" alt="学海无涯"></div><div class="info f-left ml-10"><p><a rel="nofollow" href="https://m.php.cn/zh/member/107134.html" fid="" class="replyer-name">学海无涯</a><span>2018-02-10 20:14:49</span></p><p class="content Overflow_line"><p>有大神帮忙看下么<br/></p></p><span class="detail_answer2" style="float: left" fid="235197"><div class="btn wenda-second-btn" name="学海无涯" fid="235197">回复</div></span><i class="layui-icon layui-icon-praise wenda-praise-btn"><span>0</span></i></div></li><div class="reply-list"><div class="reply-item"><span class="pull-left comment-ops absolute"><span class="mr20"><a rel="nofollow" href="https://m.php.cn/zh/member/122888.html" target="_blank"><img src="https://img.php.cn/upload/avatar/000/000/001/02a44f94f5000879ddcd02175a8e3c06.jpg" width="30" height="30" alt="徐金龙"></a></span></span><div class="reply-content-block"><div class="reply-content Overflow_line"><p>断点打印是排查错误最有效的办法之一</p></div><div><span class="comment-meta inline-block"><span> — </span><a rel="nofollow" target="_blank" class="reply_color" href="https://m.php.cn/zh/member/122888.html"><strong>徐金龙</strong></a><span class="text-muted-plus"> · 2018-03-06 09:55:09</span></span></div></div></div></div><li class="layui-clear"><div class="discuss-img"><img src="https://img.php.cn/upload/avatar/000/013/745/5ad7f3132f63e720.jpg" alt="韦小宝"></div><div class="info f-left ml-10"><p><a rel="nofollow" href="https://m.php.cn/zh/member/13745.html" fid="" class="replyer-name">韦小宝</a><span>2018-02-10 17:28:58</span></p><p class="content Overflow_line"><p>是直接就提示失败了是么?</p></p><span class="detail_answer2" style="float: left" fid="235194"><div class="btn wenda-second-btn" name="韦小宝" fid="235194">回复</div></span><i class="layui-icon layui-icon-praise wenda-praise-btn"><span>0</span></i></div></li><div class="reply-list"><div class="reply-item"><span class="pull-left comment-ops absolute"><span class="mr20"><a rel="nofollow" href="https://m.php.cn/zh/member/107134.html" target="_blank"><img src="/static/images/user_avatar.jpg" width="30" height="30" alt="学海无涯"></a></span></span><div class="reply-content-block"><div class="reply-content Overflow_line"><p>是的 是的</p></div><div><span class="comment-meta inline-block"><span> — </span><a rel="nofollow" target="_blank" class="reply_color" href="https://m.php.cn/zh/member/107134.html"><strong>学海无涯</strong></a><span class="text-muted-plus"> · 2018-02-10 18:00:28</span></span></div></div></div></div><div class="reply-list"><div class="reply-item"><span class="pull-left comment-ops absolute"><span class="mr20"><a rel="nofollow" href="https://m.php.cn/zh/member/13745.html" target="_blank"><img src="https://img.php.cn/upload/avatar/000/013/745/5ad7f3132f63e720.jpg" width="30" height="30" alt="韦小宝"></a></span></span><div class="reply-content-block"><div class="reply-content Overflow_line"><p>你看看你获取数据获取到了么</p></div><div><span class="comment-meta inline-block"><span> — </span><a rel="nofollow" target="_blank" class="reply_color" href="https://m.php.cn/zh/member/13745.html"><strong>韦小宝</strong></a><span class="text-muted-plus"> · 2018-02-11 09:09:08</span></span></div></div></div></div><div class='more'></div></div><div class='discuss-submit bg-white'><li class='info layui-clear'><span class='f-left' id='discuss-submit-close'>取消</span><span class='f-left wenda-reply-text'>回复</span></li><li class='layui-clear'><textarea type='text' rows="6" placeholder="请输入您的评论内容" class="wenda-reply-content-text"></textarea></li><li class='layui-clear'><button class="layui-btn layui-btn-danger f-right wenda-reply-publish-button">发布</button></li></div><div class='lock-screen' id='lock-screen'></div><script src="/static/ueditor/third-party/SyntaxHighlighter/shCore.js"></script><div class="headerMask"></div><link rel='stylesheet' id='_main-css' href='/static/css/viewer.min.css' type='text/css' media='all'/><script type='text/javascript' src='/static/js/viewer.min.js?1'></script><script type='text/javascript' src='/static/js/jquery-viewer.min.js'></script><footer><div class="footer"><div class="footertop"><img src="/static/imghwm/logo.png" alt=""><p>公益在线PHP培训,帮助PHP学习者快速成长!</p></div><div class="footermid"><a href="https://m.php.cn/zh/about/us.html">关于我们</a><a href="https://m.php.cn/zh/about/disclaimer.html">免责声明</a><a href="https://m.php.cn/zh/update/article_0_1.html">Sitemap</a></div><div class="footerbottom"><p> © php.cn All rights reserved </p></div></div></footer><script>isLogin = 0;</script><script type="text/javascript" src="/static/layui/layui.js"></script><script type="text/javascript" src="/static/js/global.js?4.9.47"></script></body></html>