I am working on a site for a client and am looking for some advice on how to design some of the elements.
They are in the storage business and have numerous clients that store stuff in their wharehouse. They track all of these stored items in dbase. They want to allow their clients to search their database over their website to see which items they currently have in the wharehouse. However, they only want clients to be able to search their own inventory (not other clients).
So, we're going to copy the database into a mySql database on the web, however, where I'm looking for general direction is;
1. - create a login/session access for different clients which would restrict them to only search for their inventory.
2. - Create a php script that will search the inventory db and return those results.
Anyone that has any advice on how to design this, or knows of any existing php scripts that would lend themselves nicely to either of the above --- your input is apreciated!
Thanks!
