Storing db value into php array and then looping through the array

Question

What would the benefits be of storing db values into an array and then looping through the array vs just using a while loop?

Outputting db results to an array:

$records = array();

if($results = $db->query("SELECT name, address FROM town")) {
    if($results->num_rows) {
        while($row = $results->fetch_object()) {
            $records[] = $row;
        }
        $results->free();
    }
}

Loop through array:

foreach($records as $r) {
    $r->name; 
}

VS a simple While loop:

if($result = $db->query("SELECT name, address FROM town")) {
    if($count = $result->num_rows) {

        while($row = $result->fetch_object()) {
            echo $row->name, ' ', $row->address, '<br />';
        }

        $result->free();
    }
}

davejal · Accepted Answer · 2015-11-18 16:24:47Z

2

Just a while loop and printing the result is easy and fast, but in certain times you want to do more then just print the array and then it becomes handy if you already work with arrays.

answered Nov 18, 2015 at 16:24

davejal

6,19110 gold badges45 silver badges85 bronze badges

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

Comments

Calimero · Accepted Answer · 2015-11-18 16:25:16Z

1

The most common use for this is freeing the resultset, allowing you to perform other db queries (updates, inserts...) before actually making any use of the results you got in the first place.

answered Nov 18, 2015 at 16:25

Calimero

4,3181 gold badge27 silver badges36 bronze badges

Collectives™ on Stack Overflow

Storing db value into php array and then looping through the array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related