From MySQL reference: Permitted characters in unquoted identifiers: ASCII: [0-9,a-z,A-Z$_] (basic Latin letters, digits 0-9, dollar, underscore) Extended: U+0080 .. U+FFFF Permitted characters in quoted identifiers include the full Unicode Basic Multilingual Plane (BMP), except U+0000: ASCII: U+0001 .. U+007F Extended: U+0080 .. U+FFFF ASCII NUL (U+0000) and supplementary characters (U+10000 and higher) are not … Read more
But I would like to use my secondary database connection like a standard WordPress query, so that all of the query builder functions are available. Unless the other database is a WordPress database, with the exact same table structure, you can’t. The query builder functions in WordPress are designed and built only to work with … Read more
There is no programmatic way to get a list of default tables. WordPress does not store a list of them anywhere. The closest thing there is is wp_get_db_schema(). This function returns the raw SQL used to create the default tables, but as you can see from the source, it doesn’t derive it from another source, … Read more
To insert data you should use query() (documentation), get_var() method is for selecting data. If error is encountered, query() returns FALSE. query() This function returns an integer value indicating the number of rows affected/selected for SELECT, INSERT, DELETE, UPDATE, etc. For CREATE, ALTER, TRUNCATE and DROP SQL statements, (which affect whole tables instead of specific … Read more
You can get the last inserted ID from $wpdb with the insert_id property: $wpdb->insert( … ); $couponId = $wpdb->insert_id
You’re missing your where statement. You need to tell wpdb which row it should be updating, otherwise you’re looking to insert rather than update. From the $wpdb::update Codex: wpdb->update( string $table, array $data, array $where, array|string $format = null, array|string $where_format = null );
Not quite there. In your first example you have sku LIKE %s and in your example you have product_sku LIKE ‘%{$matchedProduct->sku}%’. That’s not the same. $wpdb->prepare() uses sprintf replacements. That’s where you get the %s in your first query. If you look at the sprintf documentation under specifiers, you’ll find a list of replacement patterns. … Read more
Short answer: it’s not possible. Long answer: you should try $wpdb->query instead and write a regular SQL query, something like this: UPDATE table_name SET notes = CONCAT(notes, ‘text to append’) WHERE note_id = ‘313’ Please note it’s only an example and you should use $wpdb->prepare to also sanitize variables properly.
Welcome! WordPress already have a table for users. Also, there is another table named usermeta that will allow you to save extra information for users. There are some functions that allow developers to get information from user and usermeta tables without using custom database queries. add_user_meta update_user_meta delete_user_meta get_user_meta Solution: As mentioned in the question, … Read more
I can’t comment due to low reputation so sorry for posting this as an answer, but you are missing $ (dollar sign) near groupcat[0]