Firtly, in SQL the % symbol is a “wildcard operator”. When used in a LIKE statement, it means “0 or more characters”. So LIKE ‘Hello%’ means any string beginning with Hello, including just Hello. While LIKE ‘%Hello%’ means any string that contains Hello, either at the beginning, middle, or end. $wpdb->prepare() on the other hand … Read more
Get the date of current post: $date = get_the_date(‘Y-m-d’); Get year, month and day from the $date variable. $exploded = explode(‘-‘, $date); $year = $exploded[0]; $month = $exploded[1]; $day = $exploded[2]; Lastly, query the posts that has the same publish date. $args = array( ‘post_type’ => ‘post’, ‘post_status’ => ‘publish’, ‘date_query’ => array( array( ‘year’ … Read more
Based on our chat in the comments here’s what I came with. Please advise if it works. <?php function primary_category_query_shortcode( $post, $atts ) { //global $post; //Uncomment this global if it still doesn’t work. $atts = shortcode_atts( $defaults, $atts, ‘primary_category_query’ ); $my_meta = get_post_meta ( $post->ID, ‘_yoast_wpseo_primary_category’, true ); // WP_Query arguments $args = array … Read more
By doing a SHOW CREATE TABLE on wp_postmeta, I got the structure of that table which included this: PRIMARY KEY (`meta_id`), So the key that MySQL can do the ‘insert or update’ on is the meta_id, which you’re not providing. Therefore in your query, it will always be added as a new row. EDIT: The … Read more
It doesn’t work with add_rewrite_rule() because of the ?view= part in the URL (it’s the first parameter for the function) — i.e. WordPress strips that query string part, hence it’s not included when WordPress finds a matching rewrite rule. how I can remove ?view=12a34b56 after set post name You can’t (not on the same page), … Read more
I made it through! I’ll share how I did in case some other person lacking the php knowledge like me lands in the same spot. add_action(‘elementor_pro/posts/query/projects_designs_query’, function($query) { $post_id = get_the_ID(); $meta_query[] = [ ‘post_type’ => ‘designs’, ‘taxonomy’ => ‘projects’, ‘value’ => $post_id, ‘compare’ => ‘in’, ]; $query->set( ‘meta_query’, $meta_query ); } ); What this … Read more
Perhaps you could create a private utility taxonomy bookmarks, where each term would correspond to a user. When ever a user is created a new term would be added to the utility taxonomy. As the user bookmarks or removes one’s bookmark from a post, your code would attach or detach the user equivalent term from … Read more
yes, offcourse it is possible, I had made two websites for selling car pieces myself and that is very possible. anything is possible. you can create your own search results with the file search.php here are two ways of getting products info: $args = array( ‘post_type’ => ‘product’, ‘posts_per_page’ => 10, ‘meta_key’ => ‘_last_viewed’, ‘orderby’ … Read more
Huge thanks to @kero !! I was finally able to create a solution by making the sql statement a variable first (as kero suggested) then using that variable on wpdb->query(); Here’s my updated and fully working codes now: $imdbid = $_GET[‘id’]; $string = file_get_contents(“http://www.omdbapi.com/?i=”.$imdbid.”&apikey=9a187152″); $json = json_decode($string, true); if( $json[‘Response’] === “True” ){ $dataID = … Read more
It’s hard to say exactly what your query is trying to accomplish, but I’ll provide the two setups that come to my mind, and hope they help you out. You could setup your query arguments with the two required taxonomies and terms being searched for like: $args = array( ‘post_type’ => ‘custom’, ‘post_parent’ => 0, … Read more