Comment optimiser une requete mysql/sql?

Who-Group · 16 Octobre 2010

Bonjour,

tout est dans le titre, comment optimiser une requête mysql ? Merci

idefix · 16 Octobre 2010

Peux-tu donner un exemple de ce que tu souhaites faire ?

Who-Group · 16 Octobre 2010

Je voudrais récupérer les informations des sites (car c'est pour mon site de mesure d'audience)
Exemple; que toute la page soit chargé en 1 sec au lieu de 25 sec voir plus actuellement...

http://who-stats.com/stats-newlifebobba

idefix · 16 Octobre 2010

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 ?

Who-Group · 16 Octobre 2010

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 } ?>

vitalizo · 16 Octobre 2010

Quand on regarde ca d'un seul coup d'oeil, j'ai aucune envie de comprendre. Rajoutez des explication pour faciliter la compréhension

Who-Group · 16 Octobre 2010

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'");

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); ?>]
]

Récupérer les infos de navigateurs..

Ainsi de suite, et les donnés sont afficher sur http://who-stats.com/stats-newlifebobba

idefix · 16 Octobre 2010

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.

Who-Group · 16 Octobre 2010

En mettant en cache, je ne serais plus en "temps réel" vu qu'il y'aura 15 minutes en cache x')

Robinson · 16 Octobre 2010

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')

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 · 16 Octobre 2010

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".

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:

Leonick · 16 Octobre 2010

en fait, ce n'est pas la requête qu'il faut optimiser, mais tout le script

Who-Group · 16 Octobre 2010

Ah bon?

idefix · 16 Octobre 2010

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