|
DB ±¸Á¶´Â
year | month | day | hour | uniq_view
11 | 09 | 02 | 01 | 5
11 | 09 | 03 | 11 | 15
11 | 09 | 11 | 12 | 9
11 | 09 | 22 | 14 | 8
11 | 09 | 23 | 16 | 165
12 | 01 | 01 | 16 | 11
12 | 09 | 01 | 17 | 134
12 | 09 | 02 | 16 | 178
ÀÌ·±½Ä¿¡ µ¥ÀÌÅͰ¡ ÀÖ±¸¿ä
select ű׷ΠÁ¶È¸ ÇÒ ½ÃÀÛ ³â,¿ù,ÀÏ °ú ³¡ ³â,¿ù,ÀÏÀ» ³Ö¾î¼
uniq_view°ªÀ» ´õÇØ Ãâ·ÂÇϰí Àִµ¥¿ä
¹Ì¼÷ÇÑ ½Ç·ÂÀÌ¿©¼ ´ÙÁß forÀ¸·Î ¸· µ¹·Á¼ üũÇϴµ¥ ±¸ÇöÀÌ Èûµå³×¿ä ¤Ì¤Ì
Àú¿¡°Ô ÈùÆ®¿Í µµ¿òÀ» ¼Õ±æÁ» ÁÖ¼¼¿ä ^^!~
DB ±¸Á¶´Â
year | month | day | hour | uniq_view
11 | 09 | 02 | 01 | 5
11 | 09 | 03 | 11 | 15
11 | 09 | 11 | 12 | 9
11 | 09 | 22 | 14 | 8
11 | 09 | 23 | 16 | 165
12 | 01 | 01 | 16 | 11
12 | 09 | 01 | 17 | 134
12 | 09 | 02 | 16 | 178
ÀÌ·±½Ä¿¡ µ¥ÀÌÅͰ¡ ÀÖ±¸¿ä
select ű׷ΠÁ¶È¸ ÇÒ ½ÃÀÛ ³â,¿ù,ÀÏ °ú ³¡ ³â,¿ù,ÀÏÀ» ³Ö¾î¼
uniq_view°ªÀ» ´õÇØ Ãâ·ÂÇϰí Àִµ¥¿ä
¹Ì¼÷ÇÑ ½Ç·ÂÀÌ¿©¼ ´ÙÁß forÀ¸·Î ¸· µ¹·Á¼ üũÇϴµ¥ ±¸ÇöÀÌ Èûµå³×¿ä ¤Ì¤Ì
Àú¿¡°Ô ÈùÆ®¿Í µµ¿òÀ» ¼Õ±æÁ» ÁÖ¼¼¿ä ^^!~
[ ¡å Áú¹®°ü·Ã Âü°í Source ]
<?php
if($_POST['s_month'] == $_POST['e_month']){ $day_loop0_first_chk = 1; }
for($month_loop0 = $_POST['s_month']; $month_loop0 < $_POST['e_month']+1; $month_loop0++)
{
if($month_loop0 == $_POST['e_month']) {
$day_loop0_cut = $_POST['e_day'];
if($day_loop0_first_chk == 1) { $day_loop0_first = $_POST['s_day']; }
else { $day_loop0_first = "01"; }
} else {
$day_loop0_cut = "31";
$day_loop0_first = $_POST['s_day'];
}
for($day_loop0 = $day_loop0_first; $day_loop0 <= $day_loop0_cut; $day_loop0++)
{
//Day list...
if(!$date_list)
{
$date_list = "'".$month_loop0."¿ù ".$day_loop0."ÀÏ'";
}
else
{
$date_list = $date_list.",'".$month_loop0."¿ù ".$day_loop0."ÀÏ'";
}
//Query each day visiter on market...
for($loop0=0; $loop0 <= 3; $loop0++)
{
if($market_arry[$loop0]) {
$graph_day_by_day = sql_query("select SUM(uniq_view) from opms_count_visit where item_market = '$market_arry[$loop0]' and month = '$month_loop0' and day = '$day_loop0'");
$grahp_view = mysql_result($graph_day_by_day, 0, 0);
if(!$grahp_view) {$grahp_view = "1";}
if(!$market_view[$loop0]) { $market_view[$loop0] = $grahp_view;}
else { $market_view[$loop0] = $market_view[$loop0].",".$grahp_view; }
}
}
}
}
?>
|