我有下面的代码，除了它不会回显结果之外，它似乎很好。如果我将 echo 语句更改为仅读取 echo $pointrow，那么它将返回"array"。所以我按照下面的方式写了它，现在页面上什么都没有。不知道我做错了什么。积分表中确实有一列称为积分。
<?php
$pointresults = $dbh->prepare("SELECT
wp_users.ID,
points.points
FROM wp_users
LEFT JOIN points on points.ID = wp_users.ID
WHERE (wp_users.ID = $user_ID)");
$pointresults->bindParam(':wp_users.ID', $user_ID, PDO::PARAM_INT);
$pointresults->bindParam(':points.ID', $ID, PDO::PARAM_INT);
$pointresults->execute();
$pointrow = $pointresults->fetchAll(PDO::FETCH_ASSOC);
?>
<?php echo $pointrow[0]['points'] ?>
请尝试以下操作：
<?php
$pointresults = $dbh->prepare("SELECT
wp_users.ID,
points.points
FROM wp_users
LEFT JOIN points on points.ID = wp_users.ID
WHERE (wp_users.ID = :user_ID)");
$pointresults->bindParam(':user_ID', $user_ID, PDO::PARAM_INT);
$pointresults->execute();
$pointrow = $pointresults->fetchAll();
?>
<?php echo $pointrow[0]['points'] ?>