Students

Using phpMyAdmin

In order to create tables and add data to your database you can make use of a programme installed on this server called phpMyAdmin. Here's a quick walkthrough:

A. Creating tables:

1. Use the username/password combination we provided by email (so NOT your university username/password combination) to access phpMyAdmin.

2. In the left frame, under home, you see the name of your database. Click on it.

3. Under create new table on database .... , fill in the name of the table you want to create and the number of fields. Click <go>

4. The next page allows you to define the fields.

Under field you enter the names of you fields.

Under type you specify the kind of data that will be entered in the field:

int: is for integers / numbers
date: is used for dates, standard format is 000-00-00
tinytext: is used for small amounts of text with a maximum of 255 characters
text: is used for large amounts of text

under Default you can assign a default value to the field

The first field is usually named "id". Under extra, select "auto_increment" to automatically assign a number to each record and check Primary

After specifying all fields, click on <save> and you table is created.

5. The name of the newly created table appears in the left frame.

B. Handling data:

1. Click on the name of the table in the left frame

insert data: click on insert
delete/edit data: click on browse and select de record you wish to edit/delete

C. Handling tables:

1. click on the name of your database in the left frame. In the main frame you will get an overview of all the tables you have created.

empty all records from the table: check the table and click empty
delete table from the database: check the table and click drop