Create An Inventory Sheet With PHP and MySQL
Uploaded by
ScribdTranslationsCreate An Inventory Sheet With PHP and MySQL
Uploaded by
ScribdTranslationsCreate an Inventory Sheet with PHP and MySQL
Description
This Inventory Control System with PHP and MySQL is designed for small business owners, however
it can also be a great help in organizing a home inventory. Whether you want to document the inventory of your
house for the purposes of home and furniture insurance, or to keep an eye on your personal belongings that you have.
stored, it can also be useful for keeping track of inventory in case you want to organize an event.
Companies can keep their operations in order by managing stock to avoid excess and monitoring it.
from the inventory to see which products are performing better.
Characteristics
• Creation of new records in the inventory through web interface.
• Modification of inventory data (quantity and unit cost).
• Removal of products from the inventory sheet.
• The inventory sheet can encompass various products or materials.
• Automatic calculation of the total inventory cost amount.
• Responsive design, adapts to any device size.
• Storage of the product inventory list in a MySQL database.
Installation on Windows (local server)
1. Download the source files of the system
2.Copy and unzip the file into the folder c:\xampp\htdocs, you will end up with a folder named 'hoja_inventario'.
which you can access from the browser at: http://localhost/hoja_inventario/
3. Create a database using PHPMyAdmin by accessing the following URL: http://localhost/phpmyadmin/
4.Import the tables from the database for this we will look for the file 'test_hoja_inventario.sql' in the root directory
from our system, once located we proceed to import the data from PHPMyAdmin
5.Configure the database connection data by editing the configuration file located in the
next route:config/db.php
6. Web view: http://localhost/hoja_inventario/
Note: To install the system it is necessary to have a web server installed on your computer, I recommend that you
usesXAMPP.
How to use the inventory sheet with PHP
These are some step-by-step instructions to customize the system.
• Update the information related to your company's data, go to the profile table in the database and edit the data.
that correspond to your business or company.
• Change the logo, go to the system and look for the file assets/img/logo.png and replace it with your company's logo.
Below are the fields that have been used for the creation of the inventory sheet with PHP, along with a small
description of the expected data in each field
1. Code: This field can be used to distinguish a product from the rest, which may be one that we have.
created or assigned by the supplier or manufacturer.
2. Description: It allows us to assign a name or a description of the product.
3.Here we will enter the unit of measurement to be stored in the inventory, which can be box, gallons,
bottles, etc.
4.Quantity: We will enter the current stock of our product.
5.It allows us to enter the purchase price at which we acquired the product.
6.Total cost: The system automatically calculates this value, which results from multiplying the amount of
inventory stock by the procurement cost of our products.
7. Total inventory value: The total inventory value is also a value calculated by the system, which results from summing
the total cost of our products.
8.Inventory items: Count the number of products we have in stock.
