コード例 #1
0
ファイル: modeleIndex.php プロジェクト: asuri0n/PHP-Projet
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;
}
コード例 #2
0
        // 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 -->
コード例 #3
0
ファイル: visuel_equipes.php プロジェクト: asuri0n/PHP-Projet
<!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>
コード例 #4
0
<?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']}\";/>";