Home Experience and Education Project Portfolio

Project Portfolio

Database Implementation PHP Project

This program utilizes flat file operations, arrays, string functions, regular expressions, methods, objects, exceptions, PHP, and MySQL. The purpose of this program is to demonstrate these programming structures in a meaningful way. The theme of this program is a pizza sales system. Below we will view the html interface.

In the sales interface you see three buttons sending you to each page, first we will add a customer to the sales database as shown in the photo below.

The customer will add their name and phone number values. The phone number value is error checked using a regular expression to ensure proper formatting is added into the database. Once the customer info is inserted into the database, we can begin to process our order in the next form below.

Here the customer will be selected using the drop-down menu which will correlate to the customer’s name from the table in the database. The customer can then put in the type of pizza and the quantity they would like to order. If the order is processed successfully, it will appear as in the image below.

Otherwise, if the order is not successful due to a lack of ingredients for example, the user will be told to place an alternative order or have the manager add more ingredients in the inventory which will be shown below.

Each pizza will require Cheese, Dough, and Sauce at minimum for ingredients (standard cheese pizza). For the other kind of pizzas, the ingredients will vary accordingly. Finally, we can view the reports which detail more info about the transactions in the next image.

Above you can view the inventory, re-order ingredients, view the total sum for the sales, view the biggest sale and view all transactions.