Android程序员学PHP开发(28)-简单博客系统-PhpStorm
程序员文章站
2022-04-26 18:15:31
...
简单博客系统,发布,编辑,删除,数据库的练习~暂时不考虑安全性,先看GIF动图:
看一下数据库截图:
好了,看代码:
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)!
上一篇: JS组合按键事件监听插件的详细介绍
推荐阅读
-
Android程序员学PHP开发(20)-数组(2)多维数组和实际应用-PhpStorm
-
Android程序员学PHP开发(22)-超全局数组/超全局变量-PhpStorm
-
Android程序员学PHP开发(23)-数组操作相关函数(1)键名键值篇-PhpStorm
-
Android程序员学PHP开发(24)-数组操作相关函数(2)回调函数篇-PhpStorm
-
Android程序员学PHP开发(25)-数组操作相关函数(3)拆组排列篇-PhpStorm
-
Android程序员学PHP开发(26)-简单留言板-PhpStorm
-
Android程序员学PHP开发(29)-ThinkPHP5.0(1)初体验-PhpStorm
-
Android程序员学PHP开发(27)-数据库练习-PhpStorm
-
Android程序员学PHP开发(15)-dowhile-for-goto-function-PhpStorm
-
Android程序员学PHP开发(28)-简单博客系统-PhpStorm