Concluído

XML Integration into a MySQL Database

I have an XML feed that constantly populates data into a MySQL database to run my website. I need a coder to help me with three tasks.

1. Swap a data field in the MySQL database from one field in the XML feed to another field in the XML feed.

2. The XML feed has ~2,500 products in it, but approximately 1,500 are sold out items. I want to implement a toggle to allow the database to include all 2,500 products, but have an "in stock" and "out of stock" toggle

3. Alter the homepage to display recent activity. I need my site's homepage to display the most recent comments by users in the community.

## Deliverables

Here is the detailed spec:

1. Change wine name from product <title> to product <display_name> from the XML feed

* Display of wine name

* * Throughout the entire site, wine names should be shown by using the product <display name> field

<!-- -->

* "Remove 2006 Sauvignon Blanc from Turnbull Wine Cellars" convention and replace it with with product <display name> field

* * This is relevant for the following pages:

* * Homepage within Top User Rated Wines

* Modify Search Page

* Top Rated Wines Page

1. Add Green Button Toggle Similar to Newsletter Singup on "Create New Account" page

* Toggle is: "All Wines" / "Wines in Stock"

<!-- -->

* Default should always be "Wines in Stock"

<!-- -->

* Example:

* * [url removed, login to view]

* Apply a toggle to pages:

* At top of Global Navigation below "Browse Wines"

* * On Modify Search Page next to "Wines Found"

* On New Wine list next to "New Winelist"

* * Note, also change "Winelist" to "New Wine List"

* On Wine list next to "Winelist"

* * Note, also change "Winelist" to "Wine List"

* Toggle should filter all wines in database and affect display everywhere (e.g. Top User Rated Wines, Modify Search, etc.) except for the following:

* * On the User Profile Page, "My Reviews" should always show all wine reviews (in stock and out of stock wines)

* Display of Wine Price & Buy From Winery Link

* * Modify Search Page

* * Out of stock wines should not show a price

* Wine List Page

* * Out of stock wines should not show a price

* New Wine List Page

* * Out of stock wines should not show a price

* Wine Detail Page

* * Out of Stock wines should not show a price

* Out of Stock wines should not show a "Buy From Winery" Button

1. On the homepage: Change the text "Most Talked About" to "Recent Winery Comments" and change the text "Recently Reviewed" to "Recent Wine Reviews"

* No further work necessary on "Recent Wine Reviews"

* Within "Recent Winery Comments" please show the most recent comments on winery review pages in descending order according to the date posted

* * The display should be similar to the "Recent Wine Reviews"

* * For example, the box would show:

* "Good Times at The Mayo Family Winery Tasting Room" by Kevin

* * "Good Times at The Mayo Family Winery Tasting Room" by Kevin

Habilidades: Engenharia, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website, XML

Ver mais: xml coder, need a coder to create my website, mysql database buy, create mysql database using php, a buy, mysql top 10, about wine, winery, profile database, newsletter integration, mysql database , create an add for my website homepage, box integration, mysql product search, feed data xml, mysql comments, show xml page, user profile remove, stock community, toggle show, navigation toggle, mysql homepage, mysql family, mysql review, create xml data feed website

Acerca do Empregador:
( 1 comentário ) United States

ID do Projeto: #3021431

Premiar a:

deliawl

See private message.

$255 USD em 45 dias
(99 Avaliações)
6.8

6 freelancers are bidding on average $245 for this job

trkr

See private message.

$255 USD in 45 dias
(52 Comentários)
5.5
hitprem

See private message.

$234.6 USD in 45 dias
(43 Comentários)
5.1
kesha

See private message.

$255 USD in 45 dias
(31 Comentários)
5.0
khali6581

See private message.

$255 USD in 45 dias
(7 Comentários)
3.2
mustafayontar

See private message.

$212.5 USD in 45 dias
(0 Comentários)
0.0