PHP 将参数绑定(bind)到 SQL 查询并循环并打印结果

Question

我目前在尝试打印 SQL 查询结果的 html 表时遇到问题。

我目前有一个 sql 查询，它需要一个存储为局部变量的“sid”。

我正在尝试创建一个准备好的语句，它将 $sid var 绑定(bind)到查询并创建一个 while 循环来遍历数据并将结果打印到表中。

下面，我已经尝试创建代码，但它似乎还没有工作。任何帮助，将不胜感激，谢谢

$sid = '166410';

    $query =  "SELECT enrl.ayr, enrl.status, prog.ptitle, enrl.lvl
               FROM enrl, prog
               WHERE enrl.sid =?
               AND enrl.pid = prog.pid
               ORDER BY lvl DESC";

$scap = '';

if ($st = mysqli_prepare($link, $query)) {

    mysqli_stmt_execute($st);

    mysqli_stmt_bind_param($st, "s", $sid);

    mysqli_stmt_bind_result($st, $ayr, $status, $ptitle, $lvl);

    while (mysqli_stmt_fetch($st)) {
            $scap .= "
                  <table id=\"test\" style=\"width:100%\">
                      <tr>
                          <td> " . $ayr . " </td>
                          <td> " . $status . "</td>
                          <td> " . $ptitle . "</td>
                          <td> " . $lvl . "</td>
                      </tr>
                  </table>
              ";
            } $st->free();
        mysqli_stmt_close($st);
    }
    mysqli_close($link);

    print($scap);

Answer 1

<?php

$sid = '166410';
$query = "SELECT enrl.ayr, enrl.status, prog.ptitle, enrl.lvl
          FROM enrl, prog
          WHERE enrl.sid =?
          AND enrl.pid = prog.pid
          ORDER BY lvl DESC";
$scap = '';
$st = mysqli_prepare($link,$query);
mysqli_stmt_bind_param($st, "s", $sid);
mysqli_stmt_execute($st);
mysqli_stmt_bind_result($st, $ayr, $status, $ptitle, $lvl);
while (mysqli_stmt_fetch($st)) {
    $scap .= "
          <table id=\"test\" style=\"width:100%\">
              <tr>
                  <td> " . $ayr . " </td>
                  <td> " . $status . "</td>
                  <td> " . $ptitle . "</td>
                  <td> " . $lvl . "</td>
              </tr>
          </table>
          ";
}
echo $scap;
mysqli_stmt_close($st);
mysqli_close($link);
?>