salut,
il parait que le probléme de trie par jour ne fonctionne pas correctement ,je voudrais avoir l'affichage des dates du jour courant .
voici le code :
<html><head><style type="text/css">
*{
margin: 0px;
padding: 0px;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
}
body{
}
a{
text-decoration: none;
color: #200;
}
ul, li{
list-style: none;
}
.mon_onglet{
float: left;
padding: 2px 10px;
margin-right: 5px;
color: #FFFFFF;
background: #000066;
border: 1px solid ##0066FF;
cursor: pointer;
margin-bottom: -1px;
}
.mon_onglet:hover{
background: #0066FF;
}
.mon_onglet_selected{
float: left;
padding: 2px 10px;
margin-right: 5px;
color: #FFFFFF;
background: #0066FF;
border-top: 1px solid #68ce3e;
border-right: 1px solid #0066FF;
border-left: 1px solid ##0066FF;
border-bottom: 1px solid ##0066FF;
cursor: pointer;
margin-bottom: -1px;
}
.clear{
clear: both;
}
.mon_contenu{
color: #000000;
background: #a3t222;
border: 2px solid #0099FF;
padding: 10px;
}
#mes_contenus, #mes_onglets{
width: 900px;
}
</style>
<script language="javascript">
function changeOnglet(_this){
var getOnglets = document.getElementById('mes_onglets').getElementsByTagName('li');
for(var i = 0; i < getOnglets.length; i++){
if(getOnglets[i].id){
if(getOnglets[i].id == _this.id){
getOnglets[i].className = 'mon_onglet_selected';
document.getElementById('c' + _this.id).style.display = 'block';
}
else{
getOnglets[i].className = 'mon_onglet';
document.getElementById('c' + getOnglets[i].id).style.display = 'none';
}
}
}
}
</script></head></html>
<?php
$host = "localhost";
$user = "root";
$bdd = "dotproject";
$passwd = "";
mysql_connect($host,$user,$passwd) or die("Connexion impossible");
mysql_select_db($bdd) or die("Echec de selection de la base");
?>
<style type="text/css">
<!--
.Style1 {font-weight: bold}
.Style2 {font-weight: bold}
.Style3 {color: #FFFFFF}
-->
</style>
<?php
$today = date("Y:m:d");
$query = "SELECT * FROM `presence` WHERE `date`='$today'";
$result = mysql_query($query);
$querya = "SELECT * FROM presence WHERE WEEK(date, 3) = DATE_FORMAT(NOW(), '%u');";
$resulta = mysql_query($querya);
?>
<style type="text/css">
<!--
.Style1 {
color: #FFFFFF;
font-weight: bold;
}
.Style2 {
color: #EBE9ED;
font-weight: bold;
}
-->
</style>
<br /><br />
<div id="mes_onglets">
<ul>
<li class="mon_onglet_selected Style3" id="o_1" onclick="changeOnglet(this);">Par jour</li>
<li class="mon_onglet Style3" id="o_2" onclick="changeOnglet(this);">Par semaine</li>
<li class="mon_onglet Style3" id="o_3" onclick="changeOnglet(this);">Par mois</li>
<div class="clear"></div>
</ul>
</div>
<div id="mes_contenus">
<div id="co_1" class="mon_contenu"><table width=800 border="1">
<tr>
<td align="center" bgcolor="#000066"><span class="Style1">Identifiant</span></td>
<td align="center" bgcolor="#000066"><span class="Style1">Utilisateur</span></td>
<td align="center" bgcolor="#000066"><span class="Style2">Evenement</span></td>
<td align="center" bgcolor="#000066"><span class="Style2">Date</span></td>
</tr>
<?php
while ($row = mysql_fetch_array($result)) {
echo '<tr>';
echo '<td align="center" >'.$row['id_user'].'</td>';
echo '<td align="center" >'.$row['nom'].'</td>';
echo '<td align="center" >'.$row['evenement'].'</td>';
echo '<td align="center" >'.$row['date'].'</td>';
echo '</tr>';
}
?>
</table></div>
<div id="co_2" class="mon_contenu" style="display: none;"><table width=800 border="1">
<tr>
<td align="center" bgcolor="#000066"><span class="Style1">Identifiant</span></td>
<td align="center" bgcolor="#000066"><span class="Style1">Utilisateur</span></td>
<td align="center" bgcolor="#000066"><span class="Style2">Evenement</span></td>
<td align="center" bgcolor="#000066"><span class="Style2">Date</span></td>
</tr>
<?php
while ($row = mysql_fetch_array($resulta)) {
echo '<tr>';
echo '<td align="center" >'.$row['id_user'].'</td>';
echo '<td align="center" >'.$row['nom'].'</td>';
echo '<td align="center" >'.$row['evenement'].'</td>';
echo '<td align="center" >'.$row['date'].'</td>';
echo '</tr>';
}
?>
</table></div>
<div id="co_3" class="mon_contenu" style="display: none;">Mon contenu 3</div>
</div>
merci d'avance .