问题描述
我在CPanel中写了一些PHP脚本.当我访问网站文件夹时 (例如www.bbbbbbbb.com/folder/) 它会这样警告.
Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/2005): Unknown MySQL server host 'host07.portalwebhosting' (1) in /home/restaur/public_html/restaurant/variables/variables.php on line 7 Warning: mysqli::set_charset() [mysqli.set-charset]: Couldn't fetch mysqli in /home/restaur/public_html/restaurant/includes/connect_database.php on line 3 Warning: mysqli::stmt_init() [mysqli.stmt-init]: Couldn't fetch mysqli in /home/restaur/public_html/restaurant/includes/login_form.php on line 45 Fatal error: Call to a member function prepare() on a non-object in /home/restaur/public_html/restaurant/includes/login_form.php on line 46
我使用默认帐户管理员访问,它给了我相同的结果.
这是我的php编码
<?php // database configuration $host ="host07.portalwebhosting.com"; $user ="user"; $pass ="password"; $database = "monkey"; $connect = new mysqli($host, $user, $pass,$database) or die("Error : ".mysql_error()); // access key to access API $access_key = "12345";?>
推荐答案
检查您的连接字符串,或者可能需要尝试使用端口
$connection = new mysqli("host", "user", "pwd", "db", "3306");
无需更改端口3306是默认 为什么使用die("Error : ".mysql_error());使用mysqli
问题描述
I am writing some php script in the cpanel. When I access the website folder (e.g. www.bbbbbb.com/folder/) It give the warning like that.
Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/2005): Unknown MySQL server host 'host07.portalwebhosting' (1) in /home/restaur/public_html/restaurant/variables/variables.php on line 7 Warning: mysqli::set_charset() [mysqli.set-charset]: Couldn't fetch mysqli in /home/restaur/public_html/restaurant/includes/connect_database.php on line 3 Warning: mysqli::stmt_init() [mysqli.stmt-init]: Couldn't fetch mysqli in /home/restaur/public_html/restaurant/includes/login_form.php on line 45 Fatal error: Call to a member function prepare() on a non-object in /home/restaur/public_html/restaurant/includes/login_form.php on line 46
And I use the default account admin to access, it gives me the same result.
And here is my php coding
<?php // database configuration $host ="host07.portalwebhosting.com"; $user ="user"; $pass ="password"; $database = "monkey"; $connect = new mysqli($host, $user, $pass,$database) or die("Error : ".mysql_error()); // access key to access API $access_key = "12345";?>
推荐答案
check your connection string or may be you need to try with port
$connection = new mysqli("host", "user", "pwd", "db", "3306");
no need to change port 3306 is default why you use die("Error : ".mysql_error()); use mysqli