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.)
-retailer inventory table
-wine retailer query
-category page and banner/side advertising
-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).
32 pekerja bebas membida secara purata $461 untuk pekerjaan ini
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.