💾 Part 1: Create a table in the database

By /

I have created a database for you in our server.
You can access phpMyAdmin from here: https://pma.zone.ee/webster.ee

For future references, the full database credentials are here:

U: d119487_learning 
P: EspressoMartini99!
DB name: d119487_learning 
DB host: d119487.mysql.zonevs.eu

Creating the first table

Open the table d119487_learning and create a new table inside it.

  1. Create a table called blog
  2. Create 3 columns for that table: id, title, content
  3. To the name field type the name of the column
  4. In the id column, set type as INT, and from Index dropdown, choose “PRIMARY”. Select the “A I” checkbox. This means “auto-increment”. The ID column will then automatically increase for each new table row.
  5. For the title column, set type as VARCHAR, length as 255
  6. For the content column, set type as TEXT
  7. Click “Save” at the bottom.

Now we have the first table created, let’s add some content to it!

Click “Browse” for that table, and you should see such view

On the top bar, click “Insert”, and you can see such view.

Leave the id field empty, as the auto-incremented columns will be filled automatically with each new insertion.

  1. Add title
  2. Add content
  3. Click “Go”

When you now view your table, you can see that your table has some content in it.

Populate your table with more content

Add 5 blog posts in total.

Scroll to Top