Jump to content

Php/mysql Advice Requested


Recommended Posts

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!

Link to post
Share on other sites

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

Link to post
Share on other sites

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

Link to post
Share on other sites

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" )

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...