Scraping Structured Website and Bulk Search of websites

We require some data scraping work to be completed followed by a bulk search of extracted websites for key terms. File attached includes an existing PHP script that needs to be updated along with results from previous years (not exactly the same as this year). Deliverables can be in MySQL database format. Scraping  We require scraping of the following site and sub-pages: [login to view URL] Fields to scrape: NPRI ID Company Name City Province   Using the first company  (1132694 Ontario Inc. - Spray-Pak Industries) as an example: Sub-Page to scrape: [login to view URL] Fields to scrape and place in table: Contact Information: Name Positions Phone Fax email Street and Number Street 2 City Province Postal Code Number of employees Website - extract from email address if necessary (this will be used in step 2) Parent Company Information if applicable After this information has been compiled into a database, we would like to add three columns to the database that will be set to true of false based on a bulk search of their website using google site search or another system (i.e. site:[login to view URL] ISO 14001) We would like to perform a bulk search for the following three terms: ISO 14001 Environmental Management System EHS Management System