获取数组的最佳方法是什么

Question

Alright, so I believe that there is a better way that I can fetch an array from the database, here's the code right now that I have.

$id = 1;
$userquery = mysql_query("SELECT * FROM login WHERE id='$id'");

while($row = mysql_fetch_array($userquery, MYSQL_ASSOC)) {
    $username = $row['username'];
    $password = $row['password'];
    $email = $row['email'];
}

Answer 1

So If I am not wrong, you want a better way to get all the returned rows from mysql in a single statement, instead of using the while loop.

If thats the case, then I must say mysql_ drivers do not provide any such functionality, which means that you have to manually loop through them using foreach or while.

BUT, since mysql_ is already depricated, you are in luck! you can actually switch to a much better and newer mysqli_ or the PDO drivers, both of which DO actually have functions to get all the returned rows.

For mysqli_: mysqli_result::fetch_all

For PDO : PDOStatement::fetchAll

Eg.

mysqli_fetch_all($result,MYSQLI_ASSOC); 
// The second argument defines what type of array should be produced 
// by the function. `MYSQLI_ASSOC`,`MYSQLI_NUM`,`MYSQLI_BOTH`.