One rule:
--> You bid now, you start now until finished.
If you know what you are doing, it shouldn't take more than 1-2 hours max!
I would like to scrape a few missing items,
--> $sql = "INSERT INTO `races` ( `meeting_id`, `race_number`, `race_schedule_time`, `race_title` ) VALUES ( ?, ?, ?, ? );";
--> I would like to add 'distance' to that.
I would also like to get last 10 runs --> screenshot attached
$sql = "INSERT INTO `horses` ( `race_id`, `horse_number`, `horse_name`, `horse_weight`, `horse_fixed_odds`, `horse_h2h` ) VALUES ( ?, ?, ?, ?, ?, ? );";
$stmt_horses;
I have a future project, so if you can perform well for me here, I will give you a bigger project
Good day, I read your specification carefully, checked the codes and the screenshot.
For your first requirement. Adding the distance data into the races table what I'll do are:
1. update the function parse_races to scrape the distance on the race schedule on the meeting details page of the website.
2. update database table to add a new column for the distance.
3. update the function save_race and edit the bind_param to include the distance as well.
For the second task, "I would also like to get last 10 runs". Im not quite sure what you want to fetch there, I'm available to discuss if you are interested. Thanks