Loading MySQL data into a PHP array

Question

I am trying to load a list of IDs into a PHP array which I can loop through. The SQL query I am using returns 283 rows when I run it in PHPMyAdmin. However, when I run the following PHP script, it only returns a single row (the first row). How can I modify my code to include all the rows from the resulting SQL query in my PHP array?

Code:

//Get active listing IDs 
$active = "SELECT L_ListingID FROM `markers`";
$active = mysql_query($active) or die(mysql_error());

if(is_resource($active) and mysql_num_rows($active)>0){
$row = mysql_fetch_array($active);
print_r($row);
};

Thanks,

datasage · Accepted Answer · 2012-12-23 23:42:04Z

7

Using mysql_fetch_array will return only the first row and then advance the internal counter. You need to implement it as part of a loop like the following to get what you want.

while($row = mysql_fetch_array($active)) {
 // Your code here
}

Keep in mind that mysql_ functions are now also deprecated and slated to be removed in future version of php. Use mysqli_ functions or PDO.

answered Dec 23, 2012 at 23:42

datasage

19.7k2 gold badges51 silver badges55 bronze badges

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

1 Comment

AME Over a year ago

How could I write the same function using PDO instead?

hakre · Accepted Answer · 2012-12-23 23:48:32Z

4

In PDO it's rather straight forward:

$rows = $conn->query($active)->fetchAll();

See PDO::query^Docs and PDOStatement::fetchAll^Docs.

answered Dec 23, 2012 at 23:48

hakre

200k55 gold badges454 silver badges865 bronze badges

Comments

Olaf Dietsche · Accepted Answer · 2012-12-24 00:00:33Z

2

With mysqli you would use mysqli_result::fetch_all and with PDO there's PDOStatement::fetchAll to fetch all rows into an array.

Code for mysqli

$sql = "SELECT L_ListingID FROM `markers`";
$result = $mysqli->query($sql);
if ($result !== false) {
    $rows = $result->fetch_all();
}

with PDO it's nearly the same

$sql = "SELECT L_ListingID FROM `markers`";
$result = $pdo->query($sql);
if ($result !== false) {
    $rows = $result->fetchAll();
}

edited Dec 24, 2012 at 0:00

answered Dec 23, 2012 at 23:50

Olaf Dietsche

74.4k9 gold badges113 silver badges214 bronze badges

Collectives™ on Stack Overflow

Loading MySQL data into a PHP array

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related