Encerrado

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.

Habilidades: MySQL, PHP, Arquitetura de software

Ver mais: php code online, pdo website, online php execute, execute php online, clear search fields, net connect, php pdo, pdo, mysqli, mysql php, stored procedures mysql pdo, format php code, form connect database mysql, php script execute, mysql multiple insert, php pdo pagination script, mysql search table, curl code, net based code, insert php code form, submit mysql page, php code format, connect database php form, php mysql query multiple, mysql search database table

Acerca do Empregador:
( 3 comentários ) London, United Kingdom

ID do Projeto: #5113831

5 freelancers estão ofertando em média $100 para este trabalho

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: http://sigma-dns.sigmavirtual.com/PDemo1/Am Mais

$103 USD in 3 dias
(242 Comentários)
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. Mais

$154 USD em 1 dia
(466 Comentários)
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 Mais

$134 USD in 3 dias
(93 Comentários)
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 Mais

$50 USD em 1 dia
(295 Comentários)
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 dias
(11 Comentários)
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 dias
(3 Comentários)
1.8