19
BAZIN Alban RT2A BERNARD Guillaume HARDY Maxime Codes sources Connect.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Agence de voyage</title> <link rel="stylesheet" type="text/css" href="style_defaut.css" /> </head> <body> <? //connection a la bd require_once('../projet/Connections/distant.php'); //Debut de session if(isset($_POST) && !empty($_POST['login']) && !empty ($_POST['passwd'])){ extract($_POST); //On recupere le password de la table qui correspond au login du visiteur mysql_select_db($database_distant, $distant); $sql = "select * from admin where num_admin = '".$_POST['login']."'"; $req = mysql_query($sql) or die ('erreur SQL !<br>'.$sql.'<br>'.mysql_error()); $data = mysql_fetch_assoc($req); if($data['password_admin'] != $_POST['passwd']) { ?> <script>alert('Mauvais login / Password, merci de recommencer'); </script> <script>document.location.href = "frame_admin.html"; </script> <? } else { session_start(); $_SESSION['login'] = $_POST['login']; ?> <script>alert('<? echo 'Vous etes bien logué, vous etes administrateur'.$data['nom']; ?>')</script> <script>document.location.href = "frame_administration.php"; </script>; <? } } else { ?> <script>alert('Vous avez oublier de remplir un champ.'); </script> <script>document.location.href = "frame_admin.html"; </script> <? } ?> </body> </html>

Rapport Agence de voyage, Codes sources, Bazin Bernard Hardy

Embed Size (px)

Citation preview

Page 1: Rapport Agence de voyage, Codes sources, Bazin Bernard Hardy

BAZIN Alban RT2A

BERNARD Guillaume

HARDY Maxime

Codes sources

Connect.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transi tional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitiona l.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Agence de voyage</title> <link rel="stylesheet" type="text/css" href="style_ defaut.css" /> </head> <body> <? //connection a la bd require_once('../projet/Connections/distant.php'); //Debut de session if(isset($_POST) && !empty($_POST['login']) && !emp ty ($_POST['passwd'])){ extract($_POST); //On recupere le password de la table qui correspo nd au login du visiteur mysql_select_db($database_distant, $distant); $sql = "select * from admin where num_admin = '".$ _POST['login']."'"; $req = mysql_query($sql) or die ('erreur SQL !<br> '.$sql.'<br>'.mysql_error()); $data = mysql_fetch_assoc($req); if($data['password_admin'] != $_POST['passwd']) { ?> <script>alert('Mauvais login / Password, merci de recommencer'); </script> <script>document.location.href = "frame_admin.htm l"; </script> <? } else { session_start(); $_SESSION['login'] = $_POST['login']; ?> <script>alert('<? echo 'Vous etes bien logué, vo us etes administrateur'.$data['nom']; ?>')</script> <script>document.location.href = "frame_adminis tration.php"; </script>; <? } } else { ?> <script>alert('Vous avez oublier de remplir un champ.'); </script> <script>document.location.href = "frame_admin. html"; </script> <? } ?> </body> </html>

Page 2: Rapport Agence de voyage, Codes sources, Bazin Bernard Hardy

Description_voyage.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Description</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

</head>

<body>

<h5><div align="center">

<div align="center">Description du voyage

<?php

$id=mysql_connect("spartacus","maxime_hardy","ookacica") or die ("PROBLEME");

$db=mysql_select_db("rt2_maxime_hardy",$id) or die ("PROBLEME");

$req3="select num_circuit,nom_circuit,description,nb_max_personne,duree,nb_escale from circuit c where

c.num_circuit='".$_POST['num_circuit']."'";

$reponse=mysql_query($req3,$id) or die (mysql_error());

while ($row=mysql_fetch_assoc($reponse))

echo "<h5>".$row['nom_circuit']."</h5>"."<table border=2><tr><td>Numero Circuit</td><td>Nom

Circuit</td><td>Description</td><td>Nombre max de personne</td><td>Duree (jours)</td><td>Nombre

escale</td></tr><tr><td>".$row['num_circuit']."</td><td>".$row['nom_circuit']."</td><td>".$row['description']."</td><td>".$row['nb_ma

x_personne']."</td><td>".$row['duree']."</td><td>".$row['nb_escale']."</td></tr></table>";

?>

<?php

$id=mysql_connect("spartacus","maxime_hardy","ookacica") or die ("PROBLEME");

$db=mysql_select_db("rt2_maxime_hardy",$id) or die ("PROBLEME");

$req1="select ref_voyage,date_depart,date_retour,prix,nom_circuit from circuit c, voyage v where c.num_circuit=v.num_circuit and

c.num_circuit='".$_POST['num_circuit']."'";

$reponse=mysql_query($req1,$id) or die (mysql_error());

echo "<h1>Le Voyage</h1>"."<table border=2><tr><td>Ref Voyage</td><td>Date Départ</td><td>Date Retour</td><td>Prix</td></tr>";

while ($row=mysql_fetch_assoc($reponse)){

echo"<tr><td>".$row['ref_voyage']."</td><td>".$row['date_depart']."</td><td>".$row['date_retour']."</td><td>".$row['prix']."

€"."</td></tr>";}

echo"</table>";

?>

</div>

<br>

<br>

<h1 align="center">Les Escales</h1>

<div align="center">

<?php

$id=mysql_connect("spartacus","maxime_hardy","ookacica") or die ("PROBLEME");

$db=mysql_select_db("rt2_maxime_hardy",$id) or die ("PROBLEME");

$req2="select num_escale,date_jour_arrivee,date_jour_depart,nom_ville,nom_pays,activite,hebergement,ref_hotel from escale e,circuit c

where c.num_circuit=e.num_circuit and c.num_circuit='".$_POST['num_circuit']."'";

$reponse=mysql_query($req2,$id) or die (mysql_error());

echo "<table border=2 width=100%><tr><td>Numero Escale</td><td>Date jour arrivee</td><td>Date jour Depart</td><td>Nom

ville</td><td>Nom Pays</td><td>Activite</td><td>Type Hebergement</td><td>Ref herbergement</td></tr>";

while ($row=mysql_fetch_assoc($reponse)){

echo"<tr><td>".$row['num_escale']."</td><td>".$row['date_jour_arrivee']."</td><td>".$row['date_jour_depart']."</td><td>".$

row['nom_ville']."</td><td>".$row['nom_pays']."</td><td>".$row['activite']."</td><td>".$row['hebergement']."</td><td>".$row['ref_hote

l']."</td></tr>";}

echo"</table>";

?>

Page 3: Rapport Agence de voyage, Codes sources, Bazin Bernard Hardy

<?php

$id=mysql_connect("spartacus","maxime_hardy","ookacica") or die ("PROBLEME");

$db=mysql_select_db("rt2_maxime_hardy",$id) or die ("PROBLEME");

$req4="select h.ref_hotel,c.num_circuit,nom_hotel,animation,confort from hotel h,circuit c,escale e where h.ref_hotel=e.ref_hotel and

c.num_circuit=e.num_circuit and c.num_circuit='".$_POST['num_circuit']."'";

$reponse=mysql_query($req4,$id) or die (mysql_error());

echo "<h1>Hotel ".$row['nom_hotel']."</h1>"."<table border=2><tr><td>Ref hotel</td><td>Confort</td><td>Nom

Hotel</td><td>Animation</td></tr>";

while ($row=mysql_fetch_assoc($reponse)){

echo"<tr><td>".$row['ref_hotel']."</td><td>".$row['confort']."</td><td>".$row['nom_hotel']."</td><td>".$row['animation']."<

/td></tr>";}

echo"</table>";

?>

<?php

$id=mysql_connect("spartacus","maxime_hardy","ookacica") or die ("PROBLEME");

$db=mysql_select_db("rt2_maxime_hardy",$id) or die ("PROBLEME");

$req5="select a.num_accompagnateur,c.num_accompagnateur,nom_accompagnateur,prenom_accompagnateur from accompagnateur

a,circuit c where a.num_accompagnateur=c.num_accompagnateur and c.num_circuit='".$_POST['num_circuit']."'";

$reponse=mysql_query($req5,$id) or die (mysql_error());

while ($row=mysql_fetch_assoc($reponse))

echo "<h1>Votre accompagnateur sera ".$row['nom_accompagnateur']."</h1>"."<table border=2><tr><td>Nom

Accompagnateur</td><td>Prenom

Accompagnateur</td></tr><tr><td>".$row['nom_accompagnateur']."</td><td>".$row['prenom_accompagnateur']."</td></tr></table>";

?>

</div>

<br>

<!-- DEBUT MENU : MENU.HTML -->

<TABLE WIDTH="186" BORDER="0" CELLSPACING="0" CELLPADDING="0">

<TR>

<TD CLASS="titremenu"><a href="reserv_voyage.php" target="mainFrame">Réserver ce

voyage</a></TD>

</TR>

</TABLE>

<!-- DEBUT MENU : MENU.HTML -->

</body>

</html>

Frame_admin.html <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Agence de voyage</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

<style type="text/css">

<!--

body {

background-image: url(img/fond_contenu.jpg);

}

.style1 {font-size: 13px}

-->

</style>

</head>

<body>

<h1 align="center">Connection Administrateur</h1>

<form action ="connect.php"method="post">

<p><span class=HR>Login </span><input type="text" name="login" size="20">

<span class=HR>Mot de Passe </span><input type="password" name="passwd" size="20">

<input type="submit" name="valider" value="valider">

</p>

</form>

</body>

</html>

Page 4: Rapport Agence de voyage, Codes sources, Bazin Bernard Hardy

Frame_administration .php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Agence de voyage</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

</head>

<body>

<h4 align="center">Administration</h4>

<h1 align="center">Voyage</h1>

<h3 align="center"><a href="frame_consulter_voyage.php">Consulter</a> | <a href="frame_ajouter_voyage.php">Ajouter</a> | <a

href="frame_supprimer_voyage.php">Supprimer</a> </h3>

<h1 align="center">Circuit</h1>

<h3 align="center"><a href="frame_consulter_circuit.php">Consulter</a> | <a href="frame_ajouter_circuit.php">Ajouter</a> | <a

href="frame_supprimer_circuit.php">Supprimer</a></h3>

<h1 align="center">Escale</h1>

<h3 align="center"><a href="frame_consulter_escale.php">Consulter</a> | <a href="frame_ajouter_escale.php">Ajouter</a> | <a

href="frame_supprimer_escale.php">Supprimer</a></h3>

<h1 align="center">Hotel</h1>

<h3 align="center"><a href="frame_consulter_hotel.php">Consulter</a> | <a href="frame_ajouter_hotel.php">Ajouter</a> | <a

href="frame_supprimer_hotel.php">Supprimer</a></h3>

<h1 align="center">Accompagnateur</h1>

<h3 align="center"><a href="frame_consulter_accompagnateur.php">Consulter</a> | <a

href="frame_ajouter_accompagnateur.php">Ajouter</a> | <a href="frame_supprimer_accompagnateur.php">Supprimer</a></h3>

<h1 align="center">Administrateur</h1>

<h3 align="center"><a href="frame_consulter_administrateur.php">Consulter</a> | <a

href="frame_ajouter_administrateur.php">Ajouter</a> | <a href="frame_supprimer_administrateur.php">Supprimer</a></h3>

</body>

</html>

frame_ajouter_accompagnateur.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Insertion accompagnateur</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

</head>

<body>

<h1 align="center">Ajouter un accompagnateur</h1>

<h2>

<form action ="insertion_accompagnateur.php" method="post">

<p>NUMERO DE L ACCOMPAGNATEUR <input type="text" name="num" size="10">

<p>NOM DE L ACCOMPAGNATEUR <input type="text" name="nom"

size="10">

<p>PRENOM DE L ACCOMPAGNATEUR <input type="text" name="pre" size="10">

<p>SALAIRE <input type="text"

name="sal" size="10">

<p>DATE DE NAISSANCE <input type="text" name="dat"

size="10">

<p>DATE D EMBAUCHE <input type="text"

name="dat1" size="10">

<input

type="submit" name="valider" value="Ajouter">

</h2>

Page 5: Rapport Agence de voyage, Codes sources, Bazin Bernard Hardy

<a href="frame_administration.php"><img src="img/retour.jpg" alt="retour" border="0" title="retour"/></a>

</body>

</html>

frame_ajouter_administrateur.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Insertion administrateur</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

</head>

<body>

<h1 align="center">Ajouter un administrateur</h1>

<h2>

<form action ="insertion_administrateur.php" method="post">

<p>LOGIN DE L ADMINISTRATEUR <input type="text" name="log" size="10">

<p>MOT DE PASSE DE L ADMINISTRATEUR <input type="text" name="pwd" size="10">

<input

type="submit" name="valider" value="Ajouter">

</h2>

<a href="frame_administration.php"><img src="img/retour.jpg" alt="retour" border="0" title="retour"/></a>

</body>

</html>

frame_ajouter_circuit.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Insertion circuit</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

</head>

<body>

<h1 align="center">Ajouter un circuit</h1>

<h2>

<form action ="insertion_circuit.php" method="post">

<p>NUMERO CIRCUIT: <input type="text"

name="num1" size="10">

<p>NOM CIRCUIT : <input type="text" name="nom"

size="10">

<p>DESCRIPTION : <input type="text" name="des"

size="10">

<p>NOMBRE MAX DE PERSONNE: <input type="text" name="nb"

size="10">

<p>DUREE : <input type="text"

name="dur" size="10">

<p>NOMBRE D'ESCALE : <input type="text" name="nb1"

size="10">

<p>NOM PAYS : <input type="text"

name="pays" size="10">

<p>NUMERO ACCOMPAGNATEUR <input type="text" name="num2"

size="10">

<input

type="submit" name="valider" value="Ajouter">

</h2>

<a href="frame_administration.php"><img src="img/retour.jpg" alt="retour" border="0" title="retour"/></a>

</body>

</html>

frame_ajouter_escale.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Insertion escale</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

Page 6: Rapport Agence de voyage, Codes sources, Bazin Bernard Hardy

</head>

<body>

<h1 align="center">Ajouter une escale</h1>

<h2>

<form action ="insertion_escale.php" method="post">

<p>NUMERO ESCALE : <input type="text"

name="num1" size="10">

<p>DATE D'ARRIVEE : (aaaa-mm-jj hh-mm-ss) <input type="text" name="arriv" size="10">

<p>DATE DE DEPART : (aaaa-mm-jj hh-mm-ss) <input type="text" name="depart" size="10">

<p>NOM DE LA VILLE: <input type="text"

name="ville" size="10">

<p>NUM DU PAYS : <input type="text" name="pays"

size="10">

<p>ACTIVITE : <input type="text"

name="act" size="10">

<p>HEBERGEMENT : <input type="text" name="heb"

size="10">

<p>REFERENCE DE L HOTEL : <input type="text" name="ref" size="10">

<p>NUMERO DU CIRCUIT : <input type="text" name="numcircuit"

size="10">

<input

type="submit" name="valider" value="Ajouter">

</h2>

<a href="frame_administration.php"><img src="img/retour.jpg" alt="retour" border="0" title="retour"/></a>

</body>

</html>

frame_ajouter_hotel.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Insertion hotel</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

</head>

<body>

<h1 align="center">Ajouter un Hotel</h1>

<h2>

<form action ="insertion_hotel.php" method="post">

<p>REFERENCE DE L HOTEL : <input type="text"

name="ref" size="10">

<p>CONFORT /4 : <input type="text"

name="conf" size="10">

<p>NOM DE L HOTEL : <input type="text"

name="nom" size="10">

<p>ANIMATION : <input

type="text" name="ani" size="10">

<input

type="submit" name="valider" value="Ajouter">

</h2>

<a href="frame_administration.php"><img src="img/retour.jpg" alt="retour" border="0" title="retour"/></a>

</body>

</html>

frame_ajouter_voyage.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Insertion voyage</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

</head>

<body>

<h1 align="center"> Ajouter un voyage</h1>

Page 7: Rapport Agence de voyage, Codes sources, Bazin Bernard Hardy

<h2>

<form action ="insertion_voyage.php" method="post">

<p>REFERENCE VOYAGE : <input type="text" name="ref" size="10">

<p>DATE DE DEPART : (aaaa-mm-jj hh-mm-ss) <input type="text" name="dep" size="10">

<p>DATE DE RETOUR : (aaaa-mm-jj hh-mm-ss) <input type="text" name="ret" size="10">

<p>PRIX : <input type="text"

name="prix" size="10">

<p>NUM_CIRCUIT : <input type="text" name="num_circuit" size="10">

<input

type="submit" name="valider" value="Ajouter">

</h2>

<a href="frame_administration.php"><img src="img/retour.jpg" alt="retour" border="0" title="retour"/></a>

</body>

</html>

Frame_central.html <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Agence de voyage</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

<style type="text/css">

<!--

body {

background-image: url(img/fond_contenu.jpg);

}

.style1 {font-size: 13px}

-->

</style>

</head>

<body>

<h4 align="center">Agence de voyage</h4>

<div align="center"><img src="img/accueil.jpg" alt="Accueil" title="Accueil" width=100%/>

<h2>Ce site est optimisé pour une résolution de 1280x800</h2>

</div>

</body>

</html>

frame_consulter_accompagnateur.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Consultation accompagnateur</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

</head>

<body>

<h1 align="center">Consultation des Accompagnateurs</h1>

<h2>

<div align="center">

<?php

$id=mysql_connect("spartacus","maxime_hardy","ookacica") or die ("PROBLEME");

$db=mysql_select_db("rt2_maxime_hardy",$id) or die ("PROBLEME");

$req4="select * from accompagnateur ";

$reponse=mysql_query($req4,$id) or die (mysql_error());

echo "<table border=2><tr><td>Num accompagnateur</td><td>Nom Accompagnateur</td><td>Prenom

Accompagnateur</td><td>salaire</td><td>Date de naissance</td><td>Date embauche</td></tr>";

while ($row=mysql_fetch_assoc($reponse)){

echo

"<tr><td>".$row['num_accompagnateur']."</td><td>".$row['nom_accompagnateur']."</td><td>".$row['prenom_accompagnateur']."</td>

<td>".$row['salaire']."</td><td>".$row['date_naissance']."</td><td>".$row['date_embauche']."</td></tr>";}

echo "</table>";

?>

Page 8: Rapport Agence de voyage, Codes sources, Bazin Bernard Hardy

</div>

</h2>

<a href="frame_administration.php"><img src="img/retour.jpg" alt="retour" border="0" title="retour"/></a>

</body>

</html>

frame_consulter_administrateur.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Consultation admin</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

</head>

<body>

<h1 align="center">Consultation des Administrateurs</h1>

<h2>

<div align="center">

<?php

$id=mysql_connect("spartacus","maxime_hardy","ookacica") or die ("PROBLEME");

$db=mysql_select_db("rt2_maxime_hardy",$id) or die ("PROBLEME");

$req4="select * from admin ";

$reponse=mysql_query($req4,$id) or die (mysql_error());

echo "<table border=2><tr><td>Login admin</td><td>Mot de passe admin</td></tr>";

while ($row=mysql_fetch_assoc($reponse)){

echo "<tr><td>".$row['num_admin']."</td><td>".$row['password_admin']."</td></tr>";}

echo "</table>";

?>

</div>

</h2>

<a href="frame_administration.php"><img src="img/retour.jpg" alt="retour" border="0" title="retour"/></a>

</body>

</html>

frame_consulter_circuit.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Consultation circuit</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

</head>

<body>

<h1 align="center">Consultation des Circuits</h1>

<h2>

<div align="center">

<?php

$id=mysql_connect("spartacus","maxime_hardy","ookacica") or die ("PROBLEME");

$db=mysql_select_db("rt2_maxime_hardy",$id) or die ("PROBLEME");

$req3="select * from circuit";

$reponse=mysql_query($req3,$id) or die (mysql_error());

echo "<table border=2><tr><td>Numero Circuit</td><td>Nom Circuit</td><td>Description</td><td>Nombre max de

personne</td><td>Duree (jours)</td><td>Nombre escale</td><td>Pays</td><td>Numero accompagnateur</td></tr>";

while ($row=mysql_fetch_assoc($reponse)){

echo

"<tr><td>".$row['num_circuit']."</td><td>".$row['nom_circuit']."</td><td>".$row['description']."</td><td>".$row['nb_max_personne']."<

/td><td>".$row['duree']."</td><td>".$row['nb_escale']."</td><td>".$row['nom_pays_circuit']."</td><td>".$row['num_accompagnateur']."

</td></tr>";}

Page 9: Rapport Agence de voyage, Codes sources, Bazin Bernard Hardy

echo "</table>";

?>

</div>

</h2>

<a href="frame_administration.php"><img src="img/retour.jpg" alt="retour" border="0" title="retour"/></a>

</body>

</html>

frame_consulter_escale.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Description</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

</head>

<body>

<h1 align="center">Consultation des Escales</h1>

<h2>

<div align="center">

<?php

$id=mysql_connect("spartacus","maxime_hardy","ookacica") or die ("PROBLEME");

$db=mysql_select_db("rt2_maxime_hardy",$id) or die ("PROBLEME");

$req="select * from escale";

$reponse=mysql_query($req,$id) or die (mysql_error());

echo "<table border=2 width=100%><tr><td>Numero Escale</td><td>Date jour arrivee</td><td>Date jour Depart</td><td>Nom

ville</td><td>Nom Pays</td><td>Activite</td><td>Type Hebergement</td><td>Ref herbergement</td><td>Numero Circuit</tr>";

while ($row=mysql_fetch_assoc($reponse)){

echo

"<tr><td>".$row['num_escale']."</td><td>".$row['date_jour_arrivee']."</td><td>".$row['date_jour_depart']."</td><td>".$row['nom_ville'

]."</td><td>".$row['nom_pays']."</td><td>".$row['activite']."</td><td>".$row['hebergement']."</td><td>".$row['ref_hotel']."</td><td>".

$row['num_circuit']."</td></tr>";}

echo"</table>";

?>

</h2>

<a href="frame_administration.php"><img src="img/retour.jpg" alt="retour" border="0" title="retour"/></a>

</body>

</html>

frame_consulter_hotel.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Consultation circuit</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

</head>

<body>

<h1 align="center">Consultation des Hotels</h1>

<h2>

<div align="center">

<?php

$id=mysql_connect("spartacus","maxime_hardy","ookacica") or die ("PROBLEME");

$db=mysql_select_db("rt2_maxime_hardy",$id) or die ("PROBLEME");

$req4="select * from hotel ";

$reponse=mysql_query($req4,$id) or die (mysql_error());

echo "<table border=2><tr><td>Ref hotel</td><td>Confort</td><td>Nom Hotel</td><td>Animation</td></tr>";

while ($row=mysql_fetch_assoc($reponse)){

echo

"<tr><td>".$row['ref_hotel']."</td><td>".$row['confort']."</td><td>".$row['nom_hotel']."</td><td>".$row['animation']."</td></tr>";}

echo "</table>";

?>

Page 10: Rapport Agence de voyage, Codes sources, Bazin Bernard Hardy

</div>

</h2>

<a href="frame_administration.php"><img src="img/retour.jpg" alt="retour" border="0" title="retour"/></a>

</body>

</html>

frame_consulter_voyage.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

<title>Consultation voyage</title>

</head>

<body>

<h1 align="center">Consultation des voyages</h1>

<h2>

<div align="center">

<?php

$id=mysql_connect("spartacus","maxime_hardy","ookacica") or die ("PROBLEME");

$db=mysql_select_db("rt2_maxime_hardy",$id) or die ("PROBLEME");

$req3="select * from voyage" ;

$reponse=mysql_query($req3,$id) or die (mysql_error());

echo "<table border=2><tr><td>Réfèrence Voyage</td><td>Date de départ</td><td>Date de retour</td><td>Prix</td><td>Numéro du

circuit</td></tr>";

while ($row=mysql_fetch_assoc($reponse)){

echo

"<tr><td>".$row['ref_voyage']."</td><td>".$row['date_depart']."</td><td>".$row['date_retour']."</td><td>".$row['prix']."

€"."</td><td>".$row['num_circuit']."</td></tr>";}

echo"</table>";

?>

</div>

</h2>

<a href="frame_administration.php"><img src="img/retour.jpg" alt="retour" border="0" title="retour"/></a>

</body>

</html>

frame_contatcs.html <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Contatcs</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

</head>

<body>

<h5 align="center">Contacts</h5>

<h2>

<div align="center">Agence de voyage Les 3 soleils<br>

<br>

Le sable fin<br>

14000 Caen<br>

<br>

Tel : 02.31.03.02.00<br>

<br>

Envoyer un email à l'agence :<br>

mail:[email protected]<br>

<a href="mailto:[email protected]">Ecrire un mail</a>

</div>

</body>

</html>

frame_gauche.html <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

Page 11: Rapport Agence de voyage, Codes sources, Bazin Bernard Hardy

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Agence de voyage</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

<style type="text/css">

<!--

body {

background-image: url(img/fond_cell_contenu.jpg);

}

.style1 {font-size: 13px}

-->

</style>

</head>

<body>

<!-- DEBUT MENU : MENU.HTML -->

<TABLE WIDTH="186" BORDER="0" CELLSPACING="0" CELLPADDING="0">

<TR>

<TD CLASS="titremenu"><a href="frame_central.html" target="mainFrame">Accueil</a></TD>

</TR>

</TABLE>

<!-- DEBUT MENU : MENU.HTML -->

<!-- DEBUT MENU : MENU.HTML -->

<TABLE WIDTH="186" BORDER="0" CELLSPACING="0" CELLPADDING="0">

<TR>

<TD CLASS="titremenu">Voyages</TD>

</TR>

<TR>

<TD CLASS="itemmenu"><A HREF="recherche_france.php" target="mainFrame"

CLASS="menu">En France</A></TD>

</TR>

<TR>

<TD CLASS="itemmenu"><A HREF="recherche_etranger.php" target="mainFrame"

CLASS="menu">A l'etranger</A></TD>

</TR>

<TR>

<TD CLASS="itemmenu"><A HREF="frame_contatcs.html" target="mainFrame"

CLASS="menu">Contacts</A></TD>

</TR>

<TR>

<TD CLASS="basmenu">&nbsp;</TD>

</TR>

</TABLE>

<br>

<!-- DEBUT MENU : MENU.HTML -->

<br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>

<br>

<a href="frame_admin.html" target="mainFrame" ><img src="img/administrateur.gif" alt="Lien Admin" border="0" title="Lien admin"

/></a>

</body>

</html>

frame_haut.html <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

Page 12: Rapport Agence de voyage, Codes sources, Bazin Bernard Hardy

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Agence de voyage</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

<style type="text/css">

<!--

body {

background-image: url(img/fond_bandeau_haut.jpg);

}

.style1 {font-size: 13px}

-->

</style>

</head>

<body>

</body>

</html>

frame_reservation.php <?php

$id=mysql_connect("spartacus","maxime_hardy","ookacica") or die ("PROBLEME");

$db=mysql_select_db("rt2_maxime_hardy",$id) or die ("PROBLEME");

$req="select num_circuit , nom_circuit from circuit";

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Réserver un voyage</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

</head>

<body>

<h1 align="center">Voyage en France</h1>

<div id="espace client, recherche circuit en France">

<div align="center"><strong><br/>

<h1>Réservation</h1></strong><br/>

<br/>

<?php

$reponse=mysql_query($req,$id) or die (mysql_error());

echo " <form action='reserv_voyage.php' method='post'>

<select name='num_circuit'>\n";

?></div>

<?php

while ($ligne = mysql_fetch_array($reponse)){

extract($ligne);

if($nom_circuit<>"")

echo "<option value='".$num_circuit."'>$nom_circuit</option>\n";

}

echo "</select>\n";

echo "<td><input type='submit'","value=\"Réserver ce voyage\"></td></form>\n";

?>

</body>

</html>

frame_supprimer_accompagnateur.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Suppresion accompagnateur</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

</head>

<body>

Page 13: Rapport Agence de voyage, Codes sources, Bazin Bernard Hardy

<h1 align="center">Suppression d'Accompagnateurs</h1>

<h2>

<div align="center">

<?php

$id=mysql_connect("spartacus","maxime_hardy","ookacica") or die ("PROBLEME");

$db=mysql_select_db("rt2_maxime_hardy",$id) or die ("PROBLEME");

$req4="select * from accompagnateur ";

$reponse=mysql_query($req4,$id) or die (mysql_error());

echo "<table border=2><tr><td>Num accompagnateur</td><td>Nom Accompagnateur</td><td>Prenom

Accompagnateur</td><td>salaire</td><td>Date de naissance</td><td>Date embauche</td></tr>";

while ($row=mysql_fetch_assoc($reponse)){

echo

"<tr><td>".$row['num_accompagnateur']."</td><td>".$row['nom_accompagnateur']."</td><td>".$row['prenom_accompagnateur']."</td>

<td>".$row['salaire']."</td><td>".$row['date_naissance']."</td><td>".$row['date_embauche']."</td></tr>";}

echo "</table>";

?>

<form action ="suppression_accompagnateur.php" method="post">

<p>NUMERO DE L ACCOMPAGNATEUR <input type="text" name="num" size="10">

<input

type="submit" name="valider" value="Supprimer">

</div>

</h2>

<a href="frame_administration.php"><img src="img/retour.jpg" alt="retour" border="0" title="retour"/></a>

</body>

</html>

frame_supprimer_administrateur.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Suppresion administrateur</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

</head>

<body>

<h1 align="center">Suppression d'administrateurs</h1>

<h2>

<div align="center">

<?php

$id=mysql_connect("spartacus","maxime_hardy","ookacica") or die ("PROBLEME");

$db=mysql_select_db("rt2_maxime_hardy",$id) or die ("PROBLEME");

$req4="select * from admin ";

$reponse=mysql_query($req4,$id) or die (mysql_error());

echo "<table border=2><tr><td>Login admin</td><td>Mot de passe admin</td></tr>";

while ($row=mysql_fetch_assoc($reponse)){

echo "<tr><td>".$row['num_admin']."</td><td>".$row['password_admin']."</td></tr>";}

echo "</table>";

?>

<form action ="suppression_administrateur.php" method="post">

<p>NUMERO DE L ADMINISTRATEUR <input type="text" name="num" size="10">

<input

type="submit" name="valider" value="Supprimer">

</div>

</h2>

<a href="frame_administration.php"><img src="img/retour.jpg" alt="retour" border="0" title="retour"/></a>

</body>

</html>

frame_supprimer_circuit.php

Page 14: Rapport Agence de voyage, Codes sources, Bazin Bernard Hardy

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Suppresion circuit</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

</head>

<body>

<h1 align="center">Suppression de circuits</h1>

<h2>

<div align="center">

<?php

$id=mysql_connect("spartacus","maxime_hardy","ookacica") or die ("PROBLEME");

$db=mysql_select_db("rt2_maxime_hardy",$id) or die ("PROBLEME");

$req3="select * from circuit";

$reponse=mysql_query($req3,$id) or die (mysql_error());

echo "<table border=2><tr><td>Numero Circuit</td><td>Nom Circuit</td><td>Description</td><td>Nombre max de

personne</td><td>Duree (jours)</td><td>Nombre escale</td></tr>";

while ($row=mysql_fetch_assoc($reponse)){

echo

"<tr><td>".$row['num_circuit']."</td><td>".$row['nom_circuit']."</td><td>".$row['description']."</td><td>".$row['nb_max_personne']."<

/td><td>".$row['duree']."</td><td>".$row['nb_escale']."</td></tr>";}

echo "</table>";

?>

<form action ="suppression_circuit.php" method="post">

<p>NUMERO DU CIRCUIT <input type="text" name="num" size="10">

<input type="submit"

name="valider" value="Supprimer">

</div>

</h2>

<a href="frame_administration.php"><img src="img/retour.jpg" alt="retour" border="0" title="retour"/></a>

</body>

</html>

frame_supprimer_escale.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Untitled Document</title>

</head>

<body>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Suppresion voyage</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

</head>

<body>

<h1 align="center">Suppression d'escales</h1>

<h2>

<div align="center">

<?php

$id=mysql_connect("spartacus","maxime_hardy","ookacica") or die ("PROBLEME");

$db=mysql_select_db("rt2_maxime_hardy",$id) or die ("PROBLEME");

$req="select * from escale";

$reponse=mysql_query($req,$id) or die (mysql_error());

echo "<table border=2 width=100%><tr><td>Numero Escale</td><td>Date jour arrivee</td><td>Date jour Depart</td><td>Nom

ville</td><td>Nom Pays</td><td>Activite</td><td>Type Hebergement</td><td>Ref herbergement</td></tr>";

while ($row=mysql_fetch_assoc($reponse)){

Page 15: Rapport Agence de voyage, Codes sources, Bazin Bernard Hardy

echo

"<tr><td>".$row['num_escale']."</td><td>".$row['date_jour_arrivee']."</td><td>".$row['date_jour_depart']."</td><td>".$row['nom_ville'

]."</td><td>".$row['nom_pays']."</td><td>".$row['activite']."</td><td>".$row['hebergement']."</td><td>".$row['ref_hotel']."</td></tr>";

}

echo"</table>";

?>

<form action ="suppression_escale.php" method="post">

<p>NUMERO DE L ESCALE <input type="text" name="num" size="10">

<input type="submit"

name="valider" value="Supprimer">

</div>

</h2>

<a href="frame_administration.php"><img src="img/retour.jpg" alt="retour" border="0" title="retour"/></a>

</body>

</html>

</body>

</html>

frame_supprimer_hotel.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Suppresion hotel</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

</head>

<body>

<h1 align="center">Suppression d'hotels</h1>

<h2>

<div align="center">

<?php

$id=mysql_connect("spartacus","maxime_hardy","ookacica") or die ("PROBLEME");

$db=mysql_select_db("rt2_maxime_hardy",$id) or die ("PROBLEME");

$req4="select * from hotel ";

$reponse=mysql_query($req4,$id) or die (mysql_error());

echo "<table border=2><tr><td>Ref hotel</td><td>Confort</td><td>Nom Hotel</td><td>Animation</td></tr>";

while ($row=mysql_fetch_assoc($reponse)){

echo

"<tr><td>".$row['ref_hotel']."</td><td>".$row['confort']."</td><td>".$row['nom_hotel']."</td><td>".$row['animation']."</td></tr>";}

echo "</table>";

?>

<form action ="suppression_hotel.php" method="post">

<p>REFERENCE DE L HOTEL <input type="text" name="ref" size="10">

<input type="submit"

name="valider" value="Supprimer">

</div>

</h2>

<a href="frame_administration.php"><img src="img/retour.jpg" alt="retour" border="0" title="retour"/></a>

</body>

</html>

frame_supprimer_voyage.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Suppresion voyage</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

</head>

Page 16: Rapport Agence de voyage, Codes sources, Bazin Bernard Hardy

<body>

<h1 align="center">Suppression des voyages</h1>

<h2>

<div align="center">

<?php

$id=mysql_connect("spartacus","maxime_hardy","ookacica") or die ("PROBLEME");

$db=mysql_select_db("rt2_maxime_hardy",$id) or die ("PROBLEME");

$req3="select * from voyage" ;

$reponse=mysql_query($req3,$id) or die (mysql_error());

echo "<table border=2><tr><td>Réfèrence Voyage</td><td>Date de départ</td><td>Date de retour</td><td>Prix</td><td>Numéro du

circuit</td></tr>";

while ($row=mysql_fetch_assoc($reponse)){

echo

"<tr><td>".$row['ref_voyage']."</td><td>".$row['date_depart']."</td><td>".$row['date_retour']."</td><td>".$row['prix']."

€"."</td><td>".$row['num_circuit']."</td></tr>";}

echo"</table>";

?>

<form action ="suppression_voyage.php" method="post">

<p>REFERENCE DU VOYAGE <input type="text" name="ref" size="10">

<input type="submit"

name="valider" value="Supprimer">

</div>

</h2>

<a href="frame_administration.php"><img src="img/retour.jpg" alt="retour" border="0" title="retour"/></a>

</body>

</html>

index.html <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Frameset//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-frameset.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Untitled Document</title>

</head>

<frameset rows="84,*" cols="*" framespacing="3" frameborder="yes" border="3" bordercolor="#000000">

<frame src="frame_haut.html" name="topFrame" scrolling="No" noresize="noresize" id="topFrame" title="topFrame" />

<frameset rows="*" cols="197,*" framespacing="3" frameborder="yes" border="3" bordercolor="#000000">

<frame src="frame_gauche.html" name="leftFrame" scrolling="No" noresize="noresize" id="leftFrame" title="leftFrame" />

<frame src="frame_central.html" name="mainFrame" id="mainFrame" title="mainFrame" />

</frameset>

</frameset>

<noframes><body>

</body>

</noframes></html>

recherche_etranger.php <?php

$id=mysql_connect("spartacus","maxime_hardy","ookacica") or die ("PROBLEME");

$db=mysql_select_db("rt2_maxime_hardy",$id) or die ("PROBLEME");

$req="select num_circuit , nom_circuit from circuit where nom_pays_circuit!='france'";

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Rechercher un voyage à l'étranger</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

</head>

<body>

<h5 align="center">Voyages à l'etranger</h5>

<div id="espace client, recherche circuit en France">

<div align="center"><strong><br/>

<h1>Choisissez votre circuit : </h1></strong><br/>

Page 17: Rapport Agence de voyage, Codes sources, Bazin Bernard Hardy

<br/>

<?php

$reponse=mysql_query($req,$id) or die (mysql_error());

echo " <form action='description_voyage.php' method='post'>

<select name='num_circuit'>\n";

?></div>

<?php

while ($ligne = mysql_fetch_array($reponse)){

extract($ligne);

if($nom_circuit<>"")

echo "<option value='".$num_circuit."'>$nom_circuit</option>\n";

}

echo "</select>\n";

echo "<td><input type='submit'","value=\"choisir ce circuit\"></td></form>\n";

?>

<p><div align="center"><img src="img/monde.jpg" alt="carte monde" border="0" title="monde"/></p>

</body>

</html>

recherche_france.php <?php

$id=mysql_connect("spartacus","maxime_hardy","ookacica") or die ("PROBLEME");

$db=mysql_select_db("rt2_maxime_hardy",$id) or die ("PROBLEME");

$req="select num_circuit , nom_circuit from circuit where nom_pays_circuit='france'";

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Rechercher un voyage en France</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

</head>

<body>

<h5 align="center">Voyage en France</h5>

<div id="espace client, recherche circuit en France">

<div align="center"><strong><br/>

<h1>Choisissez votre circuit : </h1></strong><br/>

<br/>

<?php

$reponse=mysql_query($req,$id) or die (mysql_error());

echo " <form action='description_voyage.php' method='post'>

<select name='num_circuit'>\n";

?></div>

<?php

while ($ligne = mysql_fetch_array($reponse)){

extract($ligne);

if($nom_circuit<>"")

echo "<option value='".$num_circuit."'>$nom_circuit</option>\n";

}

echo "</select>\n";

echo "<td><input type='submit'","value=\"choisir ce circuit\"></td></form>\n";

?>

<p><div align="center"><img src="img/france.jpg" alt="carte france" border="0" title="france"/></p>

</div>

</body>

</html>

reserv_voyage.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

Page 18: Rapport Agence de voyage, Codes sources, Bazin Bernard Hardy

<title>Procédure de réservation</title>

<link rel="stylesheet" type="text/css" href="style_defaut.css" />

</head>

<body>

<h1 align="center">Procédure de réservation</h1>

<h2>

<div align="center">Pour réserver un voyage, vous devez imprimer la page de desciption du voyage que vous désirez, en indiquant au verso

:

<h2>

</div>

<ul><li>Le nombre de personne</li>

<li>Vos coordonnées postales</li>

<li>Un numéro de téléphone</li>

<li>Le mode de paiement</li></ul>

<br>Veuillez nous envoyer ces informations dans une enveloppe affranchie à l'adresse suivante :

<p>

Agence de voyage les trois soleils<br>

Le sable fin<br>

14000 Caen</p>

<p>Pour tout renseignementn veuillez nous contacter au numéro suivant :<br>

Tel : 02.31.03.02.00

</p>

</h2>

</body>

</html>

style_defaut.css /* Definition de regle */

@charset "iso-8859-1";

BODY {font-family: Verdana, sans-serif; background-image: url(img/fond_page.gif); margin-top: 0px; margin-right: 0px; margin-bottom:

0px; margin-left: 0px; scrollbar-face-color: #000000; scrollbar-highlight-color: #A8AFC5; scrollbar-shadow-color: #A8AFC5; scrollbar-

3dlight-color: #000000; scrollbar-arrow-color: #A8AFC5; scrollbar-track-color: #101938; scrollbar-darkshadow-color: #7D8E9D;}

H1 {font-family: Verdana, sans-serif; color: #FFDA00; font-size: 10pt; font: bold; text-indent: 25; text-transform: uppercase}

H2 {font-family: Verdana, sans-serif; color: #FFFFFF; font-size: 10pt; font: bold small-caps;}

H3 {font-family: Verdana, sans-serif; color: #FFFFFF; font-size: 10pt; font: normal italic}

H4 {font-family: Verdana, sans-serif; color: #FFDA00; font-size: 20pt; font: bold; text-indent: 25; text-transform: uppercase}

H5 {font-family: Verdana, sans-serif; color: #FFDA00; font-size: 15pt; font: bold; text-indent: 25; text-transform: uppercase}

.HR {color:#FFFFFF; height: 1px; width: 50%; text-align: center}

UL {list-style: square none;}

UL.deux {list-style: disc none;}

UL.trois {list-style: circle none;}

INPUT {font-family: Verdana, sans-serif; font-size: xx-small; color: #FFFFFF; background: #6587B0;}

INPUT.radio {background: #131A30;}

SELECT {font-family: Verdana, sans-serif; font-size: xx-small; color: #FFFFFF; background: #6587B0;}

TEXTAREA {font-family: Verdana, sans-serif; font-size: xx-small; color: #FFFFFF; background: #6587B0;}

.titre {font-family: Verdana, sans-serif; color: #FFDA00; font-size: 10pt; font: bold}

.jaune {color: #FFDA00;}

.lien_menu {position: relative; top: -2px; color: #FFFFFF; font-size: 8pt; font-family: verdana; font-weight: bold; letter-spacing: -1pt; text-

decoration: none;}

Page 19: Rapport Agence de voyage, Codes sources, Bazin Bernard Hardy

.divise_menu {position: relative; top: 0px; color: #C0C0C0; background: #000000; font-size: 12pt;}

.justifie {text-align: justify;}

TD {font-family: Verdana, sans-serif; font-size: 8pt; color: #FFFFFF;}

TD.bandeauhaut {background-image: url(img/fond_bandeau_haut.jpg); background-repeat: no-repeat; height: 86px; white-space:

nowrap;}

TD.barrenoire {background-image: url(img/fond_23px.gif); height: 23px; padding-left: 12px;}

TD.barrenoirenoire {background-image: url(img/barrenoire.gif); height: 23px; padding-left: 12px;}

TD.titremenu {font-family: Verdana, sans-serif; font-size: 8pt; color: #000000; font-weight: bold; background-image:

url(img/fond_titre_menu.gif); background-repeat: no-repeat; padding-left: 12px; height: 23px;}

TD.itemmenu {background-image: url(img/fond_item_menu.gif); background-repeat: no-repeat; height: 31px; padding-left: 12px;}

TD.basmenu {background-image: url(img/fond_bas_menu.gif); background-repeat: no-repeat; height: 31px; padding-left: 12px;}

TD.droite {width: 100%; padding-top: 14px; padding-left: 17px; padding-right: 17px; vertical-align: top;}

TABLE.tablecontenu {background-image: url(img/fond_contenu.jpg); background-repeat: no-repeat; white-space: nowrap; width: 100%;}

TABLE.contourrubrique {border: 1px solid #6587B0;}

TD.titrerubrique {font-family: Verdana, sans-serif; font-size: 8pt; color: #000000; font-weight: bold; background-image:

url(img/fond_titre_rub.gif); white-space: nowrap; width: 100%; height: 19px;}

TD.titretableau {text-indent: 2; font-family: Verdana, sans-serif; font-size: 8pt; color: #FFDA00; font-weight: bold; background-image:

url(img/fond_titre_tableau.jpg); white-space: nowrap; height: 16px}

TD.contenurubrique {font-family: Verdana, sans-serif; font-size: 8pt; color: #FFFFFF; background: #101938; background-image:

url(img/fond_cell_contenu.jpg); background-repeat: no-repeat; width: 100%; height: 19px; padding: 20px;}

TD.basrubrique {background-image: url(img/fond_bas_rub.gif); height: 6px; text-align: right;}

TD.bordblanc {border-right: #FFF 1px solid;}

TD.tablo {text-decoration:none; padding-top: 9px; padding-left: 17px; padding-right: 17px; vertical-align: top;}

A {font-family: Verdana, sans-serif; font-size: 8pt; color: #FFFFFF; text-decoration: underline;}

A:hover {font-family: Verdana, sans-serif; font-size: 8pt; color: #FFD400; text-decoration: underline;}

A.menu {font-family: Verdana, sans-serif; font-size: 8pt; color: #FFFFFF; text-decoration: none;}

A.menu:hover {font-family: Verdana, sans-serif; font-size: 8pt; color: #FFFFFF; text-decoration: underline;}

A.lienrub {font-family: Verdana, sans-serif; font-size: 8pt; color: #CCCCCC; text-decoration: none; font-weight: bold;}

A.lienrub:hover {font-family: Verdana, sans-serif; font-size: 8pt; color: #FFDA00; text-decoration: underline; font-weight: bold;}

/* Fin de la section de style genere par WebExpert le 18/02/2005 14:38:37 */

Certains codes sources ne sont pas la dernière version implantée sur le site web tel que le fichier de

modification des bases par l’administrateur pour le test des erreurs.