php - Mysqli_fetch_assoc 未存储为 session 变量

Question

我正在尝试将我从 mySQL 查询中输出的表存储到 session 变量中，以便在另一个页面中使用。到目前为止，这是我所拥有的，但我没有得到输出:

显示搜索结果的第一个页面:

<?php
session_start();
$personid = ($_POST['personid']) ? $_POST['personid'] : $_GET['personid'];


if (empty($personid)) {
echo 'Please enter some search parameters';
} else {

$sql = "SELECT * FROM persons WHERE 1=1";

if ($personid)
$sql .= " AND personid='" . mysqli_real_escape_string($mysqli,$personid) . "'";

$total_records = mysqli_num_rows(mysqli_query($mysqli,$sql));

$sql .= " ORDER BY surname";

$loop = mysqli_query($mysqli,$sql)
or die ('cannot run the query because: ' . mysqli_error($mysqli));

  echo "<table border='1' cellpadding='10'>";
    echo "<tr> <th>Name</th> <th>Address</th> <th>City</th> <th>Province</th>    <th>Postal Code</th> <th>Phone Number</th> <th>Email</th> <th></th></tr>";

while ($record = mysqli_fetch_assoc($loop)) {
echo "<tr>";
          /*  echo '<td>' . $record['firstname'] .   $record['surname'] .'</td>';*/
             echo "<td><a href=\"person.php?$record[personid]\">$record[firstname]   $record[surname]</a></td>";
            echo '<td>' . $record['address'] . '</td>';
            echo '<td>' . $record['city'] . '</td>';
            echo '<td>' . $record['province'] . '</td>';
            echo '<td>' . $record['postalcode'] . '</td>';
            echo '<td>' . $record['phone'] . '</td>';
            echo '<td>' . $record['email'] . '</td>';

            echo ("<td><a href=\"records.php?$record[personid]\">Edit</a></td>");

            echo "</tr>"; 


 }
 echo "</table>";


$_SESSION['animals']=$loop;

echo "<center>" . number_format($total_records) . " search results found</center>";



}

?>
<a href="passthru.php" target="_blank">Click here to see if sessions work</a>

然后转到这个脚本:

<?php
session_start();

echo "The results";



 while ($record = mysqli_fetch_assoc($_SESSION['animals'])) {
echo "<tr>";
             echo "<td><a href=\"person.php?$record[personid]\">$record[firstname]   $record[surname]</a></td>";
            echo '<td>' . $record['address'] . '</td>';
            echo '<td>' . $record['city'] . '</td>';
            echo '<td>' . $record['province'] . '</td>';
            echo '<td>' . $record['postalcode'] . '</td>';
            echo '<td>' . $record['phone'] . '</td>';
            echo '<td>' . $record['email'] . '</td>';

            echo ("<td><a href=\"records.php?$record[personid]\">Edit</a></td>");

            echo "</tr>"; 


}

可能是什么问题？提前致谢。

Answer 1

session 用于存储原始数据类型。

将结果集存储到 session 中是一个糟糕的想法，很可能对服务器资源不利。

如果您在应用的其他地方确实需要该数据，只需再次查询您的数据库，这不会太昂贵。