在Openshift中PHP MySQL 5.5 db连接 [英] PHP MySQL 5.5 db connection in Openshift
问题描述
我对openshift和这些git,ssh编程非常陌生。到目前为止,我发展了这么多。
安装了PHP 5.3,MySQL 5.5,phpMyAdmin 4.0盒式磁带
这是我在php中的dbcon文件。
基本上我需要将我的php应用程序与openshift mysql db连接起来。这是我做的。
<?php
//数据库连接设置
$ dbhost =127.0.0.1; //主机名
$ dbport =3308; //主机端口
$ dbusername =user; // Mysql username
$ dbpassword =pass; // Mysql密码
$ db_name =mf; //数据库名称
$ mysqlCon = mysqli_connect($ dbhost,$ dbusername,$ dbpassword,,$ dbport)或die(Error:。mysqli_error($ mysqlCon));
mysqli_select_db($ mysqlCon,$ db_name)或死(Error:。mysqli_error($ mysqlCon));
?>
这给了我一个openshift错误,但适用于其他php应用程序。我没有得到任何关于错误的解释,只有错误:{... blank space ...}。
你可以帮我解决这个问题吗?
非常感谢你的努力。之前没有引发视觉错误。但我已经做到了这一点。
**
全球使用
$ b $ $ p $
define('DB_HOST',getenv('OPENSHIFT_MYSQL_DB_HOST')) ;
define('DB_PORT',getenv('OPENSHIFT_MYSQL_DB_PORT'));
define('DB_USER',getenv('OPENSHIFT_MYSQL_DB_USERNAME'));
define('DB_PASS',getenv('OPENSHIFT_MYSQL_DB_PASSWORD'));
define('DB_NAME',getenv('OPENSHIFT_GEAR_NAME'));
$ dbhost =常量(DB_HOST); //主机名
$ dbport =常量(DB_PORT); //主机端口
$ dbusername =常量(DB_USER); // MySQL用户名
$ dbpassword =常量(DB_PASS); // MySQL密码
$ db_name =常量(DB_NAME); //数据库名称
**
或者
** $ dbhost = getenv('OPENSHIFT_MYSQL_DB_HOST' ); //主机名
$ dbport = getenv('OPENSHIFT_MYSQL_DB_PORT'); //主机端口
$ dbusername = getenv('OPENSHIFT_MYSQL_DB_USERNAME'); // MySQL用户名
$ dbpassword = getenv('OPENSHIFT_MYSQL_DB_PASSWORD'); // MySQL密码
$ db_name = getenv('OPENSHIFT_GEAR_NAME'); //数据库名称
$ dbhost = getenv('OPENSHIFT_MYSQL_DB_HOST' ); //主机名
$ dbport = getenv('OPENSHIFT_MYSQL_DB_PORT'); //主机端口
$ dbusername = getenv('OPENSHIFT_MYSQL_DB_USERNAME'); // MySQL用户名
$ dbpassword = getenv('OPENSHIFT_MYSQL_DB_PASSWORD'); // MySQL密码
$ db_name = getenv('OPENSHIFT_GEAR_NAME'); //数据库名称
I'm very new to openshift and these git, ssh programming. I developed this much so far. Installed PHP 5.3, MySQL 5.5, phpMyAdmin 4.0 Cartridges
This is my dbcon file in php. Basically i need to connect my php application with openshift mysql db. Here's what i did.
<?php
// Database Connection Setting
$dbhost = "127.0.0.1"; // Host name
$dbport = "3308"; // Host port
$dbusername = "user"; // Mysql username
$dbpassword = "pass"; // Mysql password
$db_name = "mf"; // Database name
$mysqlCon = mysqli_connect($dbhost, $dbusername, $dbpassword, "", $dbport) or die("Error: " . mysqli_error($mysqlCon));
mysqli_select_db($mysqlCon, $db_name) or die("Error: " . mysqli_error($mysqlCon));
?>
This gives me an error on openshift but works for other php apps. I get nothing on error explanation only as Error: { ...blank space... }.
can you help me out guys?
Thanks alot for your efforts guys. No visual error thrown before. but I've made it to work by doing this.
**
Global Use
**
define('DB_HOST', getenv('OPENSHIFT_MYSQL_DB_HOST'));
define('DB_PORT', getenv('OPENSHIFT_MYSQL_DB_PORT'));
define('DB_USER', getenv('OPENSHIFT_MYSQL_DB_USERNAME'));
define('DB_PASS', getenv('OPENSHIFT_MYSQL_DB_PASSWORD'));
define('DB_NAME', getenv('OPENSHIFT_GEAR_NAME'));
$dbhost = constant("DB_HOST"); // Host name
$dbport = constant("DB_PORT"); // Host port
$dbusername = constant("DB_USER"); // MySQL username
$dbpassword = constant("DB_PASS"); // MySQL password
$db_name = constant("DB_NAME"); // Database name
**
Alternatively
**
$dbhost = getenv('OPENSHIFT_MYSQL_DB_HOST'); // Host name
$dbport = getenv('OPENSHIFT_MYSQL_DB_PORT'); // Host port
$dbusername = getenv('OPENSHIFT_MYSQL_DB_USERNAME'); // MySQL username
$dbpassword = getenv('OPENSHIFT_MYSQL_DB_PASSWORD'); // MySQL password
$db_name = getenv('OPENSHIFT_GEAR_NAME'); // Database name
这篇关于在Openshift中PHP MySQL 5.5 db连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!