php - MySQL 连接不存在 | PHP & MySQL

Question

我写了一些代码，我正在调用(需要函数).php 文件，它将连接到 MySQL 基础。该文件(不是用于 MySQL 连接的文件)我调入另一个文件，因为我想一次打开一个连接，然后关闭一次。错误说

Undefined variable: _hsync_konekcija in C:\Program Files\WAMP\www\hsync_hsync_scripts_hsync_pristup.php on line 21

_hsync_pristup.php 文件

<?php

require('_hsync_scripts/_hsync_baza.php');

function _hsync_pristup()
{
    session_start();

    if(isset($_COOKIE['_hsync_prijavljen'])) $_hsync_id = $_COOKIE['_hsync_prijavljen']; // PRIJAVLJEN
    else if(isset($_SESSION['_hsync_sess_prijavljen'])) $_hsync_id = $_SESSION['_hsync_sess_prijavljen']; // PRIJAVLJEN
    else
    {
        $_hsync_pristup_info = array(
            '_hsync_pristup' => 0
        );

        $_hsync_konekcija->close();
        return ($_hsync_pristup_info);
    }

    /* THIS LINE */ $_hsync_statment = $_hsync_konekcija->prepare("SELECT Zakljucan, Ime, Skin FROM $_hsync_usr WHERE ID = ?"); // LINE 21
    $_hsync_statment->bind_param("i", $_hsync_id);
    $_hsync_statment->execute();
    $_hsync_rezultat = $_hsync_statment->get_result();

    if($_hsync_rezultat->num_rows == 0) // OBIRSAN RAČUN
    {
        $_hsync_pristup_info = array(
            '_hsync_pristup' => -1
        );

        session_unset();
        session_destroy();
        setcookie("_hsync_prijavljen", null, -1, "/");

        $_hsync_statment->close();
        $_hsync_rezultat->close();
        $_hsync_konekcija->close();
        return ($_hsync_pristup_info);
    }

    $_hsync_podatci = $_hsync_rezultat->fetch_assoc();
    if($_hsync_podatci["Zakljucan"] != 0) // ZAKLJUČAN RAČUN
    {
        session_unset();
        session_destroy();
        setcookie("_hsync_zakljucan", $_hsync_id, time() + 8, "/");
        setcookie("_hsync_zakljucan_zap", rand(6, 16), time() + 8, "/");
        setcookie("_hsync_prijavljen", null, -1, "/");

        $_hsync_pristup_info = array(
            '_hsync_pristup' => -2
        );

        $_hsync_statment->close();
        $_hsync_rezultat->close();
        $_hsync_konekcija->close();
        return ($_hsync_pristup_info);
    }
    else
    {
        $_hsync_ime = $_hsync_podatci['Ime'];
        $_hsync_skin = $_hsync_podatci['Skin'];
    }

    $_hsync_statment = $_hsync_konekcija->prepare("SELECT ServerID FROM $_hsync_srv_online WHERE ID = ?");
    $_hsync_statment->bind_param("i", $_hsync_id);
    $_hsync_statment->execute();
    $_hsync_rezultat = $_hsync_statment->get_result();

    if($_hsync_rezultat->num_rows != 0) // PRIJAVLJEN NA GAME SERVERU
    {
        $_hsync_podatci = $_hsync_rezultat->fetch_assoc();
        $_hsync_serverid = $_hsync_podatci["ServerID"];

        session_unset();
        session_destroy();
        setcookie("_hsync_prijavljen", null, -1, "/");
        setcookie("_hsync_online", $_hsync_id, time() + 8, "/");
        setcookie("_hsync_online_id", $_hsync_serverid, time() + 8, "/");

        $_hsync_pristup_info = array(
            '_hsync_pristup' => -3
        );

        $_hsync_statment->close();
        $_hsync_rezultat->close();
        $_hsync_konekcija->close();
        return ($_hsync_pristup_info);
    }

    if(isset($_COOKIE['_hsync_zabrana'])) return (-4); // IMA ZABRANU PRISTUPA
    else // NEMA ZABRANU
    {
        $_hsync_statment = $_hsync_konekcija->prepare("SELECT ID FROM $_hsync_srv_bnds WHERE ID = ? AND Aktivno = 1"); // TRAŽI DALI JE IMA
        $_hsync_statment->bind_param("i", $_hsync_id);
        $_hsync_statment->execute();
        $_hsync_rezultat = $_hsync_statment->get_result();

        if($_hsync_rezultat->num_rows > 0) // IMA ZABRANU
        {
            session_unset();
            session_destroy();
            setcookie("_hsync_prijavljen", null, -1, "/");
            setcookie("_hsync_zabrana", $_hsync_id, time() + 31536000, "/");

            $_hsync_pristup_info = array(
                '_hsync_pristup' => -4
            );

            $_hsync_statment->close();
            $_hsync_rezultat->close();
            $_hsync_konekcija->close();
            return ($_hsync_pristup_info);
        }
    }

    $_hsync_datum = date("d. m. Y.");
    $_hsync_vrijeme = date("H:i:s");

    $_hsync_statment = $_hsync_konekcija->prepare("UPDATE $_hsync_usr SET DatumhSync = ?, VrijemehSync = ? WHERE ID = ?");
    $_hsync_statment->bind_param("ssi", $_hsync_datum, $_hsync_vrijeme, $_hsync_id);
    $_hsync_statment->execute();

    $_hsync_pristup_info = array(
        '_hsync_pristup' => 1,
        '_hsync_ime' => $_hsync_ime,
        '_hsync_id' => $_hsync_id,
        '_hsync_skin' => $_hsync_skin
    );

    return ($_hsync_pristup_info);
}

?>

其他文件

require('_hsync_scripts/_hsync_pristup.php'); // FRIST LINE ON THE TOP OF FILE

我不知道为什么 PHP 说连接变量不存在。 require('_hsync_scripts/_hsync_baza.php'); 在最上面，所以它是全局的，对吧？

Answer 1

如果 _hsync_konekcija 是全局的，那么告诉这个函数!在函数中访问它之前，把

global $_hsync_konekcija;

看看http://php.net/manual/en/language.variables.scope.php以获得更完整的变量范围描述。