我一直在尝试比较两个字符串,一个是用户输入的用户名,第二个是我的程序从数据库中提取的数据。这是我的php代码:
$sqlCheck = "SELECT Username FROM location WHERE Username ='$usernamebeingreq'" ;
$result2 = mysqli_query($con, $sqlCheck);
$result2 = mysql_fetch_array($result2);
$resultCheck = false;
//mysqli_query($con, $sqlCheck);
if((strcmp($result2, $usernamebeingreq) == 1))
{
$sql="INSERT INTO pending_req (fromUser, toUser) VALUES ('$username', '$usernamebeingreq')";
$resultCheck = true;
}
$usernamebeingreq等于他们输入的用户,结果应该等于从数据库中提取时的结果。我不知道为什么它不能正常工作。
不能像这样组合mysql_和mysqli_。此外,您需要对结果集进行迭代以获得值,然后进行比较:
$result2 = mysqli_query($con, $sqlCheck);
while ($row2 = mysqli_fetch_array($result2))
{
$username_to_check = $row2['Username'];
}
$resultCheck = false;
if((strcmp($username_to_check , $usernamebeingreq) == 1))
/* rest of your code */
有关mysqli_fetch_函数的详细信息:http://php.net/manual/en/mysqli-result.fetch-array.php