514499 Parse RSS of Classifieds Store Data MySQL PHP 2

PHP Script

Parse Motorcycle Classifieds, store data.

Collection Overview:

+ Parse a list of structured RSS feeds (Feed) for Posts

+ Using regular expressions, extract strings that match specific criteria

+ Test for string match to values in database tables

+ Store new Records in MySQL database

+ Modify Records in database with datestamp when Posts are no longer in feed

Example feeds:

[url removed, login to view]

[url removed, login to view]

Database Record:

1. Required for insert:

a. Date of capture

b. Make

c. Model

d. Year of Manufacture

e. Price

f. Date listed

g. Days on market (calculated)

h. Postal Code (calculated)

i. Post ID

2. Optional for insert

a. Mileage ( Integer)

b. Trim Designator (STX, R/S…)

c. Significant Features (4x4, extra cab: comma separated list)

d. Value Modifier (integer -5 to +5)

e. Dealer or Private listing (Single Alpha “D” or “P”)

f. Phone

g. Email

Processamento de Dados MySQL Odd Jobs PHP

ID do Projeto: #2260431

Sobre o projeto