Jump to content


Check out our Community Blogs

Register and join over 40,000 other developers!


Recent Status Updates

View All Updates

Photo
- - - - -

MySQL vs MySQLi

mysqli mysql

  • Please log in to reply
6 replies to this topic

#1 mikelbring

mikelbring

    CC Addict

  • Advanced Member
  • PipPipPipPipPip
  • 117 posts

Posted 23 January 2009 - 11:46 AM

Whats the major difference? Should I switch? Queries are the same right? I heard MySQLi is slower, is that true?

Just doing research, thanks. What is the main difference between MySQLi vs. MySQL?

Oh in case you aren't sure, I use MySQL.

Edited by Roger, 09 September 2010 - 09:27 AM.

  • 0

Realize the Web Web services and design.


#2 Guest_Jordan_*

Guest_Jordan_*
  • Guest

Posted 23 January 2009 - 12:19 PM

MySQLi is faster thus the name MySQL Improved. MySQLi also supports all of the features of MySQL 5.0 such as transactions. The MySQL (not improved) extension will also be dropped from PHP6 (you can still install it, if needed) and replaced with MySQLi.
  • 0

#3 amrosama

amrosama

    CC Mentor

  • VIP Member
  • PipPipPipPipPipPipPipPip
  • 2765 posts

Posted 23 January 2009 - 02:00 PM

whats the equalivant tool for using mysqli, like phpadmin for mysql?
  • 0
yo homie i heard you like one-line codes so i put a one line code that evals a decrypted one line code that prints "i love one line codes"
eval(base64_decode("cHJpbnQgJ2kgbG92ZSBvbmUtbGluZSBjb2Rlcyc7"));
www.amrosama.com | the unholy methods of javascript

#4 John

John

    CC Mentor

  • Moderator
  • 4450 posts
  • Location:New York, NY

Posted 23 January 2009 - 02:13 PM

whats the equalivant tool for using mysqli, like phpadmin for mysql?


I think you missed the point. Mysqli and mysql are not different database servers. Mysqli is just an improved way for php to communicate with the same old database. phpmyadmin will still work.
  • 0

#5 Guest_Jordan_*

Guest_Jordan_*
  • Guest

Posted 23 January 2009 - 03:10 PM

Yeah, it is just a new extension in PHP for accessing MySQL.
  • 0

#6 Orjan

Orjan

    CC Mentor

  • Moderator
  • 2918 posts
  • Location:Karlstad, Sweden
  • Programming Language:C, Java, C++, C#, PHP, JavaScript, Pascal
  • Learning:Java, C#

Posted 23 January 2009 - 07:12 PM

The most obvious difference when starting programming with MySQLi is that it's an object you work with instead of all those lose variables, but when you dig deeper, it's many more differences, that gives more security possibilities, among others, but yes, the sql queries are the same (even if you can do them in a new partly improved way too)
  • 0

#7 mikelbring

mikelbring

    CC Addict

  • Advanced Member
  • PipPipPipPipPip
  • 117 posts

Posted 24 January 2009 - 02:16 PM

Thanks for the info. I am looking to change my mysql class to use mysqli, just looking at everything I would need to change.
  • 0

Realize the Web Web services and design.






Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download