php - Mysqli 获取数组第n行

Question

我有以下获取单行的代码:

$query = "SELECT *
          FROM translations
          WHERE iddoc = '$id'
          AND submitted = 1;";
$result = mysqli_query($query);
$row = mysqli_fetch_array($result);

我知道这在 while 循环中很有用，您可以在其中循环遍历结果。

但我需要能够抓取满足此条件的特定行。此伪代码之后的内容:

$query = "SELECT *
          FROM translations
          WHERE iddoc = '$id'
          AND submitted = 1;";
$result = mysqli_query($query);
$arrayofrows = mysqli_fetch_arrayofrows($result);
$arrayofrows[0] //(to get the first row)
$arrayofrows[1] //(2nd row)

等等……

我该怎么做？

Answer 1

你可以试试这样的东西

$arrayofrows = array();
while($row = mysqli_fetch_array($result))
{
   $arrayofrows = $row;
}

你现在可以拥有

$arrayofrows[0] //(to get the first row)
$arrayofrows[1] //(2nd row)