• tomekf
  • Senior Member
  • Offline
  • From: Poland
  • Registered: 2005-10-30
  • Posts: 104

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

tomekf's Website

  • From: Leuven, Belgium
  • Registered: 2005-06-14
  • Posts: 2,653

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

MySQLi would be better, as in 'improved' tongue

  • Registered: 2006-04-30
  • Posts: 382

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 Reply by Tjalve (edited by Tjalve 2007-11-07 15:25)

  • Registered: 2006-08-16
  • Posts: 92

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

Tjalve's Website