public function getLastMapCoord($user) { $data = array(); $data[] = $this->conn->cleanData($user->getId()); $query = <<<SQL \t\t\t\tSELECT \t\t\t\t\tlatitude, \t\t\t\t\tlongitude, \t\t\t\t\taltitude, \t\t\t\t\ttime \t\t\t\t\tFROM \t\t\t\t\t\tlaa_coordinate \t\t\t\t\tWHERE \t\t\t\t\t\tid_user = {$data['0']} \t\t\t\t\tORDER BY \t\t\t\t\t\tid DESC \t\t\t\t\tLIMIT 1 SQL; $query = $this->conn->removeBreakLine($query); $result = $this->conn->getConn()->query($query); $map = NULL; while ($data = $result->fetch_object()) { $map = new Map(); $map->setId($data->id); $map->setLatitude($data->latitude); $map->setLongitude($data->longitude); $map->setAltitude($data->altitude); break; } $result->free(); return $map; }
public function selectAll() { $all = array(); if ($this->conn) { $query = "SELECT * FROM maps"; $res = mysql_query($query, $this->conn); if ($res) { while ($row = mysql_fetch_assoc($res)) { $m = new Map(); $m->setId((int) $row['id']); $m->setName($row['name']); $m->setTiles($row['tiles']); array_push($all, $m); } } } return $all; }
public function addMap($title) { $map = new Map($this->addSubElement("map")); $map->setId($this->getId() . "_map_" . $this->getNewMapId()); $map->setTitle($title); $this->saveDOM(); return $map; }