<?php
session_start();
if($_SESSION["username"]=="")
{
 	echo "You are not Logged in Please <a href='index.html'>Sign in </a> First ";
}
else
{
include 'dbc.php';
date_default_timezone_set("Asia/Karachi");
$today=date("Y-m-d");
$month = date("m",strtotime($today));
		$year = date("Y",strtotime($today));
		 $month_name = date("F", mktime(0, 0, 0, $month, 10));
		 $my=$month_name . " " . $year;
$userid=$_SESSION["userid"];
$sql = "SELECT * FROM admission where  user_id='$userid'";
$result=$conn->query($sql);
while($row = $result->fetch_assoc())
 
  {
  $tfee=$tfee + $row['mfee'];
 
$trecord=$trecord + 1;
  }
  
  $sql2 = "SELECT * FROM admission where month='$my' and  user_id='$userid'";
$result2=$conn->query($sql2);
while($row2 = $result2->fetch_assoc())
 
  {
  $tfee2=$tfee2 + $row2['mfee'];
 
$trecord2=$trecord2 + 1;
  }
  
  $sqlactive = "SELECT * FROM admission where status='Active' and  user_id='$userid'";
$resultactive=$conn->query($sqlactive);
while($rowactive = $resultactive->fetch_assoc())
 
  {
  $tfeeactive=$tfeeactive + $rowactive['mfee'];
 
$trecordactive=$trecordactive + 1;
  }
  
   $sqlinactive = "SELECT * FROM admission where status='InActive' and  user_id='$userid'";
$resultinactive=$conn->query($sqlinactive);
while($rowinactive = $resultinactive->fetch_assoc())
 
  {
  $tfeeinactive=$tfeeinactive + $rowinactive['mfee'];
 
$trecordinactive=$trecordinactive + 1;
  }
$sql3 = "SELECT * FROM admission where user_id='$userid' and bal > 0";
$result3=$conn->query($sql3);
while($row3 = $result3->fetch_assoc())
 
  {
 
  $tbal3=$tbal3 + $row3['bal'];
$trecord3=$trecord3 + 1;
  }
  
  $sql3act = "SELECT * FROM admission where status='Active' and user_id='$userid' and bal > 0";
$result3act=$conn->query($sql3act);
while($row3act = $result3act->fetch_assoc())
 
  {
 
  $tbal3act=$tbal3act + $row3act['bal'];
$trecord3act=$trecord3act + 1;
  }
  
  $sql3inact = "SELECT * FROM admission where status='InActive' and user_id='$userid' and bal > 0";
$result3inact=$conn->query($sql3inact);
while($row3inact = $result3inact->fetch_assoc())
 
  {
 
  $tbal3inact=$tbal3inact + $row3inact['bal'];
$trecord3inact=$trecord3inact + 1;
  }
  
   $sqldisc1 = "SELECT * FROM admission where status='Active' and user_id='$userid'";
$resultdisc1=$conn->query($sqldisc1);
while($rowdisc1 = $resultdisc1->fetch_assoc())
 
  {
 $disc1= $rowdisc1['feedisc1'];
  $tbaldisc1=$tbaldisc1 + $rowdisc1['feebal1'];
$trecorddisc1=$trecorddisc1 + 1;
  }
  
 $sqldisc2 = "SELECT * FROM admission where status='Active' and user_id='$userid'";
$resultdisc2=$conn->query($sqldisc2);
while($rowdisc2 = $resultdisc2->fetch_assoc())
 
  {
 $disc2= $rowdisc2['feedisc2'];
  $tbaldisc2=$tbaldisc2 + $rowdisc2['feebal2'];
$trecorddisc2=$trecorddisc2 + 1;
  }
  
 $sqldisc3 = "SELECT * FROM admission where status='Active' and user_id='$userid'";
$resultdisc3=$conn->query($sqldisc3);
while($rowdisc3 = $resultdisc3->fetch_assoc())
 
  {
 $disc3= $rowdisc3['feedisc3'];
  $tbaldisc3=$tbaldisc3 + $rowdisc3['feebal3'];
$trecorddisc3=$trecorddisc3 + 1;
  }
  
   $sqldisc4 = "SELECT * FROM admission where status='Active' and user_id='$userid'";
$resultdisc4=$conn->query($sqldisc4);
while($rowdisc4 = $resultdisc4->fetch_assoc())

  {
  $disc4= $rowdisc4['feedisc4'];
  $tbaldisc4=$tbaldisc4 + $rowdisc4['feebal4'];
$trecorddisc4=$trecorddisc4 + 1;
}
 $sqldisc5 = "SELECT * FROM admission where status='Active' and user_id='$userid'";
$resultdisc5=$conn->query($sqldisc5);
while($rowdisc5 = $resultdisc5->fetch_assoc())
 
  {
 $disc5= $rowdisc5['feedisc5'];
  $tbaldisc5=$tbaldisc5 + $rowdisc5['feebal5'];
$trecorddisc5=$trecorddisc5 + 1;
  }
  
  $sqldisc6 = "SELECT * FROM admission where status='Active' and user_id='$userid'";
$resultdisc6=$conn->query($sqldisc6);
while($rowdisc6 = $resultdisc6->fetch_assoc())

  {
  $disc6= $rowdisc6['feedisc6'];
  $tbaldisc6=$tbaldisc6 + $rowdisc6['feebal6'];
$trecorddisc6=$trecorddisc6 + 1;
  }
  
  
  $sqlissue = "SELECT * FROM issueslip where month_name='$my' and  user_id='$userid'";
$resultissue=$conn->query($sqlissue);
while($rowissue = $resultissue->fetch_assoc())
 
  {
  $tissue=$tissue + $rowissue['mfee'];
$trecordissue=$trecordissue + 1;
  }
  
   $sqlrec = "SELECT * FROM issueslip where month_name='$my' and  user_id='$userid' and feerec > 0";
$resultrec=$conn->query($sqlrec);
while($rowrec = $resultrec->fetch_assoc())
 
  {
  $trecfee=$trecfee + $rowrec['feerec'];
$trecordrecfee=$trecordrecfee + 1;
  }
  
   $sqlfeebal = "SELECT * FROM issueslip where month_name='$my' and  user_id='$userid' and feebal > 0";
$resultfeebal=$conn->query($sqlfeebal);
while($rowfeebal = $resultfeebal->fetch_assoc())
 
  {
  $tfeebal=$tfeebal + $rowfeebal['feebal'];
$trecordfeebal=$trecordfeebal + 1;
  }
  
   $sqlwidraw = "SELECT * FROM widraw where month='$my' and  user_id='$userid'";
$resultwidraw=$conn->query($sqlwidraw);
while($rowwidraw = $resultwidraw->fetch_assoc())
 
  {
  $twidraw=$twidraw + $rowwidraw['bal'];
$trecordwidraw=$trecordwidraw + 1;
  }
  
   $sqlw = "SELECT * FROM widraw where  user_id='$userid'";
$resultw=$conn->query($sqlw);
while($roww = $resultw->fetch_assoc())
 
  {
  $tw=$tw + $roww['bal'];
$trecordw=$trecordw + 1;
  }
  
  
   $sqlsalary = "SELECT * FROM paidsalary where month_name='$my' and  user_id='$userid'";
$resultsalary=$conn->query($sqlsalary);
while($rowsalary = $resultsalary->fetch_assoc())
 
  {
  $tsalary=$tsalary + $rowsalary['netsalary'];
$trecordsalary=$trecordsalary + 1;
  }
  
   $sqlexp = "SELECT * FROM expense_voucher where month_name='$my' and  user_id='$userid'";
$resultexp=$conn->query($sqlexp);
while($rowexp = $resultexp->fetch_assoc())
 
  {
  $texp=$texp + $rowexp['amount'];
$trecordexp=$trecordexp + 1;
  }
  
  $sqla = "SELECT * FROM attendence where date='$today' and  status='A' and  user_id='$userid'";
$resulta=$conn->query($sqla);
while($rowa = $resulta->fetch_assoc())
 
  {
  
$trecorda=$trecorda + 1;
  }
  $sqlp = "SELECT * FROM attendence where date='$today' and  status='P' and  user_id='$userid'";
$resultp=$conn->query($sqlp);
while($rowp = $resultp->fetch_assoc())
 
  {
  
$trecordp=$trecordp + 1;
  }
  
   $sqll = "SELECT * FROM attendence where date='$today' and  status='L' and  user_id='$userid'";
$resultl=$conn->query($sqll);
while($rowl = $resultl->fetch_assoc())
 
  {
  
$trecordl=$trecordl + 1;
  }
  
?>
<!doctype html>
<!--[if lt IE 7]>      <html class="no-js lt-ie9 lt-ie8 lt-ie7" lang=""> <![endif]-->
<!--[if IE 7]>         <html class="no-js lt-ie9 lt-ie8" lang=""> <![endif]-->
<!--[if IE 8]>         <html class="no-js lt-ie9" lang=""> <![endif]-->
<!--[if gt IE 8]><!-->
<html class="no-js" lang="en">
<!--<![endif]-->

<head>
   <?php include("includes/header.php") ?>
</head>

<body>


    <!-- Left Panel -->

    <?php include("includes/menu.php") ?><!-- /#left-panel -->

    <!-- Left Panel -->

    <!-- Right Panel -->

    <div id="right-panel" class="right-panel">

        <!-- Header-->
        <header id="header" class="header">

             <?php include("includes/headermenu.php") ?>

        </header><!-- /header -->
        <!-- Header-->

        <div class="breadcrumbs">
            <div class="col-sm-6">
                <div class="page-header float-left">
                    <div class="page-title">
                        <h1><? echo "" . $_SESSION["userid"]; ?></h1>
                    </div>
                </div>
            </div>
            <div class="col-sm-6">
                <div class="page-header float-right">
                    <div class="page-title">
                        <ol class="breadcrumb text-right">
                            <li class="active"><? echo "" . $_SESSION["username"]; ?></li>
                        </ol>
                    </div>
                </div>
            </div>
        </div>

        <div class="content mt-3">

           


            <div class="col-sm-6 col-lg-3">
                <div class="card text-white bg-flat-color-1">
                    <div class="card-body pb-0">
                        <div class="dropdown float-right">
                            
                            
                        </div>
                        <h4 class="mb-0">
                            <span class="count"><?php echo $trecord; ?></span>
							/
							<span class="count"><?php echo $tfee; ?></span>
                        </h4>
                        <p class="text-light">Total: Students/Tution Fee</p>

                        <div class="chart-wrapper px-0" style="height:70px;" height="70">
                            <canvas id="widgetChart1"></canvas>
                        </div>

                    </div>

                </div>
            </div>
            <!--/.col-->

            <div class="col-sm-6 col-lg-3">
                <div class="card text-white bg-flat-color-2">
                    <div class="card-body pb-0">
                        <div class="dropdown float-right">
                            
                            
                        </div>
                        <h4 class="mb-0">
						 <span class="count"><?php echo $trecord2; ?></span>
							/
                            <span class="count"><?php echo $tfee2; ?></span>
                        </h4>
                        <p class="text-light"> <?php echo $month_name; ?>:New Admission </p>

                        <div class="chart-wrapper px-0" style="height:70px;" height="70">
                            <canvas id="widgetChart2"></canvas>
                        </div>

                    </div>
                </div>
            </div>
            <!--/.col-->

            <div class="col-sm-6 col-lg-3">
                <div class="card text-white bg-flat-color-3">
                    <div class="card-body pb-0">
                        <div class="dropdown float-right">
                            
                            
                        </div>
                        <h4 class="mb-0">
						<span class="count"><?php echo $trecordactive; ?></span>
							/
                            <span class="count"><?php echo $tfeeactive; ?></span>
							
                        </h4>
                        <p class="text-light">Active Students </p>

                    </div>

                    <div class="chart-wrapper px-0" style="height:70px;" height="70">
                        <canvas id="widgetChart3"></canvas>
                    </div>
                </div>
            </div>
            <!--/.col-->

            <div class="col-sm-6 col-lg-3">
                <div class="card text-white bg-flat-color-4">
                    <div class="card-body pb-0">
                        <div class="dropdown float-right">
                            
                            
                        </div>
                        <h4 class="mb-0">
						<span class="count"><?php echo $trecordinactive; ?></span>
							/
                            <span class="count"><?php echo $tfeeinactive; ?></span>
                        </h4>
                        <p class="text-light">InActive Students</p>

                        <div class="chart-wrapper px-3" style="height:70px;" height="70">
                            <canvas id="widgetChart4"></canvas>
                        </div>

                    </div>
                </div>
            </div>
           
		   
		   <div class="col-sm-6 col-lg-3">
                <div class="card text-white bg-flat-color-4">
                    <div class="card-body pb-0">
                        <div class="dropdown float-right">
                            
                            
                        </div>
                        <h4 class="mb-0">
						<span class="count"><?php echo $trecord3; ?></span>
							/
                            <span class="count"><?php echo $tbal3; ?></span>
							
                        </h4>
                        <p class="text-light">Total Bal Fee</p>

                    </div>

                    <div class="chart-wrapper px-0" style="height:70px;" height="70">
                        <canvas id="widgetChart3"></canvas>
                    </div>
                </div>
            </div>
			
			
			
			
			
			<div class="col-sm-6 col-lg-3">
                <div class="card text-white bg-flat-color-3">
                    <div class="card-body pb-0">
                        <div class="dropdown float-right">
                            
                            
                        </div>
                        <h4 class="mb-0">
						<span class="count"><?php echo $trecord3act; ?></span>
							/
                            <span class="count"><?php echo $tbal3act; ?></span>
							
                        </h4>
                        <p class="text-light">Active Student Bal Fee</p>

                    </div>

                    <div class="chart-wrapper px-0" style="height:70px;" height="70">
                        <canvas id="widgetChart3"></canvas>
                    </div>
                </div>
            </div>
			
			
			
			
			<div class="col-sm-6 col-lg-3">
                <div class="card text-white bg-flat-color-2">
                    <div class="card-body pb-0">
                        <div class="dropdown float-right">
                            
                            
                        </div>
                        <h4 class="mb-0">
						<span class="count"><?php echo $trecord3inact; ?></span>
							/
                            <span class="count"><?php echo $tbal3inact; ?></span>
							
                        </h4>
                        <p class="text-light">InActive Student Bal Fee</p>

                    </div>

                    <div class="chart-wrapper px-0" style="height:70px;" height="70">
                        <canvas id="widgetChart3"></canvas>
                    </div>
                </div>
            </div>
			
			
			
			<div class="col-sm-6 col-lg-3">
                <div class="card text-white bg-flat-color-1">
                    <div class="card-body pb-0">
                        <div class="dropdown float-right">
                            
                            
                        </div>
                        <h4 class="mb-0">
						
                            <span class="count"><?php echo $tbaldisc1; ?></span>
							
                        </h4>
                        <p class="text-light"><?php echo $disc1; ?>:Balance</p>

                    </div>

                    <div class="chart-wrapper px-0" style="height:70px;" height="70">
                        <canvas id="widgetChart3"></canvas>
                    </div>
                </div>
            </div>
			
			
			
			
			<div class="col-sm-6 col-lg-3">
                <div class="card text-white bg-flat-color-3">
                    <div class="card-body pb-0">
                        <div class="dropdown float-right">
                            
                            
                        </div>
                        <h4 class="mb-0">
						
                            <span class="count"><?php echo $tbaldisc2; ?></span>
							
                        </h4>
                        <p class="text-light"><?php echo $disc2; ?>:Balance</p>

                    </div>

                    <div class="chart-wrapper px-0" style="height:70px;" height="70">
                        <canvas id="widgetChart3"></canvas>
                    </div>
                </div>
            </div>
			
			
			
			<div class="col-sm-6 col-lg-3">
                <div class="card text-white bg-flat-color-1">
                    <div class="card-body pb-0">
                        <div class="dropdown float-right">
                            
                            
                        </div>
                        <h4 class="mb-0">
						
                            <span class="count"><?php echo $tbaldisc3; ?></span>
							
                        </h4>
                        <p class="text-light"><?php echo $disc3; ?>:Balance</p>

                    </div>

                    <div class="chart-wrapper px-0" style="height:70px;" height="70">
                        <canvas id="widgetChart3"></canvas>
                    </div>
                </div>
            </div>
			
			
	<div class="col-sm-6 col-lg-3">
                <div class="card text-white bg-flat-color-2">
                    <div class="card-body pb-0">
                        <div class="dropdown float-right">
                            
                            
                        </div>
                        <h4 class="mb-0">
						
                            <span class="count"><?php echo $tbaldisc4; ?></span>
							
                        </h4>
                        <p class="text-light"><?php echo $disc4; ?>:Balance</p>

                    </div>

                    <div class="chart-wrapper px-0" style="height:70px;" height="70">
                        <canvas id="widgetChart3"></canvas>
                    </div>
                </div>
            </div>
			
			
			
			
			<div class="col-sm-6 col-lg-3">
                <div class="card text-white bg-flat-color-3">
                    <div class="card-body pb-0">
                        <div class="dropdown float-right">
                            
                            
                        </div>
                        <h4 class="mb-0">
						
                            <span class="count"><?php echo $tbaldisc5; ?></span>
							
                        </h4>
                        <p class="text-light"><?php echo $disc5; ?>:Balance</p>

                    </div>

                    <div class="chart-wrapper px-0" style="height:70px;" height="70">
                        <canvas id="widgetChart3"></canvas>
                    </div>
                </div>
            </div>
			
			
			
			<div class="col-sm-6 col-lg-3">
                <div class="card text-white bg-flat-color-1">
                    <div class="card-body pb-0">
                        <div class="dropdown float-right">
                            
                            
                        </div>
                        <h4 class="mb-0">
						
                            <span class="count"><?php echo $tbaldisc6; ?></span>
							
                        </h4>
                        <p class="text-light"><?php echo $disc6; ?>:Bal</p>

                    </div>

                    <div class="chart-wrapper px-0" style="height:70px;" height="70">
                        <canvas id="widgetChart3"></canvas>
                    </div>
                </div>
            </div>
					
		   
		   
		   
		   <div class="col-sm-6 col-lg-3">
                <div class="card text-white bg-flat-color-2">
                    <div class="card-body pb-0">
                        <div class="dropdown float-right">
                            
                            
                        </div>
                        <h4 class="mb-0">
						<span class="count"><?php echo $trecordissue; ?></span>
							/
                            <span class="count"><?php echo $tissue; ?></span>
                        </h4>
                        <p class="text-light"><?php echo $my; ?> :Genrate Fee</p>

                        <div class="chart-wrapper px-3" style="height:70px;" height="70">
                            <canvas id="widgetChart4"></canvas>
                        </div>

                    </div>
                </div>
            </div>
		   
		   
		   <div class="col-sm-6 col-lg-3">
                <div class="card text-white bg-flat-color-3">
                    <div class="card-body pb-0">
                        <div class="dropdown float-right">
                            
                            
                        </div>
                        <h4 class="mb-0">
						<span class="count"><?php echo $trecordrecfee; ?></span>
							/
                            <span class="count"><?php echo $trecfee; ?></span>
                        </h4>
                        <p class="text-light"><?php echo $my; ?> : Fee Receipt</p>

                        <div class="chart-wrapper px-3" style="height:70px;" height="70">
                            <canvas id="widgetChart4"></canvas>
                        </div>

                    </div>
                </div>
            </div>
			
			
			
			 <div class="col-sm-6 col-lg-3">
                <div class="card text-white bg-flat-color-4">
                    <div class="card-body pb-0">
                        <div class="dropdown float-right">
                            
                            
                        </div>
                        <h4 class="mb-0">
						<span class="count"><?php echo $trecordfeebal; ?></span>
							/
                            <span class="count"><?php echo $tfeebal; ?></span>
                        </h4>
                        <p class="text-light"><?php echo $my; ?> : Fee Balance</p>

                        <div class="chart-wrapper px-3" style="height:70px;" height="70">
                            <canvas id="widgetChart4"></canvas>
                        </div>

                    </div>
                </div>
            </div>
		   
		   
		   
		   
		   
		   
<div class="col-sm-6 col-lg-3">
                <div class="card text-white bg-flat-color-3">
                    <div class="card-body pb-0">
                        <div class="dropdown float-right">
                            
                            
                        </div>
                        <h4 class="mb-0">
						<span class="count"><?php echo $trecordwidraw; ?></span>
							/
                            <span class="count"><?php echo $twidraw; ?></span>
                        </h4>
                        <p class="text-light"><?php echo $month_name; ?> :Withdraw</p>

                        <div class="chart-wrapper px-3" style="height:70px;" height="70">
                            <canvas id="widgetChart4"></canvas>
                        </div>

                    </div>
                </div>
            </div>
           
            <!--/.col-->

            <div class="col-sm-6 col-lg-3">
                <div class="card text-white bg-flat-color-2">
                    <div class="card-body pb-0">
                        <div class="dropdown float-right">
                            
                            
                        </div>
                        <h4 class="mb-0">
						 <span class="count"><?php echo $trecordw; ?></span>
							/
                            <span class="count"><?php echo $tw; ?></span>
                        </h4>
                        <p class="text-light">Total withdraw/Balance </p>

                        <div class="chart-wrapper px-0" style="height:70px;" height="70">
                            <canvas id="widgetChart2"></canvas>
                        </div>

                    </div>
                </div>
            </div>
            <!--/.col-->
			<div class="col-sm-6 col-lg-3">
                <div class="card text-white bg-flat-color-1">
                    <div class="card-body pb-0">
                        <div class="dropdown float-right">
                            
                            
                        </div>
                        <h4 class="mb-0">
                            <span class="count"><?php echo $trecordsalary; ?></span>
							/
							<span class="count"><?php echo $tsalary; ?></span>
                        </h4>
                        <p class="text-light"><?php echo $month_name; ?>:Salary</p>

                        <div class="chart-wrapper px-0" style="height:70px;" height="70">
                            <canvas id="widgetChart1"></canvas>
                        </div>

                    </div>

                </div>
            </div>

            <div class="col-sm-6 col-lg-3">
                <div class="card text-white bg-flat-color-3">
                    <div class="card-body pb-0">
                        <div class="dropdown float-right">
                            
                            
                        </div>
                        <h4 class="mb-0">
                            <span class="count"><?php echo $texp; ?></span>
							
                        </h4>
                        <p class="text-light"><?php echo $month_name; ?>:Expences</p>

                    </div>

                    <div class="chart-wrapper px-0" style="height:70px;" height="70">
                        <canvas id="widgetChart3"></canvas>
                    </div>
                </div>
            </div>
            <!--/.col-->

            
             

            


            <div class="col-xl-3 col-lg-6">
                <div class="card">
                    <div class="card-body">
                        <div class="stat-widget-one">
                            <div class="stat-icon dib"><i class="ti-user text-primary border-primary"></i></div>
                            <div class="stat-content dib">
                                <div class="stat-text">Absent Students</div>
                                <div class="stat-digit"> <?php echo $trecorda; ?>
							</div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>


            <div class="col-xl-3 col-lg-6">
                <div class="card">
                    <div class="card-body">
                        <div class="stat-widget-one">
                            <div class="stat-icon dib"><i class="ti-user text-primary border-primary"></i></div>
                            <div class="stat-content dib">
                                <div class="stat-text">Present Students</div>
                                <div class="stat-digit"> <?php echo $trecordp; ?>
							</div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <div class="col-xl-3 col-lg-6">
                <div class="card">
                    <div class="card-body">
                        <div class="stat-widget-one">
                            <div class="stat-icon dib"><i class="ti-user text-primary border-primary"></i></div>
                            <div class="stat-content dib">
                                <div class="stat-text">Leave Students</div>
                                <div class="stat-digit"> <?php echo $trecordl; ?>
							</div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
			
			
			<div class="col-xl-3 col-lg-6">
                <div class="card">
                    <div class="card-body">
                        <div class="stat-widget-one">
                            <div class="stat-icon dib"><i class="ti-user text-primary border-primary"></i></div>
                            <div class="stat-content dib">
                                <div class="stat-text"> Complains</div>
                                <div class="stat-digit"> <?php echo $trecordinactive; ?>
							</div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
			
			
<div class="stat-text"><h2>Student Fee Packages</h2></div>
            <div class="card-body">
							<?php

include 'dbc.php';


$userid=$_SESSION["userid"];
$sql = "SELECT * FROM addclass where user_id='$userid'";
$result=$conn->query($sql);
?>
                                <table id="bootstrap-data-table-export" class="table table-striped table-bordered">
                                    <thead>
									<?php
                                       echo "<tr>";
echo "<th > Class Name </th>";
echo "<th > Tution Fee </th>";
echo "<th > Discription Fee1 </th>";
echo "<th > Discription Fee2 </th>";
echo "<th > Discription Fee3 </th>";
echo "<th > Discription Fee4 </th>";
echo "<th > Discription Fee5 </th>";
echo "<th > Discription Fee6 </th>";


echo "</tr>";
?>
                                    </thead>
									
                                    <tbody>
									<?php
                                       while($row = $result->fetch_assoc())
 
  {
  $id = $row['id'];	
   echo "<tr>";
echo "<td>" .$row['cname'] . "</td>";
echo "<td>" .$row['mfee'] . "</td>";
 echo "<td>" .$row['feedisc1'] . ":". $row['fee1'] . "</td>";
  echo "<td>" .$row['feedisc2'] . ":". $row['fee2'] . "</td>";
 echo "<td>" .$row['feedisc3'] . ":". $row['fee3'] . "</td>";
 echo "<td>" .$row['feedisc4'] . ":". $row['fee4'] . "</td>";
 echo "<td>" .$row['feedisc5'] . ":". $row['fee5'] . "</td>";
 echo "<td>" .$row['feedisc6'] . ":". $row['fee6'] . "</td>";

		 
		  
	
  echo "</tr>";


  }
  ?>
                                       
                                    </tbody>
                                </table>
                            </div>


        </div> <!-- .content -->
    </div><!-- /#right-panel -->

    <!-- Right Panel -->

   <?php include("includes/footermenu.php") ?>

</body>

</html>
<?php
}
?>