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

3 votes203 views1 answer
Wordpress base theme child url
PHP Wordpress
1 vote244 views2 answers
Download php7.4-mbstring ubuntu
PHP
3 votes195 views1 answer
Drop table phpmyadmin
PHP
9 votes271 views4 answers
Datetime format laravel
PHP
0 vote230 views1 answer
Same column in and where laravel query
PHP
0 vote180 views1 answer
Php location same page
PHP
3 votes228 views3 answers
Class 'App\Http\Controllers\Admin\Route' not found
PHP
0 vote217 views2 answers
Iframe site bi link laravel
PHP
0 vote264 views1 answer
Add another column in a table in laravel
PHP
2 votes205 views1 answer
Wp_siteurl
PHP