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 vote110 views1 answer
Kill laravel server
PHP
0 vote102 views1 answer
Wordpress php query randomise
PHP
0 vote112 views1 answer
Get url segment in php
PHP
0 vote144 views1 answer
Insert array values in database using codeigniter
PHP CodeIgniter
0 vote112 views1 answer
Php slugify
PHP
0 vote111 views1 answer
User input in oop php
PHP
1 vote107 views2 answers
Htaccess redirect https laravel
PHP
9 votes103 views6 answers
Php add days to date
PHP
-1 vote159 views2 answers
Elvis operator php
PHP
0 vote108 views1 answer
Php document append script to head
PHP