• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Trouble with the db connection

#1
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
Reply

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

#3
It's the same thing with beta 2.
Reply

#4
To connect to the database:

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

// or

$db db_connect(); 
What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )
Reply

#5
I already have
PHP Code:
$db db_connect(); 
Reply

#6
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.
What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )
Reply

#7
(04-08-2019, 03:12 AM)InsiteFX Wrote: 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
Reply

#8
(04-08-2019, 08:10 AM)primadonna Wrote:
(04-08-2019, 03:12 AM)InsiteFX Wrote: 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?
Reply

#9
(04-09-2019, 01:22 AM)titounnes Wrote:
(04-08-2019, 08:10 AM)primadonna Wrote:
(04-08-2019, 03:12 AM)InsiteFX Wrote: 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.
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.