PHP sorting thru Nested loops question

[ad_1]

Hello all,

So I’m trying to sort thru nested data from an API and insert it into the WordPress MySQL database. I’ve already created my SQL table, and I’ve succesfully pushed API data to it using a simpler test loop.

However, when I try to access all the levels of the JSON data using a big ol’ foreach loop, I’m getting nothing in the database:

$results = wp_remote_retrieve_body(wp_remote_get( $url, $args ));

$res = json_decode($results);

$odds = [];

foreach ($res as $odd) {
foreach ($odd->bookmakers as $bm) {
foreach ($bm->markets as $market) {
foreach ($market->outcomes as $outcome) {
$odds = [
‘key_id’ => $odd->id,
‘home_team’ => $odd->home_team,
‘away_team’ => $odd->away_team,
‘commence_time’ => $bm->commence_time,
‘sport_key’ => $odd->sport_key,
‘last_updated_at’ => $bm->last_update,
‘bookmaker_key’ => $bm->key,
‘market’ => $market->key,
‘label’ => $outcome->name,
‘price’ => $outcome->price,
‘points’ => $outcome->point
];
}
}
}

#Insert data into MySQL table
global $wpdb;

$table_name = $wpdb->prefix . ‘game_odds’;

$wpdb->insert(
$table_name,
$odds
);
}

Meanwhile this code works fine and pushes data to my database:

$results = wp_remote_retrieve_body(wp_remote_get( $url, $args ));

$res = json_decode($results);

$test_odds = [];

foreach ($res as $odd) {
$test_odds = [
‘key_id’ => $odd->id,
‘home_team’ => $odd->home_team,
‘away_team’ => $odd->away_team,
‘sport_key’ => $odd->sport_key
];

#Insert data into MySQL table
global $wpdb;

$table_name = $wpdb->prefix . ‘game_odds’;

$wpdb->insert(
$table_name,
$test_odds
);
}

Any help is appreciated, thanks!

[ad_2]