Bonjour tout le monde.
j'ai un code qui permet de recupérer les données d'une bd mysql et qui les affiche par jour,par mois et par semaine dans trois div différentes.Dans chaque div j'ai 2 boutons qui permettent le recul ou l'avancement d'un jour,d'une semaine ou d'un mois.
Mon problème est que lorsque je suis dans la 2eme ou la 3eme div et je clique sur un bouton il me renvoi dans la 1ere div(active par defaut)alors qu'il fallait rester dans la même div et afficher son contenu.Voici mon 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");
//jour precedent
if($_POST["plus_1"]=='1'){
$today = $_POST["today"];
$today = strftime("%Y-%m-%d",strtotime($today)-1*24*3600);
}
//jour suivant
if($_POST["plus_1"]=='2'){
$today = $_POST["today"];
$today = strftime("%Y-%m-%d",strtotime($today)+1*24*3600);
}
//semaine suivante
if($_POST["plus_7"]=='2'){
$today = $_POST["today"];
$today = strftime("%Y-%m-%d",strtotime($today)+8*24*3600);
}
//semaine precedente
if($_POST["plus_7"]=='1'){
$today = $_POST["today"];
$today = strftime("%Y-%m-%d",strtotime($today)-8*24*3600);
}
//semaine suivante
if($_POST["plus_7"]=='2'){
$today = $_POST["today"];
$today = strftime("%Y-%m-%d",strtotime($today)+7*24*3600);
}
//mois precedent
if($_POST["mois"]=='1'){
$today = $_POST["today"];
$today = strftime("%Y-%m-%d",strtotime($today)-10*24*3600);
}
//mois suivant
if($_POST["mois"]=='2'){
$today = $_POST["today"];
$today = strftime("%Y-%m-%d",strtotime($today)+10*24*3600);
}
$mois_en_cours=date(m);
$annnee_en_cours=date(Y);
$jour=date(d);
$query = "select* from utilisateur order by id_user";
$result = mysql_query($query);
$querya = "SELECT * FROM utilisateur order by id_user";
$resulta = mysql_query($querya);
$queryb = "SELECT * FROM utilisateur order by id_user";
$resultb = mysql_query($queryb);
?>
<style type="text/css">
<!--
.Style1 {
color: #FFFFFF;
font-weight: bold;
}
.Style2 {
color: #EBE9ED;
font-weight: bold;
}
-->
</style>
<br /><br />
<div id="mes_onglets">
<img src="images/presence.png" >
<br /><br />
<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">
<form name="form" method="post" action="" id="form_">
<div id="co_1" class="mon_contenu">
<p align="center"><b>
<input name="jpreced" type="button" value="jour précédent" onclick="document.getElementById('plus_1').value = '1';document.getElementById('form_').submit();" />
<input type="hidden" id="plus_1" value="0" name="plus_1"/>
On est le: <? echo $today; ?>
<input type="hidden" name="today" value="<?php echo $today; ?>" />
<input name="jsuiv" type="button" value="jour suivant" onclick="document.getElementById('plus_1').value = '2';document.getElementById('form_').submit();"/></b></p>
<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="Style1">Date</span></td>
<td align="center" bgcolor="#000066"><span class="Style1">Entrée/sorite</span></td>
<td align="center" bgcolor="#000066"><span class="Style1">Nombre d'heures</span></td>
<td align="center" bgcolor="#000066"><span class="Style1">Total</span></td>
</tr>
<?php
while ($row = mysql_fetch_array($result)) {
$Total=0;
echo '<tr>';
echo '<td align="center" >'.$row['id_user'].'</td>';
echo '<td align="center" >'.$row['nom'].'</td>';
echo '<td align="center"> ';
//affichage de la date
$query1 = "select * from presence where date='$today' and id_user=".$row['id_user'];
$result1 = mysql_query($query1) or die( mysql_error());
while ($row1 = mysql_fetch_array($result1)) {
echo $row1['date'].'<br>';
}
echo "</td>";
echo '<td align="center"> ';
//affichage de entree et sortie
$query2 = "select * from presence where date='$today' and id_user=".$row['id_user'];
$result2 = mysql_query($query2) or die( mysql_error());
while ($row2 = mysql_fetch_array($result2)) {
echo $row2['entree'].' '.$row2['sortie'].'<br>';
}
echo "</td>";
echo '<td align="center"> ';
//affichage de nombre d'heures et total
$query3 = "select * from presence where date='$today' and id_user=".$row['id_user'];
$result3 = mysql_query($query3) or die( mysql_error());
$total = 0;
while ($row3 = mysql_fetch_array($result3)) {
$diff=strtotime($row3['sortie'])-strtotime($row3['entree']);
$h=(int)($diff/3600);
$m=($diff/60)%60;
$s=$diff%60;
$duree=$h.":".$m.":".$s;
echo $duree.'<br>';
$total+=$diff;
$ht=(int)($total/3600);
$mt=($total/60)%60;
$st=$total%60;
$Total=$ht.":".$mt.":".$st;
}
echo '</td>';
echo'<td align="center">'.$Total.'</td></tr>';
}
?>
</table></div></form>
<form name="form1" method="post" action="" id="form_1">
<div id="co_2" class="mon_contenu" style="display:none; ">
<p align="center"><b>
<input name="spreced" type="button" value="semaine précédente"
onclick="document.getElementById('plus_7').value ='1';
document.getElementById('form_1').submit();
document.getElementById('form.co_2').display;
" />
<input type="hidden" id="plus_7" value="0" name="plus_7"/>
On est dans la semaine du : <? echo $today; ?>
<input type="hidden" name="today" value="<?php echo $today; ?>" />
<input name="ssuiv" type="button" value="semaine suivante"
onclick="document.getElementById('plus_7').value = '2';
document.getElementById('form_1').submit();"/></b></p>
<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="Style1">Date</span></td>
<td align="center" bgcolor="#000066"><span class="Style1">Entrée/sorite</span></td>
<td align="center" bgcolor="#000066"><span class="Style1">Nombre d'heures</span></td>
<td align="center" bgcolor="#000066"><span class="Style1">Total</span></td>
<?php
while ($row = mysql_fetch_array($resulta)) {
$Total=0;
echo '<tr>';
echo '<td align="center" >'.$row['id_user'].'</td>';
echo '<td align="center" >'.$row['nom'].'</td>';
echo '<td align="center"> ';
//affichage de la date
$query1 = "select * from presence where WEEK(date, 3) = DATE_FORMAT(NOW(), '%u') AND id_user=".$row['id_user'];
$result1 = mysql_query($query1) or die( mysql_error());
while ($row1 = mysql_fetch_array($result1)) {
echo $row1['date'].'<br>';
}
echo "</td>";
echo '<td align="center"> ';
//affichage de entree et sortie
$query2 = "select * from presence where WEEK(date, 3) = DATE_FORMAT(NOW(), '%u') AND id_user=".$row['id_user'];
$result2 = mysql_query($query2) or die( mysql_error());
while ($row2 = mysql_fetch_array($result2)) {
echo $row2['entree'].' '.$row2['sortie'].'<br>';
}
echo "</td>";
echo '<td align="center"> ';
//affichage de nombre d'heures et total
$query3 = "select * from presence where WEEK(date, 3) = DATE_FORMAT(NOW(), '%u') AND id_user=".$row['id_user'];
$result3 = mysql_query($query3) or die( mysql_error());
$total = 0;
while ($row3 = mysql_fetch_array($result3)) {
$diff=strtotime($row3['sortie'])-strtotime($row3['entree']);
$h=(int)($diff/3600);
$m=($diff/60)%60;
$s=$diff%60;
$duree=$h.":".$m.":".$s;
echo $duree.'<br>';
$total+=$diff;
$ht=(int)($total/3600);
$mt=($total/60)%60;
$st=$total%60;
$Total=$ht.":".$mt.":".$st;
}
echo '</td>';
echo'<td align="center">'.$Total.'</td></tr>';
}
?>
</table></div></form>
<form name="form2" method="post" action="" id="form_2">
<div id="co_3" class="mon_contenu" style="display: none;">
<p align="center"><b>
<input name="mpreced" type="button" value="mois précédent" onclick="document.getElementById('mois').value =
'1';document.getElementById('form_2').submit();" />
<input type="hidden" id="mois" value="0" name="mois"/>
On est dans la semaine du : <? echo $today; ?>
<input type="hidden" name="today" value="<?php echo $today; ?>" />
<input name="msuiv" type="button" value="mois suivant" onclick="document.getElementById('mois').value = '2';document.getElementById('form_1').submit();"/></b></p>
<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="Style1">Date</span></td>
<td align="center" bgcolor="#000066"><span class="Style1">Entrée/sorite</span></td>
<td align="center" bgcolor="#000066"><span class="Style1">Nombre d'heures</span></td>
<td align="center" bgcolor="#000066"><span class="Style1">Total</span></td> </tr>
<?php
while ($row = mysql_fetch_array($resultb)) {
$Total=0;
echo '<tr>';
echo '<td align="center" >'.$row['id_user'].'</td>';
echo '<td align="center" >'.$row['nom'].'</td>';
echo '<td align="center"> ';
//affichage de la date
$query1 = "select date from presence where MONTH(date) = DATE_FORMAT(NOW(), '%m') and id_user=".$row['id_user'];
$result1 = mysql_query($query1) or die( mysql_error());
while ($row1 = mysql_fetch_array($result1)) {
echo $row1['date'].'<br>';
}
echo "</td>";
echo '<td align="center"> ';
//affichage de entree et sorite
$query2 = "select * from presence where MONTH(date) = DATE_FORMAT(NOW(), '%m') AND id_user=".$row['id_user'];
$result2 = mysql_query($query2) or die( mysql_error());
while ($row2 = mysql_fetch_array($result2)) {
echo $row2['entree'].' '.$row2['sortie'].'<br>';
}
echo "</td>";
echo '<td align="center"> ';
//affichage de nombred'heures et total
$query3 = "select * from presence where MONTH(date) = DATE_FORMAT(NOW(), '%m') AND id_user=".$row['id_user'];
$result3 = mysql_query($query3) or die( mysql_error());
$total = 0;
while ($row3 = mysql_fetch_array($result3)) {
$diff=strtotime($row3['sortie'])-strtotime($row3['entree']);
$h=(int)($diff/3600);
$m=($diff/60)%60;
$s=$diff%60;
$duree=$h.":".$m.":".$s;
echo $duree.'<br>';
$total+=$diff;
$ht=(int)($total/3600);
$mt=($total/60)%60;
$st=$total%60;
$Total=$ht.":".$mt.":".$st;
}
echo '</td>';
echo'<td align="center">'.$Total.'</td></tr>';
}
?>
</table></div></form>
</div>
Merci d'avance.