{"id":933,"date":"2013-04-15T05:28:52","date_gmt":"2013-04-14T19:28:52","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=933"},"modified":"2018-08-31T11:28:44","modified_gmt":"2018-08-31T01:28:44","slug":"php-and-mysql-via-mamp-primer-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/php-and-mysql-via-mamp-primer-tutorial\/","title":{"rendered":"PHP and MySql via MAMP Primer Tutorial"},"content":{"rendered":"
\"PHP<\/a>

PHP and MySql via MAMP Primer Tutorial<\/p><\/div>\n

\nPHP is a server-side language hankering to do database and file management at the server?<\/p>\n

Unfortunately this can not be done with a handkerchief alone, as you will also need a database like MySql.<\/p>\n

What else is needed? A framework to act as a web server, and for our purposes on this tutorial, on a Mac laptop, we are going to use MAMP<\/a>.<\/p>\n

So we will first show you the MAMP environment for PHP and MySql where we are talking about URLs like http:\/\/localhost:8888\/ ( or http:\/\/127.0.0.1:8888\/ ).<\/p>\n

Then we will show you a MySql database and table that we will access later via PHP.<\/p>\n

Then we will show you two simple PHP scripts to ask for requirements from the MySql database, and one to report on the results of running that SQL query on that MySql database.<\/p>\n

Grasp these concepts and a lot of functionality opens up. Imagine what you could do with Ajax techniques.<\/p>\n

Enjoy the tutorial<\/a>.<\/p>\n

A great book for this subject is<\/p>\n

Professional PHP Programming by Jesus Castagnetto, Harish Rawat, Sascha Schumann, Chris Scollo, Deepak Veliath<\/p><\/blockquote>\n

Link to downloadable source code of PHP above is ourmysql_test.php<\/a> and ourmysqltest.php<\/a> which you need to rename in order to try.\n<\/p>\n

Here is a lifesaver of a link<\/a>, perhaps.<\/p>\n

If this was interesting you may be interested in this<\/a> too.<\/p>\n