php - fatal error : Call to a member function set_charset()

Question

我正在使用 Cpanel 开发我的应用程序。它给出了错误

Fatal error: Call to a member function set_charset() on a non-object in /home/restaur  /public_html/restaurant/includes/connect_database.php on line 3

当我访问“www.yyyyy.com/filename/”时

这是我的连接数据库脚本

<?php 
include($_SERVER['DOCUMENT_ROOT'].'/YOUR_FOLDER/variables/variables.php'); 
$connect->set_charset('utf8');  
?>

我的关闭数据库脚本

<?php
include($_SERVER['DOCUMENT_ROOT'].'/YOUR_FOLDER/variables/variables.php');
$connect->close();
?>

我的变量脚本

<?php
// database configuration
$host ="db_host_name";
$user ="db_username";
$pass ="db_pasword";
$database = "database_name";
$connect = new mysqli($host, $user, $pass,$database) or die("Error :       ".mysql_error());?>

Answer 1

应该是这样的

$host ="db_host_name";
$user ="db_username";
$pass ="db_pasword";
$database = "database_name";

// variables.php
$connect = new mysqli($host, $user, $pass, $database);

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

现在在 connect_database.php

// Make sure your included path is correct
include($_SERVER['DOCUMENT_ROOT'].'/YOUR_FOLDER/variables/variables.php'); 
global $connect;

$connect->set_charset('utf8');

这将帮助您更深入地了解global