如何使用Bluemix将php与IBM SQL数据库连接？ [英] How to connect php with IBM SQL Database using Bluemix?

问题描述

假设，我使用mysql_coni（）连接到mysql数据库，现在我尝试连接IBM Bluemix提供的IBM SQL数据库。

Suppose, i am connect to mysql database using mysql_coni(), so that now i am try to connect IBM SQL Database which provide by IBM Bluemix.

或者用于连接PHP的正确方法与bluemix中的IBM SQL数据库。

Which function or which correct way used to connect PHP With IBM SQL Database within bluemix.

推荐答案

要连接到Bluemix中的SQLDB服务，可以使用db2_connect。
您应该使用连接字符串而不是单独的数据库/ username / pw / etc。参数，因为它是一个远程DB服务

To connect to the SQLDB service in Bluemix you can use db2_connect. You should use a connection string instead of separate database/username/pw/etc. parameters because it is a remote DB service

以下是解析VCAP_SERVICES以连接到PHP中的SQLDB服务的示例：

Following an example of parsing VCAP_SERVICES to connect to the SQLDB service in PHP:

# Decode JSON for DB connection parameters
$services_json = json_decode($json,true);
$sqldb = $services_json["sqldb"];
if (empty($sqldb)) {
    echo "No sqldb service instance bound. Please bind a sqldb service instance before";
    return;
}

$sqldb_config = $services_json["sqldb"][0]["credentials"];

// create DB connect string
$conn_string = "DRIVER={IBM DB2 ODBC DRIVER};";
$conn_string .= "DATABASE=" . $sqldb_config["db"] . ";"; 
$conn_string .= "HOSTNAME=" . $sqldb_config["host"] . ";";
$conn_string .= "PORT=" . $sqldb_config["port"] . ";"; 
$conn_string .= "PROTOCOL=TCPIP;";
$conn_string .= "UID=" . $sqldb_config["username"] . ";";
$conn_string .= "PWD=" . $sqldb_config["password"] . ";";

// connect to database
$conn = db2_connect($conn_string, '', '');

这篇关于如何使用Bluemix将php与IBM SQL数据库连接？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！