Closed

Page scraper .NET MySql PHP Curl

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.

Skills: MySQL, PHP, Software Architecture

See more: php code online, pdo website, online php execute, execute php online, execute c++ code online, clear search fields, advanced c# net, the net connect, php pdo, pdo, mysqli, Mysql php, mysql scrape website, scraper mysql php, stored procedures mysql pdo, format php code, php curl http code, form connect database mysql, php script execute, mysql multiple insert, php advanced search form script, php pdo pagination script, mysql search table, php scraper curl, curl code

About the Employer:
( 3 reviews ) London, United Kingdom

Project ID: #5113831

5 freelancers are bidding on average $100 for this job

SigmaVisual

Dear Client, I can help in your project. We have already experience of working on similar projects. Please see below to get idea of our experience: Amazon/Ebay Bots: [url removed, login to view] More

$103 USD in 3 days
(242 Reviews)
7.9
rajeshsonisl

Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 !!)... you can never go wrong choosing me :) I look forward to your reply. More

$154 USD in 1 day
(466 Reviews)
7.3
samitXI

Hi Sir, I am ready to work for you.I have 9 years of experience in C/C++ , java, PHP and, MySQL. please see some of my works also check my reviews you will get better idea about my skill.I deliver quality work within More

$134 USD in 3 days
(93 Reviews)
6.9
DrTech76

Hello there. The task is pretty much clear, though I do have some questions. Like: 1) The two dates "from" and "to" for the search is for the "Date Received" filter of the form? 2) Should teh script present a fo More

$50 USD in 1 day
(295 Reviews)
6.7
PHPDeveloperr

Hello sir, I'm php expert. and i can do this job quickly as possible.I'm ready to start right now. Thank you ! :)

$55 USD in 3 days
(11 Reviews)
4.2
liemvo

I am expert on crawl data from other website. Let me do it and you will love my qualification. Contact me via skype: liemvt90 Many thanks, Liem

$55 USD in 3 days
(3 Reviews)
1.8