How to Configure a Server to handle MySQL Databases and PHP Files

EmQuart
3 min readFeb 16, 2021

What is Apache?

In order to deliver the content of any web page, there must be a connection between the client and the server. But this connection must be continuous, and all that storage and security of data requires maintenance.

Luckily, Apache is a free and open-source software popular for handling data on HTML pages (with a dash of JavaScript if so desired).

Where Can I Download It?

Go to to https://www.phpmyadmin.net/

Click on Support Tab on top of page.

Under the header “Read the documentation” click on “the documentation

Scroll down and click on Installation for options based on your computer’s operating system. For Windows, select “Installing on Windows”

Click on XAMPP blue hyperlink in the descriptive paragraph

XAMPP contains not only Apache, but also MySQL and PhpMyAdmin

Installation Steps:

Install on C:

Next, navigate go to the file directories of xampp and htdocs:

Next, within htdocs, create the folder containing our HTML, PHP files:

Also, you may add the desired assets of css, js and images.

Next, open the XAMPP Control Panel:

Click the Start button for Apache and MySQL.

Next, open a browser, type in “localhost,” which will direct you to the XAMPP Apache dashboard. Select phpMyAdmin:

Now you’re ready to deploy your Fullstack project!

Which technology should your Fullstack project contain? A good place to start is a simple HTML form on the front end with PHP on the back end. Like this one, for example, to give you an idea on where to start.

CRUD operations for HTML and PHP will require a bit of MySQL, but luckily the interface in phpMyAdmin has a drag-and-drop option, so no need for scripting basic SQL commands.

Hopefully this article motivates you to craft your very own Fullstack project!

--

--

EmQuart
0 Followers

EmQuart is an American corporation that provides digital products and technology consulting.