MySQLi作为数组获取[重复]

Question

This question already has an answer here:

• How to fetch all in assoc array from a prepared statement? 5 answers

ANSWER: It turns out that I had to install mysqlnd through sudo apt-get install php5-mysqlnd.

I am using PHP and mysqli. How do I fetch data from my database as an array? I currently do this, but i want it as a array:

$stmt = $cxn->prepare('SELECT username, display_name, registered_on, ip_address FROM users WHERE user_id = ?');
$stmt->bind_param('i', $userid);
$stmt->execute();
$stmt->bind_result($username, $display_name, $registered_on, $ip_address);
$stmt->fetch();
$stmt->close();

Thank you

</div>

Answer 1

try:

$query = mysqli_query($db, "SELECT `username`, `display_name`, `registered_on`, `ip_address` FROM `users` WHERE `user_id` = '{$user_id}'");
$assoc = mysqli_fetch_assoc($query);