我正在嘗試將我自己使用的一些谷歌圖表從 mysql 升級到 mysqli程序方式，并且我在重新創(chuàng)建正確的數(shù)組以供谷歌圖表理解時遇到困難。我想我離我很近，我失去了一些東西。歡迎任何幫助。這是我的舊代碼：mysql_select_db($database_localhost, $localhost);$query_Recordset1 = "select count(*) as count,visible from packs where type=1 and serial=1 group by visible";$Recordset1 = mysql_query($query_Recordset1, $localhost) or die(mysql_error());$row_Recordset1 = mysql_fetch_assoc($Recordset1);$totalRows_Recordset1 = mysql_num_rows($Recordset1);    $data[0] = array('visible','count');            for ($i=1; $i<($totalRows_Recordset1+1); $i++)    {        $data[$i] = array(mysql_result($Recordset1, $i-1,'visible'),            (int) mysql_result($Recordset1, $i-1, 'count'));    }   結(jié)果是：[["visible","count"],["0",266],["1",1466],["2",1],["3",59]]但是當(dāng)我升級（或嘗試將代碼升級到 mysqli）時：$query_Recordset1 = "select count(*) as count,visible from packs where type=1 and serial=1 group by visible";$Recordset1 = mysqli_query($connection,$query_Recordset1) or die(mysqli_error($mysqli));$row_Recordset1 = mysqli_fetch_assoc($Recordset1);$totalRows_Recordset1 = mysqli_num_rows($Recordset1);# set heading     $data[0] = array('visible','count');        for ($i=1; $i<=($totalRows_Recordset1+1); $i++)              {                  mysqli_data_seek($Recordset1, $i-1);                    $data[$i] = array((string) mysqli_fetch_array($Recordset1)['visible'],(int) mysqli_fetch_array($Recordset1)['count']);              } 結(jié)果是：[["visible","count"],["0",1466],["1",1],["2",59],["3",0],["",0]]這顯然與我想要的結(jié)果不匹配，因為一列由于某種原因偏移了 1（參見值 266 根本沒有獲?。?