A generic term referring to the process of retrieving information from a database.

learn more… | top users | synonyms

0
votes
1answer
30 views

Counter is skipping post when I still want it visible [closed]

I am showing the 5 latest posts on my homepage. I am using a count so that on the 3rd post it shows a div which will be completely seperate to the blog posts. However rather than the 3rd post ...
-1
votes
1answer
48 views

Showing specific post in order of array wp_query

I have displayed some specific post ID's in a custom template with wp_query. I am struggling to figure out how to make these in order. I want to show 1682 first and 1540 last. They do not show this ...
3
votes
1answer
76 views

Slow wp_enqueue_media()

I have developed a WordPress plugin for my site that utilises the WP Media uploader to store files... To do this my plugin contains the following code: function enqueue_scripts() { ...
0
votes
0answers
21 views

Search with array in Meta query

I have a meta key "group_roomtype" with value a:2:{i:0;a:2:{s:16:"roomtype";s:3:"265";s:11:"qty";s:3:"100";}i:1;a:2:{s:16:"roomtype";s:3:"266";s:11:"qty";s:3:"200";}} I want filter by qty, please ...
0
votes
1answer
19 views

Why the pre_get_posts hook can cause apache stopped working?

I'm having all my posts with a Custom Field named 'validity' where I'm assigning dates until the post is valid. My taxonomy archives are showing all the posts. Now I want to filter there, and exclude ...
0
votes
1answer
41 views

Is it possible to add query parameters on the archive page?

I have a custom post type (works), and an archive page (archive-works.php). I would like to hide the non-public posts from the archive page, so I added a custom meta box. I also modified the query to ...
0
votes
2answers
108 views

Custom search SQL Query to add custom field in result

I have to write my own MySQL query since I haven't found a good way to do it within wordpress functionality. I want the search query to search trough post_title / post_content & meta_key ...
0
votes
0answers
31 views

Category list with subcategories and terms

I have a problem that I cant figure out myself. Maybe I'm going in a wrong way and thats's why it won't work. So I need a list of categories (custom post type "products"). I have some subcategories ...
0
votes
1answer
52 views

Modifying date filter on admin page for custom post type to link to custom field

Apologies if a similar question has already been asked, but I can't seem to find the exact functionality I am looking for. Basically I have a custom post type (sermons) which has 'recorded_date' as ...
1
vote
1answer
33 views

Temporarily storing main search result

I have several different post types and when someone searches, it lumps all the post types together and then I have a drop down select for the user to refine their search by the different post types ...
0
votes
0answers
20 views

Search returning everything

<div class="page-head"> <h2 class="page-title"> <?php if ( have_posts() ) : ?> <?php printf( __( 'Search Results for: %s', ...
0
votes
0answers
43 views

Reorder results of select query by distance

What I'm trying to achieve is a store directory listing nearby stores, ordered by distance. I've managed to grab all the stores within the specified radius and display them, and also calculated the ...
0
votes
1answer
22 views

Filter query posts by the count of metas for a meta key

I know it is possible to filter queries to order posts by the numeric value of a meta. For example, I store the number of total likes for a post in a single meta key : ...
0
votes
0answers
34 views

Query post by category using only one custom page template

Is it possible to query a post by category using only one custom page template? Basically I created a custom post called "Vehicle" and each post are assigned to a different a category. Instead of ...
0
votes
0answers
27 views

wpdb giving different results then query in SQL Editor

I'm trying to read candidates and the relation with expertises from 2 custom tables in my WP Database. This is my WPDB query : $candidates = $wpdb->get_results(" SELECT * FROM ...
1
vote
1answer
37 views

Include posts from feature category in pre_get_posts

I have two custom taxonomy 'cities-taxonomy' and 'userfeed-taxonomy' and I am excluding all the post which has these taxonomies assigned in my blog page using pre_get_post(); Here is my query ...
0
votes
1answer
51 views

pre_get_posts with get_posts

So in the template I've multiple featured posts and sliders and 2 default loops. I use get_posts for everything except default loops (obviously). Now the issue I'm having is excluding get_posts ...
0
votes
0answers
70 views

MySql query to retrieve post_title, post_content and feature image link BASED ON A CATEGORY

I have been trying for quite a long time to retrieve post_title, post_content and feature image link for all posts BASED ON A particular CATEGORY, from a wordpress database. I have got a query: ...
0
votes
1answer
93 views

How to reset usual $query on search page to push custom $wpdb query there?

I, recently posted 2 questions (First, Second) with no answer. I found my solution for both of them. But now it's time to fine-tune things. If I can fine-tune here, I could answer both the questions. ...
0
votes
1answer
29 views

Why my query does not run with prepare

Hi Below is my query and it works with prepare keyword on the localhost but whenever I use prepare keyword with my queries on live server the data does not show up and as soon I remove prepare from ...
0
votes
1answer
39 views

How to pass menu slug as a variable to wp_nav_menu?

I need to show a menu depending on what user selects on Page Options. I take menu name from a user to a variable and now i need it to parse through wp_nav_menu. Im trying it like this but it doesn`t ...
0
votes
1answer
21 views

How to enqueue assets only on queried pages, excluding the page being queried?

How can I enqueue scripts and styles ONLY on admin pages that have a query attached to them? I have the code below which works, but it also enqueues on the native page of the query. I want to ...
0
votes
1answer
40 views

Multiple terms not working on taxonomy

I need multiple terms support my WordPress theme - $boards = get_user_meta($user_ID, '_Following Board ID'); $pboards = get_user_meta($user_ID, '_Board Parent ID'); $paged = (get_query_var('paged')) ...
2
votes
0answers
67 views

Custom WP_Query order by post_meta and (author) user_meta

I am having an issue that i couldn't find on google and elsewhere. To put problem in the context. I am making a wordpress site where user can put their tutor listing for giving a tutorials, and i am ...
1
vote
1answer
61 views

How to show only posts with images?

I want to hide posts without images on the front page, so I need get an array of ids of those posts. I know how hide posts on the home page by id, but I need to show only posts with images. This is ...
0
votes
1answer
19 views

query_posts that have custom taxonomy and limiting what shows based on the taxonomy

I have a custom post type, technologies, that has a custom taxonomy defined for it, importance. The idea is that a technology that has any significance will get importance tagged on it (featured is ...
0
votes
2answers
184 views

How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?

I have a custom post type named store and I have a custom taxonomy city, I also have a meta box with a field that is stored with update_post_meta( $post_id, 'store_postal_code', $postal_code ); it ...
0
votes
0answers
25 views

Can I merge WP_Query and WP_Comment_Query together?

I have read about merging two WP_Query results. But I need to merge a WP_Query with a WP_Comment_Query and order the result by date. Is this possible? If so, how can I approach this? How would I ...
0
votes
0answers
23 views

Change the number of attachments loaded into the Media Popup window

I wish to ask if is there a way to change the numbers of thumbnails loaded in the media popup when it first opens. The Media Popup loads thumbnails through ajax (query-attachments), executing up to ...
0
votes
2answers
29 views

Media Query - Display Upload Author & Get Uploaded Yo Post ID

Working on a project with a lot of galleries & "attachment" post type queries. It's all working great except I noticed in the Attachment Details box in the admin dashboard that Wordpress stores ...
0
votes
2answers
128 views

Ignore sticky posts if post is not in meta query

I have such a wp query args: $args = array( 'post_type'=> 'myposttype', 'posts_per_page' => 10, 'meta_query' => array( 'relation' => 'AND', array('key' => ...
0
votes
2answers
146 views

Create a post builder skin in a plugin

Currently I'm working on a plugin that will display a grid based on post type with many settings to customize it. One of the settings will be to choose between different skins available to display ...
0
votes
1answer
122 views

Filtering custom posts by custom fields (ACF) [closed]

I'm working on a site with photo contests. Each contest has a lot of additional info, which I store in custom fields (thanks to Advanced Custom Fields). Now I want to search through contests filtering ...
0
votes
1answer
59 views

Search Functionality broken by the wp 4.2 update

I run a blog site with posts by authors, and I implemented a search that would return results if the search was like an author's name or the search term was contained in a story. I was functioning and ...
0
votes
0answers
24 views

How to move posts in featured category on top and keep pagination

I want to move every post from category_id = 11 and 10 on top of the list and then query every other post which is only in 10th. I thought that making two loops will do the trick but there is a ...
0
votes
0answers
89 views

Command to make Woocommerce product variation price the same as its parent product price

The variations are stored in the wp_posts table like the products, but they are related to the parent product itself somehow. I just wanted a command to make all products variations prices same as ...
0
votes
1answer
47 views

When add_query_arg() is necessary?

considering this code, both solutions seems to work fine. What I don't get is, is there any difference between the two solutions? general_plugin.php function add_custom_query_var( $vars ){ $vars[] ...
1
vote
1answer
169 views

add_query_arg() XSS Vulnerability

I've created a personal plugin and now I'm worried about this vulnerability: https://blog.sucuri.net/2015/04/security-advisory-xss-vulnerability-affecting-multiple-wordpress-plugins.html This is how ...
0
votes
0answers
30 views

Wordpress URL strings for filtering posts by category

I'm working on quite a large blog based site specifically on creating a category navigation system designed to display posts based on multiple category queries. I'm doing this using URLs such as ...
0
votes
0answers
94 views

Override default posts per page in taxonomy template

I am using the following code to show ordered list of posts in taxonomy page: <?php $mypage = (get_query_var('paged')) ? get_query_var('paged') : 1; $ppp = get_query_var('posts_per_page'); ...
1
vote
2answers
94 views

Looping through posts per category gives same posts for each category

For a specific section on my website I loop through some categories and get the three latest posts in that categorie and list them. Like so: <?php $categories = get_categories(array('exclude' ...
1
vote
1answer
29 views

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=''){ ...
0
votes
1answer
29 views

Display list of most recent grandchild (third tier) pages

I currently have a piece of code I'm using to display a list of the three most recent 'special' custom post type posts which will display an image, title and content of these posts. I'm trying to ...
0
votes
0answers
21 views

Query for distance OR taxonomy term

I'm using a custom query to retrieve posts with geo-coordinates within 10 miles of user coordinates and order them by distance. The query works as intended without issue. However, my client now ...
4
votes
1answer
85 views

WP_Comment_Query pagination, delving into the unknown

I am aiming to pagination WP_Comment_Query(). It appears this is either taboo or there is no viable information about it online, not anything. Why? Is it possible? If so, how?
0
votes
0answers
23 views

how to get Tag in menu populated with recent posts submenus

I would like to know if it would be possible to implement an option to "populate" each tag menu items of my WordPress site automatically with links to recent post as submenus. In other words, when ...
0
votes
2answers
46 views

Different values for get_author_posts_url and get_the_author (posts 2 posts)

Caveat- I'm not a programmer, I'm a designer that has taught myself basic php/wordpress theming. This is a very specific question, I realize, but I'm hoping the experts can help me find some ...
0
votes
1answer
43 views

How to convert query sql to shortcode in wordpress?

I want to make a shortcode like this [myshorcode:2:drinks], and query-wrangler I have managed to get the following query that shows me 2 products of a certain taxonomy PHP WP_Query: $query = array ( ...
0
votes
0answers
44 views

How can I show latest posts from certain tags menu items as submenu?

I have the following order of menu in the menu dashboard: Category1 ->tags(related to category1) category2 ->tags(related to category2) etc.. when you hover a tag menu item I want to get the list of ...
0
votes
1answer
10 views

Issue attempting a wp_query_posts with tags

Having an issue trying to query the most recent posts using the tag, in this case, trending. I used the following code but I get no results. If I switch out 'tag' to 'post_type' it will work: ...