note 117546 added to mysqli-stmt.store-result

Lost some hours to find out how to save multirows result of mysqli_stmt to array, when get_result prohibited. Idea, which works is using store_result $stmt=$this->mysqli->prepare("SELECT surname, name, user_id, last_m_own, last_m_str, role FROM users WHERE referer_id=(?)"); $stmt->bind_param('i',$referer_id); $stmt->execute(); $stmt->store_result(); $stmt->bind_result($ans['surname'], $ans['name'], $ans['user_id'], $ans['last_m_own'], $ans['last_m_str'], $ans['role']); $j=$stmt->num_rows; for ($i=0;$i<$j;$i++){ $stmt->data_seek($i); $stmt->fetch(); foreach ($ans as $key=>$value){ $result[$i][$key]=$value; } } Hope will helpful for such newbies as me ---- Server IP: 72.52.91.14 Probable Submitter: 195.69.85.78 ---- Manual Page -- http://php.net/manual/en/mysqli-stmt.store-result.php Edit -- https://master.php.net/note/edit/117546 Del: integrated -- https://master.php.net/note/delete/117546/integrated Del: useless -- https://master.php.net/note/delete/117546/useless Del: bad code -- https://master.php.net/note/delete/117546/bad+code Del: spam -- https://master.php.net/note/delete/117546/spam Del: non-english -- https://master.php.net/note/delete/117546/non-english Del: in docs -- https://master.php.net/note/delete/117546/in+docs Del: other reasons-- https://master.php.net/note/delete/117546 Reject -- https://master.php.net/note/reject/117546 Search -- https://master.php.net/manage/user-notes.php