document.open();document.writeln('
');document.writeln('
<?php');document.writeln('function insertonduplicate($table, $data) {');document.writeln('		');document.writeln('	global $wpdb;');document.writeln('		');document.writeln('	$fields = array_keys($data);');document.writeln('	$formatted_fields = array();');document.writeln('	foreach ( $fields as $field ) {');document.writeln('		$form = '%s';');document.writeln('		$formatted_fields[] = $form;');document.writeln('	}');document.writeln('	$sql = "INSERT INTO `$table` (`" . implode( '`,`', $fields ) . "`) VALUES ('" . implode( "','", $formatted_fields ) . "')";');document.writeln('	$sql .= " ON DUPLICATE KEY UPDATE ";');document.writeln('		');document.writeln('	$dup = array();');document.writeln('	foreach($fields as $field) {');document.writeln('		$dup[] = "`" . $field . "` = VALUES(`" . $field . "`)";');document.writeln('	}');document.writeln('		');document.writeln('	$sql .= implode(',', $dup);');document.writeln('		');document.writeln('	return $wpdb->query( $wpdb->prepare( $sql, $data) );');document.writeln('}');document.writeln('?>');document.writeln('
');document.writeln('');document.writeln('');document.writeln('
');document.close();