Week 8

Lecture this week was on how & why to use a mySQL in PHP. Also included some basic information of database use and about mySQL.
The reasons to use mySQL with PHP are;

• mySQL is 100% free
• It is very easy to use with PHP
• mySQL is very easy to learn & manage

The next topic on the lecture was on the structures and basic rules when using mySQL. Tables are usually structured into columns which contain data fields and the rows will have data which con-inside with those fields. Also you can view, insert, delete or edit these data using SQL queries. 

There are some basic steps when working with mySQL and PHP.

1. Connect to the database using database name, username & password
2. Create a SQL statement
3. Send a query the database
4. Hold onto results
5. Show the results
6. Close the connection

During the tutorial we learned the use of these areas and we created pages,

• To connect a data base
• To insert a record
• To view record