[RESOLVED] Write the results of a Query to an array

kemnet

HeLlo
Im kinda stuck with a little issue.

I have this query to select from my database, the thing is if more than one result is selected i want to be able to write x amount to a query.
The query works but only 1 per son is selected not two

 if (isset($_POST["firstname"]) && isset($_POST["class_num"])) {

$stmt = $this->db->prepare('SELECT id, class_status FROM School WHERE class_num=? AND firstname=?')

 $stmt->bind_param("is",$class_num, $firstname);

$stmt->execute();
$stmt->bind_result($id ,$class_status);

 $result = array(
          "class_status"=>$class_status,     

 );

Not to sure where to begin so if more than one person is selcted it gets written to the array

bradgrafelman

You should be calling the MySQLi_STMT::fetch() method (see: [man]mysqli_stmt.fetch[/man]) in a loop until it no longer returns TRUE. See the PHP manual page for more info/examples.

kemnet

urg i have this line

while ($stmt->fetch()) {
break;
}
$result = array(
"class_status"=>$class_status,

);

missed adding it

kemnet

shoulnt that cut it?

bradgrafelman

Take a look at that while loop:

while ($stmt->fetch()) {
break;
}

the one and only statement that loop ever executes is... a command to stop the loop. Doesn't that seem blatantly wrong to you?

Instead, you should be processing the data in the bounded variable(s) inside that loop (not after it).

kemnet

tried this but instead i get an error 🙁

while ($stmt->fetch()) {
$result = array(
"class_status"=>$class_status,

);
}

bradgrafelman

kemnet;10988800 wrote:
tried this but instead i get an error 🙁

while ($stmt->fetch()) {
$result = array(
"class_status"=>$class_status,

);
}

What was the error?

Also note that your while() loop is now overwriting the value in $result repeatedly without ever actually using any of the values. In other words, after that while loop has executed you'll only be left with the last row in the result set.

kemnet

ok then i need to specify a size?but i kinda wanted that to be dynamic

bradgrafelman

kemnet;10988818 wrote:
ok then i need to specify a size?

A size for what? (Regardless, the answer is "no, you don't.")

kemnet;10988818 wrote:
i kinda wanted that to be dynamic

Then handle the data inside the while loop (as I said above) rather than just repeatedly storing each value into the same variable without ever using the values.

(Alternatively, if you really wanted to collect the results in an array first for whatever reason, turn $result into a multi-dimensional array (e.g. store each row's data as $result[] inside the loop).)

kemnet

ok that solved it! thanks