Congratulations, you now have access to WealthStep financial advice. WealthStep = Easy Aim>Save>Invest>Spend advice built by experts. See if you are on track for financial independence… and what to do next.
Your employer created a WealthStep online advice account as an additional benefit for you. Simply fill out the form on this page to complete the process.
Make better retirement planning decisions:
Ways to access WealthStep – You have special access to #1 through your employer:
All levels include at least one level of Aim > Save > Invest > Spend online advice, plus video and article education.
>
1. WealthStep 401k/Retirement Plans – FREE/paid for by the employer. Access to Basic and Advanced advice.
2. WealthStep Direct – Access to Basic and Advanced advice, plus portfolio management for your qualified investment accounts outside of a company retirement plan. A low, transparent fee (see FAQ). Optional financial planning projects with a human advisor available to “WealthStep Plus” clients (learn more). Get Started
3. WealthStep Basic – FREE “Basic” advice. Aim > Save > Invest > Spend online advice & video/article education, available to the public, through the public sign-up page. This is WealthStep’s way of giving back to the community.
About
WealthStep was designed by experts to solve a common problem… most people want financial independence but don’t know how much to save or when, or how to invest or adjust investments over time to fit their life stage. To improve the world’s financial fitness, WealthStep applies decades of experience to make success simpler.
Retirement Plan account users
Get password from your employer and click log-in button at top
SELECT ws_posts.ID FROM ws_posts WHERE 1=1 AND ws_posts.post_parent = 5770 AND ws_posts.post_type = 'page' AND ((ws_posts.post_status = 'publish')) ORDER BY ws_posts.post_title ASC LIMIT 0, 1 /* From [wealthstep.com/sign-up-invite/] in [/nas/content/live/wealthstep/wp-content/themes/wealthstep/header.php:87] */
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
Defined in :
$db->query("SELECT ws_posts.ID FROM ws_posts WHERE 1=1 AND ws_posts.post_parent = 5770 AND ws_posts.post_type = 'page' AND ((ws_posts.post_status = 'publish')) ORDER BY ws_posts.post_title ASC LIMIT 0, 1 /* From [wealthstep.com/sign-up-invite/] in [/nas/content/live/wealthstep/wp-content/themes/wealthstep/header.php:87] */")
Connects to the database server and selects a database. Does the actual setting up of the class properties and connection to the database. @since 2.0.8 @link https://core.trac.wordpress.org/ticket/3354 @param string $dbuser Database user. @param string $dbpassword Database password. @param string $dbname Database name. @param string $dbhost Database host. Defined in <ROOT>/wp-includes/class-wpdb.php:752
Makes private properties readable for backward compatibility. @since 3.5.0 @param string $name The private member to get, and optionally process. @return mixed The private member. Defined in <ROOT>/wp-includes/class-wpdb.php:778
Makes private properties check-able for backward compatibility. @since 3.5.0 @param string $name The private member to check. @return bool If the member is set or not. Defined in <ROOT>/wp-includes/class-wpdb.php:815
Makes private properties settable for backward compatibility. @since 3.5.0 @param string $name The private member to set. @param mixed $value The value to set. Defined in <ROOT>/wp-includes/class-wpdb.php:794
Makes private properties un-settable for backward compatibility. @since 3.5.0 @param string $name The private member to unset Defined in <ROOT>/wp-includes/class-wpdb.php:826
Escapes data. Works on arrays. @since 2.8.0 @uses wpdb::_real_escape() @param string|array $data Data to escape. @return string|array Escaped data, in the same type as supplied. Defined in <ROOT>/wp-includes/class-wpdb.php:1302
Helper function for insert and replace. Runs an insert or replace query based on `$type` argument. @since 3.0.0 @see wpdb::prepare() @see wpdb::$field_types @see wp_set_wpdb_vars() @param string $table Table name. @param array $data 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. @param string[]|string $format 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 null. @param string $type Optional. Type of operation. Either 'INSERT' or 'REPLACE'. Default 'INSERT'. @return int|false The number of rows affected, or false on error. Defined in <ROOT>/wp-includes/class-wpdb.php:2580
Real escape using mysqli_real_escape_string(). @since 2.8.0 @see mysqli_real_escape_string() @param string $data String to escape. @return string Escaped string. Defined in <ROOT>/wp-includes/class-wpdb.php:1272
Do not use, deprecated. Use esc_sql() or wpdb::prepare() instead. @since 2.8.0 @deprecated 3.6.0 Use wpdb::prepare() @see wpdb::prepare() @see esc_sql() @param string $data @return string Defined in <ROOT>/wp-includes/class-wpdb.php:1255
Adds a placeholder escape string, to escape anything that resembles a printf() placeholder. @since 4.8.3 @param string $query The query to escape. @return string The query with the placeholder escape string inserted where necessary. Defined in <ROOT>/wp-includes/class-wpdb.php:2436
Wraps errors in a nice header and footer and dies. Will not die if wpdb::$show_errors is false. @since 1.5.0 @param string $message The error message. @param string $error_code Optional. A computer-readable string to identify the error. Default '500'. @return void|false Void if the showing of errors is enabled, false if disabled. Defined in <ROOT>/wp-includes/class-wpdb.php:3931
Checks that the connection to the database is still up. If not, try to reconnect. If this function is unable to reconnect, it will forcibly die, or if called after the {@see 'template_redirect'} hook has been fired, return false instead. If `$allow_bail` is false, the lack of database connection will need to be handled manually. @since 3.9.0 @param bool $allow_bail Optional. Allows the function to bail. Default true. @return bool|void True if the connection is up. Defined in <ROOT>/wp-includes/class-wpdb.php:2116
Determines whether MySQL database is at least the required minimum version. @since 2.5.0 @global string $required_mysql_version The required MySQL version string. @return void|WP_Error Defined in <ROOT>/wp-includes/class-wpdb.php:3989
Closes the current database connection. @since 4.5.0 @return bool True if the connection was successfully closed, false if it wasn't, or if the connection doesn't exist. Defined in <ROOT>/wp-includes/class-wpdb.php:3965
Connects to and selects database. If `$allow_bail` is false, the lack of database connection will need to be handled manually. @since 3.0.0 @since 3.9.0 $allow_bail parameter added. @param bool $allow_bail Optional. Allows the function to bail. Default true. @return bool True with a successful connection, false on failure. Defined in <ROOT>/wp-includes/class-wpdb.php:1948
Returns the version of the MySQL server. @since 5.5.0 @return string Server version as a string. Defined in <ROOT>/wp-includes/class-wpdb.php:4131
Retrieves the database server version. @since 2.7.0 @return string|null Version number on success, null on failure. Defined in <ROOT>/wp-includes/class-wpdb.php:4120
Deletes a row in the table. Examples: $wpdb->delete( 'table', array( 'ID' => 1, ) ); $wpdb->delete( 'table', array( 'ID' => 1, ), array( '%d', ) ); @since 3.4.0 @see wpdb::prepare() @see wpdb::$field_types @see wp_set_wpdb_vars() @param string $table Table name. @param array $where A named array of WHERE clauses (in column => value pairs). Multiple clauses will be joined with ANDs. Both $where columns and $where values should be "raw". Sending a null value will create an IS NULL comparison - the corresponding format will be ignored in this case. @param string[]|string $where_format Optional. An array of formats to be mapped to each of the values in $where. If string, that format will be used for all of the items in $where. 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 deleted, or false on error. Defined in <ROOT>/wp-includes/class-wpdb.php:2759
Determines the best charset and collation to use given a charset and collation. For example, when able, utf8mb4 should be used instead of utf8. @since 4.6.0 @param string $charset The character set to check. @param string $collate The collation to check. @return array { The most appropriate character set and collation to use. @type string $charset Character set. @type string $collate Collation. } Defined in <ROOT>/wp-includes/class-wpdb.php:876
First half of escaping for `LIKE` special characters `%` and `_` before preparing for SQL. Use this only before wpdb::prepare() or esc_sql(). Reversing the order is very bad for security. Example Prepared Statement: $wild = '%'; $find = 'only 43% of planets'; $like = $wild . $wpdb->esc_like( $find ) . $wild; $sql = $wpdb->prepare( "SELECT * FROM $wpdb->posts WHERE post_content LIKE %s", $like ); Example Escape Chain: $sql = esc_sql( $wpdb->esc_like( $input ) ); @since 4.0.0 @param string $text The raw text to be escaped. The input typed by the user should have no extra or deleted slashes. @return string Text in the form of a LIKE phrase. The output is not SQL safe. Call wpdb::prepare() or wpdb::_real_escape() next. Defined in <ROOT>/wp-includes/class-wpdb.php:1779
Do not use, deprecated. Use esc_sql() or wpdb::prepare() instead. @since 0.71 @deprecated 3.6.0 Use wpdb::prepare() @see wpdb::prepare() @see esc_sql() @param string|array $data Data to escape. @return string|array Escaped data, in the same type as supplied. Defined in <ROOT>/wp-includes/class-wpdb.php:1331
Escapes content by reference for insertion into the database, for security. @uses wpdb::_real_escape() @since 2.3.0 @param string $data String to escape. Defined in <ROOT>/wp-includes/class-wpdb.php:1359
Kills cached query results. @since 0.71 Defined in <ROOT>/wp-includes/class-wpdb.php:1913
Gets blog prefix. @since 3.0.0 @param int $blog_id Optional. Blog ID to retrieve the table prefix for. Defaults to the current blog ID. @return string Blog prefix. Defined in <ROOT>/wp-includes/class-wpdb.php:1074
Retrieves a comma-separated list of the names of the functions that called wpdb. @since 2.5.0 @return string Comma-separated list of the calling functions. Defined in <ROOT>/wp-includes/class-wpdb.php:4109
Retrieves the database character collate. @since 3.5.0 @return string The database character collate. Defined in <ROOT>/wp-includes/class-wpdb.php:4024
Retrieves one column from the database. Executes a SQL query and returns the column from the SQL result. If the SQL result contains more than one column, the column specified is returned. If $query is null, the specified column from the previous SQL result is returned. @since 0.71 @param string|null $query Optional. SQL query. Defaults to previous query. @param int $x Optional. Column to return. Indexed from 0. Default 0. @return array Database query result. Array indexed from 0 by SQL result row number. Defined in <ROOT>/wp-includes/class-wpdb.php:3097
Retrieves the character set for the given column. @since 4.2.0 @param string $table Table name. @param string $column Column name. @return string|false|WP_Error Column character set as a string. False if the column has no character set. WP_Error object if there was an error. Defined in <ROOT>/wp-includes/class-wpdb.php:3296
Retrieves column metadata from the last query. @since 0.71 @param string $info_type Optional. Possible values include 'name', 'table', 'def', 'max_length', 'not_null', 'primary_key', 'multiple_key', 'unique_key', 'numeric', 'blob', 'type', 'unsigned', 'zerofill'. Default 'name'. @param int $col_offset Optional. 0: col name. 1: which table the col's in. 2: col's max length. 3: if the col is numeric. 4: col's type. Default -1. @return mixed Column results. Defined in <ROOT>/wp-includes/class-wpdb.php:3878
Retrieves the maximum string length allowed in a given column. The length may either be specified as a byte length or a character length. @since 4.2.1 @param string $table Table name. @param string $column Column name. @return array|false|WP_Error { Array of column length information, false if the column has no length (for example, numeric column), WP_Error object if there was an error. @type string $type One of 'byte' or 'char'. @type int $length The column length. } Defined in <ROOT>/wp-includes/class-wpdb.php:3366
Retrieves an entire SQL result set from the database (i.e., many rows). Executes a SQL query and returns the entire SQL result. @since 0.71 @param string $query SQL query. @param string $output Optional. Any of ARRAY_A | ARRAY_N | OBJECT | OBJECT_K constants. With one of the first three, return an array of rows indexed from 0 by SQL result row number. Each row is an associative array (column => value, ...), a numerically indexed array (0 => value, ...), or an object ( ->column = value ), respectively. With OBJECT_K, return an associative array of row objects keyed by the value of each row's first column's value. Duplicate keys are discarded. Default OBJECT. @return array|object|null Database query results. Defined in <ROOT>/wp-includes/class-wpdb.php:3134
Retrieves one row from the database. Executes a SQL query and returns the row from the SQL result. @since 0.71 @param string|null $query SQL query. @param string $output Optional. The required return type. One of OBJECT, ARRAY_A, or ARRAY_N, which correspond to an stdClass object, an associative array, or a numeric array, respectively. Default OBJECT. @param int $y Optional. Row to return. Indexed from 0. Default 0. @return array|object|null|void Database query result in format specified by $output or null on failure. Defined in <ROOT>/wp-includes/class-wpdb.php:3053
Retrieves one value from the database. Executes a SQL query and returns the value from the SQL result. If the SQL result contains more than one column and/or more than one row, the value in the column and row specified is returned. If $query is null, the value in the specified column and row from the previous SQL result is returned. @since 0.71 @param string|null $query Optional. SQL query. Defaults to null, use the result from the previous query. @param int $x Optional. Column of value to return. Indexed from 0. Default 0. @param int $y Optional. Row of value to return. Indexed from 0. Default 0. @return string|null Database query result (as string), or null on failure. Defined in <ROOT>/wp-includes/class-wpdb.php:3019
Determines whether the database or WPDB supports a particular feature. Capability sniffs for the database server and current version of WPDB. Database sniffs are based on the version of MySQL the site is using. WPDB sniffs are added as new features are introduced to allow theme and plugin developers to determine feature support. This is to account for drop-ins which may introduce feature support at a different time to WordPress. @since 2.7.0 @since 4.1.0 Added support for the 'utf8mb4' feature. @since 4.6.0 Added support for the 'utf8mb4_520' feature. @since 6.2.0 Added support for the 'identifier_placeholders' feature. @since 6.6.0 The `utf8mb4` feature now always returns true. @see wpdb::db_version() @param string $db_cap The feature to check for. Accepts 'collation', 'group_concat', 'subqueries', 'set_charset', 'utf8mb4', 'utf8mb4_520', or 'identifier_placeholders'. @return bool True when the database feature is supported, false otherwise. Defined in <ROOT>/wp-includes/class-wpdb.php:4061
Disables showing of database errors. By default database errors are not shown. @since 0.71 @see wpdb::show_errors() @return bool Whether showing of errors was previously active. Defined in <ROOT>/wp-includes/class-wpdb.php:1884
Sets $this->charset and $this->collate. @since 3.1.0 Defined in <ROOT>/wp-includes/class-wpdb.php:835
Inserts a row into the table. Examples: $wpdb->insert( 'table', array( 'column1' => 'foo', 'column2' => 'bar', ) ); $wpdb->insert( 'table', array( 'column1' => 'foo', 'column2' => 1337, ), array( '%s', '%d', ) ); @since 2.5.0 @see wpdb::prepare() @see wpdb::$field_types @see wp_set_wpdb_vars() @param string $table Table name. @param array $data 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. @param string[]|string $format 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 null. @return int|false The number of rows inserted, or false on error. Defined in <ROOT>/wp-includes/class-wpdb.php:2498
Logs query data. @since 5.3.0 @param string $query The query's SQL. @param float $query_time Total time spent on the query, in seconds. @param string $query_callstack Comma-separated list of the calling functions. @param float $query_start Unix timestamp of the time at the start of the query. @param array $query_data Custom query data. Defined in <ROOT>/wp-includes/class-wpdb.php:2372
Parses the DB_HOST setting to interpret it for mysqli_real_connect(). mysqli_real_connect() doesn't support the host param including a port or socket like mysql_connect() does. This duplicates how mysql_connect() detects a port and/or socket file. @since 4.9.0 @param string $host The DB_HOST setting to parse. @return array|false { Array containing the host, the port, the socket and whether it is an IPv6 address, in that order. False if the host couldn't be parsed. @type string $0 Host name. @type string|null $1 Port. @type string|null $2 Socket. @type bool $3 Whether it is an IPv6 address. } Defined in <ROOT>/wp-includes/class-wpdb.php:2065
Generates and returns a placeholder escape string for use in queries returned by ::prepare(). @since 4.8.3 @return string String to escape placeholders. Defined in <ROOT>/wp-includes/class-wpdb.php:2405
Prepares a SQL query for safe execution. Uses `sprintf()`-like syntax. The following placeholders can be used in the query string: - `%d` (integer) - `%f` (float) - `%s` (string) - `%i` (identifier, e.g. table/field names) All placeholders MUST be left unquoted in the query string. A corresponding argument MUST be passed for each placeholder. Note: There is one exception to the above: for compatibility with old behavior, numbered or formatted string placeholders (eg, `%1$s`, `%5s`) will not have quotes added by this function, so should be passed with appropriate quotes around them. Literal percentage signs (`%`) in the query string must be written as `%%`. Percentage wildcards (for example, to use in LIKE syntax) must be passed via a substitution argument containing the complete LIKE string, these cannot be inserted directly in the query string. Also see wpdb::esc_like(). Arguments may be passed as individual arguments to the method, or as a single array containing all arguments. A combination of the two is not supported. Examples: $wpdb->prepare( "SELECT * FROM `table` WHERE `column` = %s AND `field` = %d OR `other_field` LIKE %s", array( 'foo', 1337, '%bar' ) ); $wpdb->prepare( "SELECT DATE_FORMAT(`field`, '%%c') FROM `table` WHERE `column` = %s", 'foo' ); @since 2.3.0 @since 5.3.0 Formalized the existing and already documented `...$args` parameter by updating the function signature. The second parameter was changed from `$args` to `...$args`. @since 6.2.0 Added `%i` for identifiers, e.g. table or field names. Check support via `wpdb::has_cap( 'identifier_placeholders' )`. This preserves compatibility with `sprintf()`, as the C version uses `%d` and `$i` as a signed integer, whereas PHP only supports `%d`. @link https://www.php.net/sprintf Description of syntax. @param string $query Query statement with `sprintf()`-like placeholders. @param array|mixed $args The array of variables to substitute into the query's placeholders if being called with an array of arguments, or the first variable to substitute into the query's placeholders if being called with individual arguments. @param mixed ...$args Further variables to substitute into the query's placeholders if being called with individual arguments. @return string|void Sanitized query string, if there is a query to prepare. Defined in <ROOT>/wp-includes/class-wpdb.php:1452
Prints SQL/DB error. @since 0.71 @global array $EZSQL_ERROR Stores error information of query and error string. @param string $str The error to display. @return void|false Void if the showing of errors is enabled, false if disabled. Defined in <ROOT>/wp-includes/class-wpdb.php:1793
Performs a database query, using current database connection. More information can be found on the documentation page. @since 0.71 @link https://developer.wordpress.org/reference/classes/wpdb/ @param string $query Database query. @return int|bool Boolean true for CREATE, ALTER, TRUNCATE and DROP queries. Number of rows affected/selected for all other queries. Boolean false on error. Defined in <ROOT>/wp-includes/class-wpdb.php:2206
Quotes an identifier for a MySQL database, e.g. table/field names. @since 6.2.0 @param string $identifier Identifier to escape. @return string Escaped identifier. Defined in <ROOT>/wp-includes/class-wpdb.php:1373
Removes the placeholder escape strings from a query. @since 4.8.3 @param string $query The query from which the placeholder will be removed. @return string The query with the placeholder removed. Defined in <ROOT>/wp-includes/class-wpdb.php:2452
Replaces a row in the table or inserts it if it does not exist, based on a PRIMARY KEY or a UNIQUE index. A REPLACE works exactly like an INSERT, except that if an old row in the table has the same value as a new row for a PRIMARY KEY or a UNIQUE index, the old row is deleted before the new row is inserted. Examples: $wpdb->replace( 'table', array( 'ID' => 123, 'column1' => 'foo', 'column2' => 'bar', ) ); $wpdb->replace( 'table', array( 'ID' => 456, 'column1' => 'foo', 'column2' => 1337, ), array( '%d', '%s', '%d', ) ); @since 3.0.0 @see wpdb::prepare() @see wpdb::$field_types @see wp_set_wpdb_vars() @param string $table Table name. @param array $data Data to insert (in column => value pairs). Both `$data` columns and `$data` values should be "raw" (neither should be SQL escaped). A primary key or unique index is required to perform a replace operation. Sending a null value will cause the column to be set to NULL - the corresponding format is ignored in this case. @param string[]|string $format 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 null. @return int|false The number of rows affected, or false on error. Defined in <ROOT>/wp-includes/class-wpdb.php:2551
Selects a database using the current or provided database connection. The database name will be changed based on the current database connection. On failure, the execution will bail and display a DB error. @since 0.71 @param string $db Database name. @param mysqli $dbh Optional. Database connection. Defaults to the current database handle. Defined in <ROOT>/wp-includes/class-wpdb.php:1193
Sets blog ID. @since 3.0.0 @param int $blog_id @param int $network_id Optional. Network ID. Default 0. @return int Previous blog ID. Defined in <ROOT>/wp-includes/class-wpdb.php:1044
Sets the connection's character set. @since 3.1.0 @param mysqli $dbh The connection returned by `mysqli_connect()`. @param string $charset Optional. The character set. Default null. @param string $collate Optional. The collation. Default null. Defined in <ROOT>/wp-includes/class-wpdb.php:911
Sets the table prefix for the WordPress tables. @since 2.5.0 @param string $prefix Alphanumeric name for the new prefix. @param bool $set_table_names Optional. Whether the table names, e.g. wpdb::$posts, should be updated or not. Default true. @return string|WP_Error Old prefix or WP_Error on error. Defined in <ROOT>/wp-includes/class-wpdb.php:999
Changes the current SQL mode, and ensures its WordPress compatibility. If no modes are passed, it will ensure the current MySQL server modes are compatible. @since 3.9.0 @param array $modes Optional. A list of SQL modes to set. Default empty array. Defined in <ROOT>/wp-includes/class-wpdb.php:944
Enables showing of database errors. This function should be used only to enable showing of errors. wpdb::hide_errors() should be used instead for hiding errors. @since 0.71 @see wpdb::hide_errors() @param bool $show Optional. Whether to show errors. Default true. @return bool Whether showing of errors was previously active. Defined in <ROOT>/wp-includes/class-wpdb.php:1867
Strips any invalid characters from the string for a given table and column. @since 4.2.0 @param string $table Table name. @param string $column Column name. @param string $value The text to check. @return string|WP_Error The converted string, or a WP_Error object if the conversion fails. Defined in <ROOT>/wp-includes/class-wpdb.php:3744
Determines whether the database supports collation. Called when WordPress is generating the table scheme. Use `wpdb::has_cap( 'collation' )`. @since 2.5.0 @deprecated 3.5.0 Use wpdb::has_cap() @return bool True if collation is supported, false if not. Defined in <ROOT>/wp-includes/class-wpdb.php:4012
Enables or disables suppressing of database errors. By default database errors are suppressed. @since 2.5.0 @see wpdb::hide_errors() @param bool $suppress Optional. Whether to suppress errors. Default true. @return bool Whether suppressing of errors was previously active. Defined in <ROOT>/wp-includes/class-wpdb.php:1902
Returns an array of WordPress tables. Also allows for the `CUSTOM_USER_TABLE` and `CUSTOM_USER_META_TABLE` to override the WordPress users and usermeta tables that would otherwise be determined by the prefix. The `$scope` argument can take one of the following: - 'all' - returns 'all' and 'global' tables. No old tables are returned. - 'blog' - returns the blog-level tables for the queried blog. - 'global' - returns the global tables for the installation, returning multisite tables only on multisite. - 'ms_global' - returns the multisite global tables, regardless if current installation is multisite. - 'old' - returns tables which are deprecated. @since 3.0.0 @since 6.1.0 `old` now includes deprecated multisite global tables only on multisite. @uses wpdb::$tables @uses wpdb::$old_tables @uses wpdb::$global_tables @uses wpdb::$ms_global_tables @uses wpdb::$old_ms_global_tables @param string $scope Optional. Possible values include 'all', 'global', 'ms_global', 'blog', or 'old' tables. Default 'all'. @param bool $prefix Optional. Whether to include table prefixes. If blog prefix is requested, then the custom users and usermeta tables will be mapped. Default true. @param int $blog_id Optional. The blog_id to prefix. Used only when prefix is requested. Defaults to `wpdb::$blogid`. @return string[] Table names. When a prefix is requested, the key is the unprefixed table name. Defined in <ROOT>/wp-includes/class-wpdb.php:1123
Starts the timer, for debugging purposes. @since 1.5.0 @return true Defined in <ROOT>/wp-includes/class-wpdb.php:3903
Stops the debugging timer. @since 1.5.0 @return float Total time spent on the query, in seconds. Defined in <ROOT>/wp-includes/class-wpdb.php:3915
Updates a row in the table. Examples: $wpdb->update( 'table', array( 'column1' => 'foo', 'column2' => 'bar', ), array( 'ID' => 1, ) ); $wpdb->update( 'table', array( 'column1' => 'foo', 'column2' => 1337, ), array( 'ID' => 1, ), array( '%s', '%d', ), array( '%d', ) ); @since 2.5.0 @see wpdb::prepare() @see wpdb::$field_types @see wp_set_wpdb_vars() @param string $table Table name. @param array $data Data to update (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. @param array $where A named array of WHERE clauses (in column => value pairs). Multiple clauses will be joined with ANDs. Both $where columns and $where values should be "raw". Sending a null value will create an IS NULL comparison - the corresponding format will be ignored in this case. @param string[]|string $format Optional. An array of formats to be mapped to each of the values 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. @param string[]|string $where_format Optional. An array of formats to be mapped to each of the values in $where. If string, that format will be used for all of the items in $where. A format is one of '%d', '%f', '%s' (integer, float, string). If omitted, all values in $where will be treated as strings unless otherwise specified in wpdb::$field_types. Default null. @return int|false The number of rows updated, or false on error. Defined in <ROOT>/wp-includes/class-wpdb.php:2674
Checks if a string is ASCII. The negative regex is faster for non-ASCII strings, as it allows the search to finish as soon as it encounters a non-ASCII character. @since 4.2.0 @param string $input_string String to check. @return bool True if ASCII, false if not. Defined in <ROOT>/wp-includes/class-wpdb.php:3455
Checks if the query is accessing a collation considered safe on the current version of MySQL. @since 4.2.0 @param string $query The query to check. @return bool True if the collation is safe, false if it isn't. Defined in <ROOT>/wp-includes/class-wpdb.php:3475
Retrieves the character set for the given table. @since 4.2.0 @param string $table Table name. @return string|WP_Error Table character set, WP_Error object if it couldn't be found. Defined in <ROOT>/wp-includes/class-wpdb.php:3197
Finds the first table name referenced in a query. @since 4.2.0 @param string $query The query to search. @return string|false The table name found, or false if a table couldn't be found. Defined in <ROOT>/wp-includes/class-wpdb.php:3782
Loads the column metadata from the last query. @since 3.5.0 Defined in <ROOT>/wp-includes/class-wpdb.php:3854
Adds field charsets to field/value/format arrays generated by wpdb::process_field_formats(). @since 4.2.0 @param array $data { Array of values and formats keyed by their field names, as it comes from the wpdb::process_field_formats() method. @type array ...$0 { Value and format for this field. @type mixed $value The value to be formatted. @type string $format The format to be mapped to the value. } } @param string $table Table name. @return array|false { The same array of data with additional 'charset' keys, or false if the charset for the table cannot be found. @type array ...$0 { Value, format, and charset for this field. @type mixed $value The value to be formatted. @type string $format The format to be mapped to the value. @type string|false $charset The charset to be used for the value. } } Defined in <ROOT>/wp-includes/class-wpdb.php:2924
Prepares arrays of value/format pairs as passed to wpdb CRUD methods. @since 4.2.0 @param array $data Array of values keyed by their field names. @param string[]|string $format Formats or format to be mapped to the values in the data. @return array { Array of values and formats keyed by their field names. @type mixed $value The value to be formatted. @type string $format The format to be mapped to the value. } Defined in <ROOT>/wp-includes/class-wpdb.php:2869
For string fields, records the maximum string length that field can safely save. @since 4.2.1 @param array $data { Array of values, formats, and charsets keyed by their field names, as it comes from the wpdb::process_field_charsets() method. @type array ...$0 { Value, format, and charset for this field. @type mixed $value The value to be formatted. @type string $format The format to be mapped to the value. @type string|false $charset The charset to be used for the value. } } @param string $table Table name. @return array|false { The same array of data with additional 'length' keys, or false if information for the table cannot be found. @type array ...$0 { Value, format, charset, and length for this field. @type mixed $value The value to be formatted. @type string $format The format to be mapped to the value. @type string|false $charset The charset to be used for the value. @type array|false $length { Information about the maximum length of the value. False if the column has no length. @type string $type One of 'byte' or 'char'. @type int $length The column length. } } } Defined in <ROOT>/wp-includes/class-wpdb.php:2983
Processes arrays of field/value pairs and field formats. This is a helper method for wpdb's CRUD methods, which take field/value pairs for inserts, updates, and where clauses. This method first pairs each value with a format. Then it determines the charset of that field, using that to determine if any invalid text would be stripped. If text is stripped, then field processing is rejected and the query fails. @since 4.2.0 @param string $table Table name. @param array $data Array of values keyed by their field names. @param string[]|string $format Formats or format to be mapped to the values in the data. @return array|false An array of fields that contain paired value and formats. False for invalid values. Defined in <ROOT>/wp-includes/class-wpdb.php:2806
Strips any invalid characters based on value/charset pairs. @since 4.2.0 @param array $data Array of value arrays. Each value array has the keys 'value', 'charset', and 'length'. An optional 'ascii' key can be set to false to avoid redundant ASCII checks. @return array|WP_Error The $data parameter, with invalid characters removed from each value. This works as a passthrough: any additional keys such as 'field' are retained in each value array. If we cannot remove invalid characters, a WP_Error object is returned. Defined in <ROOT>/wp-includes/class-wpdb.php:3545
Strips any invalid characters from the query. @since 4.2.0 @param string $query Query to convert. @return string|WP_Error The converted query, or a WP_Error object if the conversion fails. Defined in <ROOT>/wp-includes/class-wpdb.php:3697
Internal function to perform the mysqli_query() call. @since 3.9.0 @see wpdb::query() @param string $query The query to run. Defined in <ROOT>/wp-includes/class-wpdb.php:2339
Escapes an identifier value without adding the surrounding quotes. - Permitted characters in quoted identifiers include the full Unicode Basic Multilingual Plane (BMP), except U+0000. - To quote the identifier itself, you need to double the character, e.g. `a``b`. @since 6.2.0 @link https://dev.mysql.com/doc/refman/8.0/en/identifiers.html @param string $identifier Identifier to escape. @return string Escaped identifier. Defined in <ROOT>/wp-includes/class-wpdb.php:1391