Convert wordpress custom field into single array

Question

I am converting wordpress custom fields into one single array in the wp database. I am able to do it but I have duplicated entries. I just need one. Please guide me. Thanks!

Before running my code:

After running my code:

What I actually want:

My code:

add_action( 'init', function() {
    if ( 'migrate' !== filter_input( INPUT_GET, 'action' ) ) {
        return;
    }
 
    $query = new WP_Query( [
        'posts_per_page' => -1,
        'post_type'      => 'post',
        'post_status'    => 'any',
    ] );
    if ( ! $query->have_posts() ) {
        return;
    }
 
    while ( $query->have_posts() ) {
        $query->the_post();
        
        $field_id_1 = 'gallery';
        $field_value_1 = get_post_meta( get_the_ID(), $field_id_1, false );
        
        update_post_meta( get_the_ID(), $field_id_1, $field_value_1);
    }
} );

In the loop allow first iteration to update, and all other to delete_post_meta() — Mulli
– Mulli, Commented May 28, 2022 at 7:04
@Mulli Thanks for commenting. Do you have any example for me? — Ryan Tan
– Ryan Tan, Commented May 28, 2022 at 7:07

Ryan Tan · Accepted Answer · 2022-05-28 08:44:15Z

1

add_action( 'init', function() {
    if ( 'migrate' !== filter_input( INPUT_GET, 'action' ) ) {
        return;
    }
 
    $query = new WP_Query( [
        'posts_per_page' => -1,
        'post_type'      => 'post',
        'post_status'    => 'any',
    ] );
    if ( ! $query->have_posts() ) {
        return;
    }
 
    while ( $query->have_posts() ) {
        $query->the_post();
        
        $field_id_1 = 'gallery';
        $field_value_1 = get_post_meta( get_the_ID(), $field_id_1, false );
        
        delete_post_meta( get_the_ID(), $field_id_1 );

        add_post_meta( get_the_ID(), $field_id_1, $field_value_1);

    }
} );

@Mulli I got it working this way. Instead of updating the post_meta, I decide to delete the post_meta first and then add_post_meta. Thank you for your help!

answered May 28, 2022 at 8:44

Ryan Tan

531 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mulli · Accepted Answer · 2022-05-28 07:14:25Z

0

See the relevant part:

    $first=true;
    $field_id_1 = 'gallery';
    while ( $query->have_posts() ) {
        $query->the_post();
        
        $field_value_1 = get_post_meta( get_the_ID(), $field_id_1, false );

        if ($first){
            update_post_meta( get_the_ID(), $field_id_1, $field_value_1);
            $first = false;
        else delete_post_meta( get_the_ID(), $field_id_1, $field_value_1);
    }

answered May 28, 2022 at 7:14

Mulli

1,7085 gold badges24 silver badges42 bronze badges

2 Comments

Ryan Tan Over a year ago

I am getting syntax error with if else.

Ryan Tan Over a year ago

I tried this and it didn't work. I meant the duplicates are still there. pastecode.io/s/xedpwmuv

Collectives™ on Stack Overflow

Convert wordpress custom field into single array

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related