Mysqli: Insert

<?php

$sql = 'insert into my_table (field1, field2) 
    values (
    "' . $mysqli->real_escape_string($value1) . '", 
    "' . $mysqli->real_escape_string($value2) . '"
    )';

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

?>

 

Related Snippets

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