欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  后端开发

Android程序员学PHP开发(28)-简单博客系统-PhpStorm

程序员文章站 2022-04-26 18:15:31
...
简单博客系统,发布,编辑,删除,数据库的练习~暂时不考虑安全性,先看GIF动图:

Android程序员学PHP开发(28)-简单博客系统-PhpStorm


看一下数据库截图:

Android程序员学PHP开发(28)-简单博客系统-PhpStorm


好了,看代码:

conn.php:

<?php
    /**
     * mysql_query — 发送一条 MySQL 查询
     */

    /**
     * 连接数据库(返回资源)
     */
    @mysql_connect("127.0.0.1:3306","root","") or die("mysql数据库连接失败");

    /**
     * 选择一个数据库作为默认的数据库使用
     */
    @mysql_select_db("blog")or die("db连接失败");


index.php:

<a href="index.php"><B>index</B></a>
<a href="add.php"><B>add blog</B></a>
<br><br>
<form action="" method="get" style='align:"right"'>
    <input type="text" name="keys" >
    <input type="submit" name="subs" >
</form>
<hr>

<?php
    include("conn.php"); //引入连接数据库

    $sql = "select id,hits,title,date,contents from simpleblog";

    $result = mysql_query($sql); // 只要放一个正确的sql就可以执行

    while (list($id, $hits, $title, $date, $contents) = mysql_fetch_row($result)){ // 遍历表内容
        echo "id = {$id}<br>";
        echo "hits = {$hits}<br>";
        echo "title = {$title}<br>";

        ?>titleLink: <a href="view.php?id=<?php echo $id; ?>"><?php echo $title."<br>"; ?></a><?php

        echo "date = {$date}<br>";
        echo "contents = {$contents}<br>";
        echo "contents = ".iconv_substr($contents,0,15)."...<br>"; // iconv_substr — 截取字符串的部分

        ?>edit: <a href="edit.php?id=<?php echo $id; ?>">edit</a><?php echo "<br>";
        ?>delete: <a href="del.php?id=<?php echo $id; ?>">delete</a><?php echo "<br>";
        echo "--------------------------------------------------<br>";
    }


add.php:

<a href="index.php"><B>index</B></a>
<a href="add.php"><B>add blog</B></a>
<hr>

<?php
    include("conn.php"); //引入连接数据库

    if (!empty($_POST['sub'])) {
        $title = $_POST['title'];  //获取title表单内容
        $con = $_POST['con'];      //获取contents表单内容
        $sql= "insert into simpleblog values(null,'0','$title',now(),'$con')";
        mysql_query($sql);
        echo "insert success!";

    }
?>

<form action="add.php" method="post">
    title   :<br>
    <input type="text" name="title"><br><br>
    contents:<br>
    <textarea rows="5" cols="50" name="con"></textarea><br><br>
    <input type="submit"  name="sub" value="submit">
</form>

view.php:

<a href="index.php"><B>index</B></a>
<a href="add.php"><B>add blog</B></a>
<hr>

<?php

    include("conn.php"); //引入连接数据库

    $id = $_GET['id'];

    $sql = "select id,hits,title,date,contents from simpleblog where id='$id'";

    $result = mysql_query($sql); // 只要放一个正确的sql就可以执行

    while (list($id, $hits, $title, $date, $contents) = mysql_fetch_row($result)) { // 遍历表内容
        echo "id = {$id}<br>";
        echo "hits = {$hits}<br>";
        echo "title = {$title}<br>";

        ?>titleLink: <a href="view.php?id=<?php echo $id; ?>"><?php echo $title."<br>"; ?></a><?php

        echo "date = {$date}<br>";
        echo "contents = {$contents}<br>";
        echo "contents = ".iconv_substr($contents,0,15)."...<br>"; // iconv_substr — 截取字符串的部分

        ?>edit: <a href="edit.php?id=<?php echo $id; ?>">edit</a><?php echo "<br>";
        ?>delete: <a href="del.php?id=<?php echo $id; ?>">delete</a><?php echo "<br>";
    }

edit.php:


<a href="index.php"><B>index</B></a>
<a href="add.php"><B>add blog</B></a>
<hr>

<?php
    include("conn.php"); //引入连接数据库

    //获取数据库表数据
    if (!empty($_GET['id'])) {
        $edit = $_GET['id'];
        $sql = "select * from simpleblog where id='$edit'";
        $query = mysql_query($sql);
        $rs = mysql_fetch_array($query);
    }

    //更新数据库表数据
    if (!empty($_POST['sub'])) {
        $title = $_POST['title'];  //获取title表单内容
        $con = $_POST['con'];      //获取contents表单内容
        $hid = $_POST['hid'];
        $sql= "update simpleblog set title='$title', contents='$con' where id='$hid' ";
        mysql_query($sql);
        echo "<script>alert('update success.');location.href='index.php'</script>";

    }
?>

<form action="edit.php" method="post">
    <input type="hidden" name="hid" value="<?php echo $rs['id'];?>">
    title   :<br>
    <input type="text" name="title" value="<?php echo $rs['title'];?>">
    <br><br>
    contents:<br>
    <textarea rows="5" cols="50" name="con" ><?php echo $rs['contents'];?></textarea><br><br>
    <input type="submit"  name="sub" value="submit">
</form>

del.php:

<a href="index.php"><B>index</B></a>
<a href="add.php"><B>add blog</B></a>
<hr>

<?php
    include("conn.php"); //引入连接数据库

    if (!empty($_GET['id'])) {
        $del = $_GET['id'];  //删除blog
        $sql= "delete from simpleblog where id='$del' ";
        mysql_query($sql);
        echo "delete success!";
    }
?>


以上就是Android程序员学PHP开发(28)-简单博客系统-PhpStorm的内容,更多相关内容请关注PHP中文网(www.php.cn)!