include("head_href.php"); ?>
|
|
|
|
|
|
|
|
$query_ma="select count(anum) from auct_master where end_chk !='Y' "; //admin
$result_ma=mysqli_query($connect, $query_ma,$connect);
//echo $query_ma;
$total_ma=mysqli_fetch_array($result_ma); mysqli_free_result($result_ma);
?>
1. Total items currently on listing |
|
$query_ma="select count(anum) from auct_master where auction='2' "; //admin
$result_ma=mysqli_query($connect, $query_ma,$connect);
//echo $query_ma;
$total_ma=mysqli_fetch_array($result_ma); mysqli_free_result($result_ma);
?>
2. Total items on auction |
|
$query_ma="select count(anum) from auct_master where auction='1' "; //admin
$result_ma=mysqli_query($connect, $query_ma,$connect);
//echo $query_ma;
$total_ma=mysqli_fetch_array($result_ma); mysqli_free_result($result_ma);
?>
3. Total items on Classified |
|
$query_mem="select dob from member WHERE authenticated='Y' AND related_sites LIKE '%Tradeinfo%'";
$result_mem=mysqli_query($connect, $query_mem,$connect);
$total_mem=mysqli_num_rows($result_mem);
for($i=0;$rows_mem=mysqli_fetch_array($result_mem);$i++){
$dob=$rows_mem[dob];
$dob1=substr($dob,0,4);
$sum_dob=$sum_dob+$dob1;
} mysqli_free_result($result_mem);
$ave_age=date(Y)-$sum_dob/$total_mem;
?>
4. Total Members registered |
|
$sess_dir='../../session';
$dir=opendir($sess_dir);
for($z=2;$file=readdir($dir);$z++)
{
$f_size=filesize("$sess_dir/$file");
if(($f_size>="60")&&($f_size<="150")){ //admin
//echo "$f_size ";
$ij=$ij+1;
}
}
//echo $ij;
closedir($dir);
?>
5. Total member online now |
|
|
|
|
|
|
|
|
 |
|
|