I need a php script built and installed that runs on a MYSQL Database.
This script is for products (or items is actually what we will call them). These are not going to be sold so it’s NOT going to have any shopping cart function at all. It is simply for displaying products.
The script location should be /products/
The scripts admin which does not need password protection because I will just password protect the directory should be located in /products/admin
Please set this up so that we can change “products” folder name without having to change anything in the script for it to work. Incase we need this script for something else.
ADMIN SECTION
This product (item) script will need to have an admin panel that allows us to add, edit, and remove categories, and add edit and remove products. It will also need to be able to add, edit category images for
the categories.. If a category image is not assigned, then it would show the first product of that category as the category image.
ADD and Edit a category: This will have the following fields: Category name (text field), category description (text box) and a browse image field for a category image. When editing a category it would have drop down displaying the current categories so that we can choose one to edit.
Delete a category: Simply a dropdown to select a category to delete.. If a category has products in it it will warn “are you sure since you have existing items in this category” if you click yes it would not only delete that category but alow the products that existed in that category.
Add and edit an Item (aka product): This would have the following fields. A image field for the script to create a thumbnail image, A title field (text field), a short description field (a text box), and a
WYSIWYG box so that we can create html stuff and also have a html view so we could copy and paste code if we need to. The WYSIWYG needs to have all the buttons to create and format tables, text, add photos, links etc.. When adding photos it needs to be able to except all standard image types (jpeg, gif, png etc..). But we need a feature built in so that we can use photos that are on our own computer no just hosted images.. So if we choose a photo from our computer it would upload it and compress automatically and add it to the page.
We also need seperate 12 browse image fields for this. These photos would also be able to be taken off our own computer not remote linking. It will need to be able to compress these images as well.
ALL IMAGES MUST COMPRESS AUTOMATICAlly!
It would also have an order feature that allows them to sort the items in the order they want. Just a drop down on the add and edit item pages in the admin that says order for this item: “at the top” then “below product 1″ “below product 2″ etc.. or whatever the product names are.
When editing a item it would have drop down displaying the current categories so that we can choose one to edit
USER SECTION:
The main page will show all the categories on the page ( 4 per row) The thumbnail and the cateogory name below it. When the user clicks a category’s title or thumbnail it takes them to category’s list of items. This would display them down the page 20 items per page before going to page 2 and 3 and so on… This page would show a thumbnail (the thumbnail photo) the item name, the short description and a link the says “click here for more information”. The thumbnail and the items title would also be a link to this “more information page”.
The more information page is the page there the WYSIWYG stuff will be displayed. The “more information” page will show the Item’s title at the
top of the page, the WYSIWYG stuff added for that product, then below that the thumbnails for the 12 photos (if added). If they click on a thumbnail it will pop up in a new popup window with next and previous buttons so they can scan through and see all the enlarged photos. Below that it will have a link back to the category. It will say “BACK TO THE [CATEGORY NAME].
TITLE TAGS: We want to make this so that the title tags reflect what the category is.. On the more information page we want the title tag to display what the item’s title is.
If there is no products in a category it will say show a thumbnail saying “image not available”. Likewise if there is new thumbnail added in the thumbnail image field for a product it would also so “no image available”
That’s basically it.. There is now design needed.. just make sure you use a .css file so I can change the formatting.. So I can set the style on everything except for the WYSIWYG stuff which will display
however we create it. This needs to be built so that I can edit things myself. Please place a top.php and bottom.php page include on the pages so that I can easily add a design afterwards. Please don’t
bother bidding if you are a beginner programmer. I want to make sure I get a bug free script and I want you to be able to test things so I don’t don’t have to spend a lot of time checking your work.
I want to work with someone who can stays in communication about the project and uses msn messenger so that we can keep in contact.
