Database - Read For Learn

how to access 2nd Mysqli Database from different server for wordpress

You can create a new instance of the wpdb object. It is explained in many posts like this one: Using wpdb to connect to a separate database

How to search usermeta table

This works: $WhoIsUser = get_users( array( ‘meta_key’ => ‘deviceid’, ‘meta_value’ => ‘45545’ ) ); This returns the whole row for that user from the users table. If you print_r it out like so: echo ‘<pre>’ echo print_r($WhoIsUser, TRUE); echo ‘</pre>’ you get: Array ( [0] => WP_User Object ( [data] => stdClass Object ( [ID] … Read more

What structure and database storage method should I use for temporary storage that may be written concurrently?

I ran a JMeter load test with one hundred simultaneous visitors to see if it is practical to write an array to the wp_options table via the Options API, knowing the array needs to be updated for every visit. This test confirmed that only a portion of the database updates happened in the way they … Read more

how add more field to wp user and save it to database

You want to use the WordPress function; add_user_meta add_user_meta( $user_id, ‘_level_of_awesomeness’, $awesome_level); https://developer.wordpress.org/reference/functions/add_user_meta/

“BS_” rows in postmeta table

They’re from wordpress.org/plugins/guest-author. The keys suggested they were from a guest author plugin, so I searched Google for guest author plugins, opened the first result, browsed the code, and found that it uses those keys.

I need to find posts that contain YouTube links without http:// or https:// prefix and add http:// to all of them

I think you’ll have to do a little PHP work and SQL-ing. As you might know, WordPress stores data in a database—and that database has multiple tables, each of which has several fields. You first have to know in what specific field(s) in which specific table(s) that youtube content resides. When you know where it … Read more

local wordpress broke after changing URL

User input to database

edit_user_created_user hook – using to update Groups

The GravityForms folks chimed in. To clarify, I wanted to add a row to a database table on user activation (not on form submit), and I had not found that hook. Here is the completed code… add_action( ‘gform_user_registered’, ‘hl_add_group’, 10, 4 ); function hl_add_group($user_id, $feed, $entry) { $group = $entry[8]; global $wpdb; // add form … Read more

+ More