🖥 PHP-MySQL-WebApp ~ Learn to work with Databases

This project involves a user-friendly website to display tables from a MySQL database.
Developed using HTML-Stack with PHP.

🗯️ Introduction

› This project is centered around the development of a user-friendly website. The website was crafted using HTML, CSS, JavaScript, and PHP, which are some of the most powerful and widely-used languages in web development.

🤔 - The primary function of this website is to present tables from a MySQL database in an intuitive and accessible manner. By leveraging these technologies, the project aims to provide a seamless user experience, making database interaction straightforward and efficient.

› This project was developed by Yannic Drews & Yanic Döpner for a project work in their training as IT specialists for application development - some parts of the project are on german because that's the language that was specified for the project work.

🪛 Features

› PHP-MySQL-WebApp provides a set of fundamental features that can assist you in handling databases and working with PHP, thereby facilitating your learning process on how to manage them effectively.

📢 › This project is designed to be compatible down to PHP 5.6 and has been tested on both XAMPP and IntelliJ’s built-in web server.

It supports following features:

• 📂 View MySQL Tables: With our dropdown menu on the right side, is it possible to switch between multiple tables based on the "buchladen" database.


• 📝 Add, Edit or Delete a Table Row: With the buttons on the right side at the table can you edit or delete a row inside it - with the button on the left above the table is it possible to add an entire new row.


• 📬 Write own SQL-SELECT Statements: With the small input text field on the right side above the table is it possible to write own MySQL-SELECT statements like "SELECT * FROM autoren" or else.


• 📋 Filter by Column: Click on the icon next to the column name in the table to filter by the corresponding column.


• 🔎 URL-Parameters: This little page works with URL parameters like `myurl.de/index.php?filterBy=column` to show specific MySQL tables.


• 🔩 GET & POST-Methods for PHP: We're also working with "GET" and "POST" Methods from PHP to reset the database if a button was pressed as example.


• 💡 Selectionsort-Algorithm: We're using the "Selectionsort"-Algorithm to sort our received data with PHP by the corresponding column name. However, we included also the better MySQL solution commented out.

🔨 Installation

› Before you can start exploring our small website for learning purposes, there are a few preparations you need to make.

💡 › You will need a MySQL Database and a web server capable of running PHP.

Then, follow these steps to ensure everything runs smoothly:

1. Execute our MySQL-Init Script buchladen.sql located in the assets/sql/buchladen.sql folder.
2. Set your correct MySQL login credentials in assets/php/main.php
3. Start the Webserver and have FUN!