Mysqli: Insert from array

<?php

$data = array(
    'field1' => $value1,
    'field2' => $value2,
);

$sql_fields = '';
$sql_values = '';
$sep = '';
foreach ($data as $key => $val) {
    $sql_fields .= $sep . '`' . $key . '`';
    $sql_values .= $sep . '"' . $mysqli->real_escape_string($val) . '"';
    $sep = ',';
}

$sql = 'insert into my_table (' . $sql_fields . ') values (' . $sql_values . ')';

$mysqli->query($sql) or die($mysqli->error);

?>

 

Related Snippets

•	Mysqli: Update
•	Mysqli: Update from array
•	Mysqli: Select
•	Mysqli: Insert
•	Mysqli: Connect