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);
