<?php
/* ****** обновление сразу нескольких строк за 1 запрос *********** */
if( !empty($_POST['data']) ){
	foreach ($_POST['data'] as $v) {
		$post_title .= $wpdb->prepare("WHEN %d THEN %s ",(int)$v['timel_id'],sanitize_text_field($v['timel_title']));
		$post_content .= $wpdb->prepare("WHEN %d THEN %s ",(int)$v['timel_id'],sanitize_text_field($v['timel_content']));
		$post_date .= $wpdb->prepare("WHEN %d THEN %s ",(int)$v['timel_id'],sanitize_text_field($v['timel_date']));
		$post_id .= (int)$v['timel_id'].",";
	}
	$post_id = substr($post_id, 0,-1);
	// echo $post_title;
	$update_query = "UPDATE $wpdb->posts SET
			    post_title = CASE id {$post_title} END,
			    post_content = CASE id {$post_content} END,
			    post_excerpt = CASE id {$post_date} END WHERE id IN({$post_id})";
	// echo $update_query."<hr>";
   $wpdb->query($update_query);
/*
  UPDATE wp8k_posts SET
	post_title = CASE id WHEN 10374 THEN 'alex title 1' WHEN 10375 THEN 'alex title 2' END,
	post_content = CASE id WHEN 10374 THEN 'a desc 1' WHEN 10375 THEN 'a desc 2' END,
	post_excerpt = CASE id WHEN 10374 THEN '21 Mar 2017' WHEN 10375 THEN '20 Mar 2017' END
		WHERE id IN(10374,10375)
*/
}

/* ****** обновление сразу нескольких строк за 1 запрос *********** */

/* ****** добавление сразу нескольких строк за 1 запрос *********** */
if( !empty($_POST['new_data']) ){
	$user = wp_get_current_user();
	$member_id = $user->ID;
	foreach ($_POST['new_data'] as $item) {
		$val .= $wpdb->prepare("(%s,%s,%s,%d,%s),",sanitize_text_field($item['timel_title']),sanitize_text_field($item['timel_content']),sanitize_text_field($item['timel_date']),(int)$member_id,"alex_timeline");
	}
	$val = substr($val, 0,-1);
	$insert_query = "INSERT INTO $wpdb->posts (post_title,post_content,post_excerpt,post_parent,post_type) VALUES {$val}";
	echo $insert_query;
	$wpdb->query($insert_query);
}
/*
INSERT INTO wp8k_posts (post_title,post_content,post_excerpt,post_parent,post_type)
	VALUES ('alex title 3','desc 3','15 Mar 2017',14,'alex_timeline'),
		('a title 4','desc 4','01 Mar 2017',14,'alex_timeline'),
		('a title 5','desc 5','04 Mar 2017',14,'alex_timeline')
*/
/* ****** добавление сразу нескольких строк за 1 запрос *********** */