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 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76
| <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<!-- TemplateBeginEditable name="doctitle" -->
<title>DDI</title>
<!-- TemplateEndEditable -->
<!-- TemplateBeginEditable name="head" -->
<!-- TemplateEndEditable -->
<style type="text/css">
.blanc {
color: #FFF;
}
</style>
<link href="/html2pdf.class.php.css" rel="stylesheet" type="text/css">
<script language="Javascript">
function mafonction() {
// Retrieve values from the selects
var u = document.getElementByID('userSelect').value;
}
</script>
</head>
<body>
<form>
<select name="users" id="userSelect" onchange="mafonction()">
<option value="etpt2012">etpt 2012</option>
<option value="etpt2013">etpt 2013</option>
<option value="etpt2014">etpt 2014</option>
<option value="etpt2015">etpt 2015</option>
</select>
</form>
<?php
$u=$_get["u"];
$req_sql2012="SELECT date, prog333, prog206, prog217, prog205,
prog215, prog205, prog134, prog124, prog137, prog307, prog500,
prog333+ prog206+ prog217+ prog205+ prog215+prog205+ prog134+ prog124+ prog137+ prog307+ prog500 as total
FROM $u WHERE (id_chorus = '$numero')";
//echo '1';
//exécution de la requête SQL
$resultat2012 = mysqli_query($cnx,$req_sql2012);
//echo 'cc';
//affichage du nombre de résultats
while ($rs2012=mysqli_fetch_array($resultat2012))
{
if ( $rs2012['prog333']==0)
{
echo '';}
else
{
echo $rs2012['prog333'] ;} ?>
</body>
</html> |
Partager