使用$ stmt-> fetch(PDO :: FETCH_ASSOC)时如何输出数据； [英] How to output data when using $stmt->fetch(PDO::FETCH_ASSOC);

问题描述

使用$stmt->fetch(PDO::FETCH_ASSOC)时如何正确输出数据?现在，我做的时候得到一个单词

"select name, author, title from d_books"

// Other PDO stuff goes here
$arr = $stmt->fetch(PDO::FETCH_ASSOC);
foreach ($arr as $titleData) {
   echo $titleData['name'];
}

解决方案

 $pdo = new PDO(/*Your credentials*/);
 $sql = `select name, author, title from d_books`
 $stmt = $pdo->prepare($sql);
 $stmt->execute(); 

 while ($arr = $stmt->fetch(PDO::FETCH_ASSOC)) {
    echo $arr['name'];
 }

或

 $pdo = new PDO(/*Your credentials*/);
 $sql = `select name, author, title from d_books`
 $stmt = $pdo->prepare($sql);
 $stmt->execute(); 
 $arr = $stmt->fetchAll(PDO::FETCH_ASSOC);
 foreach ($arr as $titleData) {
    echo $titleData['name'];
 }

在运行不带任何参数的查询时，您总是可以使用pdo->query()方法，这是更快的方法，但是我不认为这种情况发生得太多(运行不带任何参数的查询).

How do you correctly output data when using $stmt->fetch(PDO::FETCH_ASSOC)? Right now I'm getting single words as my result when doing

"select name, author, title from d_books"

// Other PDO stuff goes here
$arr = $stmt->fetch(PDO::FETCH_ASSOC);
foreach ($arr as $titleData) {
   echo $titleData['name'];
}

解决方案

 $pdo = new PDO(/*Your credentials*/);
 $sql = `select name, author, title from d_books`
 $stmt = $pdo->prepare($sql);
 $stmt->execute(); 

 while ($arr = $stmt->fetch(PDO::FETCH_ASSOC)) {
    echo $arr['name'];
 }

or

 $pdo = new PDO(/*Your credentials*/);
 $sql = `select name, author, title from d_books`
 $stmt = $pdo->prepare($sql);
 $stmt->execute(); 
 $arr = $stmt->fetchAll(PDO::FETCH_ASSOC);
 foreach ($arr as $titleData) {
    echo $titleData['name'];
 }

You can always use pdo->query() method when running a query without any parameters, which is faster, but I do not believe that this happens much(running queries without any parameters).

这篇关于使用$ stmt-> fetch(PDO :: FETCH_ASSOC)时如何输出数据；的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！