website with stock management

W

wizzpig666

New Member
Hi

I have a friend who would like me to build a website for his company which hires out props and set dressing for movies and television.

Some of the functionality is beyond me and I was hoping someone can point me towards some good tutorials and info. I'll give a run down of the requirements.

He wants to do all in-store invoicing through the website, so that a database is kept of quantity of items available for hire. This database would update every time he creates an invoice.

The gallery of items for hire, would include a quantity-in-stock number for each item, getting this information from the invoice-linked database. A bonus would be to be able to display a date when currently unavailable items, will be available (again getting that info from the invoicing database)

Visitors also need to be able to add items to a shopping cart, and get a quoted price, and be able to pay online, should they wish to do so.

He also would like visitors to be able to enter search terms for items.

Here's a link to a site similar to the one he wants.
http://www.sydneyprops.com/themes_02.asp?categoryID=4&


Any help with this would be much appreciated.
 
Geodun1

Geodun1

New Member
If you've got the time and money, pick up a copy of PHP for Dummies by Janet Valade, it has a full tutorial and designing a database and shopping cart system similar to this.

The best way to achieve this is to make layout a database in MySQL, then use a form on the site that allows him to add invoices. The form would link to a .php file that adds the information to the appropriate table(s) on the database, and then redirects the user to the form page again. You then can have a page that displays all the items by calling them from the table (the book explains how to do this in much greater detail).

You might be able to find some help at http://www.dummies.com/WileyCDA/DummiesTitle/productCd-0470096004.html

If I can be of more assistance just let me know :)
 
W

wizzpig666

New Member
Geodun1 said:
If you've got the time and money, pick up a copy of PHP for Dummies by Janet Valade, it has a full tutorial and designing a database and shopping cart system similar to this.

The best way to achieve this is to make layout a database in MySQL, then use a form on the site that allows him to add invoices. The form would link to a .php file that adds the information to the appropriate table(s) on the database, and then redirects the user to the form page again. You then can have a page that displays all the items by calling them from the table (the book explains how to do this in much greater detail).

You might be able to find some help at http://www.dummies.com/WileyCDA/DummiesTitle/productCd-0470096004.html

If I can be of more assistance just let me know :)
Click to expand...

That's great. Thanks a lot for the help. Quite possible I will be back here if it doesn't all go according to plan. (usually doesn't :p )
 
You must log in or register to reply here.
Top