<?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();