简单博客系统，发布，编辑，删除，数据库的练习~暂时不考虑安全性，先看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<mark style="color:transparent">本文来源gaodaimacom搞#^代%!码&网*</mark><pre>搞代gaodaima码
" ></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的内容，更多相关内容请随时关注我们网站！
转载请注明原文链接：Android程序员学PHP开发(28)-简单博客系统-PhpStorm
