php之留言板

留言板或者说一个小的博客系统有如下功能，编写标题内容并用mySQL保存，修改，删除。

<?php
    @mysql_connect("localhost:3306", "root", "") or die("mysql连接失败");
    @mysql_select_db("php100") or die("db连接失败");
    //mysql_set_charset("gbk");        5.2.3以上可以这样写，纠正函数编码
    mysql_query("set names 'gb2312_chinese_ci'");    //
    mysql_query("SET NAMES 'UTF8'"); //以此来保证网页传送中文汉字进入数据库时不会变成乱码
?>

<a href='add.php'>添加内容</a>
<hr>
<?php
    header("Content-type: text/html; charset=utf-8");//保证正常显示中文
    include_once ("conn.php");

    $sql = "select * from `news` order by id desc";
    $query = mysql_query($sql);
    
    while( $rs = mysql_fetch_array($query)) {//执行一次向下读取一条数据

?>
    <h2>标题：<?php echo $rs["title"] ?> |
        <a href="edit.php?ed=<?php echo $rs['id']?>">编辑</a> | 
        <a href="del.php?del=<?php echo $rs['id']?>">删除</a> |</h2>
    <li>时间：<?php echo $rs["dates"] ?></li>
    <p><?php echo $rs["contents"] ?></p>
    <hr>
<?php//典型的混编，简直醉了
    }
?>

<?php//添加内容页面
    header("Content-type: text/html; charset=utf-8");
    include ("conn.php");//引入连接数据库

    if(!empty($_POST['sub'])){
        $title = $_POST['title'];
        $con = $_POST['con'];
        /*$sql = "CREATE TABLE news //这个是建立表的语句
        (
            id INT(5) NOT NULL AUTO_INCREMENT, 
            PRIMARY KEY(id),
            title VARCHAR(50),
            dates DATE,
            contents TEXT
        )";*/
        $sql="insert into `news` (`id`,`title`,`dates`, `contents`) value (null, '$title',now(),'$con')";
        
        echo $sql."<br/>";
        mysql_query($sql);
        echo "insert is ok";
    }


?>

<form action="add.php" method="post">
标题<input type="text" name="title"><br>
内容<textarea rows="5" cols="50" name="con"></textarea><br>
<input type="submit" name="sub" value="发表">
</form>

<?php
    
    include ("conn.php");
    header("Content-type: text/html; charset=utf-8");
    
    if(!empty($_GET['del'])) {//在index页面中，连接后面接着的?del='$id'可以用get方法获得，以此来简单的传递信息
        $d = $_GET['del'];
        $sql = "delete from `news` where `id` = '$d'";
        mysql_query($sql);
        echo "删除成功";
    }
?>

<?php
    include_once("conn.php");
    header("Content-type: text/html; charset=utf-8");
    if(!empty($_GET['ed'])){//同样用链接的后缀传递id
        $ed = $_GET['ed'];
        $sql = "select * from `news` where `id`='$ed'";
        $query = mysql_query($sql);
        $rs = mysql_fetch_array($query);
?>

<h2>标题：<?php echo $rs['title']?></h2>
<li>时间：<?php echo $rs['dates']?></li>
<form method="POST" action="edit.php">
<input type="hidden" name="hid" value="<?php echo $ed?>"/>//隐藏的id来传递，用post方法，这种写法也学会，并不会在页面显示
内容：<textarea name="con" rows="5" cols="40"><?php echo $rs['contents']?></textarea>
<br><br>
<input type="submit" name="submit" value="修改"/>
</form>

<?php
    }

    if(!empty($_POST['submit'])) {
        $content = $_POST['con'];
        $hid = $_POST['hid'];
        $sql = "update `news` set `contents`='$content' where `id`='$hid'";
        mysql_query($sql);
        echo "<script>alert('更新成功');location.href='index.php'</script>";
    }
    
?>