本文介紹了如何使用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中刪除數據?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！
【網站聲明】本站部分內容來源于互聯網,旨在幫助大家更快的解決問題，如果有圖片或者內容侵犯了您的權益，請聯系我們刪除處理，感謝您的支持！