You’ll only need to run it once, but this should get all your posts, and then loop through them and update the meta. add_action(‘admin_init’, ‘deleteCommaDB’); function deleteCommaDB(){ // The Query $args = array ( ‘posts_per_page’ => -1 ); $the_query = new WP_Query( $args ); // The Loop while ( $the_query->have_posts() ) : $the_query->the_post(); $price_key = … Read more
The SQL query triggered by get_post_custom() is in update_meta_cache() and it looks like this: $wpdb->get_results( $wpdb->prepare( “SELECT $column, meta_key, meta_value FROM $table WHERE $column IN ($id_list)”, $meta_type ), ARRAY_A ); So there is no ORDER BY given. Without ORDER BY the resulting order is almost unpredictable: it depends on the optimizer, used indexes and their … Read more
First, dd this code [] at the end of your form field name. So your field’s name will be “test[]”. Example: <input type=”text” name=”test[]” value=”” size=”60″ /> Use this way to save the value: $old = get_post_meta($post_id, ‘your_meta_key’, true); $newtest = array(); $test = $_POST[‘test’]; $count = count( $test ); for ( $i = 0; … Read more
Problem is that meta values are not unique key/value data. E.g. with the key ‘OneKey’ you can have a lot of values for the same post. So, in a flat table, for the column ‘OneKey’ you should have multiple rows where the post id is the same and seems to me is not what you … Read more
I know you said you were looking for your own implementation, but the easiest way to add multiple featured image metaboxes is with the Multiple Post Thumbnail plugin. Following the plugin’s documentation, the way to define a secondary box is to add this code to your theme’s functions.php if (class_exists(‘MultiPostThumbnails’)) { new MultiPostThumbnails( array( ‘label’ … Read more
save_post being called multiple times is expected behavior, but because of how it’s used, you may not always want your code to execute until the user actually clicks on the save button. Like you have mentioned above regarding your requirement. So you can check the current page ( i.e post-new.php ) in the wp-admin and … Read more
This will query all the ticket posts and update a _ticket_date field. However, I’m not yet sure how to retrieve the actual date, so you’ll have to provide me with a little more information for that. Assuming it works properly I would run the following once, and then remove. You could achieve a similar effect … Read more
Register your taxonomies with ‘show_ui’ => false, and then add a single meta box to manage them. function create_book_tax() { register_taxonomy( ‘genre’, ‘book’, array( ‘label’ => __( ‘Genre’ ), ‘rewrite’ => array( ‘slug’ => ‘genre’ ), ‘hierarchical’ => true, ‘show_ui’ => false, ) ); } Or unhook the boxes from the side panel and put … Read more
Yes. get_post_meta() uses get_metadata() which in turn uses update_meta_cache() to retrieve the values. In the source code we see this part (comment mine) // $id_column is ‘meta_id’ $meta_list = $wpdb->get_results( “SELECT $column, meta_key, meta_value FROM $table WHERE $column IN ($id_list) ORDER BY $id_column ASC”, ARRAY_A ); So the meta values will be ordered by meta_id … Read more
wp_kses to the rescue! My Editor Contains everything a Post Might Pass the result through wp_kses_post on the way in and out, and all should be good. Remember, this will strip out anything added by the_content filter, so to preserve oembeds and shortcodes, use this: echo apply_filters( ‘the_content’, wp_kses_post( $content ) ); You might also … Read more