Closed

Page scraper .NET MySql PHP Curl

This project received 6 bids from talented freelancers with an average bid price of $92 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$10 - $30 USD
Total Bids
6
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, [url removed, login to view], 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 [url removed, login to view]

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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online