WooYun.org

public function address() {
		if(ispostreq()) {
			$addressid = intval($_POST["addressid"]);
			//如果是修改，但是没有权限
			if($addressid	&& !DB::getDB()->selectexist("user_address","addressid","addressid='$addressid' AND uid='".$this->uid."'") ) {
				$this->setHint("user_no_priv","error");
			}
			
			//参数
			$receiver = trim($_POST["receiver"]);
			$province = trim($_POST["province"]);
			$city	  = trim($_POST["city"]);
			$district = trim($_POST["district"]);
			$zipcode  = trim($_POST["zipcode"]);
			$link	  = trim($_POST["link"]);
			$address  = trim($_POST["address"]);
			$data = array(
					"receiver"	=>$receiver,
					"province"	=>$province,
					"city"		=>$city,
					"district"	=>$district,
					"zipcode"	=>$zipcode,
					"link"		=>$link,
					"address"	=>$address,
					"uid"		=>$this->uid);
			$text  = '';
			if($addressid) { //修改地址
				$text = 'edit';
				DB::getDB()->update("user_address",$data,"addressid='$addressid'");
			} else { //增加地址
				$text = 'add';
				DB::getDB()->insert("user_address",$data);
			}
			$this->setHint("address_{$text}_success","success");
		} else {
			$this->getHint();
			if(isset($_GET["op"])	&& ($_GET['op'] == 'edit')	) { //操作
				$addressid = intval($_GET["addressid"]);
				$this->data["address"] = DB::getDB()->selectrow("user_address","*","addressid='$addressid' AND uid='".$this->uid."'");
				if(!$this->data["address"]) {
					$this->setHint("address_not_exist","error");
				}
				$this->getDistrictopt($this->data["address"]['province'],$this->data["address"]['city'],$this->data["address"]['district']);
				$this->data['opertype'] = "edit";
			} else {
				$this->data['opertype'] = "add";
			}
			//收货地址列表
			$this->data['addresslist'] = DB::getDB()->select("user_address","*","uid='".$this->uid."'");
			$this->output("myaddress");
		}
	}

public function update($tableName,$data,$where,$only = false) {
		$sql = "UPDATE ".$this->getTableName($tableName)." SET ";
		if(is_array($data)) {
			foreach($data as $key=>$val) {
				$sql .= $this->escapekey($key) . "=" . $this->escapeval($val).",";
			}
		} else {
			$sql .= $data;
		}
		
		$sql = rtrim($sql,",")." "
			 . $this->buildWhere($where)
			 . ($only?" LIMIT 1":"")
			 ;
		
		$this->query($sql);
		return $this->errno?false:true;

public function query($sql) {
		$sql = preg_replace("/`(.+?)`/","\"\\1\"",$sql);//执行mysql的`替换成"
		
		$this->lastSql = $sql;
		$this->statement = $this->conn->prepare($sql);
		if(false === $this->statement) {
			
		}
		$result = $this->statement->execute();
		if(false === $result) {
			$error		   = $this->statement->errorInfo();
			$this->error   = $error[2];
			$this->errno   = $this->statement->errorCode();
			if($this->errno) {
				cerror("sqlsrv error:".$this->errno."  ".$this->error);
			}
		}
		$this->querynum++;
	}