[primadonna]

I'm trying to retrieve stuff from db, but I'm getting this error:

Code:

Call to undefined function CodeIgniter\Database\MySQLi\mysqli_init()

Code:

SYSTEMPATH/Database\MySQLi\Connection.php at line 107

Code:

107         $this->mysqli = mysqli_init();

My db config:

PHP Code:

public $default = [
        'DSN'      => '',
        'hostname' => '0.0.0.0',
        'username' => 'username',
        'password' => 'p4ssw0rd',
        'database' => 'db_name',
        'DBDriver' => 'MySQLi',
        'DBPrefix' => '',
        'pConnect' => false,
        'DBDebug'  => (ENVIRONMENT !== 'production'),
        'cacheOn'  => false,
        'cacheDir' => '',
                'charset'  => 'utf8mb4',
        'DBCollat' => 'utf8_general_ci',
        'swapPre'  => '',
        'encrypt'  => false,
        'compress' => false,
        'strictOn' => false,
        'failover' => [],
        'port'     => 3306,
    ]; 


The query I'm running:

PHP Code:

$query = $db->query('SELECT * FROM table_name'); 


I have PHP 7.2.4, MySQL 8 in 5 compatibility mode, Windows 10, CI4 beta 1

[MGatner]

I’m mobile right now so can’t really look right now but you should definitely start by upgrading to beta 2

[primadonna]

It's the same thing with beta 2.

[InsiteFX]

To connect to the database:

PHP Code:

$db = \Config\Database::connect();

// or

$db = db_connect(); 


[primadonna]

I already have

PHP Code:

$db = db_connect(); 


[InsiteFX]

If you change the database charset to utf8mb4 then the database collation should also be changed to utf8mb4_general_ci

Your program charset and collation needs to match what the database table is set to.

[primadonna]

If you change the database charset to utf8mb4 then the database collation should also be changed to utf8mb4_general_ci

Your program charset and collation needs to match what the database table is set to.

Already tried that, it doesn't help

[titounnes]

If you change the database charset to utf8mb4 then the database collation should also be changed to utf8mb4_general_ci

Your program charset and collation needs to match what the database table is set to.

Already tried that, it doesn't help

Is php-mysqli extension installed?

[primadonna]

If you change the database charset to utf8mb4 then the database collation should also be changed to utf8mb4_general_ci

Your program charset and collation needs to match what the database table is set to.

Already tried that, it doesn't help

Is php-mysqli extension installed?

It wasn't /enabled/.

Everything is working now, thanks.