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

0 vote320 views1 answer
Laravel telescope redirect to localhost
PHP
1 vote304 views1 answer
Date format in laravel month name day name
PHP
6 votes313 views6 answers
Search query in laravel
PHP
-2 votes336 views3 answers
SQLSTATE[42S02] lumen
PHP
0 vote420 views1 answer
Add floater to open a modal in wordpress
PHP Wordpress
10 votes301 views6 answers
Php pdo connection
PHP
0 vote385 views1 answer
Has_post_format wordpress
PHP Wordpress
0 vote310 views1 answer
Php form action self
PHP
1 vote362 views1 answer
Get user with role laravel
PHP Laravel
16 votes303 views6 answers
Php write file
PHP