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

11 votes268 views4 answers
Number format comma php
PHP
0 vote316 views1 answer
Laravel on cascade set null
PHP Laravel
2 votes335 views2 answers
How to add attributes to an object in php
PHP
0 vote287 views1 answer
Keep track of view count php
PHP
1 vote337 views3 answers
Queue jobs in laravel
PHP Laravel
0 vote276 views1 answer
Phpunit/phpunit[dev-master, 9.3.3, ..., 9.4.x-dev] require ext-dom * -> it is missing from your system. Install or enable PHP's dom extension.
PHP
4 votes337 views3 answers
Laravel cmd command to watch logs
PHP Laravel
17 votes288 views5 answers
Wordpress debug mode
PHP
0 vote280 views1 answer
Get_the_id wordpress
PHP Wordpress
36 votes267 views6 answers
Php convert to lowercase
PHP