WinBinder Manual/db create record

Creates a record in a table.

Syntax

int db_create_record(string tablename [, mixed fieldnames [, mixed fieldvalues [, string idfield]]])

Arguments

• tablename is the name of the table that will be affected.
• fieldnames is a set of identifiers that may be an array or a CSV string ( without the "id" field )
• fieldvalues is a string with the values of the records desired. It may be an array or a CSV string
• idfield is the name of identifier field (column). Default is "id".

The table below summarizes the options for fieldnames and fieldvalues.

fieldnames	fieldvalues	Data inserted
null	null	a record with all fields "0"
null	string array	a record with all fields with their fieldvalues
string array	string array	a record with fieldnames with their fieldvalues

Result

The result will be the actual id or FALSE if the record could not be created.

Example

// Create record in mytable

$fn = array("name", "what", "OK"); 
$fv = array("hut", " in the summer", 1); 
$res = db_create_record(null, null, $fv); 
echo ("id is $res "); 

See also

• <winterpostwiki>Database functions</winterpostwiki>
• <winterpostwiki>Database support</winterpostwiki>