沃梦达 / 编程问答 / php问题 / 正文

如何使用pdo从sql中删除数据?

How to delete data from sql with pdo?(如何使用pdo从sql中删除数据?)

本文介绍了如何使用pdo从sql中删除数据?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

您好,我整天都在网上搜索,试图找到使用 pdo 时删除数据的示例,但我只找到了它的 MySQL 和 MySQLi,我卡住了,我运行它时看不到我遗漏了什么,它给了我/search.php?del=Array(id).这是我的代码,请帮忙

Hello I have search the web all day trying to find example of deleting data when I use pdo but all i found its MySQL and MySQLi and I am stuck i can't see what I am missing when I run it it give me /search.php?del=Array(id). This its my code please help

<?php 
//load database connection
    $host = "localhost";
    $user = "abcd";
    $password = "******";
    $database_name = "abcd";
    $pdo = new PDO("mysql:host=$host;dbname=$database_name", $user, $password, array(
    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
    ));
// Search from MySQL database table




$search=$_POST['search'];
$query = $pdo->prepare("select * from wfuk where post_code LIKE '%$search%' OR telephone LIKE '%$search%'  LIMIT 0 , 10");
$query->bindValue(1, "%$search%", PDO::PARAM_STR);
$query->execute();
// Display search result
?>
<html>
<head>
<title> How To Create A Database Search With MySQL & PHP Script | Tutorial.World.Edu </title>
</head>
<body>
<form action="search.php" method="post">
Search: <input type="text" name="search" placeholder=" Search here ... "/>
<input type="submit" value="Submit" />
</form>
<?php
         if (!$query->rowCount() == 0) {
		 		echo "Search found :<br/>";
				echo "<table style="font-family:arial;color:#333333;">";	
                echo "<tr>
				<td style="border-style:solid;border-width:1px;border-color:#98bf21;background:#98bf21;">First Name</td>
				<td style="border-style:solid;border-width:1px;border-color:#98bf21;background:#98bf21;">Last Name</td>
				<td style="border-style:solid;border-width:1px;border-color:#98bf21;background:#98bf21;">Trade</td>
				<td style="border-style:solid;border-width:1px;border-color:#98bf21;background:#98bf21;">Post Code</td>
				<td style="border-style:solid;border-width:1px;border-color:#98bf21;background:#98bf21;">Telephone</td>
				<td style="border-style:solid;border-width:1px;border-color:#98bf21;background:#98bf21;">Comments</td>
				<td style="border-style:solid;border-width:1px;border-color:#98bf21;background:#98bf21;">To be use</td></tr>";			
            while ($results = $query->fetch()) {
				
				echo "<tr><td style="border-style:solid;border-width:1px;border-color:#98bf21;">";			
                echo $results['first_name'];
				
				echo "</td><td style="border-style:solid;border-width:1px;border-color:#98bf21;">";			
                echo $results['last_name'];
				
				echo "</td><td style="border-style:solid;border-width:1px;border-color:#98bf21;">";			
                echo $results['trade'];
				
				echo "</td><td style="border-style:solid;border-width:1px;border-color:#98bf21;">";			
                echo $results['post_code'];
				
				echo "</td><td style="border-style:solid;border-width:1px;border-color:#98bf21;">";
                echo $results['telephone'];
				
				echo "</td><td style="border-style:solid;border-width:1px;border-color:#98bf21;">";
                echo $results['comments'];
				
				echo "</td><td style="border-style:solid;border-width:1px;border-color:#98bf21;">";
				echo $results['id'];
                //this its my button for delete
				echo("<button onclick="location.href='search.php?del=$results(id)'">delete user</button>"); 
                
				echo "</td></tr>";				
            }
				echo "</table>";	

        } else {
            echo 'Nothing found';
        }
?>

推荐答案

我会从这样的事情开始:

I would start with something like this:

    $con =  new PDO( "mysql:host=".$dbHost.";"."dbname=".$dbName, $dbUsername, $dbUserPassword); 
    $con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $sql = "DELETE FROM `table` WHERE id = ?";        
    $q = $con->prepare($sql);

    $response = $q->execute(array($id));                

这篇关于如何使用pdo从sql中删除数据?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本文标题为:如何使用pdo从sql中删除数据?

基础教程推荐