The follow source is more formatted, but in the goal the same like your tests. You should see, the first line to get the ID is not necessary. You have the ID of the user, there is present. If the loop get posts, it print a title and the date. Important is, that the post … Read more
Thank You @prosti for your answer I made Thise small code based on your answer and it works for me global $post; $query_args = array( ‘post_type’ => ‘post’, ‘post_status’ => ‘publish’, ‘order’ => ‘DESC’, ‘posts_per_page’ => -1, ‘cat’ => 1, // ‘fields’ => ‘SUM(amount_to_paid)’, ); $sum = 0; $query = new WP_Query($query_args); if ( $query->have_posts() … Read more
The reason your query doesn’t return anything fruitful is because you’re not comparing the meta_value of both of the meta_keys, you’re comparing non-numeric outcomes of meta_key = ‘x’ and meta_key = ‘y’. SELECT post_id, post_title FROM wp_posts INNER JOIN wp_postmeta ON post_id = post_id WHERE post_type=”product” AND meta_key=’_regular_price’ > meta_key=’_price’ What you want to be … Read more
You don’t need a select statement to do this, a DELETE statement can handle finding the records. Make sure to backup your database first, then try the following SQL query. DELETE FROM wp_postmeta WHERE meta_key = ‘cb_full_width_post’ AND meta_value != ‘nosidebar-narrow’
You are running into the minefield of the way home and front_page work in relation to “normal” home and “static” home pages. In many situations is_home and is_frontpage both eval as true on the REAL homepage and also on the main blog page. The Codex says… This Conditional Tag checks if the main page is … Read more
The code you posted: <a href=”https://wordpress.stackexchange.com/questions/270167/<?php if ( is_user_logged_in() ) { echo get_post_meta($post_id,”external_link’, true); } else { echo ‘Login to View’; } ?> “>View Website</a> Is going to echo “Login to View” as the href attribute. You need something more like: <a href=”https://wordpress.stackexchange.com/questions/270167/<?php if ( is_user_logged_in() ) { echo get_post_meta($post_id,”external_link’, true); } else { echo … Read more
I tried online unserializer tool, but failed to interpret your value, because it’s broken. Anyway, the way to get value is like below: // Get the value from db first $meta_value = get_post_meta( $post->ID, ‘invoice_details’ , true ); //’invoice_details’ is a string, not a variable // Get to the desired value $desired_value = $meta_value[‘array_key’]; // … Read more
The text that is output in the author name/date (called ‘post meta’) is controlled by your theme. If you want to change that, it’s best to create a Child Theme, then copy the template from the main theme to your Child Theme folder and edit that. (Never edit the theme files directly, as any changes … Read more
If you “Import” Products, i assume you use the wp_insert_post function? In that case, you can use the meta_input argument like this: $args[‘meta_input’] = array( ‘meta_key_1’ => ‘meta_value_1’, ‘meta_key_2’ => ‘meta_key_2′, … ); Other than that, if you know EXACTLY what you’re doing, you could look into inserting the data directly by using the wpdb … Read more
guid doesn’t affect the image URL, it is just used as a unique identifier. It could be random gobbledygook and as long as it is unique it wouldn’t make a difference. It should be safe to use postmeta as long as you aren’t using any plugins that would potentially completely overwrite all postmeta associated with … Read more