PHP mysqli连接函数 [英] PHP mysqli connect function
本文介绍了PHP mysqli连接函数的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我刚刚开始研究Mysqli,现在我已经了解了大部分内容,但是我遇到了一个将我连接到其他页面上的数据库的函数的问题。
我想要的是只输入getConnected();
这是代码: $ host ='localhost';
$ user ='logintest';
$ pass ='logintest';
$ db ='vibo';
$ mysqli = new mysqli($ host,$ user,$ pass,$ db);
if($ mysqli-> connect_error){
die('Connect Error('。mysqli_connect_errno()。')'
。mysqli_connect_error());
}
}
这是我得到的错误:
注意:未定义的变量:mysqli在C:\ xampp\htdocs\xampp\loginsystem\index.php on line 19
解决方案
正如一些用户建议的),返回mysqli实例
function getConnected($ host,$ user,$ pass,$ db){
$ mysqli = new mysqli($ host,$ user,$ pass,$ db);
if($ mysqli-> connect_error)
die('Connect Error('。mysqli_connect_errno()。')'。mysqli_connect_error());
return $ mysqli;
}
示例:
$ mysqli = getConnected('localhost','user','password','database');
I've just started to look into Mysqli and I've understood most of it now, but I'm having a problem with a function that connects me to the database on other pages.
What I'm aiming to have is to just type getConnected(); where i need to connect.
this is the code:
function getConnected() {
$host = 'localhost';
$user = 'logintest';
$pass = 'logintest';
$db = 'vibo';
$mysqli = new mysqli($host, $user, $pass, $db);
if($mysqli->connect_error) {
die('Connect Error (' . mysqli_connect_errno() . ') '
. mysqli_connect_error());
}
}
and this is the error i get:
Notice: Undefined variable: mysqli in C:\xampp\htdocs\xampp\loginsystem\index.php on line 19
解决方案
As some users have suggested (and is the best way), return the mysqli instance
function getConnected($host,$user,$pass,$db) {
$mysqli = new mysqli($host, $user, $pass, $db);
if($mysqli->connect_error)
die('Connect Error (' . mysqli_connect_errno() . ') '. mysqli_connect_error());
return $mysqli;
}
Example:
$mysqli = getConnected('localhost','user','password','database');
这篇关于PHP mysqli连接函数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文