It seems that you in your INNER JOIN, you are joining on wp_term_relationships.object_id == wp_posts.post_title which is erroneous, since object_id is the post-id in this case-scenario. I want all IDs (post-ids) SELECT ID FROM $wpdb->posts Who have a record in the wp_term_relationships table // Now we are comparing the correct columns INNER JOIN $wpdb->term_relationships ON … Read more
wp_insert_post runs whenever a post is updated, not just when it’s first saved. So your payment_meta() function is running every time a post is saved, and since you’re using add_post_meta() in that function, a new meta entry is created every time the post is saved. Instead of using add_post_meta() stick to just using update_post_meta() if … Read more
The $wpdb object is part of WordPress, so wouldn’t be loaded into a standalone PHP page as it is into a WordPress template. You might want to look into creating your own page templates, then you could run your database query as part of that page template. As a side note: You are currently trusting … Read more
You’ll want to include the wp-load.php, not the wp-config.php. Depending on how you’re doing it, you may also have to set $_SERVER variables if they aren’t already set to prevent WordPress from trying to redirect you. For example: $_SERVER = array( “HTTP_HOST” => “http://example.com”, “SERVER_NAME” => “http://example.com”, “REQUEST_URI” => “https://wordpress.stackexchange.com/”, “REQUEST_METHOD” => “GET” );
Prepare your Queries! global $wpdb; $wpdb->get_results( $wpdb->prepare( “SELECT %s blog_id, last_updated FROM %s WHERE public=”1″ AND archived = ‘0’ AND mature=”0” AND spam = ‘0’ AND deleted =’0′ AND UPPER(blog_name) LIKE ‘%s’ %s %s “, ARRAY_A ), $extra, $wpdb->blogs, $wpdb->esc_like( ‘A%’ ), $order, $limit ); Never ever send data without prepare! Also: There’re some functions … Read more
I saw on here one other guy was having problems with $wpdb->prepare. Am I using it incorrectly? As you can read in the Codex, it’s a simple No. You have to use it like sprintf/printf(). The only allowed inputs are string: %s digit: %d Example $sql = $wpdb->prepare( ” INSERT INTO %s (`post_content`, `imported`) VALUES … Read more
Unless you want to retrieve custom data from the database, you will hardly ever need to make use of the WPDB class (or its global object, respectively). Though it is obviously possible to do things that way as well. Just for the sake of completeness, if you had a reason to not use a more … Read more
You can filter query. See wpdb::query() in wp-includes/wp-db.php. You get the complete SQL string as parameter. Then look for queries to the comments table: add_filter( ‘query’, function( $query ) { global $wpdb; if ( FALSE === stripos( $query, “FROM $wpdb->comments” ) return $query; // Now change the SQL }); But you have to catch all … Read more
Use the IN operator for arrays. When using $wpdb->prepare() you don’t have to use quotes around the string placeholder %s. The string placeholder will be quoted automatically. That’s also the reason why you have to take precautions when using $wpdb->prepare() with the IN operator if the array values are strings. This first example doesn’t use … Read more
BOOL or BOOLEAN are as far as MYSQL is concerned just replacements/synonyms for TINYINT(1), tiny integer, so using %d for integers is the correct way to do it. Some additional information: Codex: Class Reference – wpdb – Placeholders MySQL: Numeric Type Overview MySQL: Boolean Literals MySQL: Integer Types