I am looking for a linux script that will parse through a structured html page and extract the data.? The data will then be inserted into a mysql databse.? ? The script should? use any combination of bash, php and awk.
All of the html files are in the same format.? I am including 2 examples of the html files, and an excel spreadsheet that shows the database layout.? ?
Notice that there are 2 tables.? The charges section goes into a seperate table.? The amount of charges will vary, so it is a seperate table.? The "booking" is the relation field.