You have a structural problem with your data. Serialized data in the database is terrible if you need to search over pieces of that serialized data. There is no reliable, efficient, and certainly no easy, SQL query to search over serialized data. “serialization” is a PHP mechanism. It isn’t SQL. To the database that is … Read more
If its your own custom post type you should know the field names? Iterate through the fields – or better just get the required field – an then use the attachment Id with wp_get_attachment_image_src. http://codex.wordpress.org/Function_Reference/wp_get_attachment_image_src Chech the codex for further examples and Google for “WordPress custom post type fields”.
I tried your code and it works: I changed the wp_verify_nonce function, because that wasn’t working for me. I added an action instead of what it had. Now, for this to work, you have to create a nonce field with a code like this, of course that you can change the names if you want. … Read more
hope this will usefull to some one. <?php /* ADDED by for sorting ASCENDING order but call for price (ie price with 0) last */ function my_sort_custom( $orderby, $query ){ global $wpdb; $orderby = ” case when CAST(meta_value AS SIGNED) = ‘0’ then 1 else 0 end ,CAST(meta_value AS SIGNED) “; return $orderby; } add_filter(‘posts_orderby’,’my_sort_custom’,10,2); … Read more
I’ve answered my question… when your not giving the id of the post meta … it’s creating another one … you give the id and it’s updating… –
First you have to declare the global $wpdb before using it. Also you need to include the table prefix when calling the table names. global $wpdb; $posts_table = $wpdb->prefix . “posts”; $posts_meta_table = $wpdb->prefix . “postmeta”; Next get an array of post ids by the author needed( make sure you have the id of desired … Read more
Check out this post under the “Get Posts Meta Field Is Not Available By Default” heading: https://1fix.io/blog/2015/07/20/query-vars-wp-api/
Try update_post_meta function without esc_attr <?php update_post_meta($post_id, ‘province’, $_POST[‘postProvince’], true); ?>
$Featured_image = $wpdb->get_results(” SELECT p.* FROM net_5_postmeta AS pm INNER JOIN net_5_posts AS p ON pm.meta_value=p.ID WHERE pm.post_id = $da_id AND pm.meta_key = ‘_thumbnail_id’ ORDER BY p.post_date DESC LIMIT 15 “,’ARRAY_A’); A related solution, to query for posts WITHOUT providing a post ID (ordered by post date, and using the wp_ database prefix): SELECT p1.*, … Read more
Please try below code and check if ‘sound_s‘ key exists in the array or not $file_id = get_post_meta($post_id); echo “<pre>”; print_r( $file_id ); exit;