public function insertGroupTrack($group_id) { $query = "INSERT INTO " . $this->prefix . "group_track (`group_id`, `track_id`) values ('" . $group_id . "','" . $this->track_id . "')"; $this->track_id = db_query_return_id($query); #return error return; }
private function insertSpot() { $query = "INSERT INTO " . $this->prefix . "spot (`spot_user_id`, `spot_track_id`, `spot_lat`, `spot_lon`, `spot_description`, `spot_date_insert`) values ('" . $this->spot_user_id . "','" . $this->spot_track_id . "','" . $this->spot_lat . "','" . $this->spot_lon . "','" . $this->spot_description . "','" . $this->spot_date_insert . "')"; $this->spot_id = db_query_return_id($query); return; }
private function insertUser() { $query = "INSERT INTO " . $this->prefix . "user (`user_username`, `user_password`, `user_nickname`, `user_group`, `user_date_insert`, `user_level`) values ('" . $this->user_username . "','" . $this->user_password . "','" . $this->user_nickname . "','" . $this->user_group . "','" . $this->user_date_insert . "','" . $this->user_level . "')"; $this->user_id = db_query_return_id($query); return; }