bind result variables

cupboy

this isn't too useful if you've got 93 columns....
$stmt->bind_result($name, $code);

I tried something doing it sort of like this..
$stmt->bind_result($array);

but it doesn't seem to care for that. Is there a way to just bind everything to an array?

bradgrafelman

cupboy;10989565 wrote:
Is there a way to just bind everything to an array?

Sure.. don't use prepared statements. 😃

NogDog

If you use PDO with prepared statements, binding of results to PHP variables is optional: you can use the fetch() and fetchAll() methods without any such binding if desired.

If using MySQLi, you can use the mysqli_stmt::get_result() method to get a result object, then use the result object's fetch_*() methods as desired instead of having to bind the results when using the stmt->fetch() method.

bradgrafelman

NogDog;10989570 wrote:
If you use PDO with prepared statements, binding of results to PHP variables is optional

D'oh, never knew that. (Then again, I never use prepared statements either, so that's probably why I know so little about them. :p)

cupboy

This is how I ended up doing it:

if ($mysqli) {        

        if ($stmt = $mysqli->prepare($sql)) 
          {
           $stmt->execute();
           $result = $stmt->get_result();           

           while ($row = $result->fetch_array(MYSQLI_NUM)) // note: $row is an array 
            {              

              $array1[]=$row;                       

            }
           $stmt->close();   

          }
          mysqli_close($mysqli);
      }

If there's a way to improve this at all go ahead and post it. Thanks.

NogDog

I prefer to use fetch_assoc(), so that the array keys are the field names, not just 0th based numeric indexes, making the code a bit more readable.

foreach($array1 as $row) {
   echo $row['user_name']."<br />\n";
}

// instead of...
foreach($array1 as $row) {
   echo $row['2']."<br />\n";
}

Also, the associative keys won't change if you add or subtract a selected column in the query.