mysql:creat insert sql

book.php

function createInsertSql(){

	$fields = array('tuanno','adddate','tuanname','tuanbianhao','buydate','dipeiname','guideno','guidemobile','contacttel','contactfax','tuantype','area','traffic','sleepis','sleephotel','tuannum','buynum','tickect','allnum');
	$sqlk = $sqlv = '';
	foreach($info as $k=>$v) {
		if(in_array($k, $fields)) { $sqlk .= ','.$k; $sqlv .= ",'$v'"; }
	}
	$sqlk = substr($sqlk, 1);
	$sqlv = substr($sqlv, 1);
	$db->query("INSERT INTO mg_form_team ($sqlk) VALUES ($sqlv)");
	if ($db->insert_id()) {
		showmessage('申报完成,请等待审核!', WLSL_PATH.'member/');
	}
}