PHPize Online / SQLize Online  /  SQLtest Online

<?php // $mysqli is already declared as a working database connection by this sandbox $array = [ [ 'date' => '2018-05-23', 'content' => [ [ 'AAAAAA', 'BBBBBB', 'CCCCCC', 'DDDDDD', 'EEEEEE', 'FFFFFF', 'GGGGGG', 'HHHHHH', 'IIIIII', 'JJJJJJ', ], ], ], [ 'date' => '2018-05-22', 'content' => [ [ 'KKKKKK', 'LLLLLL', 'MMMMMM', 'NNNNNN', ], ], ], ]; $sql = "INSERT INTO your_table (date, content1, content2) VALUES (?,?,?)"; foreach ($array as ['date' => $date, 'content' => [0 => $entries]]) { foreach (array_chunk($entries, 2) as $pair) { $mysqli->execute_query($sql, [$date, ...$pair]); } } foreach ($mysqli->query("SELECT * FROM your_table") as $row) { echo "<div>{$row['date']} : {$row['content1']}, {$row['content2']}</div>\n"; }