wpdb::insert() – Method | Developer.WordPress.org

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', ) );

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

int|false The number of rows inserted, or false on error.

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

Uses	Description
wpdb::_insert_replace_helper()`wp-includes/class-wpdb.php`	Helper function for insert and replace.

Used by	Description
wp_insert_site()`wp-includes/ms-site.php`	Inserts a new site into the database.
add_network_option()`wp-includes/option.php`	Adds a new network option.
populate_network()`wp-admin/includes/schema.php`	Populate network settings.
wp_install_defaults()`wp-admin/includes/upgrade.php`	Creates the initial content for a newly-installed site.
wp_insert_link()`wp-admin/includes/bookmark.php`	Inserts a link into the database, or updates an existing link.
update_usermeta()`wp-includes/deprecated.php`	Update metadata of user.
wp_insert_term()`wp-includes/taxonomy.php`	Adds a new term to the database.
wp_set_object_terms()`wp-includes/taxonomy.php`	Creates term and taxonomy relationships.
wp_insert_user()`wp-includes/user.php`	Inserts a user into the database.
wp_insert_post()`wp-includes/post.php`	Inserts or update a post.
wpmu_log_new_registrations()`wp-includes/ms-functions.php`	Logs the user email, IP, and registration date of a new site.
wpmu_signup_blog()`wp-includes/ms-functions.php`	Records site signup information for future activation.
wpmu_signup_user()`wp-includes/ms-functions.php`	Records user signup information for future activation.
wp_insert_comment()`wp-includes/comment.php`	Inserts a comment into the database.
add_metadata()`wp-includes/meta.php`	Adds metadata for the specified object.

Show 10 more Show less

Changelog

Version	Description
2.5.0	Introduced.

User Contributed Notes

Skip to note 5 content

alordiel 8 years ago

You must log in to vote on the helpfulness of this noteVote results for this note: 23You must log in to vote on the helpfulness of this note
To get the id of the inserted object use $wpdb->insert_id;
```
global $wpdb; $table = $wpdb->prefix.'you_table_name'; $data = array('column1' => 'data one', 'column2' => 123); $format = array('%s','%d'); $wpdb->insert($table,$data,$format); $my_id = $wpdb->insert_id;
```
Log in to add feedback
Skip to note 6 content

geraltoftrivia 3 years ago

You must log in to vote on the helpfulness of this noteVote results for this note: 5You must log in to vote on the helpfulness of this note

Worth mentioning that wpdb::insert sanitizes your data for you, unlike $wpdb->query which requires you to sanitize your query with $wpdb->prepare.

Log in to add feedback

shewa12 3 years ago

Insert multiple rows at once

function insert_multiple_rows( $table, $request ) { global $wpdb; $column_keys = ''; $column_values = ''; $sql = ''; $last_key = array_key_last( $request ); $first_key = array_key_first( $request ); foreach ( $request as $k => $value ) { $keys = array_keys( $value ); // Prepare column keys & values. foreach ( $keys as $v ) { $column_keys .= sanitize_key( $v ) . ','; $sanitize_value = sanitize_text_field( $value[ $v ] ); $column_values .= is_numeric( $sanitize_value ) ? $sanitize_value . ',' : "'$sanitize_value'" . ','; } // Trim trailing comma. $column_keys = rtrim( $column_keys, ',' ); $column_values = rtrim( $column_values, ',' ); if ( $first_key === $k ) { $sql .= "INSERT INTO {$table} ($column_keys) VALUES ($column_values),"; } elseif ( $last_key == $k ) { $sql .= "($column_values)"; } else { $sql .= "($column_values),"; } // Reset keys & values to avoid duplication. $column_keys = ''; $column_values = ''; } return $wpdb->query( $sql ); } // Usage $table = 'table_name'; $data = array( array( 'id' => 1, 'name' => 'John' ), array( 'id' => 2, 'name' => 'Doe' ), ); insert_multiple_rows( $table, $data );

MostafaNk 2 years ago

-1

global $wpdb; //get my table $tableUsers = $wpdb->prefix . 'wpdocs_users'; $name = 'mostafa'; $family = 'niakan'; $phone = '+9812345678'; $data = array( 'name' => $name, 'family' => $family, 'phone' => $phone, ); $format = array( '%s', '%s', '%s', '%d' ); $stmt = $wpdb->insert( $tableUsers, $data, $format ); //get insert id var_dump( $wpdb->insert_id );

This will fail, as the length of $format is four, while the length of $data is three; they must match.

crstauf 2 years ago

wpdb::insert( string $table, array $data, string[]|string $format = null ): int|false

In this article

Description

See also

Parameters

Return

Source

Changelog

User Contributed Notes