如何检查会话ID是否从一个表列中存在于另一个表列中,并回声输出错误或成功代码。
我尝试了以下内容,但没有回荡任何东西
<?php
$result = $DBcon->query("SELECT username, email, Phone_number, subcription FROM tbl_users join mergeing on tbl_users.user_id = mergeing.donator_1 where mergeing.donor = {$_SESSION['userSession']}");
if(!$result){
echo "user does not exist in Db";
}
else{
while($row = $result->fetch_array()){
}
}
?>
我使用此
修复了它$result = $DBcon->query("SELECT username, email, Phone_number, subcription FROM tbl_users join mergeing on tbl_users.user_id = mergeing.donator_1 where mergeing.donor = {$_SESSION['userSession']}");
if ($result->num_rows == 0) {
echo "YOU HAVE NOT YET BEEN CONFIRMED";
}else{
while($row = $result->fetch_array())
{
echo $row['username'];
}