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? Link to comment https://forums.phpfreaks.com/topic/106477-mysql-installation-choices/ 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. Link to comment https://forums.phpfreaks.com/topic/106477-mysql-installation-choices/#findComment-545852 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.