A Wordpress method for inserting or updating multiple rows in a safer and faster way
$insert_arrays = array();
$time = current_time( 'mysql' );
$insert_arrays[0] = array(
'type' => "multiple_row_insert",
'status' => 1,
'name'=>"gordon freeman",
'added_date' => $time,
'last_update' => $time);
$insert_arrays[1] = array(
'type' => "multiple_row_insert",
'status' => 2,
'name'=>"captain dance",
'added_date' => $time,
'last_update' => $time);
$insert_arrays[2] = array(
'type' => "multiple_row_insert",
'status' => 3,
'name'=>"doc. emmet l. brown",
'added_date' => $time,
'last_update' => $time);
wp_insert_rows($insert_arrays,$wp_table_name);
wp_insert_rows($insert_arrays, $wpdb->tablename, true, "primary_column");