/** * 添加一个楼盘到数据库 * @param $premises Array(name, type, description, project_id, state, area, structure, lng, lat, zoom) * @return bool 是否成功 */ public function add($premises) { $ret = false; $point = new Point(); $point_id = (int) $point->add($premises['lng'], $premises['lat'], $premises['zoom']); $mysql = new MysqlAccess(); if ($point_id > 0) { $sql = "insert into premises(`name`, `description`, `point_id`, `project_id`) " . "values('{$premises['name']}', '{$premises['description']}', {$point_id}, " . "{$premises['project_id']})"; $mysql->runSql($sql); $ret = true; } return $ret; }
/** * 添加person */ public function add($person) { $ret = false; $point = new Point(); $now_id = (int) $point->add($person['now']['lng'], $person['now']['lat'], $person['now']['zoom']); $want_id = (int) $point->add($person['want']['lng'], $person['want']['lat'], $person['want']['zoom']); $mysql = new MysqlAccess(); if ($now_id > 0 && $want_id > 0) { $sql = "insert into person(`name`, `now`, `want`, `state`, `description`) values " . "('{$person['name']}', {$now_id}, {$want_id}, '{$person['state']}', '{$person['description']}')"; $mysql->runSql($sql); $ret = true; } return $ret; }
/** * 根据id删除 * */ public function delete($id) { $mysql = new MysqlAccess(); $sql = "delete from point where id = {$id}"; $mysql->runSql($sql); }