What can I use instead of mysql_fetch_array?

Question

In my php code I take data from the database and I put to a specific values of the Array:

$from_db=mysql_query(" SELECT * FROM ... ");

while ($row = mysql_fetch_array($from_db)) {
$number_id[]=$row['number_id'];
...
}

And now I would like add this line (for other purposes) before comand "while":

$from_db = mysql_fetch_array($from_db);

How can I change this line: while ($row = mysql_fetch_array($from_db)) { to process an array instead of a raw data from database?

your question is way unclear. in both cases you have arrays both contains raw data from database. Can you tell what you actually want, and why? Without using some terms you don't quite understand. Thanks. — Your Common Sense
– Your Common Sense, Commented Feb 23, 2012 at 10:05
I tried put $from_db to cache, but I got an error, so I needed convert mysql_query to an Array, put in into cache and after that process. — Lucas
– Lucas, Commented Feb 23, 2012 at 10:19
WHAT you want to put into cache? what for? Do you really need any cache? May be you need to learn very basic syntax first? — Your Common Sense
– Your Common Sense, Commented Feb 23, 2012 at 10:21
I needed put result from mysql_query(" SELECT * FROM ... ") into cache. But mysql_query result need to be converted to an Array before will be saved on a disk for future use. — Lucas
– Lucas, Commented Feb 23, 2012 at 10:24
why do you want this cache at all? do you have your query slow or what? most queries require no caching, mysql can cache query results better than you can do. Do you have any certain reason to cache query results? — Your Common Sense
– Your Common Sense, Commented Feb 23, 2012 at 10:28

kingmaple · Accepted Answer · 2012-02-23 09:58:04Z

3

I suggest you use PDO class instead. mysql_* functions are not recommended anymore and will be deprecated in the (far) future.

An example is something like:

//Connect to database and whatnot
//...
$PDOquery=$PDO->prepare('SELECT * FROM users WHERE id=?;');
$PDOquery->execute(array(1));
$resultArray=$PDOquery->fetchAll(PDO::FETCH_ASSOC); //Results stored as associative array in ths array.

answered Feb 23, 2012 at 9:58

kingmaple

4,3705 gold badges35 silver badges44 bronze badges

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

Comments

Mchl · Accepted Answer · 2012-02-23 10:02:45Z

0

Something like this is unfortunately necessary:

$from_db=mysql_query(" SELECT * FROM ... ");

$from_db = array();

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

foreach($from_db as $row) {
  $number_id[]=$row['number_id'];
}

answered Feb 23, 2012 at 10:02

Mchl

62.4k9 gold badges121 silver badges121 bronze badges

Comments

Roman Newaza · Accepted Answer · 2012-02-23 10:04:17Z

0

You would better use PDO or MySQLi.

For example, PDOStatement::fetchAll:

<?php
$sth = $dbh->prepare("SELECT name, colour FROM fruit");
$sth->execute();

/* Fetch all of the remaining rows in the result set */
print("Fetch all of the remaining rows in the result set:\n");
$result = $sth->fetchAll();
print_r($result);

answered Feb 23, 2012 at 10:04

Roman Newaza

11.8k12 gold badges65 silver badges94 bronze badges

Comments

waseem · Accepted Answer · 2012-02-23 10:08:11Z

-1

mysql_fetch_assoc()
mysql_fetch_object()

http://php.net/manual/en/function.mysql-fetch-assoc.php

answered Feb 23, 2012 at 10:08

waseem

1671 silver badge4 bronze badges

Collectives™ on Stack Overflow

What can I use instead of mysql_fetch_array?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related