Home and Learn: PHP Programming Course
We've created a database for you for this section. Amongst the files you downloaded there is a folder called databases. Inside of this folder is a file called membertest.sql. MySQL Files that end in SQL can be imported into phpMyAdmin. To do this, login to phpMyAdmin with your username and password. (The defaults are root and leave blank for the password.) Now click the Import tab at the top:
On the Import screen, click the Browse button at the top (Make sure that the Format dropdown list at the bottom says SQL):
Now Browse to where you saved the folder that you download from our site. Double click the databases folder and then select the file called membertest.sql:
Click the Open button to get back to the Import screen. Now scroll down to the bottom of the Import screen. Click the GO button to Import the database:
You should then have a database on the left menu called membertest. Click on the table name of members and the Browse tab at the top should show the following:
The Browse tab shows that we already have two entries in the table: those with the username test1, and testTwo. (NOTE: we haven't encrypted the passwords, here. We'll discuss encryption in the next section when we tackle user authentication.)
Click on the Structure tab at the top to see how we have set this database table up:
So we have four fields in the table: ID, username, password, and email. The Types for these fields are tinyint, and varchar(20). The primary key is the ID field, which is also set up to be Auto Incremented.
Whenever you create a database in phpMyAdmin, you can Export it a SQL file. This file (database) can then be uploaded to your own web server or web hosting company (if the hosting company gives you access to phpMyAdmin, that is).
In the next part, you'll learn about something called Prepared Statements. You'll need your membertest database for this.
Email us: enquiry at homeandlearn.co.uk