Home > Backend Development > PHP Tutorial > PHP deletes page records and refreshes the page at the same time. The deletion conditions are obtained using GET_PHP Tutorial

PHP deletes page records and refreshes the page at the same time. The deletion conditions are obtained using GET_PHP Tutorial

WBOY
Release: 2016-07-21 15:22:08
Original
1008 people have browsed it

Functions:
1. Display query data on a certain page, and add a delete function after each piece of data. Click "Delete" to delete the data and refresh the page at the same time
2. Use GET to obtain deletion conditions
Database connection variables connectvars.php

Copy code The code is as follows:

//Server
define('DB_HOST', 'localhost');
//Username
define('DB_USER', 'root');
//Password
define('DB_PASSWORD', 'root');
//Database
define('DB_NAME','test');
?>

Record display page display.php, each record There is a "Delete" function at the end. Click "Delete" to delete the record and refresh the page at the same time
Copy the code The code is as follows:

require_once 'connectvars.php';
$dbc = mysqli_connect(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME);
//If there is ' in the page link when calling this page DelID' variable, get the 'ID' number of the record to be deleted and delete it
if(isset($_GET['DelID'])){
$query = "DELETE FROM toyota WHERE ID = ".$ _GET['DelID']." LIMIT 1";
mysqli_query($dbc,$query);
}
//Find all records and display them in the next table (if the above The deletion code is executed, which is equivalent to refreshing the page)
$query = "SELECT * FROM toyota ORDER BY ID DESC";
$data = mysqli_query($dbc,$query);
// Count the number of queried records
$count = mysqli_num_rows($data);
?>


Toyota car data View










//Loop output list elements: title, source, carType, majorPart, and then Add a "delete" link
while($row = mysqli_fetch_array($data)){
echo '';
echo '';
echo '';
echo '';
//Click the "Delete" link to call your own page. At the same time, add the 'DelID' variable to the page link and assign it the 'ID' number recorded in the database for GET Get
echo '';
}
?>
Title Source Model Main components< /th>
Operation
'.$row['title'].''.$row['source'].'';
echo '
'.$row['carType'].''.$row['majorPart']. 'Delete';
echo '


< ;/html>

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/324753.htmlTechArticleFunction: 1. Display query data on a certain page, and add a delete function after each piece of data, click "Delete", delete the data and refresh the page at the same time. 2. Use GET method to obtain the deletion item...
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template