A sample mysqli insert-update statement for strings, numbers and dates.

MysqliInsertUpdate.php

$now = date("Y-m-d H:i:s");

//Insert
$query = 'insert into '.$tableNamespace.'tableName(field1, field2, field3, field4) values ('.
'"'.$strValue1.'",'.
'"'.$strValue2.'",'.
$intValue3.','.
'"'.$now.'"'.
')';

mysqli_query($con,$query);

//Update
$query = 'update '.$tableNamespace.'tableName set numeric_field = 1, date_field="'.$now.'" where numeric_condition='.$numeric.' string_condition ="'.$string.'"';
mysqli_query($con,$query);