PHP implementation of simple news release system example

PHP implementation of simple news release system example_php skills

WBOY

Release： 2016-05-16 20:09:58

Original

1397 people have browsed it

The example in this article describes the implementation of a simple news release system in PHP. Share it with everyone for your reference. The details are as follows:

I am a novice and have been writing PHP using templates and frameworks in my company. I found that sometimes I even forget basic SQL statements, so I want to review and consolidate the basics of PHP when I have time. Pagination, search, and sorting have not been written yet, and will be updated later... (Code modification: add search and paging functions)

articlePublish.html:

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" 
"http://www.w3.org/TR/html4/loose.dtd">
<html lang="en">
 <head>
<meta http-equiv="Content-Type" content="text/html; charset=utf8">
<title>Insert title here</title>
</head>
<body bgcolor="#ccc">
 <form name="article" method="post" action="articlePublishDo.php" style="margin:5px 500px;">
   <h1>发布新闻系统</h1>
  标题：<input type="text" name="title"/><br/>
  内容：<textarea cols=30 rows=5 name="content"></textarea><br/><br/>
   <input type="submit" value="发布新闻"/>
 </form>
</body>
</html>

Copy after login

articlePublishDo.php:

<&#63;php
 header("content-type:text/html;charset=utf8");
 date_default_timezone_set('Asia/Shanghai');
 $title=trim($_POST['title']);
 $content=trim($_POST['content']);
 $time=date("y-m-d H:i:s");
 require_once 'init.php';
 $sql="insert into article(title,content,create_time) values('$title','$content','$time')";
 //echo $sql;
 $re=mysql_query($sql);//执行sql语句
 if($re){
  echo "发布成功";
  echo '<a href="articleList.php">返回文章列表</a>';
 }else{
  echo "发布失败";
  echo '<a href="articleList.php">返回文章列表</a>';
 }
 mysql_close();//关闭数据库

Copy after login

articleList.php：

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf8">
<title>Insert title here</title>
</head>
<body>
<!--
 搜索框
-->
 <form method="get" action="articleList.php" style="margin:10px 400px;">
  <input type="text" name="search"/>
  <input type="submit" value="搜索"/>
 </form>
 <br/>
 <table cellspacing="0" cellpadding="0" align="center" bgcolor="#ccc" width=500 >
 <a href="articlePublish.html" style="padding:20px 30px">返回发布文章</a>
  <tr>
   <th>编号</th>
   <th>文章标题</th>
   <th>文章内容</th>
   <th>编辑文章</th>
  </tr>
  <&#63;php
   require_once 'init.php';
   /**
    * 搜索
    */
   $keyword=$_GET['search'];
   /*分页*/
   $sql="select count(*) from article where title like '%$keyword%' or content like '%$keyword%'";
   $res=mysql_query($sql);
   //$count= (int)mysql_num_rows($result);
   $arr=mysql_fetch_assoc($res);
   while(list($key,$val)=each($arr)){
    $count = (int)$val; 
   }
   //echo $count;
   $pageSize=4;
   $page=floor($count/$pageSize)+1;//总页数$page
   echo $page;
   //echo $page;
   if(isset($_GET['page']))
   {
    //$currentPage = $_GET['page'];
    if($_GET['page'] <=1){
     $currentPage = 1;
    }elseif ($_GET['page'] >= $page){
     $currentPage = $page-1;
    }else{
     $currentPage = $_GET['page'];
    }
   }else
   {
    $currentPage=1;
   }
   $start = ($currentPage-1)*$pageSize;
   $sql="select id,title,content from article where title like '%$keyword%' or content like '%$keyword%' limit $start,$pageSize";
   //echo $sql;
   $re=mysql_query($sql);//执行sql语句
   while($arr=mysql_fetch_assoc($re)){
  &#63;> 
    <tr>
     <td align="center" style="border:1px solid #000"><&#63;php echo $arr['id'];&#63;></td>
     <input type="hidden" name="id" value="<&#63;php echo $arr['id'];&#63;>"/>
     <td align="center" style="border:1px solid #000"><&#63;php echo $arr['title'];&#63;></td>
     <td align="center" style="border:1px solid #000"><&#63;php echo $arr['content'];&#63;></td>
     <td align="center" style="border:1px solid #000">
      <a href="articleEdit.php&#63;id=<&#63;php echo $arr['id']&#63;>"><font color="red">修改</font></a>
      <a href="articleDelete.php&#63;id=<&#63;php echo $arr['id']&#63;>"><font color="red">删除</font></a>
     </td>
    </tr>
  <&#63;php 
    }
   mysql_close();//关闭数据库
  &#63;>
 </table>
 <div style="margin:20px 400px;">
  共<&#63;php echo $page&#63;>页 |查到<&#63;php echo $count;&#63;>条记录
  当前第<&#63;php echo $_GET['page']&#63;>页|
  <a href="articleList.php&#63;page=1&search=<&#63;php echo $keyword&#63;>">首页</a>
  <a href="articleList.php&#63;page=<&#63;php echo ($currentPage-1)&#63;>&search=<&#63;php echo $keyword&#63;>">|上一页</a>
  <a href="articleList.php&#63;page=<&#63;php echo ($currentPage+1)&#63;>&search=<&#63;php echo $keyword&#63;>">|下一页</a>
  <a href="articleList.php&#63;page=<&#63;php echo $page&#63;>&search=<&#63;php echo $keyword&#63;>">|末页</a>
 </div>
</body>
</html>

Copy after login

articleEdit.php:

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" 
"http://www.w3.org/TR/html4/loose.dtd">
<html lang="en">
 <head>
<meta http-equiv="Content-Type" content="text/html; charset=utf8">
<title>Insert title here</title>
</head>
<body bgcolor="#ccc">
<&#63;php 
   $id=(int)$_GET['id'];
   require_once 'init.php';
   $sql="select id,title,content from article where id = '$id'";
   //echo $sql;
   $re=mysql_query($sql);//执行sql语句
   $arr=mysql_fetch_assoc($re);
   //var_dump($arr);
   mysql_close();//关闭数据库
    
&#63;>
 <form name="article" method="post" action="articleUpdate.php" style="margin:5px 500px;">
   <h1>文章发布系统</h1>
   <input type="hidden" name="id" value="<&#63;php echo $arr['id']&#63;>"/><br/>
  标题:<input type="text" name="title" value="<&#63;php echo $arr['title']&#63;>"/><br/>
  内容:<textarea cols=30 rows=5 name="content"><&#63;php echo $arr['content']&#63;></textarea><br/><br/>
   <input type="submit" value="修改文章"/>
   <a href="articleList.php">返回文章列表</a>
   <a href="articlePublish.html">返回发布文章</a>
 </form>
</body>
</html>

Copy after login

articleUpdate.php:

<&#63;php
 header("content-type:text/html;charset=utf8");
 $arr=$_POST;
 $id=(int)$arr['id'];
 require_once 'init.php';
 $sql="update article set title = '$arr[title]',content = '$arr[content]' where id = '$id'";
 //echo $sql;
 $re=mysql_query($sql);//执行sql语句
 //echo $re;
 if($re){
  echo "修改成功";
  echo "<a href='articleList.php'>返回文章列表</a>";
 }else{
  echo "修改失败";
  echo "<a href='articleList.php'>返回文章列表</a>";
 }
 mysql_close();//关闭数据库

Copy after login

articleDelete.php:

<&#63;php
 header("content-type:text/html;charset=utf8");
 require_once 'init.php';
 $id=(int)$_GET['id'];
 $sql="delete from article where id = '$id'";
 //echo $sql;
 $re=mysql_query($sql);
 if($re){
  echo "删除成功";
  echo "<a href='articleList.php'>返回文章列表</a>";
 }else{
  echo "删除失败";
  echo "<a href='articleList.php'>返回文章列表</a>";
 }

Copy after login

init.php:

<&#63;php
 //连接数据库
 //五步走
 //往数据库添加文章
 $conn=mysql_connect("localhost","root","");//链接数据库
 //echo $conn;
 $re=mysql_select_db("article");//选择数据库
 mysql_query("set names utf8");//设置交互字符集

Copy after login

Summary of basic knowledge:

Article Publishing System

1.articlePublish.html publish article page, submit to articlePublishDo.php page, execute writing to database

2.articleList.php article list page

3. Click Edit, modify the article and submit it to the aiticleEdit.php form page (echo)

4. Click the Modify Article button to submit to articleUpdate.php

I hope this article will be helpful to everyone’s PHP programming design.