Mastering PHP: Building My First PHPMyAdmin Database

by Roxanne Reyes Founder of Wae Tech Solutions

 

 

 

Building my first PHPMyadmin database for an application was really exciting for me.

I recall the ups and downs and obstacles along the way.  I’m a newbie learning PHP on my own while following a Udemy course on PHP programming, so I discovered some interesting problems that I need to figure out on my own.  This is some of the non-glamourous problems you don’t hear very often by people on YouTube.  You just hear the end result about how their making a $100 k and living large and working remote.  Spare me the fantasy because learning programming is pure dedication and constant grind every single day.  You have absolutely have nobody to hold your hand, although you learn more on your own than going to a 4 year college.  I’m speaking from experience here because the professor that taught computer science at my school assumed we already knew programming.  This was really hard for me at first and I ended up dropping out of the program and majoring in history and English literature.  The teacher’s perspective in my opinion was supposed to assume that we knew nothing about computers, but that is not the case.  Education in college has discouraged me.

Right now we have more resources at our finger tips than ever before.

What do I mean?

We have online courses like Udemy, Code Academy, Treehouse and Free Code Camp.  We also have YouTube, which we can learn tutorials for free.

I personally love learning PHP.  I needed to learn a back end programming language and Udemy has some of the best instructors for a cost that I can afford.  That’s how I learned to build my first PHPMyadmin database with Edwin Diaz and how I learned to build some awesome applications with HTML and CSS.

It’s changed my life so much and I love it.  I’m hoping to change my career into becoming a web developer.  Who knows maybe I will love PHP?

So in this article I’m also going to document everything step by step, so you can follow it and build an application one day.

 

Things you should know before building your first PHPMyadmin database:

  • Programming basics (loops, arrays, if statements, while loops and functions)
  • MySQL basics (good to know, but not required)

 

This is for people who already know the basics of programming.  By basics I mean they’ve already learned about loops, arrays, if statements, switch statements and functions.

I kind of started it out this way because most people are looking for advance learning and want to do a project on their own.  Besides most employers are looking someone that knows PHP and MySQL.

Okay, without further ado lets get started to build your first PHPMyadmin database.

 

 

1.Download Mamp (for Mac) or Xamp (Windows)

Install this to run your database.  This will enable you to access PHPMyadmin and create your database through Apache.

Follow the directions to install.  It’s very easy to do.  Afterwards you can proceed to the next step.

mamp for database

 

 

Xamp PHPMyadmin

 

 

I use Xamp to run the Apache server that enables you to write MySQL and PHP to create a database.  It’s excellent and used by many professionals.  I realized that Xamp is available for Mac and Linux, so I guess it’s your preference.  Xamp is also highly documented, has lots of resources, is open source and highly secure.

Once you have installed Xamp, it should look like this in step 2 for Xamp control panel.

 

 

 

2.Start to run Apache and MySQL

  • Press start buttons under actions.

The ports should be displayed and the modules should be highlighted in green.  It might be different for Mamp.  You’re so close to building your first PHPMyadmin database.

See control panel below.

Xamp control panel

 

 

3.Open a new browser page to build your first PHPMyadmin database

 

  • Type in the search bar, localhost/phpmyadmin.  It should look like this below:

 

phpMyadmin

 

Other good reads:   How to create a HTML5 contact form using PHP from scratch?

 

4.Click on Databases tab

  • Click on Databases tab.
  • Then under Create Database, type in the name of your database and click create.

See example below.  Then it will appear on the left side along with the other databases I currently have.

Oh my gosh you just built your first PHPMyadmin database!

You can even delete or drop a database by clicking on the database at the bottom.  But I’m just letting you know, so DON’T DO IT. Only for demonstration purposes okay.  And that’s it.  It was simple right.  On the next article I’m going to show how to create tables and insert data in PHPMyadmin.

how to create a database in PHPMYadmin

 

Okay stay tuned for creating tables and inserting data into PHPMyadmin.  Thanks for reading!

Thanks for sticking with me in building my first PHPMyadmin database.

Other good reads:

Crush the competition with these CSS grid layouts practical features

The single most effective way to master CSS grid as a Web Developer