-PHP and MySQL, JSON, and-phpmysqljson. -PHP and MySQL, JSON, and-phpmysqljsonhi ~ 1. the php and mysql5.4 interfaces are also interfaces and programs. Interface article. modify. php? Phprequire_once (... connect. php); read-PHP and MySQL, JSON,-phpmysqljson
Hi
Coding ~
1. php and mysql
5.4 modify interface
The same interface and program.
Interface article. modify. php
Require_once ('../connect. php ');
// Read the old information
$ Id = $ _ GET ['id'];
$ Query = mysqli_query ($ con, "select * from article where id = $ id ");
$ Data = mysqli_fetch_assoc ($ query );
?>
Untitled Document
Background management system |
Publish an article Manage articles |
|
Copyright |
The key point is php reading and php calling of values in html.
Modify program article. modify. handle. php
// If it is related to the database, write such a sentence unconditionally
Require_once ('../connect. php ');
// Accept the modified data (Form transfer)
$ Id = $ _ POST ['id'];
$ Title = $ _ POST ['title'];
$ Author = $ _ POST ['author'];
$ Description = $ _ POST ['description'];
$ Content = $ _ POST ['content'];
$ Dateline = time ();
// Write the SQL modification statement, determine whether the statement is successful, and switch back to the modification page.
$ Updatesql = "update article set title = '$ title', author =' $ author', description = '$ description', content =' $ content ', dateline = $ dateline where id = $ id ";
If (mysqli_query ($ con, $ updatesql )){
Echo "script" alert ('Article modified successfully'); window. location. href = 'article. manage. php'; script ";
} Else {
Echo "script" alert ('document modification failed'); window. location. href = 'article. manage. php'; script ";
}
?>
5.5 delete an article
Requirement analysis first: the requirements are slightly different from those above,Deleting an article requires no interface. you only need a delete button to delete it.. So there is only one file. The key SQL statement has only one sentence.
$ Delsql = "delete from article where id = $ id ";
Aritcle. del. handle. php
Require_once ('../connect. php ');
// Read the ID. Unlike others, there are passed values.
$ Id = $ _ GET ['id'];
$ Deletesql = "delete from article where id = $ id ";
If (mysql_query ($ deletesql )){
Echo "script" alert ('Article deleted successfully'); window. location. href = 'article. manage. php'; script ";
} Else {
Echo "script" alert ('document deletion failed'); window. location. href = 'article. manage. php'; script ";
}
?>
5.6 article Management list
Requirement Analysis: The list shows all the articles, followed by two buttons, delete (link to the delete Module in the previous section) and modify (link to the previous module)
Therefore, only one file is needed, and the display module is good.
Article. manage. php
Require_once ('../connect. php ');
$ SQL = "select * from article order by dateline desc ";
$ Query = mysqli_query ($ con, $ SQL );
If ($ query & mysqli_num_rows ($ query )){
While ($ row = mysqli_fetch_assoc ($ query )){
$ Data [] = $ row;
}
} Else {
$ Data = array ();
}
?>
Untitled Document
Background management system |
Publish an article Manage articles |
Article Management list |
No. |
Title |
Operation |
If (! Empty ($ data )){Foreach ($ data as $ value ){?>
|
|
"> Delete"> Modify |
|
Copyright |
5.7 Function Summary
Mysqli_connect ()
Mysqli_select_db ()
Mysqli_query ()
Mysqli_error ()
Mysqli_fetch_assoc ()
Mysqli_num_rows ()
VI. Development of the foreground Management Interface
6.1 Article list
Article. list. php
Require_once ('connect. php ');
$ SQL = "select * from article order by dateline desc ";
$ Query = mysqli_query ($ con, $ SQL );
If ($ query & mysqli_num_rows ($ query )){
While ($ row = mysqli_fetch_assoc ($ query )){
$ Data [] = $ row;
}
}
?>
Article publishing system
Php and mysql
- Article
- About Us
- Contact us
If (empty ($ data )){
Echo "there are no articles currently. ask the administrator to add articles in the background ";
} Else {
Foreach ($ data as $ value ){
?>
Array (Size = 2)0 =>
String
'username' (length=8) 1 =>
String
'age' (length=3)
["Username", "age"]
A: 2: {I: 0; s: 8: "username"; I: 1; s: 3: "age ";}
-- Common JSON Functions
Json_encode () -- JSON encryption
Json_decode () -- decrypt
1.3 JSON instance description
Hi, knock on the code ~ 1. the interface for modifying php and mysql 5.4 is the same as the interface and program. Interface article. modify. php? Php require_once ('../connect. php'); // read...