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.
No comments:
Post a Comment