I need to interpret an HTML table and save the data to a phpMyAdmin database.
Attached is an html file containing the source code of the table.
I need to read this source code and save each value in a column of a table in my database.
The script needs to find the part of the code where the values are, interpret and save each value in its respective database column.
The HTML structure of the file will always be the same, but the amount of values will be different.
Visually follows the file data I sent attached.
Login Volume Commission Rebate Balance
32015393 4.09 27.12 0.0 906.53
35165076 0.51 1.13 0.0 1209.7
35165770 1.99 8.84 0.0 4670.28
35165823 2.14 9.58 0.0 5187.68
35166433 4.06 18.06 0.0 9533.18
35166942 0.51 2.27 0.0 1160.22
35167298 1.23 6.27 0.0 1081.2
35167301 35.93 201.63 0.0 0.0
35170348 0.26 1.57 0.0 1046.81
35170377 1.95 8.63 0.0 366.04
35170754 1.21 7.26 0.0 0.0
35170758 0.65 3.81 0.0 1165.14
35170762 0.02 0.11 0.0 515.15
35170763 0.86 4.98 0.0 0.0
35170765 0.63 3.66 0.0 0.0
35170769 2.53 8.84 0.0 704.63
35170770 0.47 1.91 0.0 539.99
35171514 5.93 33.6 0.0 0.0
35171519 1.92 11.46 0.0 0.0
35173459 0.06 0.27 0.0 2901.37
51083993 1.06 5.88 0.0 667.35
51084133 0.48 3.48 0.0 77.29
51084342 4.01 27.52 0.0 625.31
51084343 3.91 14.79 0.0 1252.67
Totals: 412.67 0.0
I can provide you a simple PHP script that will parse your HTML and save output into MySQL database in less than 5 hours. AllI need to start is your database schema (or I can create it by myself).
Hi, I am 8 years experienced web developer . I understand your point.
I can complete this project within four hours .
Please check my profile for my work quality .
Thanks,
Bhaskar Mandal
Hello, dear Customer.
I am interested in your project and feel confident after reading your project description.
Please contact me so that we can discuss it in more detail.
Looking forward to hearing from you soon.
Thank you.