'; echo("year\t ".$year."
"); echo("month\t ".$month."
"); echo("day\t ".$day."
"); */ /* Connect to server */ $link = mysql_connect ('localhost', 'linpuscd', '9i)e!aK72UI7'); if (!$link){ die ('@@@ Could not connect:' . mysql_error()); } /* Make linpuscd_LiveUpdate as the current database */ $db_selected = mysql_select_db ('linpuscd_LiveUpdate', $link); if (!$db_selected){ die ('@@@ Can not use linpuscd_LiveUpdate:
' . mysql_error()); } echo 'Connected successfully
'; echo '
'; /* Perform SQL query */ $len_year = strlen($year); $len_month = strlen($month); $len_day = strlen($day); /* echo("len_year\t ".$len_year."
"); echo("len_month\t ".$len_month."
"); echo("len_day\t ".$len_day."
"); */ if (($len_year == 0)&&($len_month == 0)&&($len_day == 0)){ ///// get all update information echo "Select all update record !"."
"; $query = 'SELECT * FROM update_info_enhance'; $result = mysql_query($query); if (!result){ die ('@@@ Invalid query: ' . mysql_error()); } /* Count row */ $num = mysql_num_rows($result); if ($num == 0){ die ('!No update record' . mysql_error()); } // echo "rows_num: $num"; /* Use html display the result which perform SQL query */ echo "\n"; echo "\n"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "\n"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)){ echo ""; foreach ($line as $col_value){ echo ""; } echo ""; // echo "
"; } echo "

Id	SN	Update Date	Update Time	Download Time	Download Size	Download List
$col_value

"; /* Free result */ $free_result = mysql_free_result($result); if (!$free_result){ die ('Free memory: ' . mysql_error()); } //echo "###### Success to free result
"; }elseif(($len_year != 0)&&($len_month == 0)&&($len_day == 0)){ ///// get info for months of year echo "Select year: "."$year"."
"; echo "\n"; echo "\n"; echo ""; echo ""; echo ""; echo ""; echo "\n"; for ($i=1, $j=2; $i <= 12; $i++,$j++){ if ($i < 10){ $query = sprintf("SELECT sn, update_size FROM update_info_enhance where update_date >= '%d-0%d-01' and update_date < '%d-0%d-01'", $year, $i, $year, $j); $query_sn = sprintf("SELECT distinct sn FROM update_info_enhance where update_date >= '%d-0%d-01' and update_date < '%d-0%d-01'", $year, $i, $year, $j); } else{ $query = sprintf("SELECT sn, update_size FROM update_info_enhance where update_date >= '%d-%d-01' and update_date < '%d-%d-01'", $year, $i, $year, $j); $query_sn = sprintf("SELECT distinct sn FROM update_info_enhance where update_date >= '%d-%d-01' and update_date < '%d-0%d-01'", $year, $i, $year, $j); } echo ""; switch ($i) { case 1: echo ""; break; case 2: echo ""; break; case 3: echo ""; break; case 4: echo ""; break; case 5: echo ""; break; case 6: echo ""; break; case 7: echo ""; break; case 8: echo ""; break; case 9: echo ""; break; case 10: echo ""; break; case 11: echo ""; break; case 12: echo ""; break; default: break; } /* Get the number of update people*/ $result = mysql_query($query_sn); $people = mysql_num_rows($result); if ($people == 0){ // die ('@@@ No people updated:' . mysql_error()); } echo ""; mysql_free_result($result); $result = mysql_query($query); /* Update Times */ $update_times = 0; $update_times = mysql_num_rows($result); if ($update_times == 0){ // die ('@@@ No Updated:' . mysql_error()); } echo ""; $total_download_times += $update_times; /* Get update_size/month */ $down_size = 0; while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $down_size += $row["update_size"]; } $update_size = (int)($down_size/1024); echo ""; $down_size = 0; $total_download_size += $update_size; mysql_free_result($result); echo ""; // echo "
"; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

Month

People

Update Times

Update Size (MB)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

$people

$update_times

$update_size

total

/

$total_download_times

$total_download_size

"; }elseif(($len_year != 0)&&($len_month != 0)&&($len_day == 0)){ ///// get info for days of month of year echo "Select: ".$year."/".$month."
"; echo "\n"; echo "\n"; echo ""; echo ""; echo ""; echo ""; echo "\n"; for ($i=1, $j=2; $i <= 12; $i++,$j++){ if ($i < 10){ $query = sprintf("SELECT sn, update_size FROM update_info_enhance where update_date >= '%d-0%d-01' and update_date < '%d-0%d-01'", $year, $i, $year, $j); $query_sn = sprintf("SELECT distinct sn FROM update_info_enhance where update_date >= '%d-0%d-01' and update_date < '%d-0%d-01'", $year, $i, $year, $j); } else{ $query = sprintf("SELECT sn, update_size FROM update_info_enhance where update_date >= '%d-%d-01' and update_date < '%d-%d-01'", $year, $i, $year, $j); $query_sn = sprintf("SELECT distinct sn FROM update_info_enhance where update_date >= '%d-%d-01' and update_date < '%d-0%d-01'", $year, $i, $year, $j); } echo ""; // echo ""; /* Get the number of update people*/ $result = mysql_query($query_sn); $people = mysql_num_rows($result); if ($people == 0){ // die ('@@@ No people updated:' . mysql_error()); } // echo ""; echo "\n"; for ($i=1; $i <= 31; $i++){ if ($i < 10){ if ($month < 10){ $query = sprintf("SELECT * FROM update_info_enhance where update_date='%d-0%d-0%d'", $year, $month, $i); $query_sn = sprintf("SELECT distinct sn FROM update_info_enhance where update_date='%d-0%d-0%d'", $year, $month, $i); }else{ $query = sprintf("SELECT * FROM update_info_enhance where update_date='%d-%d-0%d'", $year, $month, $i); $query_sn = sprintf("SELECT distinct sn FROM update_info_enhance where update_date='%d-%d-0%d'", $year, $month, $i); } }else{ if ($month < 10){ $query = sprintf("SELECT * FROM update_info_enhance where update_date='%d-0%d-%d'", $year, $month, $i); $query_sn = sprintf("SELECT distinct sn FROM update_info_enhance where update_date='%d-0%d-%d'", $year, $month, $i); }else{ $query = sprintf("SELECT * FROM update_info_enhance where update_date='%d-%d-%d'", $year, $month, $i); $query_sn = sprintf("SELECT distinct sn FROM update_info_enhance where update_date='%d-%d-%d'", $year, $month, $i); } } echo ""; echo ""; /* Get the number of update people*/ $result = mysql_query($query_sn); $people = mysql_num_rows($result); if ($people == 0){ // die ('@@@ No people updated:' . mysql_error()); } echo ""; mysql_free_result($result); $result = mysql_query($query); /* Update Times */ $update_times = 0; $update_times = mysql_num_rows($result); if ($update_times == 0){ // die ('@@@ No Updated:' . mysql_error()); } echo ""; $total_download_times += $update_times; /* Get update_size/month */ $down_size = 0; while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $down_size += $row["update_size"]; } $update_size = (int)($down_size/1024); $total_download_size += $update_size; echo ""; $down_size = 0; mysql_free_result($result); echo ""; // echo "
"; } /* Total for particular month */ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

Day	People	Update Times	Update Size (MB)
$i	$people
$i	$people	$update_times	$update_size
total	/	$total_download_times	$total_download_size

"; } }elseif(($len_year != 0)&&($len_month != 0)&&($len_day != 0)){ ///// day info echo "Select: ".$year."/".$month."/".$day."
"; if ($day<10) $query = sprintf("SELECT * FROM update_info_enhance where update_date='%d-%d-0%d'", $year, $month, $day); else $query = sprintf("SELECT * FROM update_info_enhance where update_date='%d-%d-%d'", $year, $month, $day); // start query with row! $result = mysql_query($query); if (!result){ die ('@@@ Invalid query: ' . mysql_error()); } /* Count row */ $num = mysql_num_rows($result); if ($num == 0){ die ('!No update record' . mysql_error()); } // echo "rows_num: $num"; /* Use html display the result which perform SQL query */ echo "\n"; echo "\n"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "\n"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)){ echo ""; foreach ($line as $col_value){ echo ""; } echo ""; // echo "
"; } echo "

Id	SN	Update Date	Update Time	Download Time	Download Size (KB)	Download List
$col_value

"; /* Free result */ $free_result = mysql_free_result($result); if (!$free_result){ die ('Free memory: ' . mysql_error()); } //echo "###### Success to free result
"; }else{ echo "error! Please check you input"; } /* Closed connect */ mysql_close ($link); //END /////////////////////////////////////////////////////////////////// ?>