The prepare() method escapes %s. The second piece of code you listed breaks because quotation marks are added to the table name, hence it doesn’t match what’s in the DB. The first piece of code works because it’s a straight string replacement hence matching the name of the table in the database. What is the … Read more
Here is a quick solution to get the post count any kind of filtering you want function custom_get_user_posts_count($user_id,$args ); $args[‘author’] = $user; $args[‘fields’] = ‘ids’; $ps = get_posts($args); return count($ps); } Since this function uses get_posts you can filter and use anything that you can with WP_Query So in your case you can use it … Read more
If your things are laid properly, this code will output 10 posts from film CPT, where taxonomy is category-film and it will occur each of the term of that particular taxonomy. I’m not aware about your templating, so lay your layout accordingly. <?php $_terms = get_terms( array(‘category-film’) ); foreach ($_terms as $term) : $term_slug = … Read more
Probably just add a counter, show ad on multiples of 6. Something like $count = 0; $adEvery = 6; if (have_posts()) : while (have_posts()) : the_post(); // Individual Post $count++; if ($count%$adEvery == 0) { // your ad } endwhile; else : // No Posts Found endif;
Unless I’m missing something that is staring me in the face, you aren’t using add_query_arg() or remove_query_arg(); since those are the only functions affected by this particular exploit you should be safe. Your code does use the query_vars filter and get_query_var() but neither of those are effected by the exploit you’ve referenced. Otherwise your code … Read more
Yes, of course it starts again at 1. You’ve initialized the counter to 1 on each page load. If you were writing a custom loop you’d do this: $paged = (get_query_var(‘paged’)) ? get_query_var(‘paged’) : 1; If normal WordPress pagination mechanisms are working on your page that should work for you too. That will number your … Read more
You should query all accomodation posts in this country, and then sort them by accomodation-type and region. Then you loop through the posts, and compare the accomodation type and the region of each post with those of the previous post. If they are different you print the new accomodation type or region and then print … Read more
$items = get_posts( array( ‘post_type’ => ‘inventory’, ‘numberposts’ => -1, ‘taxonomy’ => ‘status’, ‘term’ => ‘in-stock’ ) ); $count = count( $items ); echo $count;
== Short answer == If you use the found $1 you should use LIKE and not = as you match against the title’s LIKE. So replace ((abc18meta.meta_key = ‘plz’) AND (abc18meta.meta_value = $1)) into ((abc18meta.meta_key = ‘plz’) AND (abc18meta.meta_value LIKE $1)) You could change your preg_replace search by ignore the wrapping (see below) of **ABC* … Read more
Alright, I’ve solved the problem. Turns out that you should never use action=”” for searchform.php. It will work perfectly fine in terms of search results, but it will break the pagination, when using 3.1. Instead, you should use for the form action.