Mastering PHP: The Best Way to Creating PHPMyAdmin Tables

by Roxanne Reyes Founder of Wae Tech Solutions

 

Today, we’re going to work on something exciting, which is PHPMyadmin creating tables and inserting data.

It’s going to be very easy for a beginner and you’re going to learn a lot.  There’s no heavy MySQL syntax or PHP in this article, which is nice.  I am actually documenting my learning experience with an online course with Udemy, so shout out to Edwin Diaz the master PHP instructor from Udemy.  I highly recommend this guy if you want to learn PHP.

I won’t get into the coding part until the next article because I’m going to go a little slower.  I didn’t want to overwhelm a newbie if they decide to follow this tutorial.  I definitely found the middle of the section a little tougher because problems in my Apache server started to act up.  However, there’s always resources on Stackoverflow.com to help you out if you get into a bind.

So lets start the fun part with PHPMyadmin creating tables and inserting data.

 

How to start with PHPMyAdmin creating tables and inserting data?

Mastering PHP: The Best Way to Creating PHPMyAdmin Tables

1.Start PHPMyadmin

  • Click on the icon with the bone on the bottom of your task bar of your desktop.

 

click xamp icon

 

2.Start Apache server on control panel

  • Click start on both Apache and MySQL.

 

Xamp control panel

 

 

3.Type localhost/phpmyadmin in search bar

  • It should look like this.

phpMyadmin

 

4.Click on the name of the database on the left side.

  • I am choosing the loginapp database. Locate it at the left of the screen under phpMyAdmin.

 

 

 

5.Create table by entering it in the box

  • Enter name of the table under the heading Create Table.  In this case, I am entering users1 for demonstration purposes.
  • Enter number of columns by click on the arrow.
  • I want 3 columns for user_id, username, password.
  • Click Go at the right side.
  • PHPMyadmin creating tables

 

users1 table column 3

 

 

6.Insert columns

PHPMyadmin creating tables

Under Name column enter id, username, password.

Enter the following for each:

  • Name: id     Type: INT     Length/Values: 11       Null index: Primary        Check A.I (for auto increment to generate id automatically)
  • Name: username   Type: VARCHAR     Length/Values: 100
  • Name: password     Type:  VARCHAR     Length/Values: 100

Click SAVE

users1 table columns

 

 

7. Insert values into table.

  • Enter username: Edwin
  • Enter password: superman
  • Click Go
  • PHPMyadmin creating tables and inserting tables is simple this way, but you can always learn how to do queries.

 

inserting values

 

Good reads:  My Journey to mastering PHP programming: Building my first database in PHPMyadmin

 

8.Result of SQL query

  • Result should be displayed as follows.
  • PHPMyadmin creating tables

 

user1 query

 

 

9.Click Browse to see created table.

PHPMyadmin creating tables and inserting tables.

See example below

user browse

I hope you liked this article PHPMyadmin creating tables and inserting data.  Stay tuned for more.

Next article, communicating with PHP and login markup.

PHP documentationMySQL documentation.

Any questions leave me a comment below.

Thank you for reading! Mastering PHP: The Best Way to Creating PHPMyAdmin Tables

Contact me

 

Good reads:  The most powerful and effective ways to create a responsive email template with HTML5 and CSS