<?php
require "connectAD.php";
//recupération des variables
$trnNum = $_GET['TRNNUM'];
$lieu = $_GET['lieu'];
$hreMin = $_GET['hreMin'] . ":00.000000";
//Permet la convertion au format datetime de la BDD
$hreMax = $_GET['hreMax'] . ":00.000000";
//Permet la convertion au format datetime de la BDD
$etpFin = $_GET['etpFin'] . ":00.000000";
//Permet la convertion au format datetime de la BDD
$commentaire = $_GET['commentaire'];
if (verificationHorraire($hreMin, $hreMax, $etpFin, "ac13", $trnNum) == false) {
/*echo "<meta http-equiv='refresh' content='0;url=ac13.php?message=<font color=red>Formulaire rempli de manière incorrecte.</font>'>";*/
} else {
//recuperation du plus grand ETPID pour la tournée en question :
$sql = "select ETPID from etape where TRNNUM = " . $trnNum . "; ";
echo $sql . "<br/>";
$etpid = compteSQL($sql);
echo "etpid = {$etpid}<br />";
$etpid += 1;
echo "<br/>" . $etpid . "<br/>";
//requete de remplissage de la table etape (partie AC13, donc incomplete) :
$sql = "INSERT INTO etape(`TRNNUM`, `ETPID`, `LIEUID`, `ETPHREMIN`, `ETPHREMAX`, `ETPHREFIN`, `ETPCOMMENTAIRE`) \n\t\t\t\tVALUES ({$trnNum}, {$etpid} , {$lieu} ,' {$hreMin} ',' {$hreMax} ', ' {$etpFin} ', ' {$commentaire} ');";
$result = executeSQL($sql);
//redirection vers la page de creation de tournée :
echo "<meta http-equiv='refresh' content='0;url=ac12.php?TRNNUM=" . $trnNum . "'>";
}
<?php
include 'date/date_V2.0.php';
?>
</time>
</div>
</header>
<div class="meta">
<section>
<form method="get" action="ac13.php">
<center><h2>ETAPES</h2></center>
<hr>
<?php
include 'connectAD.php';
if (empty($_GET['TRNNUM'])) {
$sql3 = "select TRNNUM from `tournee` ORDER BY TRNNUM";
$result3 = compteSQL($sql3);
if ($result3 == 0) {
$TRNNUM = 1;
} else {
$resultat = tableSQL($sql3);
$result3 -= 1;
$TRNNUM = $resultat[$result3]['0'];
$TRNNUM += 1;
}
} else {
$TRNNUM = $_GET['TRNNUM'];
}
// on crée la requête SQL
$sql = 'SELECT `ETPID`, `LIEUNOM`
FROM etape
INNER JOIN lieu
