Insert array

protected function build_sql_insert($table, $data) {
    $key = array_keys($data);
    $val = array_values($data);
    $sql = "INSERT INTO $table (" . implode(', ', $key) . ") "
         . "VALUES ('" . implode("', '", $val) . "')";
    return($sql);
}

Source: phpflow.com

Similar codes

1 vote310 views2 answers
Laravel middleware in constructor
PHP Laravel
1 vote234 views1 answer
How to add attribute to the request object in laravel
PHP
1 vote261 views1 answer
Types of controller in laravel
PHP Laravel
1 vote259 views1 answer
How to find mysql server name in php
PHP
6 votes238 views2 answers
Php mkdir if not exists
PHP
3 votes221 views2 answers
Return last inserted id in laravel
PHP
3 votes214 views1 answer
Cannot use object of type App\ViewModels\Admin\Category\Category ViewModels as array (View: C:\OSPanel\domains\megaimkon.loc\resources\views\admin\category\index.blade.php)
PHP
0 vote247 views1 answer
Return false inside loop of function php
PHP
1 vote287 views1 answer
Drupal 8 show php errors settings.php
PHP Drupal
0 vote210 views1 answer
The uploaded file exceeds the upload_max_filesize in laravel
PHP