/** * 根据person.id查找 */ public function findById($id) { $sql = "select person.id id, person.name name, person.state state, person.description description " . ",now.longitude now_lng, now.latitude now_lat, now.zoom now_zoom " . ", want.longitude want_lng, want.latitude want_lat, want.zoom want_zoom " . "from person left join point as now on person.now = now.id " . "left join point as want on person.want = want.id " . "where person.id = {$id}"; $mysql = new MysqlAccess(); $result = $mysql->getLine($sql); return $result; }
/** * 根据楼盘id返回项目 */ public function findPremisesById($id) { $sql = "select premises.id pid, premises.name name, point.longitude lng, " . " point.latitude lat, premises.description description, " . " project.name proname from premises" . " left join point on premises.point_id = point.id " . " left join project on project.id = premises.project_id where premises.id = {$id}"; $mysql = new MysqlAccess(); $result = $mysql->getLine($sql); return $result; }
/** * 根据用户名查找 */ public function findByUsername($uname) { $mysql = new MysqlAccess(); $sql = "select `username`, `password`, `last_login`, `last_ip` from admin where `username` = '{$uname}'"; $result = $mysql->getLine($sql); return $result; }