[insert_php]
$h_innr = $_REQUEST[‘search’];
// echo “ID “;
// echo $h_innr;
// echo “
“;
// echo “
“;
$servername = “localhost”;
$username = “corvetteex_usr”;
$password = “corvettez06”;
// Create connection
$con=mysqli_connect(“localhost”,”corvetteex_usr”,”corvettez06″,”corvetteex_db”);
if (mysqli_connect_errno()) {
echo “Failed to connect to MySQL: ” . mysqli_connect_error();
} else {
// echo “(Connection To Database OK!) ” ;
// $nowtime = date(“Y-m-d H:i:s”);
// $cortime = date(‘Y-m-d H:i:s’, strtotime($nowtime . ‘ + 120 minute’));
// echo $cortime;
// echo ““;
// echo “
“;
}
// ———————————————————
$h_taal = $_POST[’taal’];
// ———————————————————taal
switch ($h_taal) {
case “Francais”:
$h_string = “Vous avez réservé avec les informations suivantes : “;
break;
case “English”:
$h_string = “You made a reservation with the following information : “;
break;
default:
$h_string = “U reserveerde met volgende gegevens : “;
}
echo $h_string ;
echo “
“;
// ———————————————————id
$result = mysqli_query($con,”SELECT * FROM reservations where id=$h_innr”);
while($row = mysqli_fetch_array( $result ))
{
$h_status = $row[‘status’];
echo “
“;
$h_id = $row[‘id’];
switch ($h_taal) {
case “Francais”:
$h_string = “Reservation-ID : “;
break;
case “English”:
$h_string = “Reservation-ID : “;
break;
default:
$h_string = “Reservatie-ID : “;
}
echo $h_string . $h_id;
echo “
“;
// ———————————————————datum
$h_datum = $row[‘datum’];
switch ($h_taal) {
case “Francais”:
$h_string = “Date : “;
break;
case “English”:
$h_string = “Date : “;
break;
default:
$h_string = “Datum : “;
}
echo $h_string . $h_datum;
echo “
“;
// ———————————————————uur
$h_uur = $row[‘uur’];
switch ($h_taal) {
case “Francais”:
$h_string = “Heure : “;
break;
case “English”:
$h_string = “Hour : “;
break;
default:
$h_string = “Uur : “;
}
echo $h_string . $h_uur;
echo “
“;
// ———————————————————wagen
$h_auto = $row[‘auto’];
}
// ———————————————————taal
$h_taal = $_POST[’taal’];
switch ($h_taal) {
case “Francais”:
$h_string = “Langue : “;
break;
case “English”:
$h_string = “Language : “;
break;
default:
$h_string = “Taal : “;
}
echo $h_string . $h_taal;
echo “
“;
// ———————————————————pas/pil
$h_pilo .= $_POST[“pilo”];
switch ($h_taal) {
case “Francais”:
$h_string = “Pilot/Passager : “;
break;
case “English”:
$h_string = “Pilot/Passenger : “;
break;
default:
$h_string = “Piloot/Passagier : “;
}
echo $h_string . $h_pilo;
echo “
“;
// ———————————————————voornaam
$h_vona = $_POST[‘vona’];
switch ($h_taal) {
case “Francais”:
$h_string = “Prénom : “;
break;
case “English”:
$h_string = “First Name : “;
break;
default:
$h_string = “Voornaam : “;
}
echo $h_string . $h_vona;
echo “
“;
// ———————————————————achternaam
$h_acna = $_POST[‘acna’];
switch ($h_taal) {
case “Francais”:
$h_string = “Nom de famille : “;
break;
case “English”:
$h_string = “Last Name : “;
break;
default:
$h_string = “Achternaam : “;
}
echo $h_string . $h_acna;
echo “
“;
// ———————————————————adres
$h_adre .= $_POST[“adre”];
switch ($h_taal) {
case “Francais”:
$h_string = “Adresse : “;
break;
case “English”:
$h_string = “Address : “;
break;
default:
$h_string = “Adres : “;
}
echo $h_string . $h_adre;
echo “
“;
// ———————————————————postnummer
$h_ponr .= $_POST[“ponr”];
switch ($h_taal) {
case “Francais”:
$h_string = “Numéro postal : “;
break;
case “English”:
$h_string = “ZipCode : “;
break;
default:
$h_string = “Postnummer : “;
}
echo $h_string . $h_ponr;
echo “
“;
// ———————————————————plaats
$h_plts .= $_POST[“plts”];
switch ($h_taal) {
case “Francais”:
$h_string = “Ville : “;
break;
case “English”:
$h_string = “City : “;
break;
default:
$h_string = “Plaats : “;
}
echo $h_string . $h_plts;
echo “
“;
// ———————————————————gsm
$h_gsmn .= $_POST[“gsmn”];
switch ($h_taal) {
case “Francais”:
$h_string = “Téléphone : “;
break;
case “English”:
$h_string = “Phone : “;
break;
default:
$h_string = “Telefoon : “;
}
echo $h_string . $h_gsmn;
echo “
“;
// ———————————————————email
$h_emai .= $_POST[“emai”];
switch ($h_taal) {
case “Francais”:
$h_string = “E-Mail : “;
break;
case “English”:
$h_string = “E-Mail : “;
break;
default:
$h_string = “E-Mail : “;
}
echo $h_string . $h_emai;
echo “
“;
// ———————————————————geboortedatum
$h_gdat .= $_POST[“gdat”];
switch ($h_taal) {
case “Francais”:
$h_string = “Date de naissance : “;
break;
case “English”:
$h_string = “Date of birth : “;
break;
default:
$h_string = “Geboortedatum : “;
}
echo $h_string . $h_gdat;
echo “
“;
// ———————————————————formule
$h_form .= $_POST[“form”];
switch ($h_taal) {
case “Francais”:
$h_string = “Formule : “;
break;
case “English”:
$h_string = “Formula : “;
break;
default:
$h_string = “Formule : “;
}
echo $h_string . $h_form;
echo “
“;
// ———————————————————bonnummer
$h_bonn .= $_POST[“bonn”];
switch ($h_taal) {
case “Francais”:
$h_string = “Numéro de bon : “;
break;
case “English”:
$h_string = “Voucher number : “;
break;
default:
$h_string = “Bonnummer : “;
}
echo $h_string . $h_bonn;
echo “
“;
// ———————————————————verval-bon
$h_verv .= $_POST[“verv”];
switch ($h_taal) {
case “Francais”:
$h_string = “Date d’expiration bon : “;
break;
case “English”:
$h_string = “Expiration date voucher : “;
break;
default:
$h_string = “Vervaldatum bon : “;
}
echo $h_string . $h_verv;
echo “
“;
// ———————————————————opmerking
$h_opme .= $_POST[“opme”];
switch ($h_taal) {
case “Francais”:
$h_string = “Note : “;
break;
case “English”:
$h_string = “Remark : “;
break;
default:
$h_string = “Opmerking : “;
}
echo $h_string . $h_opme;
echo “
“;
echo “
“;
// ———————————————————knop ok
switch ($h_taal) {
case “Francais”:
$h_string = “Appuyez sur OK pour confirmer votre réservation “;
break;
case “English”:
$h_string = “Press OK to confirm your reservation “;
break;
default:
$h_string = “Druk OK om je reservatie te bevestigen “;
}
echo “
“;
echo “
“;
echo “
“;
[/insert_php]