<?php 
require 'database.php';
$id = 0;

if ( !empty($_GET['user_id'])) {
    $id = $_REQUEST['user_id'];
}

if ( !empty($_POST)) {
    // keep track post values
    $id = $_POST['user_id'];

    // delete data
    $pdo = Database::connect();
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $sql = "DELETE FROM admin  WHERE id = ?";  ===> Wrong on here.. //LINE18
    $q = $pdo->prepare($sql);
    $q->execute(array($id));
    Database::disconnect();
    header("Location: index.php"); 

} 

?>

有人可以帮助我吗?为什么我得到带有消息SQLSTATE[42S22]"的未捕获异常PDOException"

somebody can help me? why i got Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]

对不起，我的英语不好，谢谢

sorry my english is bad, thanks

推荐答案

True $sorguemir = $db_conn->query("SELECT * FROM komut WHERE emir = '".$eslestir."'");False $sorguemir = $db_conn->query("SELECT * FROM komut WHERE emir =$eslestir");

True $sorguemir = $db_conn->query("SELECT * FROM komut WHERE emir = '".$eslestir."'"); False $sorguemir = $db_conn->query("SELECT * FROM komut WHERE emir =$eslestir");