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;
}
// 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>
<!-- Bootstrap Core CSS -->
<!DOCTYPE html>
<?php
session_start();
//Connexion à la Base de Données
include 'includes/connexion.php';
//Chargement des fonctions
include 'includes/fonc_oracle.php';
$req = "SELECT * FROM tdf_equipe order by n_equipe";
$cur = PreparerRequete($conn, $req);
$r = ExecuterRequete($cur);
?>
<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>Equipes - Visualisations</title>
<!-- Bootstrap Core CSS -->
<link href="css/bootstrap.min.css" rel="stylesheet">
<!-- Custom CSS -->
<link href="css/sb-admin.css" rel="stylesheet">
<!-- Custom Fonts -->
<link href="font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">
</head>
<body>
<?php
include "../Core/header.html";
?>
<title>Formulaire Consultation Coureur</title>
<h1 style='font-variant:small-caps'>Consultation des Coureurs de la Base</h1>
<?php
include "../Fonctions/fonc_oracle.php";
include "../Core/log_bdd.php";
$conn = OuvrirConnexion($login, $mdp, $instance);
$req = 'SELECT * FROM tdf_coureur order by n_coureur desc';
$cur = PreparerRequete($conn, $req);
$res = ExecuterRequete($cur);
// Attention, pas &$nbLignes
$nbLignes = LireDonneesCoureur($cur, $tab);
?>
<table style="text-align:center;margin:auto">
<tr style="font-weight:bold"><td>N_COUREUR</td><td align="center">NOM</td><td>PRENOM</td><td>CODE TDF</td><td>ANNEE NAISSANCE</td><td>ANNEE TDF</td><td colspan="2">OPERATIONS</td></tr>
<?php
foreach ($tab as $i) {
echo "<tr><td>{$i['0']}</td><td align='center'>{$i['1']}</td><td>" . utf8_encode($i[2]) . "</td><td>{$i['4']}</td><td>{$i['3']}</td><td>{$i['5']}</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_coureur_operation.php" method='POST'><td><input type='submit' name='modifier' value='Modifier'/><?php
echo "<input type=\"hidden\" name=\"n_coureur\" value=\"{$i['0']}\";/>";