WordPress $wpdb Cheat Sheet

A Software › WordPress cheat sheet in English by husker

$wpdb functions syntax

WordPress

10,810 views 2,860 downloads 28 Jan 2020 History

PRs

Download

3.7 avg · 0 ratings

$wpdb->get_var

$wpdb->get_var( 'query' );
$wpdb->get_var( 'query', column_offset, row_offset );

Ex: $user_count = $wpdb->get_var( "SELECT COUNT(*) FROM $wpdb->users" );

$wpdb->get_row

$wpdb->get_row('query', output_type, row_offset);

OBJECT - result will be output as an object.
ARRAY_A - result will be output as an associative array
ARRAY_N - result will be output as a numerically indexed array.

$wpdb->get_col

$wpdb->get_col( 'query', column_offset );

$wpdb->get_results

$wpdb->get_results( 'query', output_type );

OBJECT - result will be output as a numerically indexed array of row objects.
OBJECT_K - result will be output as an associative array of row objects, using first column's values as keys (duplicates will be discarded).
ARRAY_A - result will be output as a numerically indexed array of associative arrays, using column names as keys.
ARRAY_N - result will be output as a numerically indexed array of numerically indexed arrays.

$wpdb->insert

$wpdb->insert( $table, $data, $format );

$wpdb->replace

$wpdb->replace( $table, $data, $format );

$wpdb->update

$wpdb->update( $table, $data, $where, $format = null, $where_format = null );

$wpdb->delete

$wpdb->delete( $table, $where, $where_format = null );

$wpdb->query

$wpdb->query('query');

$wpdb->prepare

$sql = $wpdb->prepare( 'query' , value_parameter[, value_parameter ... ] );

Badges

Nice Cheat Sheet

Comments

No comments yet.

WordPress $wpdb Cheat Sheet

$wpdb-­>ge­t_var

$wpdb-­>ge­t_row

$wpdb-­>ge­t_col

$wpdb-­>ge­t_r­esults

$wpdb-­>insert

$wpdb-­>re­place

$wpdb-­>update

$wpdb-­>delete

$wpdb-­>query

$wpdb-­>pr­epare