query Archives - Page 10 of 28

Get posts by category with pure SQL query

I have a meeting post type, whose titles automatically get set to a date of the form m/d/Y. I have the below query which gets all unique years from...

May 23, 2022
0 Comments

WP database error for comments_popup_link()

I’m using the comments_popup_link() function to show the number of comments for each post in a loop. <?php if (have_posts()) : while (have_posts()) : the_post(); ?> <?php if (...

May 23, 2022
0 Comments

Custom search page and search by title, content and tag

Can someone review my code , I need to know better solutions or any bug. Okey ! , I made a PHP file to get search results by parameters...

May 22, 2022
0 Comments

WordPress custom archive page

I am trying to build up a custom archive page. However, I would like this archive page to skip the first 5 posts. I’ve been able to accomplish this...

May 22, 2022
0 Comments

How can I display a specific user’s first published post?

I’m looking for a way to display a user’s first published post using their unique ID. I have a function that calls a list of specific users using their...

May 22, 2022
0 Comments

Get IDs of posts currently visible on archive

This probably is a easy one for many. And also probably is already answered here, but I don’t know how to search for it – so sorry I did...

May 22, 2022
0 Comments

Are database queries created using WordPress filters protected from SQL injection?

I’m using the WordPress ‘posts_where’ filter (https://codex.wordpress.org/Plugin_API/Filter_Reference/posts_where) to alter my queries as below: function filter_my_search($where=""){ global $wpdb; if(isset($_GET['q'])) { $where .= 'AND (((' . $wpdb->posts . '.post_title LIKE "%'.$_GET["q"].'%")...

May 22, 2022
0 Comments

Possible to get posts from multiple meta keys/values in a single query?

Say I have a bunch of posts, some of them have a meta key called “key1” and some of them have a meta key called “key2”. But the posts...

May 22, 2022
0 Comments

cron job to auto delete posts of a specific post type older than x days

I want to delete all posts of a specific post type (in this case “vfb_entry”) that are older than 60 days. The cron job should run once a day....

May 22, 2022
0 Comments

Custom Select Query with Custom Post Types

Have been trying to figure out the issue with this for the past hour, but hitting a wall. Basically I’m just trying to query my custom post type based...

May 21, 2022
0 Comments