public function store_on_temp_table() { $id_last_trajectory = get_last_id_trajectory(); $connection = get_connection(); $sql_insert_fix = sprintf($this->sql_insert_fix_temp_table, $id_last_trajectory, $this->latitude, $this->longitude, $this->timestamp, $this->accuracy); $connection->query($sql_insert_fix); if ($connection->error) { die('Could not store fix' . $connection->error); } $connection->close(); }
public function store() { $id_last_trajectory = get_last_id_trajectory(); $sql_insert_staypoint = sprintf($this->sql_insert_staypoint, $id_last_trajectory, $this->latitude, $this->longitude, $this->arrival_time, $this->departure_time, $this->fixes_involved); $connection = get_connection(); $connection->query($sql_insert_staypoint); if ($connection->error) { die('Could not store staypoint' . $connection->error); } $connection->close(); }
function update_trajectory_end_time(GpsFix $gpsFix) { global $sql_update_trajectory_end_time; $last_id = get_last_id_trajectory(); $sql_update_trajectory_end_time = sprintf($sql_update_trajectory_end_time, $gpsFix->timestamp, $last_id); $connection = get_connection(); $connection->query($sql_update_trajectory_end_time); if ($connection->error) { die('Could not update trajectory info' . $connection->error); } $connection->close(); }