Trouble with the db connection |
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 = [ 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
I’m mobile right now so can’t really look right now but you should definitely start by upgrading to beta 2
To connect to the database:
PHP Code: $db = \Config\Database::connect(); What did you Try? What did you Get? What did you Expect?
Joined CodeIgniter Community 2009. ( Skype: insitfx )
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 )
(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 Is php-mysqli extension installed?
(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 It wasn't /enabled/. Everything is working now, thanks. |
Welcome Guest, Not a member yet? Register Sign In |