消息"SQLSTATE [42S22]"的未捕获异常"PDOException":找不到列 [英] Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found

问题描述

我尝试运行以下代码，但返回了此错误消息:
致命错误:消息为"SQLSTATE [42S22]"的未捕获异常"PDOException":找不到列:1054/home/cardg/cards/jogar.php:59中的字段列表"中的未知列"1":堆栈跟踪: #0/home/cardg/cards/jogar.php(59):PDOStatement-> execute()#1 {main}在第59行的/home/cardg/cards/jogar.php中抛出
为什么会这样?

I tried to run the following code but it returned this erros:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column ''1'' in 'field list'' in /home/cardg/cards/jogar.php:59 Stack trace: #0 /home/cardg/cards/jogar.php(59): PDOStatement->execute() #1 {main} thrown in /home/cardg/cards/jogar.php on line 59
Why this is happening?

<?php

 include('config.php');


$usuarion = $_SESSION['login'];
$senhan = $_SESSION['senha'];

// $attrs is optional, this demonstrates using persistent connections,
// the equivalent of mysql_pconnect
$attrs = array(PDO::ATTR_PERSISTENT => true);

// connect to PDO
$pdo = new PDO('mysql:host='.$dbservidor.';dbname='.$dbnome.'', $dbusuario, $dbsenha);

// the following tells PDO we want it to throw Exceptions for every error.
// this is far more useful than the default mode of throwing php errors
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

// prepare the statement. the place holders allow PDO to handle substituting
// the values, which also prevents SQL injection
$stmt = $pdo->prepare("SELECT estado,usuario1,usuario2,usunivel,id  FROM duelos WHERE estado=:estadox AND usuario1!=:usuario");

// bind the parameters
$stmt->bindValue(":estadox", 0);
$stmt->bindValue(":usuario", $usuarion);

// initialise an array for the results 
$duelos = array();
if ($stmt->execute()) {
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $products[] = $row;
        echo $row['usuario1'];
    }
}



$usuario = $pdo->query("SELECT id,apelido,usuario,nivel FROM usuarios WHERE usuario = '".$usuarion."' AND senha ='".$senhan."'");
$usulinha = $usuario->fetch(PDO::FETCH_ASSOC);
$usuarioid = $usulinha['id'];
$usunivel - $usulinha['nivel'];

    $sqlduelos = "SELECT COUNT(*) FROM duelos WHERE (estado = 1 AND usuario2 = 0)";

       if ($resl = $pdo->query($sqlduelos)) {
    /* Check the number of rows that match the SELECT statement */
  if ($resl->fetchColumn() > 0) {
  $msg = "True msg";
    }
    else{
        $msg = "false msg";

        $inid = $pdo->prepare("INSERT INTO `duelos`  (`usuario1`, `usunivel`)  VALUES (
    `:usua`,
    `:usuni`)");

    $inid->bindParam(':usua', $usuarioid);
    $inid->bindParam(':usuni', $usunivel);
    $inid->execute();

    }
}

// set PDO to null in order to close the connection
$pdo = null;

    ?>

推荐答案

删除占位符周围的定界符(反引号):

Remove delimiters (backticks) around the placeholders:

$inid = $pdo->prepare("INSERT INTO `duelos`  (`usuario1`, `usunivel`)  
   VALUES (:usua, :usuni)");

...，因为它们是占位符，所以这些值(由bindValue绑定到它们)将被自动转义.否则，这些值将被视为列名，从而导致错误.

... as these are placeholders, which values (bound to them by bindValue) will be escaped automatically. Otherwise, those values will be treated as a column names, causing the error.

作为旁注，您在这里有错字:

As a sidenote, you have a typo here:

$usunivel - $usulinha['nivel'];

...最有可能是$usunivel = $usulinha['nivel'];.

这篇关于消息"SQLSTATE [42S22]"的未捕获异常"PDOException":找不到列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！