增删查改

  $val) {
		if ($str == null) {
			$sep = "";
		} else {
			$sep = ",";
		}
		$str .= $sep . $key . "='" . $val . "'";

	}
	$sql = "update {$table} set {$str} " . ($where == null ? null : " where " . $where);
	$result = mysql_query($sql);

	if ($result) {  
		return mysql_affected_rows();
	} else {
		return false;
	}
}

/**
 *	删除记录
 * @param string $table
 * @param string $where
 * @return number
 */
function delete($table, $where = null) {
	$where = $where == null ? null : " where " . $where;
	$sql = "delete from {$table} {$where}";
	 mysql_query($sql);
	return mysql_affected_rows();

}

/**
 *得到指定一条记录
 * @param string $sql
 * @param string $result_type
 * @return multitype:
 */
function fetchOne($sql, $result_type = MYSQL_ASSOC) {
	$result = mysql_query($sql);
	$row = mysql_fetch_array($result, $result_type);
	return $row;
}

/**
 * 得到结果集中所有记录 ...
 * @param string $sql
 * @param string $result_type
 * @return multitype:
 */
function fetchAll($sql, $result_type = MYSQL_ASSOC) {
	$result = mysql_query($sql);
	while ($row = mysql_fetch_array($result, $result_type)) {
		$rows[] = $row;
	}
	return $rows;
}

/**
 * 得到结果集中的记录条数
 * @param unknown_type $sql
 * @return number
 */
function getResultNum($sql) {
	$result = mysql_query($sql);
	return mysql_num_rows($result);
}

/**
 * 得到上一步插入记录的ID号
 * @return number
 */
function getInsertId() {
	return mysql_insert_id();
}


//请求腾讯地图接口API
function getaddr($add){
$url = "apis.map.qq.com/ws/geocoder/v1/?address=".$add."&key=";
//初始化一个 cURL 对象
$ch  = curl_init();
//设置你需要抓取的URL
curl_setopt($ch, CURLOPT_URL, $url);
// 设置cURL 参数，要求结果保存到字符串中还是输出到屏幕上。
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
//是否获得跳转后的页面
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
$data = curl_exec($ch);
curl_close($ch);
return json_decode($data,TRUE); 
}




header("Content-type:text/html;charset=utf-8");

mysql_query("set character set 'utf8'");
//读库
mysql_query("set names 'utf8'");
//写库