Thursday, 29 December 2011

PHP & MySQL Web Development

The book I read to research this post was PHP & MySQL Web Development for Dummies All in One by Janet Valade et al which is an excellent book which I bought from kindle. 60% of all sites are powered by apache, php & mysql, 30% use windows internet information server which does the same job as apache. Apache is apparently more reliable & is open source but both are free. WII Server is supplied with windows but is not installed by default. When people use PHP & MySQL they download it as a package which includes Apache & phpMyAdmin. PHPMyAdmin enables PHP & MySQL to work together. The main packages are
WAMPP which works with windows.
MAMPP which works with macintosh.
XAMPP which primarily works with linux but there are versions for macintosh & windows.
Linux & Macintosh usually comes with apache installed so you won't need to install it unless you need to update it to a later version.
The book recommends using PHP 5 because 6 was in beta but that has probably changed by now. PHP 5 has lots of features that weren't available for PHP 4. Apparently a lot of web hosts don't support PHP 5 or charge extra but the upgrade is worth it.
MySQL is an open source database & would be used with a website for things like a customer database or a product catalogue.

No comments:

Post a Comment