If you want to start learning PHP and MySql, the first step is to setup complete environment on your local computer. This will include Apache web server with PHP support and MySql database server.
Often in PHP you want the same block of code to run over and over again and instead of adding several almost equal lines, you can use loops to perform this task much easier.
We will learn two different ways how to download a page in PHP from a web URL, learn how to use cURL and how to set a few additional options and finally show contents on your page.
We will learn how we can write SQL command to show data from two tables and also specify some additional conditions to limit the amount of data returned.
Structured Query Language is the most widely used language for interacting with databases. Today we will learn how we can use SQL to insert or update data into MySql database.