PHPMYADMIN – Introduction and Creating tables

We have been introduced to a software tool written in PHP called, phpMyAdmin which supports MySQL for managing databases through a web browser.

We were given a phpMyAdmin username and password to login.

Screen Shot 2015-04-13 at 15.24.21

We were shown by our programmer lecturer how to create tables in phpMyAdmin to create the tables we drafted in our Entity Relationship Diagram and put them on the database.

Screen Shot 2015-04-13 at 16.16.49

Below is a screenshot of the template for creating a new table on phpMyadmin. The table includes fields for the

  • Table Name (i.e. USERS, MEMBERS)
  • Field Name (i.e. member_id, member_username, member_password)
  • Data type (i.e. INT, VARCHAR, TEXT, DATE)
  • Length/Values (how long the data can be)
  • Index (this is set to unique when using an ID data field)
  • Auto Increment (allows a unique number to be generated when a new record is inserted into a table)

Screen Shot 2015-04-13 at 15.30.23

Below is an example of a MEMBERS table, with a unique members_id that is auto incremented.

Screen Shot 2015-04-13 at 15.33.09

References:

phpmyadmin.net, 2015. Bringing MySQL to the web. Available from: http://www.phpmyadmin.net/home_page/index.php [Accessed: 24/02/2015]

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s