[PHP与MySQL]⑥---文章发布

Paste_Image.png

article.add.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>无标题文档</title>
    <style type="text/css">
        body {
            margin-left: 0px;
            margin-top: 0px;
            margin-right: 0px;
            margin-bottom: 0px;
        }
    </style>
</head>

<body>
<table width="100%" height="520" border="0" cellpadding="8" cellspacing="1" bgcolor="#000000">
    <tr>
        <td height="89" colspan="2" bgcolor="#FFFF99"><strong>后台管理系统</strong></td>
    </tr>
    <tr>
        <td width="156" height="287" align="left" valign="top" bgcolor="#FFFF99"><p><a href="article.add.php">发布文章</a></p>
            <p><a href="article.manage.php">管理文章</a></p>      <a href="article.add.php"></a></td>
        <td width="837" valign="top" bgcolor="#FFFFFF">
            <form id="form1" name="form1" method="post" action="article.add.handle.php">
                <table width="779" border="0" cellpadding="8" cellspacing="1">
                    <tr>
                        <td colspan="2" align="center">发布文章</td>
                    </tr>
                    <tr>
                        <td width="119">标题</td>
                        <td width="625"><label for="title"></label>
                            <input type="text" name="title" id="title" /></td>
                    </tr>
                    <tr>
                        <td>作者</td>
                        <td><input type="text" name="author" id="author" /></td>
                    </tr>
                    <tr>
                        <td>简介</td>
                        <td><label for="description"></label>
                            <textarea name="description" id="description" cols="60" rows="5"></textarea></td>
                    </tr>
                    <tr>
                        <td>内容</td>
                        <td><textarea name="content" cols="60" rows="15" id="content"></textarea></td>
                    </tr>
                    <tr>
                        <td colspan="2" align="right"><input type="submit" name="button" id="button" value="提交" /></td>
                    </tr>
                </table>
            </form></td>
    </tr>
    <tr>
        <td colspan="2" bgcolor="#FFFF99"><strong>版权所有</strong></td>
    </tr>
</table>
</body>
</html>

article.add.handle.php

<?php
require_once('connect.php');
//print_r($_POST);
//把传递过来的信息入库,在入库之前对所有的信息进行校验。
if (!(isset($_POST['title']) && (!empty($_POST['title'])))) {
    echo "<script>alert('标题不能为空');window.location.href='article.add.php'</script>";
}
$title = $_POST['title'];
$author = $_POST['author'];
$description = $_POST['description'];
$content = $_POST['content'];
$dateline = time();
$insertsql = "insert into article(title,author,description,content,dateline) values('$title','$author','$description','$content',$dateline)";
//title加单引号表示字符串
//echo $insertsql;先检验是否出错
if (mysql_query($insertsql)) {
    echo "<script>alert('发布文章成功');window.location.href='article.add.php'</script>";
} else {
    echo "<script>alert('发布失败');window.location.href='article.add.php'</script>";
}
?>
最后编辑于
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容