Capture info from Website

PHP or Perl Script to Capture info from a website and insert into mySQL database. ## Deliverables Screen scrape capture the Companies and other registrations from this website and page: <[login to view URL]> This is open and Public Domain information. Table fields should be as follows: 1. Date:? [DATE] {date and time of capture (now)} 2. Source: [VARCHAR 40] {[login to view URL] registrations} 3. Enterprise_name: [VARCHAR 100] {long names possible and extended ASCII Characters must be allowed} Typical long name and sometimes longer: "**OCEAN BLUE INFORMATION MANAGEMENT SOLUTIONS"** 4. Enterprise_number: [VARCHAR 20] {} Typically "2010/091030/23" 5. Enterprise_activity: [TEXT] {} Typically "SALE MAINTENANCE AND REPAIR OFMOTOR VEHICLES AND MOTOR R CYCLES;RETAIL TRADE IN AUTOMOTIVE FUEL" 6. Enterprise_region: [VARCHAR 40]{Province} Typically "Kwa-Zulu Natal" 7. Enterprise Postal Addres: {This cell containes FIVE lines of which the last one is always Postal Code - To be split in FIVE Fields} [Each Field VARCHAR 50] 7a. address_1 7b. address_2 7c. address_3 7d. address_4 7e. Postal_Code Note:? Duplicates not allowed. Can be tested on Enterprise Registration number. Could be done by making this field Unique.