php store_result,PHP: mysqli_stmt::store_result - Manual

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

$stmt->data_seek($i);

$stmt->fetch();

foreach ($ans as $key=>$value){

$result[$i][$key]=$value;

}

}

Hope will helpful for such newbies as me