Mysql查询Mysql语句和准备语句 - Mysql query to Mysqli and Prepare Statement

Mysql query to Mysqli and Prepare Statement

本文关键字：Mysql 语句查询 | 更新日期: 2023-09-27

我正试图将我的旧查询转换为mysqli + prepare语句，但我可以使用一些帮助。

原来的循环是这样的:

$query = "SELECT * FROM `table`;";
$result = @mysql_query($query);
if (@mysql_num_rows($result) > 0) {
    for ($i=0; $i < @mysql_num_rows($result); $i++) {
        $row = @mysql_fetch_array($result);
        print $row['id'];
        print " - ";
        print $row['username'];
        print "<br>";
    }
}

但是我被mysqli + prepare语句卡住了。

谢谢!

$stmt = $mysqli->prepare("SELECT * FROM `table` WHERE `columnStr`= ? AND `columnInt`= ?");
$stmt->bind_param('si','string', 1);
$result = $stmt->execute();
while ($row = $result->fetch_row()) {
    var_dump($row);
}

字体:Mysqli Prepare