Mysqli_query()期望参数1为mysqli,是否为null?令人困惑? [英] Mysqli_query() expects parameter 1 to be mysqli, null given? Confusing?
本文介绍了Mysqli_query()期望参数1为mysqli,是否为null?令人困惑?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
define('DB_HOST', 'localhost');
define('DB_USER', '******');
define('DB_PASSWORD', '************');
define('DB_NAME', '***********');
$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
class User {
function checkUser($uid, $oauth_provider,$username,$email,$twitter_otoken,$twitter_otoken_secret)
{
$query = mysqli_query($dbc,"SELECT * FROM si_table WHERE oauth_uid = '$uid' and oauth_provider = '$oauth_provider'");
$result = mysqli_fetch_array($query);
if (!empty($result)) {
# User is already present
} else {
#user not present. Insert a new Record
$query = mysqli_query($dbc,"INSERT INTO si_table (oauth_provider, oauth_uid, user_name,email_id,twitter_oauth_token,twitter_oauth_token_secret) VALUES ('$oauth_provider', $uid, '$username','$email')") ;
$query = mysqli_query($dbc,"SELECT * FROM si_table WHERE oauth_uid = '$uid' and oauth_provider = '$oauth_provider'");
$result = mysqli_fetch_array($query);
return $result;
}
return $result;
}
}
我收到此错误!我不知道为什么? mysqli_query()期望参数1为mysqli,在第14、15、20、21和22行中给出null!
I am getting this error! I don;t know why? mysqli_query() expects parameter 1 to be mysqli, null given in line 14,15,20,21 and 22!
推荐答案
在checkUser
的开头添加global $dbc;
.该变量未在函数范围内定义.
Add global $dbc;
to the beginning of the checkUser
. The variable is not defined in the function scope.
这篇关于Mysqli_query()期望参数1为mysqli,是否为null?令人困惑?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文