Killersites Community: MySQL vs MySQLi - Killersites Community

Jump to content

KillerSites Network

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

MySQL vs MySQLi

#1 User is offline   benjaminmorgan 

  • PipPipPipPip
  • View blog
  • Group: Member
  • Posts: 237
  • Joined: 18-September 11

Posted 19 November 2011 - 12:32 PM

What is the difference and which one should be used and why?
Things should be made as simple as possible, but not any simpler. -Albert Einstein
0

#2 User is offline   Ben 

  • View blog
  • Group: Administrators
  • Posts: 5,409
  • Joined: 19-December 08
  • LocationChico, CA

Posted 19 November 2011 - 03:45 PM

See http://uk3.php.net/m...li.overview.php

On the surface, both do about the same thing -- allow you to communicate with a database. MySQLi has some advantages though:

- object-oriented interface
- support for prepared statements (which prevent SQL injection)
- support for multiple statements
- support for transactions
- enhanced debugging capabilities
- embedded server support.

I would definitely suggest going with MySQLi or PDO over plain MySQL, since both MySQLi and PDO support prepared statements, which allow you to escape any data that you use in your queries, preventing SQL injection (http://www.tizag.com...injection.php).
Benjamin Falk | Falken Creative : Twitter : KillerSites Screencast Blog
Skills: Photoshop, Illustrator, HTML, CSS, jQuery, PHP and CodeIgniter
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users