Return result from mysql::prepare

Question

Hi this may sound noob but i have recently started working mysqli->prepare() i have a following code and i want to return back the data from my model function to controller so that i can loop through the data how can i do that?

function get_student(){
 $sql = "select student_id from student";
    $stmt = $this->db_con->prepare($sql);
    $stmt->execute();
    $stmt->bind_result($student_id);
    return ?
   }

  $result = $model->get_student();

PS : I don't want to store my result in an array and than return i know how to do that

using fetch_all or fetchall gives this error Call to undefined method mysqli_stmt::fetchall() — ahmad05, Mar 26 '14 at 10:48

Your Common Sense · Answer 1 · 2014-03-26T10:26:25.083

-1

return $stmt->get_result();

edited Mar 26 '14 at 10:26

answered Mar 26 '14 at 10:20

Your Common Sense

156,878
40
214
345

hi this works but how do I loop through the returned result in my controller?? ' – ahmad05 Mar 26 '14 at 10:50

Return result from mysql::prepare

1 Answers1