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.
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.
Last time we created an overlay pattern image using Photoshop. Today we will use that image on a website to give the full screen background a pattern overlay.
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.
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.
Select database queries with Inner, Left and Right Join represent an important part of SQL syntax and come in very handy when you want to make more advanced queries.
