MySQL连接不存在\ PHP & MySQL
MySQL连接不存在\ PHP & MySQL
提问于 2016-05-27 15:44:23
我编写了一些代码，并调用(请求函数) .php文件，该文件将连接到MySQL基。我调用这个文件(不是MySQL连接的文件)是因为我想打开一个连接一次，然后关闭它一次。错误说
未定义变量:C：\Program21行中的Files\WAMP\www\hsync_hsync_scripts_hsync_pristup.php中的_hsync_konekcija
_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');在最上面，所以它是全球性的，对吗？
回答 2
Stack Overflow用户
回答已采纳
发布于 2016-05-27 15:52:47
如果_hsync_konekcija是全局的，那么告诉函数！在函数中访问它之前，将
global $_hsync_konekcija;查看http://php.net/manual/en/language.variables.scope.php，以获得更全面的变量范围描述。
Stack Overflow用户
发布于 2016-05-27 15:53:09
我认为这是一个范围界定的问题。基本上，您的函数无法访问外部实例化的局部变量(您从文件中包含的变量)。
有两种选择。
1)需要函数中的“_hsync_baza.php”文件。
<?php
function _hsync_pristup(){
session_start();
require('_hsync_scripts/_hsync_baza.php');
...
}2)“使用”你需要的变量。
<?php
require('_hsync_scripts/_hsync_baza.php');
function _hsync_pristup() use ($_hsync_konekcija, $_hsync_SOMETHING_ELSE, ..){
...
}作为最后的推荐，我将把session_start()调用从函数中移到文件的顶部。$_SESSION变量是“超级全局变量”，因此尽管是从函数外部初始化的，但是可以从它内部访问它们。
希望这能有所帮助
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/37487569
复制相关文章
相似问题
腾讯云开发者
