Remerciez-le!

Remerciez @Admin pour avoir partagé cet document gratuitement, de la manière la plus simple, en partageant sur les réseaux sociaux.

Creation de graphisme pour mon site #Requete SQL pour créer la table: $sql = my

Creation de graphisme pour mon site #Requete SQL pour créer la table: $sql = mysql_query("CREATE TABLE `stats` ( `id` tinyint(4) NOT NULL auto_increment, `come_from` text NOT NULL, `ip` text NOT NULL, `date` text NOT NULL, `user` tinytext NOT NULL, `day` tinytext NOT NULL, `month` tinytext NOT NULL, `Year` int(4) NOT NULL default '0', `hour` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Table de statistiques de traffic sur ProgIsland' AUTO_INCREMENT=91 ;"); #-------------------------------------------------------------------------- #Page: stats.php (avec code HTML!): <? session_start(); mysql_connect("localhost", "votre_login", "votre_pwd"); mysql_select_db("votre_bdd"); $today = date('d/m/Y'); $month = date('F'); $year = date('Y'); //On calcule le mois actuel: $num_mois = date('m'); $mois = array('Janvier', 'Février', 'Mars', 'Avril', 'Mai', 'Juin', 'Juillet', 'Août', 'Septembre', 'Octobre', 'Novembre', 'Décembre'); if ($num_mois < "10") { $num_mois = substr($num_mois,1,1); } $num_mois = $num_mois - 1; $fr_month = $mois[$num_mois]; //------------------------- //On calcule le jour actuel (en Fr) $numero_jour = date('w'); $jours = array('Dimanche', 'Lundi', 'Mardi', 'Mercredi', 'Jeudi', 'Vendredi', 'Samedi'); $current_day = $jours[$numero_jour]; //--------------------------------- ?> <html> <head> <title>Statistiques</title> </head> <body bgcolor="white" text="black" link="blue" vlink="purple" alink="red"> Statistiques Aujourd'hui: <table align="center" border="1" cellspacing="0" width="540" bordercolordark="white" bordercolorlight="black"> <tr> <td width="181" height="15"> Date </td> <td width="349" height="15" colspan="2"> Nombre de visites uniques </td> </tr> <tr> <td width="181" height="117" rowspan="4"> <?echo $current_day .' '.date('d') .' '. $fr_month;?> </td> <td width="101" height="28"> Nuit - Matin (0h - 12h) </td> <td width="244" height="28" valign="middle"> <? $count_morning = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE date='$today' AND hour<12")); $visites_morning = $count_morning['COUNT( * )']; ?> <img src="progressbar.gif" width="<? echo 1 + (2 * $visites_morning); ?>" border="0" height="12" align="middle" alt="<? echo $visites_morning; ?>"> (<? echo $visites_morning;?>) </td> </tr> <tr> <td width="101" height="12"> Apres- midi (12h - 18h) </td> <td width="244" height="12" valign="middle"> <? $count_journey = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE date='$today' AND hour>11 AND hour<18")); $visites_journey = $count_journey['COUNT( * )']; ?> <img src="progressbar.gif" width="<? echo 1 + (2 * $visites_journey); ?>" border="0" height="12" align="middle" alt="<? echo $visites_journey; ?>"> (<? echo $visites_journey;?>) </td> </tr> <tr> <td width="101" height="15"> Soir - Nuit (18h - 0h) </td> <td width="244" height="15" valign="middle"> <? $count_soir = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE date='$today' AND hour>17")); $visites_soir = $count_soir['COUNT( * )']; ?> <img src="progressbar.gif" width="<? echo 1 + (2 * $visites_soir); ?>" border="0" height="12" align="middle" alt="<? echo $visites_soir; ?>"> (<? echo $visites_soir;?>) </td> </tr> <tr> <td width="349" height="14" colspan="2"> <? $count_today = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE date='$today'")); $visites_today = $count_today['COUNT( * )']; echo $visites_today;?> </td> </tr> </table> <hr width="75%"> Stats du mois: <table align="center" border="1" cellspacing="0" width="540" bordercolordark="white" bordercolorlight="black"> <tr> <td width="132" height="15"> Mois </td> <td width="398" height="15" colspan="2"> Nombre de visites uniques à 24h </td> </tr> <tr> <td width="132" height="10" rowspan="4"> <?echo $fr_month .' '. date('Y');?> </td> <td width="114" height="11"> 1ere partie (du 1er au 10) </td> <td width="280" height="11"> - Indisponnible - </td> </tr> <tr> <td width="114" height="16"> 2e partie (du 11 au 20) </td> <td width="280" height="16"> - Indisponnible - </td> </tr> <tr> <td width="114" height="12"> 3e partie (du 20 au <? echo date('t'); ?>) </td> <td width="280" height="12"> - Indisponnible - </td> </tr> <tr> <td width="398" height="12" colspan="2"> <? $count_month = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE month='$month'")); $visites_month = $count_month['COUNT( * )']; echo $visites_month;?> </td> </tr> </table> Stats de l'année: <table align="center" border="1" cellspacing="0" width="540" bordercolordark="white" bordercolorlight="black"> <tr> <td width="105" height="15"> Année </td> <td width="448" height="15" colspan="2"> Nombre de visites uniques à 24h </td> </tr> <tr <? if ($month == "January") { echo 'bgcolor="white"'; } ?>> <td width="105" height="88" rowspan="13"> <? echo $year; ?> </td> <td width="110" height="5"> Janvier </td> <td width="334" height="5"> (<? $count_janvier = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE month='January' AND year='$year'")); $visites_janvier = $count_janvier['COUNT( * )']; echo $visites_janvier;?>) </td> </tr> <tr <? if ($month == "Ferbruary") { echo 'bgcolor="white"'; } ?>> <td width="110" height="5"> Février </td> <td width="334" height="5"> (<? $count_fevrier = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE month='February' AND year='$year'")); $visites_fevrier = $count_fevrier['COUNT( * )']; echo $visites_fevrier;?>) </td> </tr> <tr <? if ($month == "March") { echo 'bgcolor="white"'; } ?>> <td width="110" height="5"> Mars </td> <td width="334" height="5"> (<? $count_mars = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE month='March' AND year='$year'")); $visites_mars = $count_mars['COUNT( * )']; echo $visites_mars;?>) </td> </tr> <tr <? if ($month == "April") { echo 'bgcolor="white"'; } ?>> <td width="110" height="5"> Avril </td> <td width="334" height="5"> (<? $count_avril = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE month='April' AND year='$year'")); $visites_avril = $count_avril['COUNT( * )']; echo $visites_avril;?>) </td> </tr> <tr <? if ($month == "May") { echo 'bgcolor="white"'; } ?>> <td width="110" height="5"> Mai </td> <td width="334" height="5"> (<? $count_mai = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE month='May' AND year='$year'")); $visites_mai = $count_mai['COUNT( * )']; echo $visites_mai;?>) </td> </tr> <tr <? if ($month == "June") { echo 'bgcolor="white"'; } ?>> <td width="110" height="5"> Juin </td> <td width="334" height="5"> (<? $count_juin = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE month='June' AND year='$year'")); $visites_juin = $count_juin['COUNT( * )']; echo $visites_juin;?>) </td> </tr> <tr <? if ($month == "July") { echo 'bgcolor="white"'; } ?>> <td width="110" height="5"> Juillet </td> <td width="334" height="5"> (<? $count_juillet = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE month='July' AND year='$year'")); $visites_juillet = $count_juillet['COUNT( * )']; echo $visites_juillet;?>) </td> </tr> <tr <? if ($month == "August") { echo 'bgcolor="white"'; } ?>> <td width="110" height="5"> Aout </td> <td width="334" height="5"> (<? $count_aout = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE month='August' AND year='$year'")); $visites_aout = $count_aout['COUNT( * )']; echo $visites_aout;?>) </td> </tr> <tr <? if ($month == "September") { echo 'bgcolor="white"'; } ?>> <td width="110" height="5"> Septembre </td> <td width="334" height="5"> (<? $count_septembre = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE month='September' AND year='$year'")); $visites_septembre = $count_septembre['COUNT( * )']; echo $visites_septembre;?>) </td> </tr> <tr <? if ($month == "October") { echo 'bgcolor="white"'; } ?>> <td width="110" height="5"> Octobre </td> <td width="334" height="5"> (<? $count_octobre = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE month='October' AND year='$year'")); $visites_octobre = $count_octobre['COUNT( * )']; echo $visites_octobre;?>) </td> </tr> <tr <? if ($month == "November") { echo 'bgcolor="white"'; } ?>> <td width="110" height="7"> Novembre </td> <td width="334" height="7"> (<? $count_novembre = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE month='November' AND year='$year'")); $visites_novembre = $count_novembre['COUNT( * )']; echo $visites_novembre;?>) </td> </tr> <tr <? if ($month == "December") { echo 'bgcolor="white"'; } ?>> <td width="110" height="11"> Décembre </td> <td width="334" height="11"> (<? $count_decembre = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE month='December' AND year='$year'")); $visites_decembre = $count_decembre['COUNT( * )']; echo $visites_decembre;?>) </td> </tr> <tr> <td width="448" height="12" colspan="2"> <?$count_year = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE year='$year'")); $visites_year = $count_year['COUNT( * )']; echo $visites_year;?> </td> </tr> </table> <hr width="75%"> Comparatifs hebdomadaires généraux: <table align="center" border="1" cellspacing="0" bordercolordark="white" bordercolorlight="black"> <tr> <td width="116" height="13"> Jour </td> <td width="408" height="13"> Visites uniques à 24h </td> </tr> <tr> <td width="116" height="12"> Lundi </td> <td width="408" height="12"> <? $count_monday = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE day='Monday'")); $visites_monday = $count_monday['COUNT( * )']; echo $visites_monday;?> </td> </tr> <tr> <td width="116" height="11"> Mardi </td> <td width="408" height="11"> <? $count_tuesday = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE day='tuesday'")); $visites_tuesday = $count_tuesday['COUNT( * )']; echo $visites_tuesday;?> </td> </tr> <tr> <td width="116" height="15"> Mercredi </td> <td width="408" height="15"> <? $count_wednesday = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE day='wednesday'")); $visites_wednesday = $count_wednesday['COUNT( * )']; echo $visites_wednesday;?> </td> </tr> <tr> <td width="116" height="10"> Jeudi </td> <td width="408" height="10"> <? $count_thursday = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE day='thursday'")); $visites_thursday = $count_thursday['COUNT( * )']; echo $visites_thursday;?> </td> </tr> <tr> <td width="116" height="11"> Vendredi </td> <td width="408" height="11"> <? $count_friday = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE day='friday'")); $visites_friday = $count_friday['COUNT( * )']; echo $visites_friday;?> </td> </tr> <tr> <td width="116" height="14"> Samedi </td> <td width="408" height="14"> <? $count_saturday = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE day='saturday'")); $visites_saturday = $count_saturday['COUNT( * )']; echo $visites_saturday;?> </td> </tr> <tr> <td width="116" height="5"> Dimanche </td> <td width="408" height="5"> <? $count_sunday = mysql_fetch_array(mysql_query("SELECT COUNT( * ) FROM `stats` WHERE uploads/s3/ creation-de-graphisme-pour-mon-site.pdf