LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   which is better "mysql" or "mysqli" to use in php 5.2.6 !? (https://www.linuxquestions.org/questions/linux-server-73/which-is-better-mysql-or-mysqli-to-use-in-php-5-2-6-a-688631/)

robertjinx 12-05-2008 05:38 PM

which is better "mysql" or "mysqli" to use in php 5.2.6 !?
 
I am using phpmyadmin, and I was wondering what is the actual difference between mysql and mysqli? Which would be better to you? Please let me know, would be very appreciated.

Thanks!

Acron_0248 12-07-2008 08:32 AM

Mysqli is an extension composed by several OOP classes. There is the Mysqli base class, mysqli Result class, STMT class and Driver class.

It's basically an oop approach to the previous mysql extension so most of the things in mysqli are based on the same functions offered by mysql with a few additions like prepared statements. You may use it in a procedural design or OOP design which make it very portable :)

It is a very good extension and a nice improvement over the mysql extension, so if want to use it, go for it, but if you pretend to use it later in a proyect of yours at some hosting, keep mind that many hosting services offers mysql and pdo_mysql, not mysqli


All times are GMT -5. The time now is 07:47 AM.