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
Illegal mix of collations using a function [closed]
$wpdb->prepare UPDATE process not work in functions.php
Yes, they’re normal. They were added in 4.8.3 to fix an SQL injection vulnerability. You can read an article describing the technical reasons for this happening here and the ticket for the change here. The placeholder characters are replaced by the random characters on the last line of $wpdb->prepare() with the $wpdb->add_placeholder_escape() function, which calls … Read more
I think you’re assuming this is intentional, it’s probably just a bug in the theme, what it’s stating is the 5th parameter is a string, but there is no 5th parameter so it’s ignored. The most likely reason is that during development a 5th entry was removed and the author forgot to update the second … Read more
Table wont load into WPDB
I think the issue may be that you think query_vars can pick up the query string arguments from a URL, but you don’t need to do it that way. That’s primarily used if you’re needing to get this into the WP Query (which isn’t what you’re doing here). It’s much easier to simply check for … Read more
You need to use a join in your mysql query. Something like this might get you closer… global $wpdb; $rsvp_table = $wpdb->prefix . ‘rsvp’; $invites_table = $wpdb->prefix . ‘invites’; $sql=”SELECT COUNT(*) as count FROM $invites_table i1 JOIN $rsvp_table r1 ON (r1.reference = i1.reference)”; $yet_to_respond = $wpdb->get_results( $sql ); echo $yet_to_respond->count;
WP Recommended Table Exclusions?