MYSQLi query to return all rows and append to an array [duplicate]

Question

I'm trying to create an array of all the data in a table.

So far I am querying the database, and then iterating through the array to add each row to it.

But I'm getting an error I haven't seen before and cannot work out what it means:

Fatal error: An iterator cannot be used with foreach

Here is the code. I want to be grabbing the whole table, row by row, and appending it onto my $data array so I have an array of complete data from the table.

$result = mysqli_query($con, "SELECT * from everystory_Comp");
    foreach ($result as &$row){
        $row = mysqli_fetch_assoc($result);
        var_dump($row);
        array_push($data,$row);
    }

is & in &$row tipfeler?

Gem
– Gem

2014-12-23 12:33:45 +00:00
Commented Dec 23, 2014 at 12:33 — Gem
– Gem, Commented Dec 23, 2014 at 12:33

vaso123 · Accepted Answer · 2014-12-23 12:33:06Z

0

You need to fetch your result. Use:

while ($row = mysqli_fetch_assoc($res)) {
  //...  
}

answered Dec 23, 2014 at 12:33

vaso123

12.4k4 gold badges37 silver badges68 bronze badges

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

Comments

McBurgerKong · Accepted Answer · 2014-12-23 13:27:54Z

0

try this:

while($row = mysqli_fetch_array($result))
{
var_dump($row);
}

answered Dec 23, 2014 at 13:27

McBurgerKong

15113 bronze badges

Comments

Cristan · Accepted Answer · 2024-02-18 15:31:51Z

0

Get all the entries at once via mysqli_fetch_all()

$query = "SELECT * from everystory_Comp";
$result = $con->query($query);     
$asArray = $result->fetch_all(MYSQLI_ASSOC);

Or if you are using a prepared statement:

$query = "SELECT * from everystory_Comp where countryCode = ?";

$stmt = $con->prepare($query); 
$stmt->bind_param("s", $countryCode);
$stmt->execute();

$resultSet = $stmt->get_result();
$asArray = $resultSet->fetch_all(MYSQLI_ASSOC);

answered Feb 18, 2024 at 15:31

Cristan

14.6k8 gold badges74 silver badges77 bronze badges

Comments

Khushboo · Accepted Answer · 2014-12-23 12:33:56Z

-1

Try this :-

while ($row = mysqli_fetch_assoc($result)){
        var_dump($row);
        array_push($data,$row);
    }

answered Dec 23, 2014 at 12:33

Khushboo

1,8191 gold badge11 silver badges17 bronze badges

Comments

kos · Accepted Answer · 2014-12-23 13:10:03Z

-1

Try this, it should work.

<?php
    // code
    while($row=mysqli_fetch_assoc($result)) {
        $data[]=$row;
    }
    // code
?>

edited Dec 23, 2014 at 13:10

answered Dec 23, 2014 at 12:44

kos

8586 silver badges22 bronze badges

Collectives™ on Stack Overflow

MYSQLi query to return all rows and append to an array [duplicate]

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Linked

Related