将db连接到函数中

Question

我无法将db连接到函数中：db连接丢失到函数中。 错误：mysqli_query（）预计参数1是mysqli的，空给出

$dbcon = mysqli_connect($db_server, $db_user, $db_passwd); 

/* check connection */ 
if ($dbcon->connect_errno) { 
    printf("Connect failed: %s\n", $dbcon->connect_error); 
    exit(); 
} 

mysqli_select_db($dbcon,$db_name); 

function news() 
{ 

    $numPosts = mysqli_query($dbcon, 'SELECT count(*) as total FROM ' . $db_prefix . 'news'); 
} 

预先感谢您

Answer 1

可以稍微重写你的函数访问$ dbcon作为一个全局变量：

function news() { 

    global $dbcon; 

    $numPosts = mysqli_query($dbcon, 'SELECT count(*) as total FROM ' . $db_prefix . 'news'); 

} 

或将其作为参数传递给news（）：

function news($dbcon) { 

    $numPosts = mysqli_query($dbcon, 'SELECT count(*) as total FROM ' . $db_prefix . 'news'); 

}