CODEWITHSUNDEEP
phpmysqlmysqliflightphp
user1762634
user1762634

Reputation:

How to use mysqli on flight php framework

Flight php documentation says how can we use PDO connection to database. For instance

Flight::register('db', 'PDO', array('mysql:host=localhost;dbname=test','user','pass'));

$db = Flight::db();

$x=$db->query("SELECT * FROM `test_table` LIMIT 0, 30")->fetch(PDO::FETCH_ASSOC);

But, how can we use MySQLi in FlightPHP?

If I replace PDO with mysqli I get this error

mysqli::__construct(): php_network_getaddresses: getaddrinfo failed: Name or service not known (2)

Flight::register('db', 'mysqli', array('mysql:host=localhost;dbname=test','user','pass'));

$db = Flight::db();

$x=$db->query("SELECT * FROM `test_table` LIMIT 0, 30")->fetch_assoc();

Upvotes: 0

Views: 1790

Answers (1)

user1762634
user1762634

Reputation:

Thanks to @Andriy Maletsky I found where the mistake was.

Flight::register('db', 'mysqli', array('localhost','my_user','my_pass','my_dbname'));

$db = Flight::db();

$x = $db->query("SELECT * FROM `test_table` LIMIT 1")->fetch_assoc();

print_r($x);

Upvotes: 2

Related Questions