You should pretty much never need to use $wpdb to grab data. There are helper functions built into WordPress that will do what you need. In this case, use get_post_meta(). Having used https://www.unserialize.com/ to unserialize your data, it looks like the item list in your question is in $meta[‘toys_item’][‘toys_item_ranger’]. I’ll use that in my code … Read more
Improve performance of slow query
Get child product categories from parent product category for CUSTOM TAXONOMY archive page
wordpress mysql / wpdb ajax load more for terms help
$combined_views = (int)$get_visit_query + (int)$offset; This doesn’t make much sense. $get_visit_query is a string (your query). Converting it to int returns in 0, see this snippet. Instead it should be $combined_views = (int)$visits_total + (int)$offset; Sidenote: Are you actually hooking the function via add_filter()? If not, apply_filters(‘get_post_views’, ..) will not have the desired effect. Using … Read more
Add posts to custom table in database instead of wp_posts
Can’t find out why dbDelta dosen’t create my table
WordPress get last inserted user id
How to save template data into wp_post table (post_content column)
This string, meta_value LIKE ‘%user-input-value%'”, contains percentage wilcards (%) that indicate that we’re looking for a row where meta_value column contains user-input-value as part of its value. $wpdb->prepare converts them into hashes, and the MySQL server gets something like this: meta_value LIKE ‘{399038939300d2c307c53b29a166ee90101da7b2aba7978a898694010bf1bfe6}user-input-value{399038939300d2c307c53b29a166ee90101da7b2aba7978a898694010bf1bfe6}’. Naturally, I was getting no results! The wpdb::prepare page reads, ‘Literal percentage … Read more