PHP get_last_id_trajectoryの例

コード例 #1

ファイル: GpsFix.php プロジェクト: s0lver/ServerSide-LocalPOI-Experiment

 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();
 }

コード例 #2

ファイル: Staypoint.php プロジェクト: s0lver/ServerSide-LocalPOI-Experiment

 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();
 }

コード例 #3

ファイル: request_tools.php プロジェクト: s0lver/ServerSide-LocalPOI-Experiment

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();
}