php - PDO BindValue 不起作用 - 执行不返回任何内容

Question

我在 pdo 方面遇到了一个大问题，似乎没有人能够帮助我 - 所以我决定问你们:-)

try {
    $links = $database->prepare("SELECT * FROM aTable WHERE visible=:visible AND access<=:access AND category=:category ORDER BY orderNum ASC");
    $links->bindValue(':visible',$first,PDO::PARAM_INT);
    $links->bindValue(':access',$second,PDO::PARAM_INT);
    $links->bindValue(':category',$third,PDO::PARAM_STR);
    $links->execute();
    print_r($asdf);
    print_r($database->errorInfo());
    print_r($links->errorInfo());
    while($row = $links->fetch(PDO::FETCH_ASSOC)){
        print_r($row);
    }
} catch (PDOException $e) {
    echo $e->getMessage();
}

数据库连接工作完美，errorInfo() 都返回:

Array
(
    [0] => 00000
    [1] => 
    [2] => 
)

现在，这段代码不知怎的没有得到任何$row。但如果我用以下几行替换准备语句:

$sql = "SELECT * FROM woody_sidebar WHERE visible=$first AND access<=$second AND category=$third ORDER BY orderNum ASC";
$links = $database->prepare($sql);

(并删除bindValue语句)代码的工作方式就像魅力!

我不知道我做错了什么，因为根本没有抛出任何错误 - 你们中有人知道我可以尝试什么吗？

谢谢

Answer 1

更改此:

$links = $database->prepare("SELECT * FROM aTable WHERE visible=:visible AND access<=:access AND category=:category ORDER BY orderNum ASC");
$links->bindValue(':visible',$first,PDO::PARAM_INT);
$links->bindValue(':access',$second,PDO::PARAM_INT);
$links->bindValue(':category',$third,PDO::PARAM_STR);

对此:

In the second query your table name is woody_sidebar but you have aTable and $third is a INT and can be passed as a PDO::PARAM_INT

$links = $database->prepare("SELECT * FROM woody_sidebar WHERE visible=:visible AND access<=:access AND category=:category ORDER BY orderNum ASC");
$links->bindValue(':visible',$first,PDO::PARAM_INT);
$links->bindValue(':access',$second,PDO::PARAM_INT);
$links->bindValue(':category',$third,PDO::PARAM_INT);