PHP 中的循环不工作

Question

$qPhysician = mysql_query("SELECT * FROM physicians");
$num = mysql_num_rows($qPhysician);
$i=0;
while($i < $num)
{
    "<tr>";
    "<td>" . mysql_result($qPhysician,$i,"lastName") . "</td>";
    "<td>" . mysql_result($qPhysician,$i,"firstName") . "</td>";
    "</tr>";
    $i++;
}

我得到空白结果。

如果我回显 $num，我会得到“19”，这是我的数据库中的行数。 如果我 echo $rowPhysician['lastName'] 只是为了测试是否获取记录，那么我至少会获取 1 条姓氏记录。不知道“while”有没有问题。请帮帮我。

Answer 1

您是否缺少打印字符串的回声？

while($i < $num) {
    echo "tr";
    echo "td" . mysql_result($qPhysician,$i,"lastName") . "/td";
    echo "td" . mysql_result($qPhysician,$i,"firstName") . "/td";
    echo "/tr";
    $i++;
}

Answer 2

从技术上讲，这不是一个答案，但以这种方式显示代码更容易：

// first, only take the records you need -- each record adds more time to
// query, so if you only need 2, only select 2.
$query = mysql_query("SELECT lastName, firstName FROM physicians");

// mysql_fetch_assoc returns an associative array of all of the columns
// mysql_fetch_row   returns a numerically indexed array.
// mysql_fetch_array returns an array with both numeric and string indexing.
// they will all return FALSE when there are no more results in the query.
while( $arr = mysql_fetch_assoc( $query ) )
{
    echo "<tr>";
    // Now, use array indexing.
    echo "<td>" . $arr[ "lastName" ] . "</td>";
    echo "<td>" . $arr[ "firstName" ] . "</td>";
    echo "</tr>";
}

在极少数情况下，mysql_result实际上是更好的选择——通常最好在 PHP 中填充几个数组，然后完成数据库。

Answer 3

不管怎样，回显 HTML 是不好的做法。更正确的输出应该类似于

...
while($i < $num) :?>
    <tr>
      <td><?php echo mysql_result($qPhysician,$i,"lastName"); ?></td>
      <td><?php echo mysql_result($qPhysician,$i,"firstName") ?></td>
    </tr>
<?php $i++; endwhile;
...

注意，您也写了错误的关闭 HTML。