問題描述

這兩個(gè)代碼在PDO中的等價(jià)物是什么

What is the equivalent of these two code in PDO

第一:

  $row=mysql_fetch_array($query);

第二個(gè):

 while($row=mysql_fetch_array($query)){
   $data[]=$row;
 }

我在下面使用了這些代碼，但我猜它們并不完全相同，因?yàn)槠溆嗟拇a不起作用.

i used these codes below but they are not exact same i guess, because the rest of the code didn't work.

$row = $query->fetch(PDO::FETCH_NUM);

和

 $data[] = $query->fetch(PDO::FETCH_ASSOC);

推薦答案

對應(yīng)關(guān)系如下:

• mysql_fetch_array = fetch(PDO::FETCH_BOTH) - 行是具有數(shù)字索引和命名索引的數(shù)組.
• mysql_fetch_assoc = fetch(PDO::FETCH_ASSOC) - 行是具有命名索引的數(shù)組.
• mysql_fetch_row = fetch(PDO::FETCH_NUM) - 行是帶有數(shù)字索引的數(shù)組.
• mysql_fetch_object = fetch(PDO::FETCH_OBJ) 或 fetch(PDO::FETCH_CLASS) 取決于您是否指定了可選的 mysql_fetch_object 的 >className 參數(shù).行是指定類或 stdClass 的對象.

• mysql_fetch_array = fetch(PDO::FETCH_BOTH) - The rows are arrays with both numeric and named indexes.
• mysql_fetch_assoc = fetch(PDO::FETCH_ASSOC) - The rows are arrays with named indexes.
• mysql_fetch_row = fetch(PDO::FETCH_NUM) - The rows are arrays with numeric indexes.
• mysql_fetch_object = fetch(PDO::FETCH_OBJ) or fetch(PDO::FETCH_CLASS) depending on whether you specify the optional className argument to mysql_fetch_object. The rows are objects, either of the specified class or stdClass.

while 循環(huán)相當(dāng)于:

$data = $query->fetchAll(PDO::FETCH_BOTH)

這篇關(guān)于將 mysql_fetch_array 轉(zhuǎn)換為 PDO::FETCH_NUM的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！