php mysqli数组行数,php – Mysqli获取数组第n行

我有以下代码来获取单行：

$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)

等等…

我怎样才能做到这一点？

解决方法:

你可以尝试这样的事情

$arrayofrows = array();

while($row = mysqli_fetch_array($result))

{

$arrayofrows = $row;

}

你现在可以拥有

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

$arrayofrows[1] //(2nd row)

标签：php,mysql,loops

来源： https://codeday.me/bug/20190725/1537636.html