db_create_record

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

Creates a record in a table.

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".

Result

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

Keys and columns

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

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

Database functions
Database support