Mysql vs Mysqli

DarkRukia

n00b
Joined
Aug 11, 2005
Messages
59
I've been told Mysqli is much more secure, due to it being published more recently and a little more research, I believe that's true. My question is, I use phpmyadmin to make mysql databases, what is the equivalent for mysqli databases? I'm not sure how to set it up, will phpmyadmin work with mysqli?

Thanks
 
first off, you have to enable the mysqli module in your php.ini file.
The immediate advantage in terms of security is mysqli supports parameterized queries, which is worth it all by itself.
 
mysqli is just a different interface to MySQL from PHP. The underlying database is the same, you're just using different code to interact with it.
 
first off, you have to enable the mysqli module in your php.ini file.
The immediate advantage in terms of security is mysqli supports parameterized queries, which is worth it all by itself.

mysqli also support sprocs which can save tons of time themselves.
 
Back
Top