fetch array php

Question

I am working on fetching data from a table in PHP with the following code. How can I copy all rows directly into an array? I tried fetch_array() instead of fetch() but it was also not successful.

$stmt = $this->db->prepare($sql); 
$stmt->execute();
$stmt->bind_result($aID, $sID);

while ($stmt -> fetch()) { 
    echo $aID . " ". $sID . "<br>";
}

Daryl Gill · Accepted Answer · 2012-12-21 19:51:07Z

1

If using PDO

the Fetch_column is what you are looking for

$stmt = $this->db->prepare($sql); 
        $stmt->execute();
        $stmt->bind_result($aID, $sID);
    $Arrays = $stmt ->fetchAll(PDO::FETCH_COLUMN);

answered Dec 21, 2012 at 19:51

Daryl Gill

5,52511 gold badges41 silver badges71 bronze badges

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

4 Comments

zhtway Over a year ago

I tried like this but not echoing. ` $stmt = $this->db->prepare($sql); $stmt->execute(); $stmt->bind_result($aID, $sID); while ($row = $stmt -> fetchAll(PDO::FETCH_COLUMN)){ echo $row[0]; echo $row[1]; }`

Daryl Gill Over a year ago

First things first; are you using mysqli or PDO? and try my structure and print_r($Arrays); Does this return an array that you are looking for?

zhtway Over a year ago

Oh..sorry .. I am using mysqli.

Daryl Gill Over a year ago

This should be mentioned in your question then; Dis-regard this post, it's for PDO

Jason McCreary · Accepted Answer · 2012-12-21 19:49:49Z

0

How can I copy all rows directly into array?

MySQLi - mysqli_fetch_all()
PDO - fetchAll()

answered Dec 21, 2012 at 19:49

Jason McCreary

73.3k23 gold badges140 silver badges177 bronze badges

3 Comments

zhtway Over a year ago

Will that be like this? ` $stmt = $this->db->prepare($sql); $stmt->execute(); $stmt->bind_result($aID, $sID); $allrows = $stmt->mysqli_fetch_all(); echo $allrows ->rowcount(); `

Jason McCreary Over a year ago

Assuming you are using MySQLi OOP, the method is just fetch_all(). Reference the links I provided to the PHP Docs. They are your friend.

zhtway Over a year ago

I changed to this now but still not working. Any idea? While ($row = $stmt -> fetch_all()){ echo $row[0]; echo $row[1];}

Rob · Accepted Answer · 2012-12-21 19:50:44Z

0

$array = $stmt->fetchAll(PDO::FETCH_ASSOC);

answered Dec 21, 2012 at 19:50

Rob

12.9k4 gold badges44 silver badges57 bronze badges

1 Comment

billinkc Over a year ago

This answer would be improved with an explanation of what the code is doing/how it would solve the problem. It's currently being identified as a low quality post due to length and content

Collectives™ on Stack Overflow

fetch array php

3 Answers 3

4 Comments

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related