php mysqli里查询,php – MYSQLI查询获取一个结果

参见英文答案 > Single Value Mysqli                                    8个

我只需要从mysql数据库中获取用户名为X的成员的id.

这只能通过while循环完成,还是有其他方法吗？

我在想的是：

$id = mysqli_query($con,'SELECT id FROM membrs WHERE username = '$username' LIMIT 1)

谢谢,

解决方法:

您可以使用：

mysqli_fetch_array();

// For Instance

$id_get = mysqli_query($con, "SELECT id FROM membrs WHERE username='$username' LIMIT 1");

$id = mysqli_fetch_array($id_get);

echo $id['id']; // This will echo the ID of that user

// What I use is the following for my site:

$user_get = mysqli_query($con, "SELECT * FROM members WHERE username='$username'");

$user = mysqli_fetch_array($user);

echo $user['username']; // This will echo the Username

echo $user['fname']; // This will echo their first name (I used this for a dashboard)

标签：php,mysql,mysqli,get

来源： https://codeday.me/bug/20191007/1865279.html