使用php打开Shift Mysql数据连接 - Open Shift Mysql data connection using php

Open Shift Mysql data connection using php

我对开放轮班更新鲜。这是我在轮班时遇到的问题。我完成了用php, Mysql和PhpMyAdmin创建应用程序然后我去phpMyAdmin创建了一个新的数据库Students_list现在我无法在php页面中使用以下代码连接到我的数据库。

$db_host = $_ENV['127.12.123.2']; //sample host 
$db_user = $_ENV['adminnxUpXA6'];
$db_pass = $_ENV['lyPfbtHYpDFcU'];
$db_name = $_ENV['students_list']; //this is the database I created in PhpMyAdmin
$db = new mysqli($db_host, $db_user, $db_pass);
if ($db->connect_errno) {
    die('Connect Error (' . $db->connect_errno . ') '
        . $db->connect_error);
}
mysqli_select_db($db,$db_name);

试试这个:

$db_host = getenv('OPENSHIFT_MYSQL_DB_HOST'); //sample host 
$db_user = getenv('OPENSHIFT_MYSQL_DB_USERNAME');
$db_pass = getenv('OPENSHIFT_MYSQL_DB_PASSWORD');
$db_name = 'students_list'; //this is the database I created in PhpMyAdmin
$db = new mysqli($db_host, $db_user, $db_pass);
if ($db->connect_errno) {
    die('Connect Error (' . $db->connect_errno . ') '
        . $db->connect_error);
}
mysqli_select_db($db,$db_name);

您正在使用$_ENV，它包含来自操作系统的环境变量。您想要做的最有可能是:

$db_host = 'ip';
$db_user = 'username';
$db_pass = 'password';
$db_name = 'students_list';

mysqli连接字符串的结构如下:

mysqli(Hostname,Username,Password,DatabaseName);