Start
Introduction
PHP Syntax
Connection
Data Types
Tables
Insert
Select
Where
Update
Delete
Like
Sorting Results
Joins
NULL Values
Regexps
Transactions
Alter
Index
Temporary Tables
Database Info
Sequences
Duplicates
SQL Injection
Export

First of all go to the login page and register for a new account. Once that is done, go in the dashboard and create a new MySQL database - we'll then give you a username, database name, and password. Keep these safe as without them you will not be able to use your free MySQL database.

Next its time to use your new database. The simplist way is to go to the phpMyAdmin login page and use your details that were given when you created your database to log in. Using phpMyAdmin you will be able to perform lots of actions to your database - view the database structure, browse the tables, execute SQL queries and much more, through a web interface. You can access using it many other ways, using your programming language of choice or MySQL workbench for example, but for these lessons we will stick with PHP.

What follows goes through a few examples that may help you learn.

• Next