<?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