PHP LireDonneesAnnee Examples

Example #1

File: form_epreuve_add.php Project: bvjkqsg/Projet_PHP

include "../Core/header.html";
?>
	<title>Formulaire Ajout Epreuve</title>
	<h1 style='font-variant:small-caps;text-align:center'>Ajout d'une Epreuve dans la Base</h1>
		
		<?php 
include "../Fonctions/fonc_oracle.php";
include "../Fonctions/fonc_text.php";
include "../Fonctions/fonc_sql.php";
include "../Core/log_bdd.php";
$conn = OuvrirConnexion($login, $mdp, $instance);
$req_annee = 'SELECT annee,jour_repos FROM tdf_annee order by annee';
$cur = PreparerRequete($conn, $req_annee);
$res = ExecuterRequete($cur);
$nbLignes_annee = LireDonneesAnnee($cur, $tab_annee);
$req_pays = 'SELECT * FROM tdf_pays order by nom';
$cur = PreparerRequete($conn, $req_pays);
$res = ExecuterRequete($cur);
$nbLignes_pays = LireDonneesPays($cur, $tab_pays);
$req_type = 'SELECT * FROM tdf_categorie_epreuve';
$cur = PreparerRequete($conn, $req_type);
$res = ExecuterRequete($cur);
$nbLignes_type = LireDonnees2($cur, $tab_type);
?>

		<form name="form_add" action="<?php 
$_SERVER['PHP_SELF'];
?>
" method="POST" >
			<table style="margin:auto">

Example #2

File: form_annee_look.php Project: bvjkqsg/Projet_PHP

<?php

include "../Core/header.html";
?>
		<title>Formulaire Consultation Annee</title>
		<h1 style='font-variant:small-caps'>Consultation des Annees de la Base</h1>

<?php 
include "../Fonctions/fonc_oracle.php";
include "../Core/log_bdd.php";
$conn = OuvrirConnexion($login, $mdp, $instance);
$req = 'SELECT * FROM tdf_annee order by annee desc';
$cur = PreparerRequete($conn, $req);
$res = ExecuterRequete($cur);
// Attention, pas &$nbLignes
$nbLignes = LireDonneesAnnee($cur, $tab);
?>
   
	   <table style="text-align:center;margin:auto">
	    	<tr style="font-weight:bold"><td>ANNEE</td><td align="center">NB JOUR REPOS</td><td colspan="2">OPERATIONS</td></tr>
	    <?php 
foreach ($tab as $i) {
    echo "<tr><td>{$i['0']}</td><td align='center'>{$i['1']}</td>";
    ?>
	    			<form action="form_annee_operation.php" method='POST'><td><input type='submit' name='modif' value='Modifier'/><?php 
    echo "<input type=\"hidden\" name=\"annee\" value=\"{$i['0']}\";/>";
    ?>
</td>
						<td><input type='submit' name='modif' value='Supprimer'/></td></form>
	    	<?php 
    echo "</tr>";