If you’re looking for raw SQL query, then this should help: UPDATE <PREFIX>postmeta SET meta_value=”temp4″ WHERE meta_value=”temp1″ AND meta_key = ‘post_template’ If you want to run this query from WP, then you can use this: global $wpdb; $wpdb->update( “{$wpdb->prefix}postmeta”, array( ‘meta_value’ => ‘temp4’ ), array( ‘meta_key’ => ‘post_template’, ‘meta_value’ => ‘temp1’ ) );
Export media library with metadata and import into new blog
That original value is a serialised array. If you want to see the original array you can use the unserialize() function, or a site like https://www.unserialize.com. The problem is that this isn’t working for your Array, because the serialised value is invalid. The problem is here: s:11:”target” “Target” is 6 letters, so this needs to … Read more
The default way WordPress separates different types of meta data, such as in the post meta data, is using a pipe |. For example, Author Name | Date | Cat1, cat2, cat3 This isn’t correct. WordPress doesn’t have a default way that it displays this information. It’s entirely up to the theme developer. if you’d … Read more
You can definitely accomplish this via the new_to_auto-draft action. This works because wp_insert_post has just finished taking the template from the post array and updating the meta to reflect this. You will essentially overwrite this value in the database right after it’s set. Here’s an example: function my_project_change_default_template( $post ) { if ( ! strpos( … Read more
Display multiple meta_key/meta_values by single SQL query
Custom Fields Not Showing (ACF not installed)
I fixed your input type/sanitization and escaping issues. I think there’s still some cleanup that could be done with this code though. I see inputs without labels, invalid attributes, etc. add_action( ‘add_meta_boxes_post’, function ( $post ) { if ( $post->_wp_page_template === ‘page-templates/skyscraper-post.php’ ) { add_meta_box( ‘sky_post_excerpt’, ‘SkyScraper Post Excerpt and Links’, ‘sky_post_excerpts’, ‘post’, ‘advanced’, ‘high’ … Read more
I did by removing backslash(/) from Date. $resultdob = $_POST[‘studentdob’]; $studentdob = str_replace(“https://wordpress.stackexchange.com/”, “”, $resultdob);
Since my post meta data was holding this data even upon refresh, all I had to do was delete this metakey once all the shortcodes on my post content were processed. For that, I made another shortcode and invoked that with do_shortcode() on single.php since that only processes once at the end. Now once I … Read more