function getRequetes($from, $conn) { $req = "SELECT distinct(count(*)) from {$from}"; $cur = PreparerRequete($conn, $req); $r = ExecuterRequete($cur); $return = oci_fetch_array($cur); oci_free_statement($cur); return $return; }
$pagination = 100; // Numéro du 1er enregistrement à lire $limit_start = ($page - 1) * $pagination; // Numéro du dernier enregistrement à lire $limit_stop = $limit_start + $pagination; //Requete a executer $req = "SELECT * FROM tdf_coureur where n_coureur > {$limit_start} and n_coureur <= {$limit_stop} order by n_coureur"; } else { $req = "SELECT * FROM tdf_coureur order by n_coureur"; } } $cur = PreparerRequete($conn, $req); $r = ExecuterRequete($cur); //Utile pour le nombre de pages a afficher $req = "SELECT count(*) FROM tdf_coureur"; $cur_nb = PreparerRequete($conn, $req); $r = ExecuterRequete($cur_nb); $nb_coureurs = oci_fetch_array($cur_nb, OCI_BOTH); $pages = $nb_coureurs[0] / 19; ?> <html lang="fr"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="description" content=""> <meta name="author" content=""> <title>Coureurs - Visualisations</title>
?> <script>window.alert("Champ(s) Invalide(s) ( Incomplet(s) ou Vide(s) )");</script><?php echo ""; } } else { if (isset($_POST["annuler"])) { header("location:form_coureur_look.php"); } } $selec_suppr = 'SELECT * FROM tdf_coureur WHERE N_COUREUR=\'' . $_POST['n_coureur'] . '\''; $cur = PreparerRequete($conn, $selec_suppr); $res = ExecuterRequete($cur); // Attention, pas &$nbLignes $nbLignes = LireDonneesCoureur($cur, $tab); $req_pays = 'SELECT code_tdf,nom FROM tdf_pays order by nom'; $cur = PreparerRequete($conn, $req_pays); $res = ExecuterRequete($cur); // Attention, pas &$nbLignes $nbLignesPays = LireDonneesPays($cur, $tab_pays); ?> <table style="margin:auto"><tr><td colspan=5 style="text-align:center;font-weight:bold;padding-bottom:30px">Modification du Coureur</td></tr> <tr><td>N° COUREUR : </td><td><?php echo $tab[0][0]; ?> </td> <form action="<?php $_SERVER['PHP_SELF']; ?> " method="POST">
<?php include "../Core/header.html"; ?> <title>Formulaire Consultation Epreuve</title> <h1 style='font-variant:small-caps'>Consultation des Epreuves de la Base</h1> <?php include "../Fonctions/fonc_oracle.php"; include "../Core/log_bdd.php"; $conn = OuvrirConnexion($login, $mdp, $instance); $req_epreuve = 'SELECT * FROM tdf_epreuve order by annee desc,n_epreuve'; $cur = PreparerRequete($conn, $req_epreuve); $res = ExecuterRequete($cur); // Attention, pas &$nbLignes $nbLignes = LireDonneesEpreuve($cur, $tab_epreuve); ?> <table style="margin:auto"> <tr style="font-weight:bold"><td >ANNEE</td><td align="center">N_EPREUVE</td><td>DEPART</td><td>ARRIVEE</td><td>DISTANCE</td><td>MOYENNE</td><td>TDF DEPART</td><td>TDF ARRIVEE</td><td>JOUR</td><td style="text-align:center">CAT CODE</td><td colspan="2">OPERATIONS</td></tr> <?php foreach ($tab_epreuve as $i) { echo "<tr><td>{$i['0']}</td><td align='center'>{$i['1']}</td><td>" . $i[2] . "</td><td>{$i['3']}</td><td>{$i['4']}</td><td>{$i['5']}</td><td>{$i['6']}</td><td>{$i['7']}</td><td>{$i['8']}</td><td style=\"text-align:center\">{$i['9']}</td>"; ?> <?php /*<form action="modif_coureur.php" method='POST'><td><input type='submit' name='modif' value='Modifier'/><?php echo "<input type=\"hidden\" name=\"n_coureur\" value=\"$i[0]\";/>"?></td></form> <form action="confirm_suppr_coureur.php" method='POST'><td><input type='submit' name='modif' value='Supprimer'/><?php echo "<input type=\"hidden\" name=\"n_coureur\" value=\"$i[0]\";/>"?></td></form> */ ?> <form action="form_epreuve_operation.php" method='POST'><td><input type='submit' name='modifier' value='Modifier'/><?php echo "<input type=\"hidden\" name=\"annee\" value=\"{$i['0']}\"/><input type=\"hidden\" name=\"n_epreuve\" value=\"{$i['1']}\"/>";
$tab_verif = verif_inser_coureur($_POST['nom'], $_POST['prenom'], $_POST['anneeNaiss'], $_POST['pays'], $_POST['anneeTDF']); if ($tab_verif[0]) { $req_numero = 'SELECT max(N_COUREUR) as num_max from tdf_coureur'; $cur = PreparerRequete($conn, $req_numero); $res = ExecuterRequete($cur); // Attention, pas &$nbLignes $nbLignes = LireDonnees1($cur, $tab); $n_coureur = $tab['NUM_MAX'][0] + 5; $req_inser = 'INSERT INTO tdf_coureur (N_COUREUR,NOM,PRENOM,ANNEE_NAISSANCE,CODE_TDF,ANNEE_TDF) values (' . $n_coureur . ',\'' . $tab_verif[1] . '\',\'' . $tab_verif[2] . '\',' . $tab_verif[3] . ',\'' . $tab_verif[4] . '\',' . $tab_verif[5] . ')'; if (!exist_coureur_inser($tab_verif[1], $tab_verif[2], $tab_verif[4])) { $cur = PreparerRequete($conn, $req_inser); $res = ExecuterRequete($cur); // Attention, pas &$nbLignes $req_commit = 'COMMIT'; $cur = PreparerRequete($conn, $req_commit); $res = ExecuterRequete($cur); ?> <script>window.alert("Coureur inséré dans la base");</script><?php header("location:form_coureur_look.php"); } else { ?> <script>window.alert("Coureur déjà présent dans la base");</script><?php echo ""; } } else { ?> <script>window.alert("Champ(s) Invalide(s) ( Incomplet(s) ou Vide(s) )");</script><?php echo ""; } }
// Si passé Juillet --> On incrémente l'année actuel if (date('m') < 7) { $year = date('Y'); } else { $year = date('Y') + 1; } $stid = oci_parse($conn, "SELECT distinct annee from tdf_annee where annee >= {$year} order by annee"); oci_execute($stid); echo 'Année : <select class="form-control" name="year" required >' . "\n"; while (($row = oci_fetch_array($stid, OCI_BOTH)) != false) { echo '<option value="' . $row[0] . '">' . $row[0]; echo '</option>'; } echo '</select><br/>'; //N_SPONSOR $cur = PreparerRequete($conn, "SELECT max(N_SPONSOR)+1 from tdf_sponsor"); $r = ExecuterRequete($cur); $row = oci_fetch_array($cur, OCI_BOTH); echo 'N_SPONSOR: <input class="form-control" type="text" name="n_sponsor" value="' . $row[0] . '" readonly ><br/>'; oci_free_statement($cur); // Nom Sponsor echo 'NOM : <input type="text" class="form-control" name="nom_sponsor" placeholder="INVOLVED GAMING" required><br/>'; // NA Sponsor echo 'NA : <input type="text" class="form-control" name="na_sponsor" placeholder="ING" required><br/>'; // Pays Sponsor $stid = oci_parse($conn, "SELECT distinct code_tdf from tdf_pays order by code_tdf"); oci_execute($stid); echo 'Pays: <select class="form-control" name="pays_sponsor" required >' . "\n"; while (($row = oci_fetch_array($stid, OCI_BOTH)) != false) { echo '<option value="' . $row[0] . '">' . $row[0]; echo '</option>';
} else { $annee = date('Y') + 1; } $stid = oci_parse($conn, "SELECT distinct annee from tdf_annee where annee >= {$annee} order by annee"); oci_execute($stid); echo 'Année : <select class="form-control" name="annee" required >' . "\n"; while (($row = oci_fetch_array($stid, OCI_BOTH)) != false) { echo '<option value="' . $row[0] . '">' . $row[0]; echo '</option>'; } echo '</select><br/>'; oci_free_statement($stid); echo '<input type="submit" class="btn btn-success" name="step1" value="Ajouter"> '; echo '<input type="button" class="btn btn-danger" value="Retour" onclick="self.location.href=\'index.php\'">'; } else { $cur = PreparerRequete($conn, "SELECT max(N_EPREUVE)+1 from tdf_epreuve where annee = {$annee}"); $r = ExecuterRequete($cur); $row = oci_fetch_array($cur, OCI_BOTH); if ($row) { echo 'N_EPREUVE: <input class="form-control" type="text" name="n_epreuve" value="' . $row[0] . '" readonly ><br/>'; } else { echo 'N_EPREUVE: <input class="form-control" type="text" name="n_epreuve" value="0" readonly ><br/>'; } oci_free_statement($cur); echo 'Ville depart : <input type="text" class="form-control" name="ville_d"><br/>'; echo 'Ville arrivee : <input type="text" class="form-control" name="ville_a"><br/>'; echo 'Distance : <input type="number" min="0" step="0.1" class="form-control" name="distance"><br/>'; echo 'Moyenne : <input type="number" min="0" step="0.001" class="form-control" name="moyenne"><br/>'; // Pays depart $stid = oci_parse($conn, "SELECT nom, code_tdf from tdf_pays order by code_tdf"); oci_execute($stid);