Sign In
Create Account
Follow Us on Twitter
Subscribe on Youtube
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.
6 replies to this topic
#1
Posted 23 January 2009 - 11:46 AM
mikelbring
-
- Members
-
- 118 posts
Programmer
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.
Just doing research, thanks. What is the main difference between MySQLi vs. MySQL?
Oh in case you aren't sure, I use MySQL.
Realize the Web Web services and design.
Back to top|
|
|
#2
Guest_Jordan_*
Posted 23 January 2009 - 12:19 PM
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
Posted 23 January 2009 - 02:00 PM
amrosama
-
- Members
-
- 8,674 posts
Writes binary right handed and hex left handed
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
Posted 23 January 2009 - 02:13 PM
John
-
- Moderators
-
- 6,321 posts
Writes binary right handed and hex left handed
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_*
Posted 23 January 2009 - 03:10 PM
Guest_Jordan_*
Guest_Jordan_*
-
- Guests
Yeah, it is just a new extension in PHP for accessing MySQL.
#6
Posted 23 January 2009 - 07:12 PM
Orjan
-
- Moderators
-
- 3,299 posts
Writes binary right handed and hex left handed
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
Posted 24 January 2009 - 02:16 PM
mikelbring
-
- Members
-
- 118 posts
Programmer
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.
