0

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";
}
RiggsFolly
  • 89,708
  • 20
  • 100
  • 143
MEDANIS
  • 95
  • 7

0 Answers0