Topic: MySQL or MySQLi, which is better and why?

Hi,

Could you tell me which database type MySQL or MySQLi is better and why?

Darmowe forum - Polish free forum hosting

Re: MySQL or MySQLi, which is better and why?

MySQLi would be better, as in 'improved' tongue

Re: MySQL or MySQLi, which is better and why?

The database itself and the engine are the exact same.
The only difference is that php uses a different set of functions to access it.
I am not aware of the advantages as i never used mysqli myself, but i would guess that all in all there is no noticeable difference. I use mysql, without the 'i' for no particular reason, i just do.
If your forums are small you can actualy go for sqlite which can be more practical, if you are running php5

4 (edited by Tjalve 2007-11-07 15:25)

Re: MySQL or MySQLi, which is better and why?

MySQLI:
Object-oriented interface
Prepared statements
Bound input and output parameters
SSL connections
Multi-query functions
Designed to work with the version 4.1.3 or above of MySQL

Post hoc ergo propter hoc