/electronics-store

Electronics Store CRUD - PHP + PL/pgSQL

Primary LanguagePHP

An online electronics store project

A group project for a Database subject in college, completed by: Maciej Biel, Karol Bobowski, Kamil Data.

Technology stack: PHP 8, PostgreSQL, PL/pgSQL

About the project

NOTE: Polish names in folders and class names appear for the purpose of the subject.

The project is an online electronics store web application. The application allows the administrator to manage customers, products, create new orders, edit them, delete them, etc. It also allows customers to place orders and edit them.

The back-end, or all the business logic, has been fully transferred to PostgreSQL. PHP is only used to perform functions and procedures implemented in PostgreSQL, which return appropriate data or messages, errors, etc.

The front-end was created using pure PHP without any frameworks. The MVC pattern was used in the application. Class autoloading complies with PSR-4. The Twig template was used, the Faker library was used to generate random user data and addresses, and the X-Kom website was used to help with product data. The pecee/simple-router was used as a router.

Screeenshots

Homepage

localhost_projekt-bazy_

Login panel

localhost_projekt-bazy_login_

Admin panel - home

localhost_projekt-bazy_admin_ (1)

Admin panel - all users addresses

localhost_projekt-bazy_admin_adresy_

Admin panel - add user address

localhost_projekt-bazy_admin_adresy_dodaj_

Admin panel - show user address

localhost_projekt-bazy_admin_adresy_1

Admin panel - edit user address

localhost_projekt-bazy_admin_adresy_edytuj_1

Admin panel - all users

localhost_projekt-bazy_admin_uzytkownicy_

Admin panel - show user

localhost_projekt-bazy_admin_uzytkownicy_1

Admin panel - add user

localhost_projekt-bazy_admin_uzytkownicy_dodaj_

Admin panel - all products

localhost_projekt-bazy_admin_produkty_

Admin panel - show product

localhost_projekt-bazy_admin_produkty_1

Admin panel - edit product

localhost_projekt-bazy_admin_produkty_edytuj_1

Admin panel - orders

localhost_projekt-bazy_admin_zamowienia_

Admin panel - add order

localhost_projekt-bazy_admin_zamowienia_dodaj_ (1)

Admin panel - add order

localhost_projekt-bazy_admin_zamowienia_dodaj_

Admin panel - show order

localhost_projekt-bazy_admin_zamowienia_edytuj_1

Admin panel - show order

localhost_projekt-bazy_user_

Admin panel - system logs

localhost_projekt-bazy_admin_logi_