Php web application can't process clearDB mysql service on bluemix

Question

I'm trying to deploy a php web application on bluemix. So I have bound a clearDB mysql service to my application. The vcap_service variable are provided to me. but when I use those variable to perform simple sql query, the application page does nothing, while same code is doing well with xamp localhost. please help me.

here is the code :

<?php
$servername = "us-cdbr-iron-east-02.cleardb.net";
$username = "b23807********";
$password = "********";
$dbname = "ad_70723170af1****";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// sql to create table
$sql = "CREATE TABLE flybird (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
email VARCHAR(50),
reg_date TIMESTAMP
)";

if ($conn->query($sql) === TRUE) {
    echo "Table flybird created successfully";
} else {
    echo "Error creating table: " . $conn->error;
}

$conn->close();
?>

The following error is showing: Got error 'PHP message: PHP Fatal error: Class 'mysqli' not found in /home/vcap/app/htdocs/table.php on line 8\n.

Can you please post output of : cf logs **appname** --recent — vmovva, Jun 01 '15 at 15:09
Yup! mysqli function was the problem. Now app is doing great . A lot of thanks — Sahil S., Jun 02 '15 at 04:07

score 2 · Answer 1 · answered Jun 01 '15 at 20:31

2

There is an issue with the php buildpack, you need to explicitly add the mysqli function in your application.

Create a file called .bp-config/options.json. You can customize the php buildpack extensions, check this out for more info.

The contents should contain the following.

{
    "PHP_EXTENSIONS": ["mysqli"]
}

answered Jun 01 '15 at 20:31

Jeff Sloyer

4,899
1
24
48

Yup! mysqli function was the problem. Now app is doing great . A lot of thanks – Sahil S. Jun 02 '15 at 04:06

score 0 · Answer 2 · answered Aug 19 '15 at 16:28

0

you should specify mysqli dependency on composer.json config.

{"require": { "ext-mysqli": "*" } }

answered Aug 19 '15 at 16:28

v.bontempi

1,562
1
9
10

Rafael Pereira · Answer 3 · 2015-06-01T23:33:07.227

-2

I think you need to explicitly add the mysqli function in your application

You have to enable the library in .bp-config/options.json file. Like the example below

EX:

{ "PHP_EXTENSIONS": ["mysqli"] }

If you don't have this file in your aplication just create it, add the extension and push it to your Bluemix app. (link)

Check this page on developerworks for more information , i think it is the same issue you are having (link)

edited Jun 01 '15 at 23:33

answered Jun 01 '15 at 16:29

Rafael Pereira

1
3

Yup! mysqli function was the problem. Now app is doing great . A lot of thanks – Sahil S. Jun 02 '15 at 04:07

Php web application can't process clearDB mysql service on bluemix

3 Answers3