Convert data from product gallery to CPT project acf field gallery


<?php

/**
 * Template name: Page Run DB
 */


/**
 * _product_image_gallery => string space: 5698,5699,5700,5701,
 * 5702,5703,5704,5705,5706,5707,5708,5709,5710,5711,5712,5713,5714,5715,5716,5717,5718,5719,5720,5721
 * =>> gallery => a:4:{i:0;s:5:"11522";i:1;s:5:"11534";i:2;s:5:"11535";i:3;s:5:"11532";}
 * get data table:  wp_postmeta where _product_image_gallery
 * process
 * update data > wp_postmeta
 *
 */


get_header();
global $wpdb;
$table = $wpdb->prefix . 'postmeta';
$sql = "SELECT * FROM {$table} WHERE `meta_key` = '_product_image_gallery'";
$data = $wpdb->get_results( $wpdb->prepare($sql), ARRAY_A);

foreach($data as $item) {
	$meta_pid = $item['meta_id'];
	$meta_key = $item['meta_key'];
	$meta_value = $item['meta_value'];
	$meta_value_new = explode(',', $meta_value);
	$meta_value_new2 = serialize($meta_value_new);

	$data_new = array(
		'meta_key' => 'gallery',
		'meta_value' => $meta_value_new2
	);

	$update = $wpdb->update(
		$table,
		$data_new,
		array('meta_id'=>$meta_pid)
	);

	if($update > 0) {
		echo "Proccess done.";
	} else {
		exit( var_dump( $wpdb->last_query ) );
	}
}
$wpdb->flush();
get_footer();

Convert content from post excerpt to post_content

<?php

/**
 * Template name: Page Run DB
 */


get_header();
global $wpdb;
$table = $wpdb->prefix . 'posts';
$sql = "SELECT id, post_excerpt FROM {$table} WHERE `post_type` = 'project'";
$data = $wpdb->get_results( $wpdb->prepare($sql), ARRAY_A);

foreach($data as $item) {
	$pid = $item['id'];
	$excerpt = html_entity_decode($item['post_excerpt']);

	if(!empty($excerpt)) {
		$data_update = array(
			'post_content' => $excerpt
		);

		$update = $wpdb->update(
			$table,
			$data_update,
			array('id'=>$pid)
		);

		//var_dump($update);
		if($update > 0) {

			echo "Proccess done.";
		} else {
			exit( var_dump( $wpdb->last_query ) );
		}
	}
}
$wpdb->flush();
get_footer();

Leave a Reply

Your email address will not be published. Required fields are marked *