Page scraper .NET MySql PHP Curl

CLOSED
Bids
6
Avg Bid (USD)
$92
Project Budget (USD)
$10 - $30

Project Description:
Project Description:
Please read the description carefully, especially the code format requirements.
I require a script which will connect to the following page, http://publicaccess.chelmsford.gov.uk/online-applications/search.do?action=advanced&searchType=Application, submit the form with search criteria based on two variables of $date_from and $date_to and then scrape all the results which may be listed across multiple pages (pagination)and insert them in to a MySql table called “tbl_planning_leads”.
Fields to return are:
Reference
Address
Proposal
Status
Applicant name
Application type
Application received date

This script needs to be written in Curl to connect to the website and PHP to parse and insert in to table. Any PHP code needs to use the MYSQLI extension and include no syntax short cuts. All code needs to be cleanly written and contain clear commenting. The MySqli insert statement needs to be of type “
//Execute the insert query on the database
if ($conn->query($query)===TRUE){

$query = "INSERT INTO tbl_planning_leads (reference,address,proposal ,etc etc etc )
VALUES
('value_1,'value_2,' ',etc etc )";

Stored procedures & PDO are not to be used,
Idealy, the parsing would be executed using the “SimpleHTMLDOM” parser found at http://simplehtmldom.sourceforge.net/

All code to be clearly commented and presented in a way which will be easy for us to maintain it going forward.
I have attached a copy of tbl_planning_leads for your convenience.

Skills required:
MySQL, PHP, Software Architecture
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 103
in 3 days
Hire rajeshsonisl
$ 154
in 1 days
$ 134
in 3 days
Hire DrTech76
$ 50
in 1 days
$ 55
in 3 days
Hire liemvo
$ 55
in 3 days