开源ECSHOP中SQL DELETE\INSERT\UPDATE操作集锦，练习SQL

	//使用implode将PHP数组转化为“,”分隔的字符串，为IN查询提供集合
	function implode($arr) {
		return "'".implode("','", (array)$arr)."'";
	}
	
	$this->db->query("DELETE FROM ".UC_DBTABLEPRE."pm_members WHERE plid IN (".$this->base->implode($list).") AND uid='$uid'");
	
	IN语句用法：
		SELECT "栏位名" 
		FROM "表格名" 
		WHERE "栏位名" IN ('值一', '值二', ...)
	这样该列值为值一或者值二的记录都将被列出	
	
	DELETE一次删除的是一整条记录，所以不存在类似SELECT那样的语法：DELETE * FROM table WHERE...  DELETE index1, index2 FROM table WHERE...
	
	
	//使用implode为UPDATE提供操作列
	$sets = array();
	foreach ($update_values AS $key => $value) {
		$sets[] = $key . " = '" . $value . "'";
	}
	if (!empty($sets)) {
		$sql = 'UPDATE ' . $table . ' SET ' . implode(', ', $sets) . ' WHERE ' . $where;
	}
	
	UPDATE语法：UPDATE table1 SET index1 = value1, index2 = value2 WHERE ...
	
	
	//INSERT
	INSERT INTO `ecs_touch_nav` VALUES ('1', '', '0', '全部分类', '1', '0', '0', 'middle');
	//使用implode为INSERT提供操作列
    foreach ($field_names AS $value) {
		$fields[] = $value;
		$values[] = "'" . $field_values[$value] . "'";
    }
	
	if (!empty($fields)) {
		$sql = 'INSERT INTO ' . $table . ' (' . implode(', ', $fields) . ') VALUES (' . implode(', ', $values) . ')';
	}