bonjour,
j'ai une table sql "presence" qui contient les champs suivants:
id_presence int
id_user int
entree dateTime
sortie dateTime
mon probléme consiste à:
comment peut -t-on calculer le nbre d'heures entre la date sortie et la date entree tout en affichant ceux ci dans la colonne nbre d'heures???
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");
$mois_en_cours=date(m);
$query = "select* from utilisateur";
$result = mysql_query($query) or die( mysql_error());
//$arrays = mysql_fetch_assoc($result);
$querya = "SELECT * FROM presence, utilisateur WHERE WEEK(entree, 3) = DATE_FORMAT(NOW(), '%u')order by entree; ";
$resulta = mysql_query($querya);
$queryb = "SELECT * FROM utilisateur";
$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">
<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>
</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 '</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">Nombre d'heures</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'</tr>';
}
?>
</table></div>
<div id="co_3" 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="Style1">Entree/sorite</span></td>
<td align="center" bgcolor="#000066"><span class="Style1">nb</span></td>
</tr>
<?php
while ($row = mysql_fetch_array($resultb)) {
echo '<tr>';
echo '<td align="center" >'.$row['id_user'].'</td>';
echo '<td align="center" >'.$row['nom'].'</td>';
echo '<td align="center">';
$query = "select * from presence where id_user=".$row['id_user'];
$result2 = mysql_query($query) or die( mysql_error());
while ($row2 = mysql_fetch_array($result2)) {
echo $row2['entree'].' '.$row2['sortie'].'<br>';
}
echo "</td>";
echo '<td align="center">';
$query = "select * from presence where id_user=".$row['id_user'];
$result2 = mysql_query($query) or die( mysql_error());
while ($row2 = mysql_fetch_array($result2)) {
$diff=mktime($row2['sortie']-$row2['entree']);
echo ($diff).'<br>';
}
echo '</td></tr>';
}
?>
</table></div>
</div>
merci d'avance.