If you need to search by your meta_key/meta_value then do not store them in a single key. If you store as a single key then you are going to have to store your data as serialized string, or something similar. The only way you can search that would be via an inefficient %LIKE% query which … Read more
UPDATED ANSWER The correct function to use in context to WordPress and its intended API for this purpose is; esc_textarea Thus your code would reflect something like this; <textarea><?php echo esc_textarea($images);?></textarea> Although htmlspecialchars and htmlentities are valid to use, and even though esc_textarea wraps htmlspecialchars anyway, its more appropriate to use the official API call. … Read more
The parent post ID is stored in $post->post_parent. So you can access the parent data by using that ID in get_post_meta(). To get the ancestors use get_post_ancestors( $post->ID ). It returns an array of parent IDs, the last one is the highest. Let’s invent a helper function for the next examples: if ( ! function_exists( … Read more
Is there an easy way to do this without having to unserialize it? Not in any reliable way. You can certainly ORDER BY that value but the sorting will use the whole serialized string, which will give you technically accurate results but not the results you want. You can’t extract part of the string for … Read more
To add a custom field to attachments, place the following code in your functions.php. add_filter(‘attachment_fields_to_edit’, ‘edit_media_custom_field’, 11, 2 ); add_filter(‘attachment_fields_to_save’, ‘save_media_custom_field’, 11, 2 ); function edit_media_custom_field( $form_fields, $post ) { $form_fields[‘custom_field’] = array( ‘label’ => ‘Custom Field’, ‘input’ => ‘text’, ‘value’ => get_post_meta( $post->ID, ‘_custom_field’, true ) ); return $form_fields; } function save_media_custom_field( $post, $attachment … Read more
I use the following code to prevent updates of my custom fields during auto-saves, ajax requests (quick edit) and bulk edits. add_action(‘save_post’, ‘save_my_post’); function save_my_post($post_id) { // Stop WP from clearing custom fields on autosave, // and also during ajax requests (e.g. quick edit) and bulk edits. if ((defined(‘DOING_AUTOSAVE’) && DOING_AUTOSAVE) || (defined(‘DOING_AJAX’) && DOING_AJAX) … Read more
The one dirty option is using LIKE comparison in meta query request. It will just treat serialized value as string to make substring match against. It won’t be my first (or second) approach to rely on, but in some cases I had to do it like this. Non-unique meta keys are a little tricky to … Read more
For SQL, the post’s content is saved in “wp_posts” table under “post_content” column. When doing this from phpmyadmin, you’ll have to take care that you’re updating only the main post & not one of it’s revisions If you’re looking for some wordpress based solution, the wordpress way to do it is to use wp_update_post // … Read more
Checking if meta values exist You can use get_posts() (or the WP_Query object) to query all posts which match the post meta you want to save. You will need to specify the post status (i.e. which statuses are you willing to ignore). Below is the untested code to this. (For completeness I’ve left in arguments … Read more
I had a very similar question (“How to make custom bulk actions work on the media/upload page?“) about Justin Stern’s Custom Bulk Action Demo, which was just answered. My biggest piece of advice to you is to take the adaptation one step at a time: make sure you have export working for media before anything … Read more