top_page.php






HOME   |  FLIGHT INFO  |   SINGLE ENGINES  |   TWIN ENGINES  |   OTHER AIRCRAFT  |   JET AIRCRAFT  |   TURBO-PROP AIRCRAFT  |   SOLO FLIGHTS
CHRONOLOGY   |   MESSAGES    |     BOOKS & VIDEOS    RECORDS    |     FLIGHTS DATABASE    |     NAMES DATABASE|     ARCHIVE 
NON-QUALIFYING FLIGHTS    |     INDEX OF AIRCRAFT    |     MEMORIAL    |     STATISTICS    |     MEETINGS AND HOSTS     |     SITE MAP  ...
CONTACT THE WEBMASTER

THE EARTHROUNDERS DATABASE

ADDING NEW DATA INTO THE DATABASE


In order to simplify life for any future Webmaster (if there is ever one...), we have created a set of simple pages to add new data to the databse. That would allow to make new entries to the database without the need to learn how to use sophisiticatted programs like PhpMyAdmin.
Such sophisticated programs are more complete, more useful but require a lot of learning and of practice to be able to get full results.
The other side of the coin is that a simplifed system will lack all the bells and wistles o those programs, especially the possibilities of editing, deleting and above all to correct mistakes, errors and/or typos.

That is why, at each step, there will be a reminder to check and recheck all entries before they are committed the Form by pressing the SUBMIT button.





The Database consists of 2 tables:
the DATA table named: "RTW", and
the RELATIONSHIP or DISTRIBUTION table named: "RTW2_2".

If one Pilot had done only one Flight, things would be very simple but as several persons can be in one flight and some can have done several flights, a DISTRIBUTION or RELATIONSHIP table is needed. It will point the name of each person to their respective flight. That is the role of the table "RTW2_2".
Example:
(In this example all names and numbers are fictitious and have no connection to the Database).

In the following example, there are:
4 persons in Flight Number 1000
2 personns in Flight Number 1001. and
only 1 person in Flight Nmber 1002.

John White was in Flight Nunber 1000
Peter Green was also in Flight Nunber 1000
John Black was also in Flight Nunber 1000
Mary Rose was also in Flight Nunber 1000

Mary Rose was also in Flight Nunber 1001
Mary Poppins was in Flight Nunber 1001

Jiminy Cricket was alone in Flight Nunber 1002

From this example, we can see that each name must point to a Flight, but that Mary Rose needs 2 separate entries,
one pointing to Flight 1000 and
one pointing to Flight 1001.

Meaning table RTW has 3 entries, while table RTW2_2 has 7 entries.


In each table, each entry has a successive number:
in table RTW ist is called: Flight Numberor Record_Number and
in table RTW2_2 it is called ID.

For each table, the last RECORD NEMBER and ID already used is given. The RECORD_NUMBER or ID for the new entry is that RECORD-NUMBER or ID incremented by +1.

Note that in this context, the words: FLIGHT_NUMBER and RECORD_NUMBER are identical.

Adding new Dta into the Database is done in TWO steps:
Step ONE: Data is added to the main table 'RTW',
Step TWO: Data is added to the Distribution or Relationship table: RTW2_2.


TO CONTINUE:



Last update: May 24, 2024
bottom.php
Contact us in English, French, German, Spanish, Italian or Portuguese:
Copyright © Claude Meunier & Margi Moss, 2000 - 2024