PHP仅获取所有数据1个 - PHP Fetch All Data Only 1 No

PHP Fetch All Data Only 1 No

本文关键字：数据 1个获取 PHP | 更新日期: 2023-09-27

我想获取所有用户，但不想获取此用户（id=12）如何实现？

$MyID = '12';
$sql_query = mysqli_query($Conn, "SELECT * FROM users WHERE country='$MyCountry'");
while ($fetch_data = mysqli_fetch_array($sql_query)) {
    $firstname = $fetch_data['firstname'];
    echo $firstname;
}

最简单的形式是：

$sql_query = mysqli_query($Conn, "SELECT * FROM users WHERE country='$MyCountry' and userid <> $MyID");

但这是不可取的，因为你的价值观没有被正确地逃脱。最好使用准备好的语句或mysqli_real_escape_string

$stmt = $mysqli->prepare("SELECT * FROM users WHERE country = ? and userId <> ?")
$stmt->bind_param("sd",$MyCountry, $MyId);
$stmt->execute();

select * from user WHERE  ID!=$mycountry;

你可以像一样轻松完成

假设您的字段是id=12

然后

SELECT * FROM your_table WHERE id <> 12