Та же структура базы данных, но в файле PHP работает только 1 из них. ⇐ Php

[Гость]

Проблема в том, что я не могу получить данные из базы данных, хотя я могу получить данные из базы данных в той же системе за пределами phpmyadmin.
Здравствуйте, у меня есть такой код следующее:

Код: Выделить всё

///////////////////////// CONFIG START /////////////////////////
$config['database']['type'] = 'mysqli';
$config['database']['database'] = 'db3';
$config['database']['table_prefix'] = 'mybb_';
$config['database']['hostname'] = '172.20.0.1';
$config['database']['username'] = 'mydbuserID';
$config['database']['password'] = '????';
$config['database']['encoding'] = 'utf8';
///////////////////////// CONFIG END /////////////////////////
$db->connect($config['database']);
$fetched_array = mysqli_fetch_array($db->query("SELECT * FROM mybb_users WHERE uid='1'"), MYSQLI_ASSOC);
echo "fetched array : ".json_encode($fetched_array)."
";

This one indeed works well and return the information of admin user (uid = 1).
However, If I change db3 to db1 like the following code:

Код: Выделить всё

///////////////////////// CONFIG START /////////////////////////
$config['database']['type'] = 'mysqli';
$config['database']['database'] = 'db1';
$config['database']['table_prefix'] = 'mybb_';
$config['database']['hostname'] = '172.20.0.1';
$config['database']['username'] = 'mydbuserID';
$config['database']['password'] = '????';
$config['database']['encoding'] = 'utf8';
///////////////////////// CONFIG END /////////////////////////
$db->connect($config['database']);
$fetched_array = mysqli_fetch_array($db->query("SELECT * FROM mybb_users WHERE uid='1'"), MYSQLI_ASSOC);
echo "fetched array : ".json_encode($fetched_array)."
";

This then returns nothing. I have no idea. In both database it has user with uid=1.
Strange thing is, if i go to phpmyadmin, and run SELECT * FROM mybb_users WHERE uid='1' for "db1" database, then it works well.
phpadmin result
So it looks like "db1" is rejecting some query executed outside of phpmyadmin.
Config for both db1 and db3 are exactly same, only the database name is different. PHP version used, nginx, mysqli version, mysql version all same.
What would be the cause?


Источник: https://stackoverflow.com/questions/781 ... a-php-file