PHP practical news management system using bootstrap framework_PHP tutorial

PHP practical news management system uses the bootstrap framework

I just came into contact with PHP and I wrote a news management system imitating the video, which also used the bootstrap framework

Write it down to organize your thoughts.

This is a very simple system. The first step is to create a database table.

mysql>create database newsdb

mysql> create table news(
-> id int unsigned not null auto_increment primary key,//This is the id of the news
-> title varchar(64) not null,//This is the title of the news
-> keywords varchar(64) not null,//This is the keyword of the news
-> author varchar(16) not null,//This is the author of the news
-> addtime int unsigned not null,//This is the adding time of the news
-> content text not null);//This is the content of the news

In this way, the database table is completed, and now we can start writing the page.

First, I wrote a database configuration file dbconfig.php:

define(HOST,"localhost");//Host name

define(USER,"root");//Username

define(PASS,"");//Password

define(DBNAME,"newsdb");//Database name

?>

Then there is a menu.php file

body{background:orange;}
@media(max-width:997px){body{background:#0FC;}}

News Management System
• 
  Browse news
• 
  Publish news

  ---

  
  

After completing the above two simple steps, it is time to write the homepage http://blog.csdn.net/q114942784/article/details/index.php:

First, import the navigation bar menu.php

Then add a title and table

Browse news

//1.导入配置文件

require("dbconfig.php");

//2.链接mysql，选择数据库

$link=@mysql_connect(HOST,USER,PASS) or die("链接数据库出错！");

mysql_select_db(DBNAME,$link);

//3.执行查询，返回结果集

$sql="select * from news order by addtime desc";

$result=mysql_query($sql,$link);

//4.解析结果集，并遍历输出

while($row=mysql_fetch_assoc($result)){

echo"

";

echo"

";

echo"

";

echo"

";

echo"

";

echo"

";

echo"

";

echo"

";

echo"

"

}

//5.释放结果集

mysql_free_result(&result);

musql_close($link);

?>

新闻id	标题	关键字	作者	时间	内容	操作
{$row['id']}	{$row['tilte']}	{$row['keywords']}	{$row['author']}	{$row['addtime']}	{$row['content']}	删除;//此处的“#”只是一个代号，后面会把它替换掉,由于增删操作比较复杂，所以单独写一个action.php文件 修改;

//1. Import configuration file require("dbconfig.php"); //2. Link to mysql and select the database $link=@mysql_connect(HOST,USER,PASS) or die("Error in linking database!"); mysql_select_db(DBNAME,$link); ///3. Execute the query and return the result set $sql="select * from news order by addtime desc"; $result=mysql_query($sql,$link); //4. Parse the result set and traverse the output while($row=mysql_fetch_assoc($result)){ echo""; echo""; echo""; echo""; echo""; echo""; echo""; echo""; echo"" } //5. Release the result set mysql_free_result(&result); musql_close($link); ?>

News id	Title	Keywords	Author	Time	Content	Operation
{$row['id']}	{$row['tilte']}	{$row['keywords']}	{$row['author']}	{$row['addtime']}	{$row['content']}	Delete;//The "#" here is just a code name, which will be replaced later. Since the addition and deletion operations are complicated, write a separate action.php file Modify;

action.php：

//This is a page for adding, deleting, modifying and checking data

//1. Import configuration file

require("dbconfig.php");

//2. Link to mysql and select the database

$link=@mysql_connect(HOST,USER,PASS) or die("Database link failed");

mysql_select_db(DBNAME,$link);

//3. Based on the value of action, determine the operation and execute the corresponding code

switch($_GET["action"]){

case "add":

//1. Obtain the information to be added and supplement other information

$tilte=$_POST["title"];

$keywords=$_POST["keywords"];

$author=$_POST["author"];

$content=$_POST["content"];

$addtime=time();

//2. Information filtering

//3. Splice sql statements and perform corresponding operations

$sql=insert into news value(null,'($title)','($keywords)','($author)',$addtime,'($content)');

mysql_query($sql,$link);

//4. Determine whether it is successful

$id=mysql_insert_id($link);

if($id>0){

echo "

News information added successfully

";

}

else{

echo "

Failed to add news information

";

}

echo("return");

echo("Browse news");

break;

case "del":

///1. Get the news id to be deleted:

$id=$_GET['id'];

//2. Assemble the delete sql statement and perform the corresponding deletion operation

$sql="delete from news where id=($id)";

mysql_query($sql,$link);

//3. Automatically jump to the news browsing interface after deletion

header("location:http://blog.csdn.net/q114942784/article/details/index.php");

break;

case "update":

//1. Get the information to be modified
$title = $_POST['title'];
$keywords = $_POST['keywords'];
$author = $_POST['author'];
$content = $_POST['content'];
$id = $_POST['id'];
//2. Filter the information to be modified (omitted here)
//3. Assemble and modify the sql statement and perform the modification operation
$sql="update news set title="($title)",keywords='($keywords)',author='($author)',content='($content)' where id=($id)" ;
//echo $sql;
mysql_query($sql,$link);
//4. Jump to the browsing interface
header("location:http://blog.csdn.net/q114942784/article/details/index.php");

break;

}

//4. Close the database link

mysql_close("$link");

?>

Write the page to add news below http://blog.csdn.net/q114942784/article/details/add.php file:

Publish news

Then the edited page edit.php page:

//1.Import configuration file
require("dbconfig.php");

//2. Connect to mysql and select the database
$link=@mysql_connect(HOST,USER,PASS)or die("Database link failed");
mysql_select_db(DBNAME,$link);
//3. Get the ID of the information to be modified, assemble and view the sql statement, execute the query, and obtain the information to be modified
$sql="select * from news where id={$_GET['id']}";
$result=mysql_query($sql,$link);
//4. Determine whether the information to be modified has been obtained
if($result && mysql_num_rows($result)>0){
$news=mysql_fetch_assoc($result);
}else{
die("No information found to be modified");
}

?>

Editor News

Finally, let me mention what should be used to replace the deleted and modified "#"

In order to be more humane, a tip is given using js code

For the first "#", use javascript: dodel({$row["id"]}) to replace

For the second "#", use edit.php? id={$row["id"]}replacement

At this point, a complete php news management system is basically completed. It will be improved tomorrow.

http://www.bkjia.com/PHPjc/871191.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/871191.htmlTechArticlePHP actual news management system uses the bootstrap framework. I just came into contact with PHP. I wrote a news management system based on the video and also used it. Write down the bootstrap framework to sort out your ideas. ...