SETTING UP DATABASE TABLES IN PHPMYADMIN

phpMyAdmin was the site that we used to set up our database tables.Screen Shot 2015-04-19 at 13.57.31

Screen Shot 2015-04-19 at 13.57.41


We set up different tables that we would use to hold the information for users to submit – this feature of user submission to a database is what make the site interactive.

Screen Shot 2015-04-19 at 13.58.37This table show all the information that users that have successfully submitted into the sign up page. Details stored in the table:

  • id
  • username
  • password
  • data_joined
  • full_name

Screen Shot 2015-04-19 at 13.58.52Job submit table:

  • id
  • username
  • company
  • job_position
  • part_full_time
  • location
  • job_description

 

Screen Shot 2015-04-19 at 13.59.02Contact table:

  • id
  • name
  • email_address
  • phone_number
  • message
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