My assumptions and assessment of the behaviour appear to be correct. By using a transition hook drat_to_publish or pending_to_publish for example, you’re actually pausing the publish process. Any changes you make to the post are irrelevant, regardless of the method used to update the post, because once the code returns from your custom function, the … Read more
I finally found a solution. I had to extend the wpdb class inside wp-contents/db.php. It looks like this: <?php /** * WordPress Database Access Abstraction Object * Custom DB Connection class to provide ssl connection to the database */ class ssldb extends wpdb { /** * Connects to the database server and selects a database. … Read more
wpdb‘s get_results method takes an optional second argument that lets you specify how the data is returned. The default return is an object. But you can also set it to… OBJECT – result will be output as a numerically indexed array of row objects. OBJECT_K – result will be output as an associative array of … Read more
It doesn’t. WordPress doesn’t use foreign keys to link tables together that way. There are also lots and lots of other reasons to declare keys and primary keys in a table that have nothing to do with this type of linkage/referencing. For example telling MySQL/MariaDB the ID column is a primary key give critical clues … Read more
get_var not returning a value when the field contains an apostrophe
There are 2 places that could have issues: Your first wpdb::prepare() here: // Prepare and execute the count query $count_query = $wpdb->prepare( $count_sql, …$query_params ); The initial value you set for $count_sql is “SELECT COUNT(*) FROM $table_name WHERE 1=1”, and if $filters doesn’t have any key matching your switch, the value of $count_sql will remain … Read more
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
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
$wpdb->get_results() query empty, but same query in phpmyadmin has results