将从数据库中检索的行存储为php中的单独变量

Question

I have a loop which displays the wanted rows but I also want each row to be stored in its own variable in php. I have a table that has an ID and an info column.

This displays the wanted ID and info:

if ($info = $stmnt2->fetch()) { 
do {
echo "$info[id] . $info[info] </br> "; 
   } while ($info = $stmnt2->fetch());
} else {
echo "<p>No Info</p>";
}

I want each row to have its own variable so I can manipulate the data later down the line. Like the first row will be stored in a php variable called $one and the second row in $second. How can I do this?

Answer 1

I wouldn't use a variable to solve this! Take an array instead:

$rows = [];

if ($info = $stmnt2->fetch()) { 
    do {
        $rows[] = $info;
        echo $info['id'].$info['info']."</br>"; 
    } while ($info = $stmnt2->fetch());
} else {
    echo "<p>No Info</p>";
}

if (!empty($rows)) {

    //you can change the values of the rows like the following.
    $rows[0]['id'] = 1; // The ID of the first row!
    $rows[0]['info'] = 'Some Info'; // The info of the first row!
    $rows[1]['id'] = 2; // The ID of the second row!
    $rows[1]['info'] = 'Some Info'; // The info of the second row!
    //...
}

With the above example each item on rows is one row ($rows[number_of_row - 1]).

Hint: $info[id] and $info[info] isn't valid. You have to replace these with $info['id'] and $info['info']!