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

4 votes286 views3 answers
Collection empty laravel
PHP
0 vote318 views1 answer
Php get keys of duplicate values in array
PHP
30 votes339 views3 answers
PHP if...else...elseif Statements
PHP
6 votes371 views1 answer
Debug query builder laravel
PHP Laravel
3 votes366 views2 answers
Get details of user using token in laravel passport
PHP
0 vote346 views2 answers
Php replace all text from string with associate array values
PHP
17 votes356 views2 answers
Mysql replace a character in a string
PHP
0 vote376 views1 answer
Database interaction in codeigniter
PHP
4 votes385 views4 answers
Multiple middleware laravel
PHP Laravel
1 vote291 views1 answer
Array push laravel
PHP