Computer Parts Sales and Inventory System in PHP MySQL with Source Code

The Computer Parts Sales and Inventory System develop in PHP MySQL database, using JavaScript, Ajax, jQuery, HTML, and CSS. This web application system, it is easy to use and user-friendly, the computer parts sales and inventory is totally very similar to inventory system, the admin can manage the product and check the stock like update, add delete, add supplier, add user, and changes password/profile.

** Computer Parts Sales and Inventory System Featured **

** Home Dashboard Admin **

Customer, Employees, Product, Inventory, Transaction, Supplier.

** Customer **

Add, First Name, Last Name, Phone Number, Search, View Details, and Edit.

** Employee **

Add Employee Name, First Name, Last Name, Role, Search View Details, and Edit.

** Product **

Add Product, Code, Name Product, Price Category, Search, View Details, and Edit.

** Inventory **

Add Inventory, Product Code, Name, Quantity on Hand, Category, Date Stock In, Search, View Details,

** Transaction **

Add Transaction, Transaction Number, Customer, Number of Items, Search, View Details, and Edit.

** Supplier **

Add Supplier, Company Name, Province, City, Phone Number, Search, View Details, and Edit.

** User Account Dashboard **

Changes Profile, Password,

** Product Category **

Keyboard, Mouse, Headset, CPU, Monitor, Motherboard, Processor, Power supply, other,

** Point of Sales **

Product Nama, Quantity, Price, Total,

Computer Parts Sales and Inventory System

Name of Project: Computer Parts Sales and Inventory System
Language Used: PHP
Database Used: My SQL
Design Interface: Bootstrap JavaScript, HTML, Ajax, JQuery,
Browser: Opera Mozilla Google Chrome IE8,
Software: WAMP/ XAMPP/ LAMP/MAMP

About System

How to setup this project

Step 1st. Download xampp

Step 2nd. Text editor notepad++ or Sublime

Step 3rd. Download the zip file/ Download winrar

Step 4th. Extract the file and copy “Electronics_Parts_Sales_and_Inventory_Systemr” folder

Step 5th. Paste inside root directory/ where you install xampp local disk C: drive D: drive E: paste: for xampp/htdocs,

Step 6th. Open PHPMyAdmin http://localhost/phpmyadmin

Step 7th. Create database name prince

Step 8th. Import prince.sql file given inside the zip package in SQL file folder

Step 9th. Run the script http://localhost/ Computer_Parts_Sales_and_Inventory_System

Step 10th. Password: username: admin/ Password: admin User: username: test / password: test

System Image

For a little Knowledge

Why Transactions?

Efficiency and security are the main benefits in applying transactions in your database operations. Transaction ensures that a group of SQL statements that begin with START/BEGIN and end with COMMIT are either as a unit or not at all. If there are server problems like the connection to the server is dropped during a transaction and the computer crashes or an emergency such as power outage happens, it cannot happen that some of the commands are executed.