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:
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
$query = "INSERT INTO tbl_planning_leads (reference,address,proposal ,etc etc etc )
('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.