检测值是否包含在一行中 - Detect if value is contained in a row

Detect if value is contained in a row

本文关键字：一行是否包含检测 | 更新日期: 2023-09-27

基本上我有一个这样的表:

|id|username|password|email|hasAlphaKey|
 1  test1    test2    -----      1
 2  test2    test3    -----      0

，我想检测hasAlphaKey == 1，我怎么才能做到这一点?

我试过这样做:

$hasAlphaKey = mysql_query("SELECT * FROM Accounts WHERE hasAlphaKey='1'");
$check_for_key = mysql_num_rows($hasAlphaKey);
if($check_for_key == 1) {
  echo 'You have an alpha key!';
}

If与Account test1一起工作，因为它在hasAlphaKey中的值为1但是，当我登录到test2，它仍然行echo 'You have an alpha key!';，但值设置为零?

可以帮我一下吗?:)

|id|username|password|email|hasAlphaKey|
 1  test1    test2    -----      1
 2  test2    test3    -----      0

$qry="SELECT * FROM Accounts WHERE hasAlphaKey=1 AND username='test2'";
$result123 = mysql_query($qry);
$check_for_key = mysql_num_rows($result123);
if($check_for_key == 1) {
  echo 'You have an alpha key!';
}

对于username='test1'，它应该回显。

对于username='test2'，不应该回显

test1有alpha key, test2没有。表中有1个键值为α的元素。代码按预期工作。也许你想这样做

SELECT * FROM Accounts WHERE hasAlphaKey=1 AND username='test2'

$hasAlphaKey = mysql_query("SELECT * FROM Accounts");
$check_for_key = mysql_num_rows($hasAlphaKey);
$row = mysql_fetch_assoc($hasAlphaKey);
$hasKey = $row['hasAlphaKey'];
if($hasKey == 1) {
     echo 'You have an alpha key!';
}