sql

Add custom fields to search

Question

I want to add a custom fields ("introduction" and "ensavoirplus") to search of Wordpress, but the SQL code is not exact. I don't understand if i do a mistake or if WP don't can do this. But my attempt fail... I don't know why because I do exactly what the codex says. This is my code :

custom-field, meta-query, search, sql ecaLdipS 3 years 0 Answers 75 views

Get the exact SQL query that get_posts() generated

Question

I am working on a WordPress that someone else started and then disappeared. She created a few custom content types and variables using different plugins and I now want to access the data sets in the functions she created for her template. $args = array( 'suppress_f

get-posts, sql user6329530 3 years 0 Answers 62 views

how to list all post that are in the custom taxonomy using $wpdb

Question

global $wpdb; $custom_post_type = 'post'; // define your custom post type slug here // A sql query to return all post titles $results = $wpdb->get_results( $wpdb->prepare( "SELECT ID, post_title FROM {$wpdb->posts} WHERE post_type = %s and post_status = 'publish' OR post_status

sql, wpdb Kenneth Gervacio 3 years 0 Answers 49 views

Insert blob data with wpdb

Question

I have a shortcode in my WordPress page with which I access the WordPress database with wpdb. It works perfectly with wpdb-> get_results () and wpdb-> query (), but I am not able to execute an insert with a blob data. With wpdb:: insert I can't as it only accepts a string, int

database, sql, wpdb alvaroqm 3 years 0 Answers 74 views

WPDB Insert or if exists Update

Question

I'm not crazy familiar with WPDB or SQL in general but I have a custom table for my project and I'm trying to assign some metadata to it. What I'd "like" to happen is if a row exists, update it and if not insert it. I've read both Insert and Update in the WPDB Codex but neither really went into a

database, sql, wpdb Howdy_McGee 3 years 0 Answers 76 views

Get posts by category with pure SQL query

Question

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 the post titles by selecting distinct values after the last / inside the post title. SELECT DI

query, query-posts, sql chrispytoes 3 years 0 Answers 65 views

How to run select query of post with category and tags?

Question

I want to fetch multiple posts with categories and tags currently I'm using this query: $pagesize = 20; $pageNumber = 1; $mysql = mysqli_query($con,"SELECT p.post_title, p.ID, p.post_content, p.post_date, p.post_name as url, t.name as category_name FROM

categories, posts, query, sql Mohnish 3 years 0 Answers 47 views

Put a database alias on the args parameter from the WordPress post_clauses filter

Question

Well, I'm trying to geolocalize products on the search engine from the Woocomerce plugin. I manage to see that everything works from filters that can be added inside the method get_catalog_ordering_args from WC_Query class. So I decided to create my own one called

php, sql z3nth10n 3 years 0 Answers 45 views

WooCommerce get specific orders by Customer ID SQL

Question

Trying to get specific orders by the customer ID via a raw SQL query. I'd like to input which order IDs I'd like to retrieve, but only retrieve them if they match a specific customer ID, here's what I have so far: SELECT * FROM wp_postmeta WHERE post_id IN ($order_ids) AND (meta_ke

mysql, sql, woocommerce, wpdb Jake 3 years 0 Answers 53 views

Get all order data by Order ID and matching Customer ID

Question

I'm trying to get order data from the wp_postmeta table by the post_id and _customer_user with a raw SQL query. However I'm having a little trouble, I think it might be due to the _customer_user being the key and I need the matching row

sql, wpdb Jake 3 years 0 Answers 56 views

1 2 … 13

Register Now

Login

Lost Password

Add question

Login

Register Now