将 mysql_fetch_array 转换为 PDO::FETCH_NUM

translation mysql_fetch_array to PDO::FETCH_NUM(将 mysql_fetch_array 转换为 PDO::FETCH_NUM)
本文介绍了将 mysql_fetch_array 转换为 PDO::FETCH_NUM的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

问题描述

限时送ChatGPT账号..

这两个代码在PDO中的等价物是什么

What is the equivalent of these two code in PDO

第一:

  $row=mysql_fetch_array($query);

第二个:

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

我在下面使用了这些代码,但我猜它们并不完全相同,因为其余的代码不起作用.

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

推荐答案

对应关系如下:

  • mysql_fetch_array = fetch(PDO::FETCH_BOTH) - 行是具有数字索引和命名索引的数组.
  • mysql_fetch_assoc = fetch(PDO::FETCH_ASSOC) - 行是具有命名索引的数组.
  • mysql_fetch_row = fetch(PDO::FETCH_NUM) - 行是带有数字索引的数组.
  • mysql_fetch_object = fetch(PDO::FETCH_OBJ)fetch(PDO::FETCH_CLASS) 取决于您是否指定了可选的 mysql_fetch_object 的 >className 参数.行是指定类或 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 循环相当于:

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

这篇关于将 mysql_fetch_array 转换为 PDO::FETCH_NUM的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益,请联系我们,我们会在确认后第一时间进行删除!

相关文档推荐

Deadlock exception code for PHP, MySQL PDOException?(PHP、MySQL PDOException 的死锁异常代码?)
PHP PDO MySQL scrollable cursor doesn#39;t work(PHP PDO MySQL 可滚动游标不起作用)
PHP PDO ODBC connection(PHP PDO ODBC 连接)
Using PDO::FETCH_CLASS with Magic Methods(使用 PDO::FETCH_CLASS 和魔术方法)
php pdo get only one value from mysql; value that equals to variable(php pdo 只从 mysql 获取一个值;等于变量的值)
MSSQL PDO could not find driver(MSSQL PDO 找不到驱动程序)