Comment optimiser une requete mysql/sql?

I
idefix
WRInaute discret
Oui mais il nous faudrait le code pour pouvoir proposer des optimisations.
Sinon qu'est-ce que tu as mis en place comme système de cache ?
 
W
Who-Group
Nouveau WRInaute
Etant donner que le site est encore nouveau, et que le site ne consomme pas il est sur un hébergement mutualisé
(donc pas de cache)

Mais pour le serveur MySQL, après 2 jours, j'en ai commander un. ((un serveur dédié))

Voici le code :
<?php
include "config.php";
$wid=$_GET['wid'];
$jour = date('d');
$jour1 = date('d')-1;
$mois = date('m');
$annee = date('y');

mysql_connect($serveur, $db_login, $db_passe);
if($_GET['type'] == "visiteurs") {
?>
<script type="text/javascript">

$('#heures').corner('15px');
$('#nav').corner('15px');
$('#reso').corner('15px');
$('#menustat').corner('15px');
$('#co').corner('5px');
$('#last').corner('15px');
$('#moi').corner('15px');
$('#jc').corner('15px');
var chart;
$(document).ready(function() {
chart = new Highcharts.Chart({
chart: {
renderTo: 'container',
defaultSeriesType: 'line',
marginRight: 10,
marginBottom: 25
},
title: {
text: 'Nombre de visiteurs uniques/heures',
x: -20 //center
},
subtitle: {
text: 'En date du <?php echo $jour1." et ".date("d-m-y"); ?>',
x: -20
},
xAxis: {
title: {
text: 'Heures'
},
categories: ['00h', '01h', '02h', '03h', '04h', '05h', '06h',
'07h', '08h', '09h', '10h', '11h', '12h', '13h', '14h', '15h', '16h', '17h'
, '18h', '19h', '20h', '21h', '22h', '23h']
},
yAxis: {
title: {
text: 'Visiteurs'
},
plotLines: [{
value: 0,
width: 1,
color: '#808080'
}]
},
tooltip: {
formatter: function() {
return '<b>'+ this.series.name +'</b><br/>'+
this.x +': '+ this.y +' Visiteurs';
}
},
legend: {
enabled: false,
layout: 'vertical',
align: 'right',
verticalAlign: 'top',
x: -10,
y: 100,
borderWidth: 0
},
series: [{
name: 'Visite',
data: [<?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='0'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='1'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='2'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='3'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='4'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='5'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='6'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='7'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='8'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='9'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='10'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='11'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='12'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='13'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='14'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='15'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='16'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='17'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='18'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='19'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='20'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='21'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='22'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='23'");
$nombre = mysql_num_rows($result); echo $nombre; ?>]
}, {
name: 'Visite Hier',
data: [<?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='0'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='1'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='2'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='3'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='4'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='5'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='6'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='7'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='8'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='9'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='10'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='11'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='12'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='13'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='14'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='15'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='16'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='17'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='18'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='19'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='20'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='21'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='22'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='23'");
$nombre = mysql_num_rows($result); echo $nombre; ?>]
}]
});


});

</script>
<div id="container" style="width: 650px; height: 400px; margin: 0 auto"></div>


<?php
}
elseif($_GET['type'] == "pages") {
?>





<script type="text/javascript">

$('#heures').corner('15px');
$('#nav').corner('15px');
$('#reso').corner('15px');
$('#menustat').corner('15px');
$('#co').corner('5px');
$('#last').corner('15px');
$('#moi').corner('15px');
$('#page').corner('15px');
var chart;
$(document).ready(function() {
chart = new Highcharts.Chart({
chart: {
renderTo: 'pages',
defaultSeriesType: 'line',
marginRight: 10,
marginBottom: 25
},
title: {
text: 'Nombre de pages vues/heures',
x: -20 //center
},
subtitle: {
text: 'En date du <?php echo $jour1." et ".date("d-m-y"); ?>',
x: -20
},
xAxis: {
title: {
text: 'Heures'
},
categories: ['00h', '01h', '02h', '03h', '04h', '05h', '06h',
'07h', '08h', '09h', '10h', '11h', '12h', '13h', '14h', '15h', '16h', '17h'
, '18h', '19h', '20h', '21h', '22h', '23h']
},
yAxis: {
title: {
text: 'Pages vues'
},
plotLines: [{
value: 0,
width: 1,
color: '#808080'
}]
},
tooltip: {
formatter: function() {
return '<b>'+ this.series.name +'</b><br/>'+
this.x +': '+ this.y +' Pages';
}
},
legend: {
enabled: false,
layout: 'vertical',
align: 'right',
verticalAlign: 'top',
x: -10,
y: 100,
borderWidth: 0
},
series: [{
name: 'Pages',
data: [<?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='0'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='1'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='2'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='3'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='4'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='5'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='6'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='7'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='8'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='9'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='10'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='11'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='12'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='13'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='14'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='15'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='16'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='17'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='18'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='19'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='20'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='21'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='22'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='23'");
$nombre = mysql_num_rows($result); echo $nombre; ?>]
}, {
name: 'Pages hier',
data: [<?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='0'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='1'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='2'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='3'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='4'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='5'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='6'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='7'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='8'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='9'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='10'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='11'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='12'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='13'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='14'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='15'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='16'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='17'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='18'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='19'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='20'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='21'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='22'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT ip
FROM stats WHERE wid='$wid' AND jour='$jour1' AND mois='$mois' AND annee='$annee' AND heure='23'");
$nombre = mysql_num_rows($result); echo $nombre; ?>]
}]
});


});

</script>



<div id="pages" style="width: 850px; height: 400px; margin: 0 auto"></div>


<?php
}
elseif($_GET['type'] == "navigateur") {
?>





<?php $resultE = mysql_db_query($database, "SELECT navigateur
FROM stats WHERE wid='$wid'");
$nombre222 = mysql_num_rows($resultE); ?>
<script type="text/javascript">

var chart;
$(document).ready(function() {
chart = new Highcharts.Chart({
chart: {
renderTo: 'navigateur',
margin: [50, 1, 1, 1]
},
title: {
text: 'Répartitions des navigateurs'
},
plotArea: {
shadow: null,
borderWidth: null,
backgroundColor: null
},
tooltip: {
formatter: function() {
return '<b>'+ this.point.name +'</b>: '+ this.y +' %';
}
},
plotOptions: {
pie: {
allowPointSelect: true,
cursor: 'pointer',
dataLabels: {
enabled: true,
formatter: function() {
if (this.y > 5) return this.point.name;
},
color: 'white',
style: {
font: '13px Trebuchet MS, Verdana, sans-serif'
}
}
}
},
legend: {
enabled:false,
layout: 'vertical',
style: {
left: 'auto',
bottom: 'auto',
right: '50px',
top: '100px'
}
},

series: [{
type: 'pie',
name: 'Navigateur',
data: [
['Chrome', <?php $resulta = mysql_db_query($database, "SELECT navigateur
FROM stats WHERE wid='$wid' AND navigateur='Google Chrome'");
$nombrea = mysql_num_rows($resulta); echo substr(($nombrea/$nombre222)*100,0,4); ?>],
['Firefox', <?php $resultb = mysql_db_query($database, "SELECT navigateur
FROM stats WHERE wid='$wid' AND navigateur='Mozilla Firefox'");
$nombreb = mysql_num_rows($resultb); echo substr(($nombreb/$nombre222)*100,0,4); ?>],
['IE', <?php $resultc = mysql_db_query($database, "SELECT navigateur
FROM stats WHERE wid='$wid' AND navigateur='Internet Explorer'");
$nombrec = mysql_num_rows($resultc); echo substr(($nombrec/$nombre222)*100,0,4); ?>],
['Safari', <?php $resultd = mysql_db_query($database, "SELECT navigateur
FROM stats WHERE wid='$wid' AND navigateur='Apple Safari'");
$nombred = mysql_num_rows($resultd); echo substr(($nombred/$nombre222)*100,0,4); ?>],
['Opera', <?php $resulte = mysql_db_query($database, "SELECT navigateur
FROM stats WHERE wid='$wid' AND navigateur='Opera'");
$nombree = mysql_num_rows($resulte); echo substr(($nombree/$nombre222)*100,0,4); ?>],
['Autres', <?php $resultf = mysql_db_query($database, "SELECT navigateur
FROM stats WHERE wid='$wid' AND navigateur='Autre'");
$nombref = mysql_num_rows($resultf); echo substr(($nombref/$nombre222)*100,0,4); ?>]
]
}]
});
});

</script>
<div id="navigateur" style="width: 400px; height: 400px; margin: 0 auto"></div>
<?php
}
elseif($_GET['type'] == "os") {
?>


<?php $resultEs = mysql_db_query($database, "SELECT os
FROM stats WHERE wid='$wid'");
$nombreos222 = mysql_num_rows($resultEs); ?>
<script type="text/javascript">

var chart;
$(document).ready(function() {
chart = new Highcharts.Chart({
chart: {
renderTo: 'os',
margin: [50, 1, 1, 1]
},
title: {
text: 'Système d\'exploitation'
},
plotArea: {
shadow: null,
borderWidth: null,
backgroundColor: null
},
tooltip: {
formatter: function() {
return '<b>'+ this.point.name +'</b>: '+ this.y +' %';
}
},
plotOptions: {
pie: {
allowPointSelect: true,
cursor: 'pointer',
dataLabels: {
enabled: true,
formatter: function() {
if (this.y > 5) return this.point.name;
},
color: 'white',
style: {
font: '13px Trebuchet MS, Verdana, sans-serif'
}
}
}
},
legend: {
enabled:false,
layout: 'vertical',
style: {
left: 'auto',
bottom: 'auto',
right: '50px',
top: '100px'
}
},

series: [{
type: 'pie',
name: "Système d'exploitation",
data: [
['Mac OS', <?php $resultosa = mysql_db_query($database, "SELECT os
FROM stats WHERE wid='$wid' AND os='Mac OS'");
$nombreosa = mysql_num_rows($resultosa); echo substr(($nombreosa/$nombreos222)*100,0,2); ?>],
['Windows Seven', <?php $resultosb = mysql_db_query($database, "SELECT os
FROM stats WHERE wid='$wid' AND os='Windows Seven'");
$nombreosb = mysql_num_rows($resultosb); echo substr(($nombreosb/$nombreos222)*100,0,2); ?>],
['Windows Vista', <?php $resultosc = mysql_db_query($database, "SELECT os
FROM stats WHERE wid='$wid' AND os='Windows Vista'");
$nombreosc = mysql_num_rows($resultosc); echo substr(($nombreosc/$nombreos222)*100,0,2); ?>],
['Windows XP', <?php $resultosd = mysql_db_query($database, "SELECT os
FROM stats WHERE wid='$wid' AND os='Windows XP'");
$nombreosd = mysql_num_rows($resultosd); echo substr(($nombreosd/$nombreos222)*100,0,2); ?>],
['Windows 2000', <?php $resultose = mysql_db_query($database, "SELECT os
FROM stats WHERE wid='$wid' AND os='Windows 2000'");
$nombreose = mysql_num_rows($resultose); echo substr(($nombreose/$nombreos222)*100,0,2); ?>],
['iPhone', <?php $resultosf = mysql_db_query($database, "SELECT os
FROM stats WHERE wid='$wid' AND os='iPhone'");
$nombreosf = mysql_num_rows($resultosf); echo substr(($nombreosf/$nombreos222)*100,0,2); ?>],
['Playstation 3', <?php $resultosf = mysql_db_query($database, "SELECT os
FROM stats WHERE wid='$wid' AND os='Playstation 3'");
$nombreosf = mysql_num_rows($resultosf); echo substr(($nombreosf/$nombreos222)*100,0,2); ?>],
['Sony PSP', <?php $resultosf = mysql_db_query($database, "SELECT os
FROM stats WHERE wid='$wid' AND os='Sony PSP'");
$nombreosf = mysql_num_rows($resultosf); echo substr(($nombreosf/$nombreos222)*100,0,2); ?>],
['Nintendo Wii', <?php $resultosf = mysql_db_query($database, "SELECT os
FROM stats WHERE wid='$wid' AND os='Nintendo Wii'");
$nombreosf = mysql_num_rows($resultosf); echo substr(($nombreosf/$nombreos222)*100,0,2); ?>],
['Android', <?php $resultosf = mysql_db_query($database, "SELECT os
FROM stats WHERE wid='$wid' AND os='Android'");
$nombreosf = mysql_num_rows($resultosf); echo substr(($nombreosf/$nombreos222)*100,0,2); ?>]
]
}]
});
});
</script>
<div id="os" style="width: 400px; height: 400px; margin: 0 auto"></div>

<?php
}
elseif($_GET['type'] == "resolution") {
?>
<script type="text/javascript">

var chart;
$(document).ready(function() {
chart = new Highcharts.Chart({
chart: {
renderTo: 'resolution',
defaultSeriesType: 'column'
},
title: {
text: 'Résolution'
},
xAxis: {
categories: [
'320x480',
'480x320',
'640x480',
'800x600',
'960x640',
'1024x768',
'1280x800',
'1280x1024',
'1440x900',
'1600x1200',
'1680x1050',
'1920x1050',
'1920x1200'
]
},
yAxis: {
min: 0,
title: {
text: 'Nombre'
}
},
legend: {
enabled:false,
layout: 'vertical',
backgroundColor: '#FFFFFF',
align: 'left',
verticalAlign: 'top',
x: 100,
y: 70
},
tooltip: {
formatter: function() {
return ''+
this.x +': '+ this.y +' Visiteurs';
}
},
plotOptions: {
column: {
pointPadding: 0.2,
borderWidth: 0
}
},
series: [{
name: 'Resolution',
data: [<?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND resolution='320x480'"); $nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND resolution='480x320'"); $nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND resolution='640x480'"); $nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND resolution='800x600'"); $nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND resolution='960x640'"); $nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND resolution='1024x768'"); $nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND resolution='1280x800'"); $nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND resolution='1280x1024'"); $nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND resolution='1440x900'"); $nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND resolution='1600x1200'"); $nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND resolution='1680x1050'"); $nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND resolution='1920x1080'"); $nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND resolution='1920x1200'"); $nombre = mysql_num_rows($result); echo $nombre; ?>]

}]
});


});

</script>
<div id="resolution" style="width: 880px; height: 400px; margin: 0 auto"></div>
<?php
}
elseif($_GET['type'] == "mois") {
?>
<script>

var chart;
$(document).ready(function() {
chart = new Highcharts.Chart({
chart: {
renderTo: 'mois',
defaultSeriesType: 'column'
},
title: {
text: 'Visiteurs uniques/mois'
},
xAxis: {
categories: [
'Jan',
'Fev',
'Mar',
'Avr',
'Mai',
'Jui',
'Juil',
'Aou',
'Sep',
'Oct',
'Nov',
'Dec'
]
},
yAxis: {
min: 0,
title: {
text: 'Nombre'
}
},
legend: {
enabled:false,
layout: 'vertical',
backgroundColor: '#FFFFFF',
align: 'left',
verticalAlign: 'top',
x: 100,
y: 70
},
tooltip: {
formatter: function() {
return ''+
this.x +': '+ this.y +' Visiteurs';
}
},
plotOptions: {
column: {
pointPadding: 0.2,
borderWidth: 0
}
},
series: [{
name: 'Visiteurs uniques/mois',
data: [<?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND mois='01' AND annee='$annee'"); $nombre = mysql_num_rows($result); echo $nombre; ?>,
<?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND mois='02' AND annee='$annee'"); $nombre = mysql_num_rows($result); echo $nombre; ?>,
<?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND mois='03' AND annee='$annee'"); $nombre = mysql_num_rows($result); echo $nombre; ?>,
<?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND mois='04' AND annee='$annee'"); $nombre = mysql_num_rows($result); echo $nombre; ?>,
<?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND mois='05' AND annee='$annee'"); $nombre = mysql_num_rows($result); echo $nombre; ?>,
<?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND mois='06' AND annee='$annee'"); $nombre = mysql_num_rows($result); echo $nombre; ?>,
<?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND mois='07' AND annee='$annee'"); $nombre = mysql_num_rows($result); echo $nombre; ?>,
<?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND mois='08' AND annee='$annee'"); $nombre = mysql_num_rows($result); echo $nombre; ?>,
<?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND mois='09' AND annee='$annee'"); $nombre = mysql_num_rows($result); echo $nombre; ?>,
<?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND mois='10' AND annee='$annee'"); $nombre = mysql_num_rows($result); echo $nombre; ?>,
<?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND mois='11' AND annee='$annee'"); $nombre = mysql_num_rows($result); echo $nombre; ?>,
<?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND mois='12' AND annee='$annee'"); $nombre = mysql_num_rows($result); echo $nombre; ?>
]

}]
});


});



Cufon.replace('#titre', {
color: '-linear-gradient(white, grey)'
});
</script>



<div id="mois" style="width: 850px; height: 400px; margin: 0 auto"></div>



<?php
}
elseif($_GET['type'] == "css") {
?>



<?php $resultE = mysql_db_query($database, "SELECT css
FROM stats WHERE wid='$wid'");
$nombre222 = mysql_num_rows($resultE); ?>
<script type="text/javascript">

var chart;
$(document).ready(function() {
chart = new Highcharts.Chart({
chart: {
renderTo: 'css',
margin: [50, 1, 1, 1]
},
title: {
text: 'Version du CSS'
},
plotArea: {
shadow: null,
borderWidth: null,
backgroundColor: null
},
tooltip: {
formatter: function() {
return '<b>'+ this.point.name +'</b>: '+ this.y +' %';
}
},
plotOptions: {
pie: {
allowPointSelect: true,
cursor: 'pointer',
dataLabels: {
enabled: true,
formatter: function() {
if (this.y > 5) return this.point.name;
},
color: 'white',
style: {
font: '13px Trebuchet MS, Verdana, sans-serif'
}
}
}
},
legend: {
enabled:false,
layout: 'vertical',
style: {
left: 'auto',
bottom: 'auto',
right: '50px',
top: '100px'
}
},

series: [{
type: 'pie',
name: 'CSS',
data: [
['2', <?php $resulta = mysql_db_query($database, "SELECT css
FROM stats WHERE wid='$wid' AND css=2");
$nombrea = mysql_num_rows($resulta); echo substr(($nombrea/$nombre222)*100,0,4); ?>],
['3', <?php $resultb = mysql_db_query($database, "SELECT css
FROM stats WHERE wid='$wid' AND css=3");
$nombreb = mysql_num_rows($resultb); echo substr(($nombreb/$nombre222)*100,0,4); ?>]
]
}]
});
});

</script>

<div id="css" style="width: 400px; height: 400px; margin: 0 auto"></div>

<?php
}
elseif($_GET['type'] == "jss") {
?>

<?php $resultE = mysql_db_query($database, "SELECT js
FROM stats WHERE wid='$wid'");
$nombre222 = mysql_num_rows($resultE); ?>
<script type="text/javascript">

var chart;
$(document).ready(function() {
chart = new Highcharts.Chart({
chart: {
renderTo: 'jsss',
margin: [50, 1, 1, 1]
},
title: {
text: 'Javascript'
},
plotArea: {
shadow: null,
borderWidth: null,
backgroundColor: null
},
tooltip: {
formatter: function() {
return '<b>'+ this.point.name +'</b>: '+ this.y +' %';
}
},
plotOptions: {
pie: {
allowPointSelect: true,
cursor: 'pointer',
dataLabels: {
enabled: true,
formatter: function() {
if (this.y > 5) return this.point.name;
},
color: 'white',
style: {
font: '13px Trebuchet MS, Verdana, sans-serif'
}
}
}
},
legend: {
enabled:false,
layout: 'vertical',
style: {
left: 'auto',
bottom: 'auto',
right: '50px',
top: '100px'
}
},

series: [{
type: 'pie',
name: 'Javascript',
data: [
['Non', <?php $resulta = mysql_db_query($database, "SELECT js
FROM stats WHERE wid='$wid' AND js=O");
$nombrea = mysql_num_rows($resulta); echo substr(($nombrea/$nombre222)*100,0,2); ?>],
['Oui', <?php $resultb = mysql_db_query($database, "SELECT js
FROM stats WHERE wid='$wid' AND js=1");
$nombreb = mysql_num_rows($resultb); echo substr(($nombreb/$nombre222)*100,0,2); ?>]
]
}]
});
});

</script>
<div id="jsss" style="width: 400px; height: 400px; margin: 0 auto"></div>
<?php } ?>
Cliquez pour agrandir...
 
V
vitalizo
WRInaute impliqué
Quand on regarde ca d'un seul coup d'oeil, j'ai aucune envie de comprendre. Rajoutez des explication pour faciliter la compréhension
 
W
Who-Group
Nouveau WRInaute
Exemple :
name: 'Visite',
data: [<?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='0'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='1'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='2'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='3'");
Cliquez pour agrandir...

Cette requête permet de récupérer le nombre de visite à l'heure indiquer.
['Chrome', <?php $resulta = mysql_db_query($database, "SELECT navigateur
FROM stats WHERE wid='$wid' AND navigateur='Google Chrome'");
$nombrea = mysql_num_rows($resulta); echo substr(($nombrea/$nombre222)*100,0,4); ?>],
['Firefox', <?php $resultb = mysql_db_query($database, "SELECT navigateur
FROM stats WHERE wid='$wid' AND navigateur='Mozilla Firefox'");
$nombreb = mysql_num_rows($resultb); echo substr(($nombreb/$nombre222)*100,0,4); ?>],
['IE', <?php $resultc = mysql_db_query($database, "SELECT navigateur
FROM stats WHERE wid='$wid' AND navigateur='Internet Explorer'");
$nombrec = mysql_num_rows($resultc); echo substr(($nombrec/$nombre222)*100,0,4); ?>],
['Safari', <?php $resultd = mysql_db_query($database, "SELECT navigateur
FROM stats WHERE wid='$wid' AND navigateur='Apple Safari'");
$nombred = mysql_num_rows($resultd); echo substr(($nombred/$nombre222)*100,0,4); ?>],
['Opera', <?php $resulte = mysql_db_query($database, "SELECT navigateur
FROM stats WHERE wid='$wid' AND navigateur='Opera'");
$nombree = mysql_num_rows($resulte); echo substr(($nombree/$nombre222)*100,0,4); ?>],
['Autres', <?php $resultf = mysql_db_query($database, "SELECT navigateur
FROM stats WHERE wid='$wid' AND navigateur='Autre'");
$nombref = mysql_num_rows($resultf); echo substr(($nombref/$nombre222)*100,0,4); ?>]
]
Cliquez pour agrandir...

Récupérer les infos de navigateurs..

Ainsi de suite, et les donnés sont afficher sur http://who-stats.com/stats-newlifebobba
 
I
idefix
WRInaute discret
A première vue :
- Il faut utiliser la commande GROUP BY notamment au lieu de faire un select par heure.
- Il faut créer un système de cache. Différentes solutions existent, certaines sont utilisables quelque soit l'hébergement. Les données ne seront plus actualisées en permanence mais tous les quart d'heure par exemple.
 
R
Robinson
WRInaute passionné
Who-Group a dit:
En mettant en cache, je ne serais plus en "temps réel" vu qu'il y'aura 15 minutes en cache x')
Cliquez pour agrandir...
Et ton temps réel pour les données des 12 mois précédents, c'est utile ? :lol:

Ton "temps réel" ne sert strictement à rien vu que tu récupères les mêmes informations qui ne bougent plus exceptées pour l'heure en cours !!!

Tu peux donc supprimer 95% de tes requêtes et créer quelques tâches crons pour générer tes fichiers "cache".
 
spout
spout
WRInaute accro
Robinson a dit:
Tu peux donc supprimer 95% de tes requêtes et créer quelques tâches crons pour générer tes fichiers "cache".
Cliquez pour agrandir...
Bcp trop de requêtes c'est sur.

Et pour ce genre de trucs:
Code: 
<?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='1'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='2'");
$nombre = mysql_num_rows($result); echo $nombre; ?>, <?php $result = mysql_db_query($database, "SELECT DISTINCT ip
FROM stats WHERE wid='$wid' AND jour='$jour' AND mois='$mois' AND annee='$annee' AND heure='3'");
Il y a un opérateur "for"... :)

Perso, en voyant ce code, crédibilité - 1 (une iframe en plus) :mrgreen:
 
I
idefix
WRInaute discret
Je dois dire que je suis un peu surpris par ton projet.
Il faut commencer par penser l'architecture de la base et du script avant de le créer. Là visiblement tu stockes chaque visite, à quoi vont ressembler tes tables dans quelques mois? As-tu anticipé le volume de données que cela va représenter? 8O
 
Vous devez vous connecter ou vous inscrire pour répondre ici.
1.fr
Discussions similaires
C
optimiser une requete mysql
Réponses
27
Affichages
2K
julienr
julienr
T
Aide pour optimiser l'écriture d'une requete PHP/MYSQL
Réponses
2
Affichages
3K
the386mmx
T
J
Optimiser une requete MySQL
Réponses
13
Affichages
7K
JeunZ
J
S
Reduire et optimiser une requete sql
Réponses
10
Affichages
2K
niap
N
S
Optimiser une requete SQL
Réponses
8
Affichages
4K
syrx20
S
R
Optimiser requete sql
Réponses
9
Affichages
3K
Robinson
R
S
Optimiser une double requete
Réponses
4
Affichages
3K
sky
S
T
Réglages CSS dans vos plugins de cache pour optimiser le CLS
Réponses
3
Affichages
745
tibiz
T
J
Est ce judicieux d'optimiser ce maillage interne ?
Réponses
4
Affichages
1K
jbm
J
V
Comment optimiser son maillage interne
Réponses
8
Affichages
1K
WebRankInfo
WebRankInfo
R
Optimiser la vitesse d'un site wordpress
Réponses
3
Affichages
850
Madrileño
Madrileño
R
SEO : comment optimiser une page d'accueil ?
Réponses
1
Affichages
1K
Madrileño
Madrileño
Mario002
OPTIMISER LES BALISES HTML D’UN SITE WEB 
Réponses
3
Affichages
2K
Marie-Aude
Marie-Aude
B
Optimiser un article qui rank sans le pénaliser
Réponses
3
Affichages
3K
teffy2021
T
V
Optimiser les vidéos pour la recherche YouTube
Réponses
1
Affichages
2K
ZImm
Z
N
Comment optimiser la profondeur des liens dans un blog ?
Réponses
3
Affichages
2K
WebRankInfo
WebRankInfo
S
Réduire et optimiser un code js
Réponses
0
Affichages
2K
sff
S
C
Comment optimiser un fichier PDF pour le SEO ?
Réponses
9
Affichages
2K
cyber-avenir
C
B
Comment optimiser le référencement des fiches produits saisonniers
Réponses
3
Affichages
2K
Gabrielleparson
G
M
Référencement local : optimiser pour les villes voisines
Réponses
4
Affichages
3K
indigene
indigene
Haut