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

18 votes159 views6 answers
Laravel form validation
PHP Laravel
1 vote120 views1 answer
Remove all attributes from HTML tags in PHP
PHP
1 vote201 views1 answer
Php remove line if it contains string
PHP
5 votes108 views1 answer
Php date + one day
PHP
0 vote119 views2 answers
Php mysql text mark question
PHP
0 vote148 views2 answers
How to link external php file to html
PHP
1 vote125 views1 answer
Add shortcode in short description
PHP
0 vote168 views1 answer
CakeResque::enqueue
PHP
2 votes132 views1 answer
Php file_get_contents disable ssl check
PHP
2 votes155 views3 answers
How to get the size of an uploaded file in laravel
PHP Laravel