php - 删除表格条目的按钮

Question

我想要一个按钮来删除它旁边的表格条目。但我做空了。我似乎在这里打错了什么是我的尝试:

<td><a href="delete-quote.php?id=<?php echo $row['id'];?>"><button class="btn-danger-dark">Delete</button></a></td>

但是好像不行。我只收到 ELSE 错误消息

我尝试了一些小改动，但没有任何影响。我很确定它是我遗漏的一些小东西。

我的 delete-quote.php 代码:

<?php

$id = $_GET['id'];
//Connect DB
// on success delete : redirect the page to original page
$dbname = "siyakhat_ibroker";
$conn = mysqli_connect("localhost", "siyakhat_root", "*****", $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}

// sql to delete a record
$sql = "DELETE FROM prerequest WHERE id = $id"; 

if (mysqli_query($conn, $sql)) {
mysqli_close($conn);
header('Location: manage-quotes.php'); 
exit;
} else {
echo "Error deleting record";
}
?>

更新

我的 dbconnect.php

<?php

$mysql_hostname ="localhost";
$mysql_user ="siyakhat_root";
$mysql_password ="****";
$mysql_database ="siyakhat_ibroker";
$prefix = "";
$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Could not connect database");
mysql_select_db($mysql_database, $bd) or die("Could not select database");

?>

Answer 1

您是否尝试创建数据库连接？

dbCon.php

define('HOST','localhost');
define('USER','root');
define('PASS','your_pass_here');
define('DB','siyakhat_ibroker');
$con = mysqli_connect(HOST,USER,PASS,DB) or die('Unable to Connect to the DB');

那么您的 delete-quote.php 应该如下所示:

 include(dbCon.php);
 $id = $_GET['id'];
 $action = $_GET['action'];
 $tableName = 'prerequest';
if($action=='delete'){
    //deleting row
    $sql = "DELETE FROM $tableName WHERE id='$id'";
    $r = mysqli_query($con,$sql);

    if($r){
        $status="success";
    //assuming this file is in your root folder
    header('Location: manage-quotes.php');
    }else{
        $status="error ".mysqli_error($con) . ": " . mysqli_error($con);
    }
    echo $status;

}mysqli_close($con);

然后调用它:delete-quote.php?id=1&action=delete

我建议您通过使用 jQuery 创建您的 onClick 事件并使用 ajax 调用动态删除行，在您的按钮中使用像 Ajax 调用这样的动态用法，而不是静态用法。

希望它有效。干杯