Thank you Scott. I re-tested by mounting your code in qa-config.php.
***** Code *****
<?php
define('QA_MYSQL_HOSTNAME', '**** host ****');
define('QA_MYSQL_USERNAME', '*** user ***');
define('QA_MYSQL_PASSWORD', '*** pw ***');
define('QA_MYSQL_DATABASE', '*** db ***');
echo '<html>'.PHP_EOL;
echo '<body>'.PHP_EOL;
echo '<h1>MySQLi test</h1>'.PHP_EOL;
echo '<h2>Create mysqli object</h2>'.PHP_EOL;
$db = new mysqli(QA_MYSQL_HOSTNAME, QA_MYSQL_USERNAME, QA_MYSQL_PASSWORD, QA_MYSQL_DATABASE);
echo '<h2>Connect result</h2>'.PHP_EOL;
echo '<pre>'.PHP_EOL;
echo 'db = '.print_r($db,true).PHP_EOL;
echo '</pre>'.PHP_EOL;
echo '<h2>Get connection status</h2>'.PHP_EOL;
$error = mysqli_connect_error();
if($error) {
echo 'Error!!'.PHP_EOL;
echo '<pre>'.PHP_EOL;
echo 'error = '.print_r($error,true).PHP_EOL;
echo '</pre>'.PHP_EOL;
} else {
echo 'Success!!'.PHP_EOL;
}
echo '</body>'.PHP_EOL;
echo '</html>'.PHP_EOL;
***** Result *****
MySQLi test
Create mysqli object
Connect result
db = mysqli Object
(
[affected_rows] => 0
[client_info] => mysqlnd 5.0.10 - 20111026 - $Id: *************************************************** $
[client_version] => 50010
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 0
[host_info] => **** host **** via TCP/IP
[info] =>
[insert_id] => 0
[server_info] => 5.5.38-log
[server_version] => 50538
[stat] => Uptime: 918372 Threads: 5 Questions: 94327756 Slow queries: 8 Opens: 136585 Flush tables: 1 Open tables: 19200 Queries per second avg: 102.711
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 3415302
[warning_count] => 0
)
Get connection status
Success!!
***** My consideration *****
MySQLi connection is succeed. . .
My test of Q2A installation might have been insufficient...????
I would try a little more debug Q2A installation process.
