Can I use MySQLi instead of MySQL without any issue? |
[eluser]Unknown[/eluser]
Hello, I have a live site coded in CI. I heard MySQLi is much better, how can I switch without any issue? Thanks.
[eluser]BrianDHall[/eluser]
MySQLi isn't a database: http://www.php.net/manual/en/intro.mysqli.php Quote:What is PHP's mysqli Extension? CI uses a database abstraction layer, so if you want to use mysqli functionality - and I don't know how it could be of any help, or harm for that matter - in config/database.php: $db['default']['dbdriver'] = "mysql"; becomes $db['default']['dbdriver'] = "mysqli"; ...and that's it, as far as I can tell. CI comes with an adapter/driver for mysqli, its just PHP5 only and less commonly used. From the mysqli_driver.php: Code: **
[eluser]Unknown[/eluser]
I know, MySQLi is a better database layer for PHP 5 and MySQL 4.1+. I was just wondering if I can switch only by changing the DB driver in database config file. Thanks. |
Welcome Guest, Not a member yet? Register Sign In |