致命错误:未捕获的异常 'PDOException' 带有消息'SQLSTATE [42S22]:找不到列:1054 'where 子句'中的未知列 'id'' [英] Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'where clause''

问题描述

<?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");

这篇关于致命错误:未捕获的异常 'PDOException' 带有消息'SQLSTATE [42S22]:找不到列:1054 'where 子句'中的未知列 'id''的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！