post-meta - Read For Learn

Read post meta values, only if posts are public

Yes, do an INNER JOIN, something like this should work: $values = $wpdb->get_col($wpdb->prepare(” SELECT meta_value FROM $wpdb->postmeta INNER JOIN $wpdb->posts {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id WHERE meta_key= %s AND {$wpdb->posts}.post_status=”publish”” ,$metakey )); I changed $wpdb->get_results() to $wpdb->get_col() since it looks like you are just selecting a single column of data as an array. I also added $wpdb->prepare() … Read more

get_post_meta not extracting title,permalink and posttype

Post metas are used for storing custom data that you want to store and retrieve yourself. The default post data post type, title, permalink are not saved in post meta. You can retrieve post_type and title using get_post() function which returns a WP_Post object. For permalink you need to use get_permalink() function like this. $post … Read more

cleaning up safely wordpress wp_postmeta table

The only generic semi-automatic procedure I can think of would be to delete post meta where the post_id is invalid. SELECT * FROM {$wpdb->postmeta} as pm LEFT JOIN {$wpdb->posts} as p ON pm.post_id = p.ID WHERE p.ID IS NULL I wrote a SELECT and not a DELETE because I don’t trust that to work in … Read more

Trying to get property of non-object error using get_post_meta()

$post is never set on init when I test this– function topSub( $Trunckvalue = null ) { global $post; var_dump($post); } add_action( ‘init’, ‘topSub’ ); The earliest hook I can find (by experimentation, not a canonical statement) is wp. Aditionally, $post is set on archive pages as well as “single” pages. On those archive pages … Read more

Custom query, multiple custom keys

I’m not an SQL expert, but I would think you might have to JOIN twice to pick two distinct rows out of wp_postmeta: $featuredquery = ” SELECT wposts.* FROM $wpdb->posts wposts JOIN $wpdb->postmeta article_level ON ( wposts.ID = article_level.post_id AND article_level.meta_key = ‘article_level’ ) JOIN $wpdb->postmeta article_genre ON ( wposts.ID = article_genre.post_id AND article_genre.meta_key = … Read more

Is it possible to retrieve a post and its metadata at the same time?

It’s not a single step, but it’s easy to write & handle in code: get_post_custom() gives you all attached meta data. But be aware: Everything comes as array, even when it´s a single value. So // Ever entry comes like this. // Example single value for ‘Hair color’: Array( [0] => Array( ‘Brown’ ) )

get_post_meta is showing file url in url bar

You should check the urls in your Custom field. This function adding http for invalid url. function addhttp($url) { if (!preg_match(“~^(?:f|ht)tps?://~i”, $url)) { $url = “http://” . $url; } return $url; } And finally: <?php function addhttp($url) { if (!preg_match(“~^(?:f|ht)tps?://~i”, $url)) { $url = “http://” . $url; } return $url; } ?> <a href=”https://wordpress.stackexchange.com/questions/275288/<?php echo … Read more

get_post_meta() not work for the first post inside the loop

In that case try to create custom sql query like this. global $wpdb; $query = “SELECT meta_value FROM wp_postmeta WHERE post_id=your post id AND meta_key=’class’; $results = $wpdb->get_row($query) ; echo $results->meta_value;

$wpdb class updating meta_value using Ajax [closed]

need some assistance with the checkboxes (selecting/deselecting featured posts)

This appears to be a general PHP warning, you’re supplying an incorrect argument in a foreach loop. $_POST[‘list_id’] is expected to be an array or any other (iteratable object), when no checkboxes are checked I assume $_POST[‘list_id’] is completely undefined. $_POST[‘list_id’] = isset( $_POST[‘list_id’] ) ? (array) $_POST[‘list_id’] : array(); Adding this before you iterate … Read more

+ More