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

Last active October 7, 2018 10:22

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/yassine-khachlek/de9d2a0ba25becb06972ff24c1dfa656.js"></script>
Save yassine-khachlek/de9d2a0ba25becb06972ff24c1dfa656 to your computer and use it in GitHub Desktop.

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));