wpdb - Read For Learn

Formatting a date/time returned from a custom $wpdb query

A much simpler method to bypass these issues is using WP_Query: $popularQuery = array(‘orderby’ => ‘comment_count’, ‘posts_per_page’ => ‘-1’, ‘author’ => 1); $popularPosts = new WP_Query($popularQuery); while($popularPosts->have_posts()) : $popularPosts->the_post(); ?> <tr> <td><a href=”https://wordpress.stackexchange.com/questions/23820/<?php the_permalink(); ?>”><?php the_title(); ?></a></td> <td><?php the_author(); ?></td> <td><?php the_time(‘j M Y h:i A’) ?></td> <td><?php comments_number(); ?></td> </tr> <?php endwhile; Also note … Read more

How to query and update one colum in postmeta table?

You probably would have to use a script which would have to be referenced in your crontab. The problem is to calculate the final value of the popularity for each post, but if you apply the funcion the right way in the PHP script, the UPDATE operation on your MySQL database should work nicely. Here … Read more

query for filtering published posts?

You can add this to the WHERE clause, just after your filter by post_date: AND post_status = “publish”

How do I modify this wpdb query to include posts that have a post_status of publish and draft?

You can use AND and OR statements in MySQL. Try this: $count = $wpdb->get_var( “SELECT COUNT(*) FROM $wpdb->posts $where AND (post_status=”publish” OR post_status=”draft”)” );

Why doesn’t my Table get created?

I figured it out – I did not have the data type declaration for user_id so it never created the table. I changed it and it worked 🙂

WordPress database error: [Query was empty] – using $wpdb->prepare()

You are aware that $wpdb->insert does exactly this? $wpdb->insert( ‘table’, // Table name array( ‘column’ => ‘foo’, ‘field’ => 1337, ), // Columns array( ‘%s’, ‘%d’, ) // Explicit formatting ); Right?

wpdb function insert doesn’t work

Consider trying with $wpdb->insert() method instead of raw query. Using of functions/methods is recommended for interacting with database over raw requests, unless absolutely impossible.

How can I change my meta_query to SQL wpdb query?

Several things, Firstly you can add the following for pagination: ‘paged’ => ( get_query_var(‘paged’) ? get_query_var(‘paged’) : 1 ) This removes the need for the array_merge. Otherwise your existing code is fine except for some indentation. I would add the rest of the query though, e.g. defining the post type, the posts per page, etc

$wpdb->get_var next var?

Instead of querying the database directly you could use the following code instead. printf( ‘<p>Total views : %s</p>’, get_post_meta( get_the_ID(), ‘views’, true ) );

wpdb->get_var – count author posts, meta value

This wouldn’t be possible unless you keep a log of users that have voted the Idea. You will have to create another hidden post_meta array which will store a list of all the users who have voted the Idea. In that way you could count the number of votes an author has given. Or better … Read more

+ More