how to develop Inventory System

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
myasirm
Forum Commoner
Posts: 54
Joined: Sat Sep 12, 2009 3:57 am

how to develop Inventory System

Post by myasirm »

hi guys
i want to create a simple inventory system just for practice of php programing but i have no idea for inventory system so kindly help me how i start and which type of data base tables required and some forms details

thanks waiting for ur replies
User avatar
Weiry
Forum Contributor
Posts: 323
Joined: Wed Sep 09, 2009 5:55 am
Location: Australia

Re: how to develop Inventory System

Post by Weiry »

The first system that comes to mind would be a video rental store.
You would need tables for customers, videos and rentedVideos (at minimum)

The Video table would need these details:
  • videoID, title, description, RRP, rentalCost, hiredOut, rentedID
(some video stores actually sell videos too, hence why the RRP)

The RentedVideos table would need:
  • rentedID, customerID, videoID, hiredDate, returnDate
The Customer table would need:
  • customerID, firstName, lastName, addressID, maximumRentals, creditDebit, banned
(creditDebit being if a customer is owed money or is required to pay money (- or +))
(banned being if the customer is still allowed to borrow videos)
(address could be optional if you want, it doesn't really affect the system)

The Address table would need:
  • addressID, address, suburb, city, postcode
Post Reply