wpdb::insert() WordPress Method
The wpdb::insert() method inserts a new row into a table in the database. The first argument is the table name, followed by an array of data to be inserted, where the keys are the column names and the values are the data to be inserted into those columns.
wpdb::insert( string $table, array $data, array|string $format = null ) #
Inserts a row into the table.
Description
Examples:
wpdb::insert( 'table', array( 'column' => 'foo', 'field' => 'bar' ) )
wpdb::insert( 'table', array( 'column' => 'foo', 'field' => 1337 ), array( '%s', '%d' ) )See also
- wpdb::prepare()
- wpdb::$field_types
- wp_set_wpdb_vars()
Parameters
- $table
(string)(Required)Table name.
- $data
(array)(Required)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.
- $format
(array|string)(Optional) 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 value: null
Return
(int|false) The number of rows inserted, or false on error.
Source
File: wp-includes/wp-db.php
public function insert( $table, $data, $format = null ) {
return $this->_insert_replace_helper( $table, $data, $format, 'INSERT' );
}
Expand full source codeCollapse full source codeView on TracView on GitHub
Changelog
| Version | Description |
|---|---|
| 2.5.0 | Introduced. |