Jump to content

MySQL vs MySQLi

- - - - -

This topic has been archived. This means that you cannot reply to this topic.
6 replies to this topic

#1
mikelbring

mikelbring

    Programmer

  • Members
  • PipPipPipPip
  • 118 posts
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.

Realize the Web Web services and design.


#2
Guest_Jordan_*

Guest_Jordan_*
  • Guests
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.

#3
amrosama

amrosama

    Writes binary right handed and hex left handed

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 8,674 posts
whats the equalivant tool for using mysqli, like phpadmin for mysql?
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

    Writes binary right handed and hex left handed

  • Moderators
  • 6,321 posts

amrosama said:

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.

#5
Guest_Jordan_*

Guest_Jordan_*
  • Guests
Yeah, it is just a new extension in PHP for accessing MySQL.

#6
Orjan

Orjan

    Writes binary right handed and hex left handed

  • Moderators
  • 3,299 posts
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)

#7
mikelbring

mikelbring

    Programmer

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

Realize the Web Web services and design.