Page 1 of 1
mysql & mysqliextensions
Posted: Thu Aug 24, 2006 11:58 pm
by dibyendrah
Hi all,
I want to use mysqli extension using php5. currently i'm using mysql extension. Can I use both mysql and mysqli extension ?
Can I do like this ?
Code: Select all
// MySQL extension
extension=php_mysql.dll
// MySQLi extension
extension=php_mysqli.dll
Has anybody tested that ?
Dibyendra
Posted: Thu Aug 24, 2006 11:59 pm
by feyd
I have them both loaded.
Posted: Fri Aug 25, 2006 12:15 am
by RobertGonzalez
I do too. And I might add that this could have been tried before it was asked.
Posted: Fri Aug 25, 2006 12:21 am
by dibyendrah
thanks feyd ! I wish I could get an abstraction layer for both extensions so that I could only focus on other side of developement. Has anybody written that ? Please share of you have one .
Thanks
Dibyendra
Re: mysql & mysqliextensions
Posted: Fri Aug 25, 2006 12:23 am
by AKA Panama Jack
dibyendrah wrote:Hi all,
I want to use mysqli extension using php5. currently i'm using mysql extension. Can I use both mysql and mysqli extension ?
Can I do like this ?
Code: Select all
// MySQL extension
extension=php_mysql.dll
// MySQLi extension
extension=php_mysqli.dll
Has anybody tested that ?
Dibyendra
Sure you can have both loaded. They each use a different function set. So you could have a connection to a mysql database using MySql functions AND a connection to a mysql database using MySqli functions at the same time. Though I wouldn't do it as that would really be a bad practice.
But there is nothing wrong with having both modules loaded. On my developement machine I have about a dozen different database extensions loaded for testing purposes and they don't clash with each other.
Posted: Fri Aug 25, 2006 1:22 am
by dibyendrah
is there any mysqli abstraction layer written for php4/5 ? I also want to use that for testing purpose. Just interested using mysqli and if it's effective, I'll be using for real purpose.
Posted: Fri Aug 25, 2006 1:26 am
by AKA Panama Jack
Well my ADOdb Lite supports MySqli as well as many other databases.

The link is in the signature.
Hmmm, that reminds me I need to get the next version wrapped up and posted this weekend.
Posted: Fri Aug 25, 2006 1:38 am
by dibyendrah
There are two versions of adodb and adodblite. Which one is better ? lite means for speed executiion or having less modules ?
I can use anyone of them but anyone having experience on both of them can write which one is better .
Thanks
Dibyendra