I am wondering if there is a way to insert a list of data using one sql query:
$myList = [ ["A1", "B1", "C1"],
["A2", "B2", "C2"],
["A3", "B3", "C3"],
] ;
$query_insert = "INSERT INTO myTable (A1, B2, C3) VALUES '$myList';";
$result = $pdo->query($query_insert);
if ($result){
$response['success'] = true;
$response['message'] = "Inserted";
}else{
$response['success'] = false;
$response['message'] = "Failed to insert data";
}