Home  >  Article  >  Backend Development  >  How to delete a row of records in php

How to delete a row of records in php

藏色散人
藏色散人Original
2021-05-10 09:00:232157browse

How to delete a row of records in php: 1. Modify the database connection username and password, database name and data table name; 2. Delete a row of records through the "function del(id){...}" method .

How to delete a row of records in php

The operating environment of this article: windows7 system, PHP7.1 version, DELL G3 computer

php deletes a record (delete confirmation prompt )

echo &#39;<a href="www.xxx.com/11.php?id=你要删除记录" confirm("是否真的要删除当前记录?")">删除</a>&#39;.

Of course, you can also use the following method to delete the instance. The code is as follows:

<script language=&#39;javascript&#39;> 
function del(id){ 
    if (false === confirm(&#39;是否真的要删除当前记录?&#39;) )return; 
    location.href = &#39;delete.php?id=&#39; + id; 
} 
</script>

Here you only need to modify your database connection username and password, the database name and the data table name. That’s it.

<?php 
    $conn = mysql_connect("localhost","root","8588027"); 
    mysql_select_db("test"); 
    $exec="delete from content where id=&#39;{$_get[&#39;id&#39;]}&#39;"; 
    mysql_query($exec); 
    mysql_close(); 
    echo "<script language=&#39;javascript&#39;>location.href=&#39;code.php&#39;;</script>"; 
?>

Recommended study: "PHP Video Tutorial"

The above is the detailed content of How to delete a row of records in php. For more information, please follow other related articles on the PHP Chinese website!

Statement:
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