MySQLi使用先前获取的$ variable的多个准备语句

Pietro di Caprio 发表于 Dev

卡皮里奥大教堂

$stmt = $mysqli->prepare("SELECT id,name,master,level,exp FROM player.guild ORDER BY exp DESC");
$stmt->execute();
$stmt->bind_result($id, $name, $master, $level, $exp);
$stmt->fetch();
$guildnum = $stmt->num_rows;
$stmt->store_result();
$stmt->close();

$stmt2 = $mysqli->prepare("SELECT id,login FROM account.account WHERE id=?");
$stmt2->bind_param("i", $master);
$stmt2->execute();
$stmt2->bind_result($boss_id, $boss_name);
$stmt2->store_result();
$stmt2->close();

$stmt3 = $mysqli->prepare("SELECT empire FROM player.player_index WHERE id=?");
$stmt3->bind_param("i", $boss_id);
$stmt3->execute();
$stmt3->bind_result($empire);
$stmt3->store_result();
$stmt3->close();

$ stm2和$ stm3不返回结果。

//说明代码

$ stm获取一些详细信息并将其存储到$ variables中

$ stm2使用变量$ master来获取“ id”和“ login”并将其存储到其他变量中

$ stm3使用$ boss_id（由$ stm2存储）来获取并设置变量$ empire

//说明代码

谁能帮我吗？

问候。

杰拉多·查尔斯·罗哈斯·维加

因此，如果一切正确，则只需获取值（bind_result）

    $stmt = $mysqli->prepare("SELECT id,name,master,level,exp FROM player.guild ORDER BY exp DESC");
    $stmt->execute();
    $stmt->bind_result($id, $name, $master, $level, $exp);
    $stmt->fetch(); //fetch values
    $guildnum = $stmt->num_rows;
    $stmt->store_result();
    $stmt->close();

    $stmt2 = $mysqli->prepare("SELECT id,login FROM account.account WHERE id=?");
    $stmt2->bind_param("i", $master);
    $stmt2->execute();
    $stmt2->bind_result($boss_id, $boss_name);
    $stmt2->fetch(); //fetch values
    $stmt2->close();

    $stmt3 = $mysqli->prepare("SELECT empire FROM player.player_index WHERE id=?");
    $stmt3->bind_param("i", $boss_id);
    $stmt3->execute();
    $stmt3->bind_result($empire);
    $stmt3->fetch(); //fetch values
    $stmt3->close();