Online PHP editor | refs for qEDP4

<?php $json = '[ { "match_id": "345064", "odd_bookmakers": "Interwetten.es", "odd_date": "2018-10-24 04:39:45", "odd_1": "2.05", "odd_x": "2.95", "odd_2": "3.95", "odd_1x": "", "odd_12": "", "odd_x2": "", "ah-4.5_1": "", "ah-4.5_2": "", "ah-4_1": "", "ah-4_2": "", "ah-3.5_1": "", "ah-3.5_2": "", "ah-3_1": "", "ah-3_2": "", "ah-2.5_1": "", "ah-2.5_2": "", "ah-2_1": "", "ah-2_2": "", "ah-1.5_1": "", "ah-1.5_2": "", "ah-1_1": "3.00", "ah-1_2": "1.33", "ah0_1": "1.42", "ah0_2": "2.65", "ah+0.5_1": "", "ah+1_1": "", "ah+1_2": "", "ah+1.5_1": "", "ah+1.5_2": "", "ah+2_1": "", "ah+2_2": "", "ah+2.5_1": "", "ah+2.5_2": "", "ah+3_1": "", "ah+3_2": "", "ah+3.5_1": "", "ah+3.5_2": "", "ah+4_1": "", "ah+4_2": "", "ah+4.5_1": "", "ah+4.5_2": "", "o+0.5": "", "u+0.5": "", "o+1": "", "u+1": "", "o+1.5": "", "u+1.5": "", "o+2": "", "u+2": "", "o+2.5": "2.45", "u+2.5": "1.48", "o+3": "", "u+3": "", "o+3.5": "", "u+3.5": "", "o+4": "", "u+4": "", "o+4.5": "", "u+4.5": "", "o+5": "", "u+5": "", "o+5.5": "", "u+5.5": "", "bts_yes": "2.05", "bts_no": "1.67" } ]'; $cols = array_fill_keys(['match_id', 'odd_bookmakers', 'odd_date', 'odd_1', 'odd_x', 'odd_2', 'odd_1x', 'o+0.5', 'u_+0.5', 'o+1.5', 'bts_yes', 'bts_no'], null); foreach(json_decode($json, true) as $row) { $row = array_replace($cols, array_intersect_key($row, $cols)); var_export($row); }