我想将我的 SQL 查询变成一个准备好的语句,但我意识到这并不像我最初想象的那么容易。这是当前形式的查询,因此不是准备好的语句。
$mysqli = new mysqli(...);
$result = mysqli_query( $mysqli,
"SELECT count(*) as total from test_users, image_uploads
WHERE test_users.APPROVAL = 'granted'
AND test_users.NAME = image_uploads.OWNER
AND (test_users.IMGAUTO = 'enabled' OR image_uploads.IAPPROVAL = 'granted')
");
$data = mysqli_fetch_assoc( $result );
$row_cnt = $data['total'];
$totalPages = ceil(($row_cnt / $cardmax));
所以我现在的问题是这个。当我制作准备好的语句时,我将无法再访问image_uploads.OWNER,因为我目前在查询中使用它。
$grant = 'granted';
$owner = ""; //<<--- how to get image_uploads.OWNER
$enabl = 'enabled';
$sql =
"SELECT COUNT(*) FROM test_users, image_uploads
WHERE test_users.APPROVAL=?
AND test_users.NAME=?
AND (test_users.IMGAUTO=? OR image_uploads.IAPPROVAL=?)
";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('ssss', $grant, $owner, $enabl, $grant);
$stmt->execute();
$row = $stmt->get_result()->fetch_row();
$row_cnt = $row[0];
$totalPages = ceil(($row_cnt / $cardmax));
有没有办法image_uploads.OWNER在我准备好的陈述中得到这个。我该如何正确地做到这一点?
喵喵时光机