marthar Posted May 20, 2008 Share Posted May 20, 2008 I'm very new to PHP and mysql. I'm looking at installing a php app for myself and several friends, and have some questions. What is the difference between mysql and mysqli? Should I use myisam tables or innodb? Once I make a decision, how hard is it to switch if I need to? If I get used to mysql and myisam for example, would using mysqli and/or innodb be a matter of changing a config setting, or would there be more I would need to understand? Would it make any difference if the host is a Windows or Unix host, assuming the host already has PHP 5 and mysql 5 installed? Quote Link to comment Share on other sites More sharing options...
wildteen88 Posted May 20, 2008 Share Posted May 20, 2008 mysql and mysqli are php extensions. They have nothing to do with MySQL itself. mysqli stands for mysql improved. mysqli is recommended to use with PHP5 and MySQL5. Check out php.net for the differences between the mysql and mysqli extensions. As for what storage engine to use, I generally use the default storage engine that MySQL is configured with. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.