PrepareInsert

array
CDatabase::PrepareInsert(
 string TableName,
 array fields,
 string FileDir = "",
 string lang = false
)

The method prepares array of two strings for SQL query that inserts a record to the database. Returns an array of two elements. The element with key '0' contains a list of fields in the form of "field_name1, field_name2[, ...]", while the element [1] contains a string "value1, value2[, ...]". The method converts all values to the SQL-compliant format with respect to the field type. Non-static method.

Parameters

Parameter	Description
TableName	Name of the table to ins ert a record into.
fields	Array of field values in the format of "field name1"=>"value1", "field name2"=>"value2" [, ...]. Use a val ue of false to insert NULL.
FileDir	Not used.
lang	Site ID (for public section) or the language ID (for administrative section). Used to determine the date format when inserting fields of the type date or datetime. Optional; false by default.

Examples of use

<?
function AddResultAnswer($arFields)
{
	$err_mess = (CForm::err_mess())."<br>Function: AddResultAnswer<br>Line: ";
	global $DB;
	$arInsert = $DB->PrepareInsert("b_form_result_answer", $arFields, "form");
	$strSql = "INS ERT IN TO b_form_result_answer (".$arInsert[0].") VALUES (".$arInsert[1].")";
	$DB->Query($strSql, false, $err_mess.__LINE__);
	return intval($DB->LastID());
}
?>

PrepareInsert

Parameters

See Also

Examples of use