How to implement click-to-delete code in php

php method to implement click-to-delete code: 1. Create a PHP sample file and connect to the database; 2. Query the database; 3. Call the javascript method at the hyperlink deletion point and pass the record id.

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

How to achieve click-to-delete code in php?

php combined with js to realize the deletion confirmation operation by clicking on the hyperlink

As the title says, this time we want to realize the execution of the js code by clicking on the hyperlink and confirm whether to delete the database data, using php .

First connect to the database and query the database data:

The code is as follows:

<?php
$dbms=&#39;mysql&#39;;                         //数据库类型 ,对于开发者来说，使用不同的数据库，只要改这个，不用记住那么多的函数
$host=&#39;localhost&#39;;                     //数据库主机名
$dbName=&#39;db_database19&#39;;            //使用的数据库
$user=&#39;root&#39;;                          //数据库连接用户名
$pass=&#39;root&#39;;                          //对应的密码
$dsn="$dbms:host=$host;dbname=$dbName";
try {
$pdo = new PDO($dsn, $user, $pass);     //初始化一个PDO对象，就是创建了数据库连接对象$pdo
$query="select * from tb_pdo_mysql";    //定义SQL语句
$result=$pdo->prepare($query);            //准备查询语句
$result->execute();                        //执行查询语句，并返回结果集
while($res=$result->fetch(PDO::FETCH_ASSOC)){        //while循环输出查询结果集，并且设置结果集的为关联索引
?>     
<tr>
<td height="22" align="center" valign="middle"><?php echo $res[&#39;id&#39;];?></td>
<td align="center" valign="middle"><?php echo $res[&#39;pdo_type&#39;];?></td>
<td align="center" valign="middle"><?php echo $res[&#39;database_name&#39;];?></td>
<td align="center" valign="middle"><?php echo $res[&#39;dates&#39;];?></td>
<td align="center" valign="middle"><a href="javascript:del(<?php echo $res[&#39;id&#39;]?>)">删除</a></td>
</tr>
<?php
}
} catch (PDOException $e) {
die ("Error!: " . $e->getMessage() . "<br/>");
}
?>

Call a javascript method at the hyperlink deletion point, pass the record id, the js method is:

The code is as follows:

<script>
     function del(_id) {
         if (confirm("确认删除"))
         {
             window.location.href="index.php?conn_id="+_id;    //本页面刷新
         }
 }
 </script>

Delete database record code:

The code is as follows:

<?php
    if(@$_GET[&#39;conn_id&#39;]!=""){
    $dbms=&#39;mysql&#39;;                         //数据库类型 ,对于开发者来说，使用不同的数据库，只要改这个，不用记住那么多的函数
    $host=&#39;localhost&#39;;                     //数据库主机名
    $dbName=&#39;db_database19&#39;;            //使用的数据库
    $user=&#39;root&#39;;                          //数据库连接用户名
    $pass=&#39;root&#39;;                          //对应的密码
    $dsn="$dbms:host=$host;dbname=$dbName";
    try {
        $pdo = new PDO($dsn, $user, $pass);     //初始化一个PDO对象，就是创建了数据库连接对象$pdo
        $pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
        $query="delete from tb_pdo_mysql where Id=:id";
        $result=$pdo->prepare($query);            //预准备语句
        $result->bindParam(&#39;:id&#39;,$_GET[&#39;conn_id&#39;]);        //绑定更新的数据
        $result->execute();
    } catch (PDOException $e) {
        echo &#39;PDO Exception Caught.&#39;;
        echo &#39;Error with the database:<br/>&#39;;
        echo  &#39;SQL Query: &#39;.$query;
        echo &#39;<pre class="brush:php;toolbar:false">&#39;;
        echo "Error: " . $e->getMessage(). "<br/>";       
        echo "Code: " . $e->getCode(). "<br/>";
        echo "File: " . $e->getFile(). "<br/>";
        echo "Line: " . $e->getLine(). "<br/>";
        echo "Trace: " . $e->getTraceAsString(). "<br/>";
        echo &#39;

This code is placed at the beginning of the body part of the html page, which is the worst It should also be placed before the query record code.

Recommended learning: "PHP Video Tutorial"

The above is the detailed content of How to implement click-to-delete code in php. For more information, please follow other related articles on the PHP Chinese website!