mySQLi

Is using SQLi less reliable or break easier than MySql?
BlackHairedAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

re-searcherCommented:
No I don't thing so, because it improved version of MySQL and not different database server. and MySQLi is faster thus the name MySQL Improved. MySQLi also supports all of the features of MySQL such as transactions and etc. . The MySQL (not improved) extension will also be dropped from PHP6 (you can still install it, if needed) and replaced with MySQLi.
MySQLi many more differences, that gives more security possibilities, among others,
0
Dave BaldwinFixer of ProblemsCommented:
This page tells a lot about the different MySQL methods in PHP: http://us3.php.net/manual/en/mysqli.overview.php
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
XzKtoCommented:
Mysqli is much more reliable when used proper. Using transactions can greatly reduce chance of changing only part of data (if you are using InnoDb). Using prepared statements can improve mysql queries speed(when you use lots of similar queries) and it does proper escaping for you.

From official mysql manual:

If you are using MySQL versions 4.1.3 or later it is strongly recommended that you use this extension (mysqli).

But there is one downside: mysqli is only supported on php5 and not all hostings provide it.

There is also PDO, witch is usually much better as it can use lots of different databases with small code changes.

TLDR: If you are writing application for php5 it is recommended to use mysqli over mysql.
0
BlackHairedAuthor Commented:
That was the best answer!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.