yassine-khachlek/Laravel MySQL INSERT ON DUPLICATE KEY UPDATE.md

## Laravel MySQL INSERT ON DUPLICATE KEY UPDATE.md

      
    Raw
  

              Laravel MySQL INSERT ON DUPLICATE KEY UPDATE.md
            
          
    $query = "INSERT INTO table_name (" . implode(',', $columns) . ") VALUES " 
. implode(
    ',',
    array_map(function($data) {
        return "(" . implode(",", array_fill(0, count($data) , '?')) . ")";
    }, $datas)
)
. " ON DUPLICATE KEY UPDATE "
. implode(
    ',',
    array_map(function($column) {
        return $column . "=VALUES(" . $column . ')';
    }, $columns)
);

DB::statement($query, array_collapse($datas));