godoggo16 Posted February 2, 2004 Posted February 2, 2004 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! Quote
surefire Posted February 2, 2004 Posted February 2, 2004 For the login part, check out patUser. http://www.php-tools.de/site.php Part two would seem to be a custom appliation that you will have to build on your own. If you don't have experience with php and mysql, then I would check out some tutorials at DevShed or purchase a book. Don't take that as a blow off answer... it's not easy to explain how to write a custom php/mysql script from start to finish. A book or online tutorial (prewritten) is your best bet. You might find a script ready to use at HotScripts.com Quote
godoggo16 Posted February 3, 2004 Author Posted February 3, 2004 Thanks for the info. I haven't done a lot of php/mySql - so I just wanted someone to get me pointed down the right path before I got started. This helps!! Quote
gjdonaldson Posted February 4, 2004 Posted February 4, 2004 I have just finished going down a similar path with a very simple application. I plugged "mysql php" into my favorite search engine and then had to search through everything that came back. Here are some of the resources I found that were very helpful: http://www.zend.com/zend/tut/tutorial-yank.php http://www.thescripts.com/serversidescript...ases/page0.html http://www.linuxworld.com/story/34322_p.htm http://codewalkers.com/tutorials/9/1.html Hope this helps! Greg Donaldson Rockville, MD Quote
vendlus Posted February 4, 2004 Posted February 4, 2004 I agree with Jack. Hunt down some websites and just read a lot. As far as what you'll need to do, I think it's fairly simply. Have each client log in with his client id and have php store that number as a session variable. Then for every search that client does, add that client id into the where part of the SQL statement. (ie "SELECT * FROM 'inventory' WHERE clientID = $clientID" ) Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.