Jump to content


Photo

mysql vs mysqli


  • Please log in to reply
1 reply to this topic

#1 earl_dc10

earl_dc10
  • Members
  • PipPipPip
  • Advanced Member
  • 71 posts

Posted 05 April 2006 - 02:38 AM

hey, I stumbled upon MySQLi at php.net when I misspelled a function name. I was wondering what the difference was, the functions look identical and the only difference I noticed was that MySQLi is MySQL Improved Extension. but I was wondering if anyone knew what the actual difference was or "improvement" is. thanks!
got a problem? Google helps many of those in need

#2 wildteen88

wildteen88
  • Staff Alumni
  • Advanced Member
  • 10,482 posts
  • LocationUK, Bournemouth

Posted 05 April 2006 - 09:15 AM

MySQLi's functions in PHP is different to the normal mysql extensions. As people that do alot of OOP (object oriented programming) can use the inbuilt mysql class with the mysqli extension to connect to the mysql database.

Also alot of the mysqli_x functions have slightly different syntax compared to normal mysql_x functions. Such as the parameters are in different locations or some have more parameters too.

Generaly mysqli is alot more better than the original mysql extension.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users