Technologie AJAX
dialogue asynchrone avec la BD
Page rafraîchit à 21:42:51
Table : Clic sur un élément
=> Requête : SELECT PLNUM,PLNOM FROM pilote
=> Réponse :
| PLNUM | PLNOM |
|---|
| 1 | MIRANDA |
| 2 | LETHANH |
| 3 | TALADOIRE |
| 4 | BONFILS |
| 5 | LAKHAL |
| 6 | BONFILS |
| 7 | MARCENAC |
| 8 | LAHIRE |
| 9 | CICCHETTI |
| 10 | CAVARERO |
=> Requête : SELECT DISTINCT * FROM pilote WHERE (SALAIRE >= 18000)
=> Réponse :
| PLNUM | PLNOM | PLPRENOM | VILLE | SALAIRE |
|---|
| 1 | MIRANDA | SERGE | PARIS | 21000.00 |
| 2 | LETHANH | NAHN | TOULOUSE | 21000.00 |
| 3 | TALADOIRE | GILLES | NICE | 18000.00 |
| 5 | LAKHAL | LOTFI | TOULOUSE | 19000.00 |
| 6 | BONFILS | GERARD | PARIS | 18000.00 |
| 9 | CICCHETTI | ROSINE | NICE | 18000.00 |
| 10 | CAVARERO | ANNIE | PARIS | 20000.00 |
=> Requête : SELECT DISTINCT * FROM pilote, vol WHERE (pilote.PLNUM = vol.PLNUM)
=> Réponse :
| PLNUM | PLNOM | PLPRENOM | VILLE | SALAIRE | VOLNUM | PLNUM | AVNUM | VILLEDEP | VILLEARR | HEUREDEP | HEUREARR |
|---|
| 1 | MIRANDA | SERGE | PARIS | 21000.00 | 100 | 1 | 1 | NICE | TOULOUSE | 11:00:00 | 12:30:00 |
| 1 | MIRANDA | SERGE | PARIS | 21000.00 | 101 | 1 | 8 | PARIS | TOULOUSE | 17:00:00 | 18:30:00 |
| 2 | LETHANH | NAHN | TOULOUSE | 21000.00 | 102 | 2 | 1 | TOULOUSE | LYON | 14:00:00 | 16:00:00 |
| 5 | LAKHAL | LOTFI | TOULOUSE | 19000.00 | 103 | 5 | 3 | TOULOUSE | LYON | 18:00:00 | 20:00:00 |
| 9 | CICCHETTI | ROSINE | NICE | 18000.00 | 104 | 9 | 1 | PARIS | NICE | 06:45:00 | 08:15:00 |
| 10 | CAVARERO | ANNIE | PARIS | 20000.00 | 105 | 10 | 2 | LYON | NICE | 11:00:00 | 12:00:00 |
| 1 | MIRANDA | SERGE | PARIS | 21000.00 | 106 | 1 | 4 | PARIS | LYON | 08:00:00 | 09:00:00 |
| 8 | LAHIRE | PHILIPPE | LYON | 15000.00 | 107 | 8 | 4 | NICE | PARIS | 07:15:00 | 08:45:00 |
| 1 | MIRANDA | SERGE | PARIS | 21000.00 | 108 | 1 | 8 | NANTES | LYON | 09:00:00 | 15:30:00 |
| 8 | LAHIRE | PHILIPPE | LYON | 15000.00 | 109 | 8 | 2 | NICE | PARIS | 12:15:00 | 13:45:00 |
| 9 | CICCHETTI | ROSINE | NICE | 18000.00 | 110 | 9 | 2 | PARIS | LYON | 15:00:00 | 16:00:00 |
| 1 | MIRANDA | SERGE | PARIS | 21000.00 | 111 | 1 | 2 | LYON | NANTES | 16:30:00 | 20:00:00 |
| 4 | BONFILS | ELIANE | PARIS | 17000.00 | 112 | 4 | 5 | NICE | LENS | 11:00:00 | 14:00:00 |
| 3 | TALADOIRE | GILLES | NICE | 18000.00 | 113 | 3 | 5 | LENS | PARIS | 15:00:00 | 16:00:00 |
| 8 | LAHIRE | PHILIPPE | LYON | 15000.00 | 114 | 8 | 9 | PARIS | TOULOUSE | 17:00:00 | 18:00:00 |
| 7 | MARCENAC | PIERRE | NICE | 17000.00 | 115 | 7 | 5 | PARIS | TOULOUSE | 18:00:00 | 19:00:00 |