Posts Tagged embedding youtube videos html newsletters

School Photography Company need website 2 sell pictures

Microsoft Access 2007 Driven Website
I am a school photographer. I need a web site that allows the customer to be able to see and order pictures and pay for them securely on line. I need each customer to only be able to see their own pictures.

Backround Information:
I am a photographer of children. I photograph children at day care centers. I am using a Microsoft access 2007 database that I created to manage the bookings and pictures that I have with day care centers in my area. The main Relevant tables that are in use are as follows.
Schools- this table maintains information about the schools that I do business with each school has a unique school id number
Bookings- this table manages the bookings that I have upcoming and past. Each booking has a unique booking id. Each booking is linked to a specific school.
Pictures- this table actually holds embedded copies of the pictures. The pictures are compressed using an active X control called DBPix that makes the file size very small. Each record in this table is linked to a specific booking. In the pictures table two copies of the pictures are there. One is a thumbnail (very small file size) that would be appropriate to place on line. I have a automated batch uploader that uploades the pictures into the database very quickly. This may be appropriate to use again if re-uploading the pictures to the web site is necessary. I hope re-loading pictures is not necessary.
Sittings- This table holds the sitting numbers of all potential sittings. A sitting is defined as a number that groups a series of pictures together. I take approximately 6 pictures of each child.
I use the primary key/auto number settings to give a new number for each child photographed.
Example: Johnnys sitting id is 567. All pictures of johnny in the pictures table have the same sitting id of 567. This indicates that all pictures with the sitting id of 567 are all associated with Johnny as opposed to Suzie. Johhny and Suzie go to the same day care center. They will share the same booking id but not the same sitting id. This is how I tell Johnny and suzie apart.
Orders this table holds information that an order has been made and customer information. It is linked to a specific booking.
Order details This table holds information about what exactly has been ordered. The picture selected and the product (portrait package) selected. This table is linked to a specific order.

Software: windows vistas and Microsoft access 2007, Dbpix

What I need:
I need a website built so that I can sell my portraits to parents. I want parents to be able to go on line and enter the booking id and the sitting id of their child (I will provide parents with this information). I need a web based solution to use my exsisting database information to provide parents with the ability to buy on line. I am willing to move the database to some secure location on line. The database is currently on my computer in my office. I currently have a web location for this project reserved with 1and1.com.
I would like the web site to populate data directly into my exsisting database. I would like to host the exsisting database on a secure server on line somewhere. I only want this option if it can be done cheaply and easily.
Other considerations: I need the data to be encrypted so the customer can enter credit card information securely . I need the information e-mailed to me after the customer makes the order on line. I will process credit card orders by hand. I want to be able to easily control when pictures for a particular booking are available and when they are no longer available through a quiere of available pictures. I will mark them available or unavailable based on the bookings table. I want an error message to pop up if a customer enters the booking id and sitting number of an unavailable picture. I want the error message to say

Tags: , , , , , , , , , , , , , , , ,

Project for Cip only

I need a blog to be added to my website, one termed "Blog" and another termed .. we will talk about this thru pm. Please make sure this blog is capable of embeding youtube videos as well as attaching images.

So technically, "2" blogs

I also need an RSS feed to be made.

Thank you.

Tags: , , , , , , , , , , , , , ,