We need a php script that needs to be integrated into our database:
a. It looks up external url for the site from our internal database
b. It then goes to that external site and finds the business name defined in the webpage (there are roughly 6-10 types of different website).
c. If found, it populates it into our businesses table and inserts the relevant id into the main table.
This should be a no brainer for an experience php web scrapper. You need to be able to analyse the page and work out the rules on how to extract business name.
I actually posted this job as manual data entry and the guy actually wrote a vb program to do it with 100% accuracy. Unfortunately, we need php script so that we can integrate it. I have attached the excel file he populate for you to get idea of the sites.