Skip to content

allienka/Birdnest-project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

56 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Birdnest-project

The aim of this project is to create a web app to list all the drone pilots that violated the NDZ perimeter around the nest of the endangered bird Monadikuikka. The area within 100 meters of the nest is declared as NDZ.

SPECIFICATIONS:

The list should::

  • Persist the pilot information for 10 minutes since their drone was last seen by the equipment
  • display the closest confirmed distance to the nest
  • contain the pilot’s name, email address and phone number
  • immediately show the information from the last 10 minutes to anyone opening application
  • not require the user to manually refresh the view to see up-to-date information

Drone positions

GET assignments.reaktor.com/birdnest/drones

Pilot information

GET assignments.reaktor.com/birdnest/pilots/:serialNumber

PREREQUISITES

  • Install XAMPP web server
  • Any Editor (Preferably VS Code or Sublime Text)
  • Any web browser with the latest version

Languages and Technologies used

  • HTML, CSS
  • XAMPP (A web server by Apache Friends)
  • Php
  • MySQL

Steps to run the project on your machine

  1. Download and install XAMPP on your machine
  2. Clone or download the repository
  3. Extract all the files and move it to the 'htdocs' folder of your XAMPP directory.
  4. Start Apache and Mysql in your XAMPP control panel.
  5. Open your web browser and type 'localhost/phpmyadmin'
  6. In phpmyadmin page, create a new database from the left panel and name it as drones
  7. Import drone table (drones.sql)
  8. Open them in editor and run index.php
  9. In web browser open localhost/nameofthexamppfolder

DATABASE STRUCTURE

Screenshot 2023-01-03 at 11 17 34

Database Drones

Table Drone:
-serial number : the drones serial number, primary key
-First name: first name to who the drone is registered
-Last name: last name of the person to who the drone in registered
-email: email of the person
-phone number: person's phone number
-position: the drones position
-timedate: the date and time when the drone was seen in the NDZ

the web app look:
Screenshot 2023-01-12 at 16 12 15

Link to the app

https://solee.com/birdnest-project/

About

web application which lists all the pilots who recently violated the NDZ, using PHP and MYSQL

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published