Just in touch with PHP in the video to write a news management system which also used the bootstrap framework
Write it down and organize your thoughts.
This is a very simple system, the first 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 () not null,//This is the headline of the News
-> keywords varchar () Not null,//This is the key word of the news
-> author varchar () not null,//This is the author of the News
-> addtime int unsigned not null,//This is the time to add news
-> content text not NULL);//This is the news.
In this way, the database table is built, and the following begins to write the page.
First 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 it's a menu.php file.
<title>Html5&bootstrap</title>
-->
News management System
- Browse News
- Release News
<script type= "Text/javascript" src= "Bootstrap-3.2.0-dist/js/jquery-1.9.1.min.js" ></script>
<script type= "Text/javascript" src= "Bootstrap-3.2.0-dist/js/bootstrap.js" ></script>
<script type= "Text/javascript" src= "Prettify-4-mar-2013/prettify.js" ></script>
After two simple work done above, it's time to do the homepage http://blog.csdn.net/q114942784/article/details/index.php:
First, import the navigation bar menu.php
Then add a title and a table.
Browse News
Require ("dbconfig.php");
2. Link MySQL, select database
$link = @mysql_connect (Host,user,pass) or Die ("Link Database error!") ");
mysql_select_db (dbname, $link);
3. Execute query, return 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);
?>
1. Import configuration file
News ID |
title |
Key Words |
author |
Time |
content |
Operation |
";
{$row [' id ']} | ";
{$row [' Tilte ']} | ";
{$row [' keywords ']} | ";
{$row [' Author ']} | ";
{$row [' Addtime ']} | ";
{$row [' content ']} | ";
The "#" here is just a code name, the back will replace it, because the additions and deletions of the operation is more complex, so write a separate action.php file Modify
| ";
"
action.php:
This is a data to delete the deletion of the page to check
1. Import configuration file
Require ("dbconfig.php");
2. Link MySQL and select database
$link = @mysql_connect (Host,user,pass) or Die ("Database link failed");
mysql_select_db (dbname, $link);
3. According to the value of the action, to determine the operation, to execute the appropriate code
Switch ($_get["action"]) {
Case "Add":
1. Get the information you want to add, add additional information
$tilte =$_post["title"];
$keywords =$_post["keywords"];
$author =$_post["Author"];
$content =$_post["Content"];
$addtime =time ();
2. Filtering of information
3. Splicing the SQL statements and performing the appropriate actions
$sql =insert into News value (NULL, ' ($title) ', ' ($keywords) ', ' ($author) ', $addtime, ' ($content) ');
mysql_query ($sql, $link);
4. Determine whether the success
$id =mysql_insert_id ($link);
if ($id >0) {
echo "
News information added successfully
";
}
else{
echo "
News information added failed
";
}
Echo ("return");
Echo ("Browse News");
Break
Case "Del":
1. Get the news ID to delete:
$id =$_get[' id '];
2. Assemble and delete the SQL statements and perform the appropriate delete operations
$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 you want to modify
$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 SQL statements and perform modification operations
$sql = "Update news set title=" ($title), keywords= ' ($keywords) ', author= ' ($author) ', content= ' ($content) ' where id= ($id )";
Echo $sql;
mysql_query ($sql, $link);
4. Jump to browse interface
Header ("location:http://blog.csdn.net/q114942784/article/details/index.php");
Break
}
4. Close the database link
Mysql_close ("$link");
?>
The following writes the page http://blog.csdn.net/q114942784/article/details/add.php file that adds the news:
Release News
Title |
|
Key words |
|
Author |
|
Content |
|
|
Then is the edited page edit.php page:
1. Import configuration file
Require ("dbconfig.php");
2. Connect MySQL, select database
$link = @mysql_connect (Host,user,pass) or Die ("Database link failed");
mysql_select_db (dbname, $link);
3. Get the ID of the information you want to modify and assemble the SQL statement, execute the query, get the information to modify
$sql = "SELECT * from news where id={$_get[' id ']}";
$result =mysql_query ($sql, $link);
4. Determine if the information to be modified is obtained
if ($result && mysql_num_rows ($result) >0) {
$news =mysql_fetch_assoc ($result);
}else{
Die ("No information was found to be modified");
}
?>
Edit News
Title |
|
Key words |
|
Author |
|
Content |
<?php echo $news [' content '];?> |
|
Finally, to mention, delete and modify the "#" with what to replace
Here for the humanization of some, with the JS code to give a hint
<script type= "Text/javascript" >
function Dodel (ID) {
if (Confirm (ok to delete)) {
window.location= "action.php?action=del&id=" +ID;
}
}
</script>
First "#", replace with Javascript:dodel ({$row ["id]}")
The second "#", with edit.php? id={$row ["id"]} instead
At this point, a complete PHP news management system is basically completed, tomorrow to improve.