translation mysql_fetch_array to PDO::FETCH_NUM

Question

What is the equivalent of these two code in PDO

first:

  $row=mysql_fetch_array($query);

second:

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

and

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

Barmar · Accepted Answer · 2014-05-10 00:50:59Z

16

Here are the correspondences:

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.

The while loop is equivalent to:

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

answered May 10, 2014 at 0:50

Barmar

789k57 gold badges554 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ruby · Accepted Answer · 2014-05-10 00:55:26Z

0

You should be able to get the data of the query in an array with this:

$data = $query->fetch(PDO::FETCH_BOTH);

If that's not working, your PDO connection is probably not setup right or your query didn't run. You can try troubleshooting the query with something like this:

try {
    $query->execute();
} catch (PDOException $e) {
    echo 'Query failed: ' . $e->getMessage();
}

edited May 10, 2014 at 0:55

answered May 10, 2014 at 0:33

Ruby

5293 silver badges14 bronze badges

4 Comments

Gorkem Yontem Over a year ago

thank you for your answer. this code is valid i know. However, i am looking for a script that, when i changed with old code works same. because the rest of the code is really long and if i change alot, i will have to change all

Ruby Over a year ago

So you're confident that the query is executing fine?

Barmar Over a year ago

@RubyMewMew It should be PDO::FETCH_BOTH to match the original code.

Funk Forty Niner Over a year ago

Sidenote: During development (only), it's better to use $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); right after the connection is opened. Doing just a catch(PDOException $e) isn't always enough.

Collectives™ on Stack Overflow

translation mysql_fetch_array to PDO::FETCH_NUM

2 Answers 2

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related