1 / 16

Designing an Inventory Database System

Design a real-time inventory database system for online stores using HTML, PHP, and MYSQL. Manage products, costs, quantities, and more with managerial options, search, and display features. Ensure data security with SSH and FTP for file transfers. Enhance business operations by allowing instant updates for managers and customers. Utilize vendor and brand search functionalities to improve inventory tracking. This project showcases the benefits of an online store for efficient inventory management.

vladimir-reyes
Télécharger la présentation

Designing an Inventory Database System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Designing an Inventory Database System CS489 Research Project in Computer Science John Ahigian Advisor: Dr. Wang

  2. Project Goal • The project goal: to design a real time inventory database online. • Online Store in HTML / PHP (Hypertext Preprocessor) / and MYSQL • My website can help business owner(s) in two or more different locations keep a product inventory in sync.

  3. Online Inventory • Managerial Administrative Options • Functions: • Adding Products • Removing Products • Edit Product • Search • Displaying Current Inventory

  4. Project Overview /Images HTML Store Directory PHP File

  5. My Database • Product / Description • Cost • Quantity

  6. SSH • SSH (secure file transfer) is what you need to use in order to maintain your directories and files on zeus. • FTP updated files and over write them in the public_html directory. • Coded in HTML and PHP to communicate with the database written in MySQL.

  7. Why an Online Store? • Manager and Staff • Best way to show Inventory real time in order for business to run properly • Customers can see Manager / Staff changes instantly after being edited

  8. Searching for Products • Manager / Staff can search by vendor name separated with a hyphen. • Customers can search by brand name or product • (Inventory entered in already) Apple, Hardware, Software, Phones, Cameras (etc.)

  9. Conclusion • Online Store is best way to prove an Inventory Database works because you need one. • My Inventory Database that is managed by staff can be accessed privately by them • Publishes real time for customers to see updates. • Added mailing list database for subscribers • Check it out!

  10. My Workspace

More Related