I recently switched to mysqli from mysql and started using prepared statements. in mysql we do
$result = mysql_query("SELECT * FROM table WHERE id = ?");
So we get the array of whole table in one variable.
But in mysqli we do
mysqli_stmt_bind_result($stmt, $result);
so basically here only one variable gets bind to variable result.
How can we get the same variable(array) that we got from mysql?
PS - Hope my ques is clear enough. I know their are not many methods possible but i am luking for the best one.
PSS - I am more comfortable with the procedural way.