Using the wpdb::prepare() method is recommended for creating queries properly and avoiding SQL injection. For a basic solution, use the addslashes() function, but this is not sufficient for preventing SQL injection. See Mysql + php with special characters like ‘(Apostrophe) and ” (Quotation mark).
Without really knowing everything about how you’ve set up your site, I can only offer a generic answer to your questions. If you have set up a way to save information to the database about who played which game and when, then you should be able to query those information. You can save data to … Read more
How to properly prepare a column name if passed to a stored procedure?
Illegal mix of collations using a function [closed]
Changing the DB connection used by a WPDB object that already exists or passing it a mysqli instance is not possible. And if it was, it still wouldn’t work for other reasons. if you want to access a new database connection you need to create a new WPDB instance: $second_db = new WPDB( ‘dbuser’, ‘dbpassword’, … Read more
Wp forms wpforms()->entry->update not working on page refresh
Skipping all WP functions for a cached version
$wpdb->insert writes a record twice for some reason, when my custom developed plugin calls my class function once
$wpdb->get_results() query empty, but same query in phpmyadmin has results
Instead of querying the database directly, you could use WP_User_Query, but you’ll get the best results by querying the REST API endpoint with a GET request at /wp-json/wp/v2/users which already lists out the users in a WordPress install. Just remember to account for pagination.