Inserts a row into the table.

Description

Examples:

$wpdb->insert(
    'table',
    array(
        'column1' => 'foo',
        'column2' => 'bar',
    )
);
$wpdb->insert(
    'table',
    array(
        'column1' => 'foo',
        'column2' => 1337,
    ),
    array(
        '%s',
        '%d',
    )
);

See also

• wpdb::prepare()
• wpdb::$field_types
• wp_set_wpdb_vars()

Parameters

$tablestringrequired

Table name.

$dataarrayrequired

Data to insert (in column => value pairs).
Both $data columns and $data values should be "raw" (neither should be SQL escaped).
Sending a null value will cause the column to be set to NULL – the corresponding format is ignored in this case.

$formatstring[]|stringoptional

An array of formats to be mapped to each of the value in $data.
If string, that format will be used for all of the values in $data.
A format is one of '%d', '%f', '%s' (integer, float, string).
If omitted, all values in $data will be treated as strings unless otherwise specified in wpdb::$field_types.

Default:null

Return

Source

public function insert( $table, $data, $format = null ) {
	return $this->_insert_replace_helper( $table, $data, $format, 'INSERT' );
}

View all references View on Trac View on GitHub

Changelog