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
| <?php
function connectbase(){
$base = mysql_connect ('localhost', 'root', '');
mysql_select_db ('base', $base) ;
}
?>
<html>
<link rel="stylesheet" href="//code.jquery.com/ui/1.11.2/themes/smoothness/jquery-ui.css">
<script src="//code.jquery.com/jquery-1.10.2.js"></script>
<script src="//code.jquery.com/ui/1.11.2/jquery-ui.js"></script>
<link rel="stylesheet" href="/resources/demos/style.css">
<head>
<title> Admin </title>
</head>
<center>
<body>
<div id=contenu>
<table id=tableau>
<tr><td><h2>Sélectionnez une date et une question</h2></td></tr>
<form method="post">
<tr><td><select name="champ" size="1">
<option value=1>Question 1
<option value=2>Question 2
<option value=3>Question 3
<option value=4>Question 4
<option value=5>Question 5
<option value=6>Question 6
<option value=7>Question 7
<option value=8>Question 8
<option value=9>Question 9
</select></td></tr></form>
<tr><td><p>Date: <input type="text" name="date" id="datepicker"></p></td>
<script>
$(function() {
$( "#datepicker" ).datepicker();
});
</script></tr>
<tr><td><input type="submit" name="valider" value="OK"/></td></tr>
<?php
if (isset ($_POST['valider'])){
connectbase();
$champ=$_POST['champ'];
$var=$_POST['date'] ;
$date= date('Ymd',strtotime($var));
$d= date('d-m-Y',strtotime($var));
$sql = 'SELECT SUM(TS) AS TS FROM SONDAGE WHERE question ='.$champ.' and date='.$date.'';
$req = mysql_query($sql) or die('Erreur SQL !'.$sql.''.mysql_error());
while ($data = mysql_fetch_array($req)) {
echo '<tr><td>Personnestressatisfaites: '.$data['TS'].'</td></tr>';
$sql = 'SELECT SUM(S) AS S FROM SONDAGE WHERE question ='.$champ.' and date='.$date.'';
$req = mysql_query($sql) or die('Erreur SQL !'.$sql.''.mysql_error());
while ($data = mysql_fetch_array($req)) {
echo '<tr><td>Personnessatisfaites: '.$data['S'].'</td></tr>';
$sql = 'SELECT SUM(I) AS I FROM SONDAGE WHERE question ='.$champ.' and date='.$date.'';
$req = mysql_query($sql) or die('Erreur SQL !'.$sql.''.mysql_error());
while ($data = mysql_fetch_array($req)) {
echo '<tr><td>Personnesinsatisfaites: '.$data['I'].'</td></tr>';
?>
</table></div>
</center>
</body>
</html> |
Partager