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

learn more… | top users | synonyms

0
votes
2answers
19 views

Show featured image as background image from postQuery

The code below gets the image but I want it to be a background image. I believe I need to save the image as a variable first and then echo it out somehow. My PHP is not great so please give an example ...
0
votes
0answers
16 views

Custom database query with accents returning no results

I have an issue where using accents in my custom database query (wpdb) returns no results. $wpdb->get_results( "SELECT * FROM table WHERE city = 'Montréal'" ); Returns nothing, while ...
0
votes
0answers
21 views

Limiting a filtered query

I'm struggling with this query. I have a page where I will show products launched from last month and this current month. (http://the.nett.mx/innvictus/wp/) Everything works great, but when I apply ...
0
votes
0answers
9 views

Filter User Query via URL Like Posts

I have two taxonomies assigned to users and I use them to create a user query and output the users. One of the taxonomies is ESPECIALIDAD, the other is REGION. When I am in: ...
0
votes
0answers
16 views

Use $wpdb->get_results with filter based on array

I need to filter my SQL query (in a plugin) based on an array of meta_values. I have CPT-A which is related to CPT-B. I am keeping an array of CPT-A ids in meta_key afz_entry_tags of CPT-B I need ...
0
votes
1answer
12 views

wpdb get posts by taxonomy SQL

I need a list of posts of a specific post_type plus the name of a custom taxonomy term. This is what I got so far SELECT p.post_name,t.name as clientName FROM $wpdb->posts AS p, $wpdb->terms ...
1
vote
1answer
18 views

How can I get the query that would be run for the archive page?

When a user visits a post type archive page on my site, I've got a bunch of hooks and filters that run on that query and get it just so. How can I, in a different request, say "I want the query that ...
0
votes
1answer
15 views

Wordpress PHP syntax doesn't seem to be working correctly

When I run this wordpress query, instead of the background image showing I just get the end of the div string echoed out? The image string appears in the browser inspector, but not to the screen. Here ...
-1
votes
1answer
10 views

database search feature

I am looking to create a website that creates and searches the created database then displays the results on a custom page. I initially thought this would be a lot easier than it is proving to be. I ...
0
votes
1answer
22 views

Customizing the_tags output?

I am trying to display a list of tags. I want to display 6 tags but random tags. Not post tags but tags from the entire site. <?php $number_to_show = 10; $tags = wp_tag_cloud( array( ...
0
votes
0answers
21 views

Limit results of custom query to current category

I have created a geolocation system for a custom post type of services and have been working on a query to limit the results based on address/distance entered by the user. Everything seems to be ...
0
votes
0answers
20 views

How to use pre_get_posts filter from frontend user input (GET variables) or do_action

I'm trying to allow users to filter certain pages based on the input from a dropdown. <div class="filter-by-calories"> <h3 class="filed-title">BROWSE BY CALORIES</h3> ...
0
votes
1answer
35 views

Query Posts that have or don't have a meta_value and order by the same ASC

I'm trying to perform a scheduled update to all posts, 10 posts at time. To achieve this, I run Cron job with a script that saves 2 post meta: $DATA: the data I want to be update $TIME: the UNIX ...
-1
votes
2answers
23 views

Can't See Media Queries with Inspect Tool [closed]

all - I do not have the greatest CSS skills in the world, but I can normally figure things out. Right now I'm trying to implement a fairly simple media query in the child theme of my Wordpress site. ...
1
vote
0answers
18 views

Query with relation and one without relation using multiple taxonomies?

I'm trying to use one query for two queries, one with an and relation and one without without having to do multiple queries and loops, is this possible? <?php $args = array( 'post_type' ...
0
votes
1answer
26 views

Query custom post type by custom taxonomy (category slug)

I've followed several related solution. But I'm still facing the problem. I've applied the following code for my custom post query by taxonomy (category). But it's not working. I think my problem with ...
0
votes
1answer
41 views

$query->set( 'post_type', 'post' ); not working

I am trying to exclude pages from my search result with this function: function posts_for_current_author($query) { global $user_level; if($query->is_admin && $user_level < 5) { ...
0
votes
1answer
21 views

Exclude current custom post on single post

I'm trying to exclude the current custom post that is viewed from a list. I've tried with exclude but it still displays it. Here is the code I have on single-works.php: <?php $currentID = ...
0
votes
0answers
16 views

A simple way to unfilter the closing h2 Tag in the excerpt

normaly the Wordpress Excerpt is beeing filtered. For some auto correction inside a Plugin i would need to know where the h2 tag ends, and finally to set a dot on its place with a preg replace. I ...
0
votes
2answers
55 views

Conditional posts in WP_query for search

I have a custom post type that im trying to limit results in search. The CPT is a deal/coupon, with a start and end date for each of the deals. What I'm trying to do is only show these posts in ...
0
votes
3answers
46 views

is_main_query() never called on WP 4.4

Im fairly new to WP dev, however as far as i can see ive followed the correct procedure in my custom archive page (below). If i remove the check for is_main_query() it wipes the menus out and likely a ...
0
votes
0answers
23 views

Archive page: how to orderby category and then by author?

Is it possible to display an archive page ordering its articles by (sub)categories first and by author (alphabetically) as second level order? What do I need to modify and where?
0
votes
0answers
33 views

Query can not search data with space?

I have following code $wpdb->get_results( 'SELECT * FROM '.$device_token_table.' WHERE user_pushtoken="'.$server_method['user_pushtoken'].'" AND user_id = '.$user_id,ARRAY_A ); ...
0
votes
0answers
17 views

Order posts by a descending meta key integer value and append posts with no meta key after them

Let's assume that there are 10 posts. 8 of them has a votes meta_key with an integer value associated to it: key => 'votes', value => 5 But 2 of the 10 posts doesn't has a votes meta_key at all ...
0
votes
1answer
51 views

Wp_query WooCommerce products

I'm currently developing an e-commerce store using Wordpress and WooCommerce. I'm planning on creating a basic product filtering system and was wondering if it's possible to wp_query the results shown ...
0
votes
1answer
50 views

Check if CTP category taxonomy is set in shortcode

I have created a custom post type with the ability to add categories (taxonomy). Taxonomy function create_cat_tax() { register_taxonomy( 'cpt_cats', 'cpt_faqs', ...
0
votes
0answers
35 views

SQL Query for all posts in specific category

I try to add a custom field to all posts in specific category with a sql query. This query set meta_value of new meta_key as post_author value in ldn_posts table. Here is begin of the code (works for ...
5
votes
2answers
158 views

Is there a way of increasing the speed of this query?

I need to cross reference two taxonomies, product_categories and brands. the only way I can think to do this is to get all the posts in one taxonomy, then get all the posts that exist in another ...
0
votes
1answer
21 views

Random posts in WP_Query when searching by tag

I have a section that want to include featured posts. I want to look for featured posts based on tag. For example, I want to fetch all the latest posts that have the featured tag. I use the following ...
0
votes
1answer
52 views

Show recent products first but “sold out last” in query

I am using WooCommerce and would would like to show the "out of stock" products last in the query on the archive page. How can I do that? Currently we are making the newest product show first with ...
0
votes
2answers
115 views

How i make a custom sql query for Woocommerce

hello i have an ecommerce with Wordpress + Woocommerce, just yesterday a hacker boy or...i don't know moved all woocommerce products in to the trash.... there are lots of products and default ...
0
votes
0answers
27 views

Fast User Query Using SQL vs WP_User_Query

I've found that WP_User_Query() is very slow when dealing with more than 1,000 users and I have decided to use custom MySQL queries. In my code below, I pulled only user_id to make it work faster and ...
0
votes
1answer
44 views

Improving WP_Query for performance when random posts are ordered

I have made a new query after I've asked a question about my query_posts code... you guys didn't find that great, so I decided to change that. I made this: $page = (get_query_var('paged')) ? ...
0
votes
0answers
29 views

Rewrite URL query string for all pages

I need to pass query string http://example.com/anypage?query=123 to look like this: http://example.com/anypage/123 and it should work on any page: ...com/anotherpage/123 I am looking for the ...
0
votes
0answers
34 views

Meta Box Plugin - Adding field value inside echo

I am using Meta Box Plugin to add some custom options to my Page Edit. I added a field to add an image background to the header which is working great. This image background has a parallax background ...
0
votes
0answers
17 views

Add Hook for clearing transient when post is added

I have this fragment caching implemented in a page. I've got the codes from https://css-tricks.com/wordpress-fragment-caching-revisited/. Which goes like this: function fragment_cache($key, ...
3
votes
1answer
31 views

Difference between fragment caching and wp_cache

I've been really confused about this two caching. What's the main difference of fragment caching vs wp_cache? Can both of them be used hand in hand? EDIT i've read about the fragment caching found ...
0
votes
2answers
49 views

Check return value of get_posts

I've been trying to change my WP_Query to get_posts methods. But I am not really sure how to check if get_posts is null or have a value. How can i transform this WP_Query checker to appropriate ...
0
votes
1answer
51 views

Does wp_query and query_posts affect website performance? [duplicate]

I've been aware about the difference of wp_query and query_posts. I just want to know what impact does both query methods to the performance of the page? Which query method makes the page load quicker ...
1
vote
1answer
28 views

unable to retrive parent page information

I am trying to display the parent page title, parent page id, current title and current id on a page via a plugin. I have the below code which I then echo the value of each. The trouble I am having ...
1
vote
1answer
47 views

Change query_posts to WP_Query in page but does not work

I have this code in page.php and it calls the template part for my home. Inside the home.php i used query_posts instead of WP_Query and i wanted to change it into WP_Query. I tried changing it but ...
0
votes
0answers
16 views

Excerpt data from one page into another

I'm a comparative noob at working inside WordPress. I'm trying to do my homework before asking, but haven't been able to uncover answers to the following. I could use your expertise. I'm working ...
0
votes
2answers
21 views

WP_Query with child element

I have my calendar events, I want to sort them by creation date with the query, but here's the issue: I have a meta key which has child values: First one is $data = ...
0
votes
1answer
23 views

$wpdb query for price in custom field value

A classifieds list site have only 3 criterias when searching products: the common search, category and region (for ZIP, city or full address) It's not enough and I really need to include a basic price ...
1
vote
1answer
40 views

First custom field value (out of several) displayed twice after query

I have the following piece of code, which is based on the solution to this question: <?php $game_titles = get_terms('game'); foreach($game_titles as $game_title) { ...
1
vote
2answers
55 views

Create WP_Query to search for posts by their categories or their parent/child categories

Hello I am really sorry if this has been asked before but I couldn't find the exact solution I need. So here's the problem I want to create a search in my Wordpress page. Whenever a user submits the ...
0
votes
1answer
28 views

Having trouble going from Jfiddle to implementing in Wordpress :(

If someone could point me in the right direction on how exactly to do this without yelling about follow codex site lol. I wouldnt be here if I wasnt able to get it working haha. I created a neat ...
0
votes
1answer
47 views

Alternative layout the loop

i'm trying to make an alternative loop as found here on stackexchange, it has been a great help to what i've achieved so far, but i'm stuck now. The goal is to make the newspage look like this The ...
0
votes
0answers
27 views

Function returning same value for all posts

I have this function to get the size in KB from a file. It works like a charm as long as it's on a single post. However, if I do a query, all posts take the value from the first post. Thus, if the ...
0
votes
0answers
8 views

Query Code Making Menu Disappear

I'm trying to display only certain tags on my site, but when I use the code my menu disapears. Heres what I have: $query->set('tag', 'break','crunch'); return $query; I have this placed in the ...