Sedang Disiapkan

wine database

Need MySQL database and web site built for wine publication in HTML and .php. Wine reviews will be written to a database, along with other important details by web site staff. Visitors can search for wines by grape, region, wine name, or score. Each wine review will include a where-to-buy-it-reference (wtbir). Retailers will create a password protected account with their details. Retailers will be able to checkbox if they carry a wine, so that they will be added to the wtbir at the bottom of each applicable review.

See redwhiteandrose dot com/[url removed, login to view] for examples of reviews and existing web site (the newsletter has the HTML component, but main pages does not have format I want). Looking at the wine reviews here will enable you to see my vision, which is not much different than what is already online.

First phase involves building:

-Interface for wine review input in MySQL and .php to be populated by administrator—log-in via web,

-Interface for category page and advertising details to be maintained by administrator—via web,

-Retail store log-in and account profile details in MySQL and .php to be populated by retailer store—unique log-in via web,

-Web pages built for wine review searches in HTML and .php, searchable by the public.

-Same web pages, returned from queries, use category and advertising information stored.

See redwhiteandrose dot com/[url removed, login to view] for wine review example. Utility must search for wine reviews and deliver these reviews and append the names of the local liquor stores who carry the product at the bottom of the review. The retail stores are called the where-to-buy-it-reference (wtbir).

-Wine review table with administator login and input screen--need not be pretty, it is not public. The table will include fields for data not used until later phases of the project. These pieces of datum will be entered into the input screen to be preserved for future phases, so the existing wine reviews will not have to be updated.

-Retailer table with password protected login and input screen to add and edit details about the retail store, such as phone number, URL, hours of operation, etc--need not be pretty.

-Additional retailer interface that allows retailers to search for wine reviews they carry in their store inventory. Allows them to choose the product, so that their link will show below the wine review (checkbox). Retailers search by date or name. They will have write abilities for one field in this table, a checkbox designating that they sell the product. The input page will keep track of how any wines the retailers has choosen, so that they can manage their membership level (explained below).

-Retailer wine inventory table supplies information to a query for each wine. If the retail store sells the wine, their URL will be passed to the wine review assembling process to be included on the wtbir under the queried review. See example on redwhiteandrose dot com/[url removed, login to view]

-Retailer interface will include widget to pay for the membership and web page advertising via PayPal.

-Administrator interface to enter and edit banner and side web site advertising. Spaces will be defined and banners will have generic names. Each category page will pull from advertising table. Current banner ads and side advertising will have the same generic names for each web page they are featured. When ads are changed, no need to change code, just rename new artwork to generic name for particular page.

-Affiliate spaces created on sides of the site -- namely Google (but there may be others). The code for these ads will be held in the table containing the advertising. The affiliate code will be added to the page as the page is assembled. This will allow for different affiliates on different pages.

Web site pages are formulated from a table storing banner advertising links. An input screen for this table will be at the administrator level. Administrator will add HTML links with generic names for category page banners. Administrator knows how to write HTML.

Web site will feature category pages, written for general regions and grape varieties, created from search parameters. All searches land on a category page (such as New Zealand, merlot, or Chianti). These pages will pull advertising images from the banner advertising table, including the first three wine reviews to be written to the page. These reviews are called above the fold reviews or ATFR reviews. AFT reviews are paid positions for each category page. (Automating the population of the advertising, specifically the above the fold reviews, will be addressed in Phase Three.)

MySQL tables:

-wine review

-retailer profile

-retailer inventory table

-wine retailer query

-category page and banner/side advertising

Searches include:


-grape variety


-wine name

-wtbir reference (not public, used for assembling the wine review.

Searches will return stored HTML components <tr><td>Complete Wine Review</td></tr> from the wine review table according to the search parameters. The wtbir reference will be appended to bottom. The componet is only a row from a table, but contains the entire wine review. The search will be compared against the category pages for advertising. A category page will be assembled if the search falls into a category. A general page will be assembled if the search does not fall into a category. (Categories are grape names chardonnay, merlot, cabernet sauvignon, etc, and regions California, Napa Valley, Bordeaux, Alsace, Germany etc.) There are about fifty category pages that a search can utilize. All the pages will be assembled from the category/advertising table. All reviews will be assembled from the wine review and retailer inventory tables.

Each review will append the names of liquor store on the bottom of the review. Retailers will be assigned wtbi reference plans. They will be able to append their store link to a certain amount of wine reviews, i.e., 50 reviews, 200 reviews, 500, etc.

Phase two will involve a shopping cart being implemented so that retailers can sign up for a wtbi reference plan via their interface. Phase One will include a widget for the retailer to pay for their membership via PayPal.

I will supply the fields for the MySQL database in the form of spreadsheets. Most of the tables will contain test data. I will need the MySQL database set up for me (I used to code in .asp with Access, but do not want to do this anymore, want .php and MySQL. I do not want to learn a new language. No time, busy tasting and writing about wine.)

Design of web site should stay the same, but I would be open to changes in design. It is simple and need not be crowded with content. Mostly all I want is the green background, white text background and my logo in a few places. The advertising artwork will create color.

I will need to be able to set the plan level of each retailer initially.

I will be writing some pages in HTML, for SEO and for ease of publication. The newsletters and newsletter archive page are good examples of this. Most wine article pages will be added as HTML pages and maintained by an archive page that is HTML. These pages will be linked to by general names such as [url removed, login to view] in the .php category pages.

I have been reading the GetAFreelancer web site and am impressed with the set-up. I will be looking at reviews and encourage anyone who wants to bid to please include some references or examples of work. My web site will grow over the next six months to year. It is a very large project overall, which is why I am breaking it down. If I am looking for someone who will be available for future phases. These phases will be explained upon initiation of the first phase (the one you are bidding for here).

Thank you

Kemahiran: PHP, SEO, Reka Bentuk Laman Web

Lihat lebih lanjut: you pull and pay, writing with ease level 2, writing with ease level 1, writing with ease, writing wine reviews online, writing supplies, writing spaces, writing shopping online, writing score, writing positions online, writing on any background online, writing logo online, writing banner ads, writing a newsletter article, writing and advertising article, writing a feature article, write three wants, write site logo online, write an article on why you want to, write an article of publication, write a logo online, wine com, wine by design, why do you want to work here, why do i want to work here

Tentang Majikan:
( 8 ulasan ) Littleton, United States

ID Projek: #365434

Dianugerahkan kepada:


Hi, Please check PMB. Thanks. Andy

$500 USD dalam 30 hari
(59 Ulasan)

32 pekerja bebas membida secara purata $461 untuk pekerjaan ini


Hi, We have gone through your project details and we have perceived that we can do this best, as we have prior experiences on similar projects. Please check the PM. I am looking forward to your response and believe Lagi

$500 USD dalam 15 hari
(363 Ulasan)

Got expertise in doing this sort of work... Thanks

$500 USD dalam 14 hari
(624 Ulasan)

lets do it,thanks

$500 USD dalam 0 hari
(132 Ulasan)

We can assist you with this and future phases. Take a look on our portfolio at [url removed, login to view] and read details in a private message

$500 USD dalam 30 hari
(80 Ulasan)

Dear Sir, I am interested in your project and can be done with your 100% satisfaction. I request you to check your PM for our quality work. 30 Days development + Bug Fixing. Progress Report Weekly + Dedicated Team + Yo Lagi

$500 USD dalam 12 hari
(231 Ulasan)

Hello Sir, Kindly check your PMB for more details Thanks

$500 USD dalam 45 hari
(77 Ulasan)

I can do it professional from scratch. Please view PM. Regards from Ralph [url removed, login to view]

$450 USD dalam 10 hari
(138 Ulasan)

I am interested.

$490 USD dalam 25 hari
(96 Ulasan)

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our Lagi

$500 USD dalam 30 hari
(72 Ulasan)

Please see PMB.

$500 USD dalam 8 hari
(40 Ulasan)

Hello, please see PM for details. Thank you, Nic

$500 USD dalam 25 hari
(68 Ulasan)

Hi, we are professional web Design and Development Company, providing web development in PHP, CMS based websites, E-commerce website, web design template, logo design, banner design, flash… We also provide SEO servic Lagi

$499 USD dalam 12 hari
(132 Ulasan)

Hi sir,choose us so that we can start with your work,please check pmb,Regards

$400 USD dalam 15 hari
(78 Ulasan)

Hi, Please check PMB for details. Thanks KD

$500 USD dalam 30 hari
(52 Ulasan)

Hi, we are very [url removed, login to view] have gone through with the requirements you described in your detail. We can easily do it with our expertise. we will provide your project with required language. we will provide you regul Lagi

$500 USD dalam 30 hari
(78 Ulasan)

Can help... check my reviews... costs more...

$500 USD dalam 21 hari
(47 Ulasan)

If you believe in QUALITY,COMMITMENT and TIME MANAGEMENT than CRONY INFOTECH is the right place to stand on. Please see the PM for the detailed description.

$430 USD dalam 21 hari
(44 Ulasan)

Dear Sir I have 7 years experience in php,mysql,smarty,oscommerce, zen cart, creloaded,wordpress,ajax,javascript. I have experienced and expertise in these fields. Please view PMB about my developed sites. I will appre Lagi

$400 USD dalam 18 hari
(46 Ulasan)

please kidnly check your PMB thanks........

$500 USD dalam 20 hari
(10 Ulasan)

Hello, I understand your requirements. Please check your private message.

$480 USD dalam 23 hari
(21 Ulasan)