1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
|
<?php
require("conf.php");
$connection = mysql_connect("$sql_serveur","$sql_login","$sql_pass");
// test la connection
if ( ! $connection ) die ("connection impossible");
// Connecte la base
mysql_select_db($sql_bdd) or die ("pas de connection");
$rqst="SELECT COUNT(id) FROM feuilletemps WHERE login_client='$pseudo'";
$rep=mysql_query($rqst);
list($nb) = mysql_fetch_row( $rep);
$sql="SELECT * FROM feuilletemps WHERE login_client='$pseudo'";
$req=mysql_query($sql,$connection)or exit ('Erreur SQL !'.$sql.''.mysql_error());
while( $data=mysql_fetch_array($req) ){
$id=$data['id'];
$day=$data['day'];
$timesheet1=$data['timesheet1'];
$timesheet2=$data['timesheet2'];
echo "<p align=\"center\">Vous avez $nb Rendez-vous le <a href=\"index.php?page=7&pages=9&id=$id\">$day $timesheet1
$timesheet2</a></p>
";
}
?> |
Partager