Function class

<?php
    $host="localhost";
$username="danduwaw_meetfri";


   
$con=mysql_connect($host, $username, $password)or die(mysql_error());
mysql_select_db("$db_name")or die(mysql_error());    



//========================================
function  markAsUserLogged($email){


$result =mysql_query("UPDATE customer SET logstatus='1' WHERE email='com'")or die(mysql_error());
$json = array();

}

                                   


//==============================================================
       
        $attencence="0";
    
    
function markSubject1Absence($year,$month,$today,$grade,$subject_id1){
$sql = "SELECT `apn` FROM `student` WHERE `grade` = '".$grade."' ";
$result = mysql_query($sql);
$json = array();
if(mysql_num_rows($result))
{
while($row=mysql_fetch_assoc($result))
{
        // $json['student'][]=$row;
        $json[]=$row;
}
}
//======================================================================
if($subject_id1==1){
for($i = 0, $l = count($json); $i < $l; ++$i) {
  $apn=$json[$i];
  $cleanedAPN=$apn['apn'];
 
  $subject_id="1";      
                                           
$inserted_Attendence = mysql_query("INSERT INTO attendence VALUES(null, '$year', '$month', '$today' ,'$grade', '$cleanedAPN', '$subject_id', '$attencence' )")or die(mysql_error());

}
} else{
}
}
//======================================================================
function markSubject2Absence($year,$month,$today,$grade,$subject_id1){
$sql = "SELECT `apn` FROM `student` WHERE `grade` = '".$grade."' ";
$result = mysql_query($sql);
$json = array();
if(mysql_num_rows($result))
{
while($row=mysql_fetch_assoc($result))
{
        // $json['student'][]=$row;
        $json[]=$row;
}
}
//======================================================================
if($subject_id1==2){
for($i = 0, $l = count($json); $i < $l; ++$i) {
  $apn=$json[$i];
  $cleanedAPN=$apn['apn'];
 
  $subject_id="2";      
                                           
$inserted_Attendence = mysql_query("INSERT INTO attendence VALUES(null, '$year', '$month', '$today' ,'$grade', '$cleanedAPN', '$subject_id', '$attencence' )")or die(mysql_error());

}
} else{
}
}
    //========================================
   
function markSubject3Absence($year,$month,$today,$grade,$subject_id1){
$sql = "SELECT `apn` FROM `student` WHERE `grade` = '".$grade."' ";
$result = mysql_query($sql);
$json = array();
if(mysql_num_rows($result))
{
while($row=mysql_fetch_assoc($result))
{
        // $json['student'][]=$row;
        $json[]=$row;
}
}
//======================================================================
if($subject_id1==3){
for($i = 0, $l = count($json); $i < $l; ++$i) {
  $apn=$json[$i];
  $cleanedAPN=$apn['apn'];
 
  $subject_id="3";      
                                           
$inserted_Attendence = mysql_query("INSERT INTO attendence VALUES(null, '$year', '$month', '$today' ,'$grade', '$cleanedAPN', '$subject_id', '$attencence' )")or die(mysql_error());

}
} else{
}
}
?>
----------------------------------------
DB_Connect.php
<?php
class DB_Connect {
    private $conn;

    // Connecting to database
    public function connect() {
      /**
 * Database config variables
 */
define("DB_HOST", "localhost");
define("DB_USER", "danduwawetfri");
define("DB_PASSWORD", " ");
define("DB_DATABASE", "_meetfriends");

        
        // Connecting to mysql database
        $this->conn = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);
        
        // return database handler
        return $this->conn;
    }
}

?>
-----------------------
<?php
       
$host="localhost";





$con=mysql_connect($host, $username, $password)or die(mysql_error());
mysql_select_db("$db_name")or die(mysql_error());


//=================================

$sql = "SELECT * FROM `customer` ";
$result = mysql_query($sql);
$json = array();

if(mysql_num_rows($result)){
    while($row=mysql_fetch_assoc($result)){
        $json['customer'][]=$row;
    }
}
mysql_close($con);
echo json_encode($json );
?>

-----------------------------------------

<?php
   
$host="localhost";
$username="";
$password="";
$db_name=" ";


$con=mysql_connect($host, $username, $password)or die(mysql_error());
mysql_select_db("$db_name")or die(mysql_error());
                      
                            
        $syear= mysql_real_escape_string($_REQUEST['syear']);
        $smonth= mysql_real_escape_string($_REQUEST['smonth']);
    $sdays= mysql_real_escape_string($_REQUEST['sdays']);
   
    $eyear= mysql_real_escape_string($_REQUEST['eyear']);
        $emonth= mysql_real_escape_string($_REQUEST['emonth']);
    $eday= mysql_real_escape_string($_REQUEST['eday']);
   
    $grade= mysql_real_escape_string($_REQUEST['grade']);
    $subject_id= mysql_real_escape_string($_REQUEST['subject_id']);
   
   
   
     $d1= mysql_real_escape_string($_REQUEST['StartDate_madeDate']);
         $d2= mysql_real_escape_string($_REQUEST['EndDate_madeDate']);
  
   // $sql = "SELECT * FROM `payments` WHERE `subject_id` = '".$subject_id."' AND `grade` = '".$grade."' AND
   //      `timestamp` BETWEEN '2013-1-28 00:00:00' and '2015-5-29 00:00:00' ";

  $sql = "SELECT * FROM `payments` WHERE `subject_id` = '".$subject_id."' AND `grade` = '".$grade."' AND
         `timestamp` BETWEEN '".$d1."' and '".$d2."' ";



$result = mysql_query($sql);

$json = array();
if(mysql_num_rows($result))
{
while($row=mysql_fetch_assoc($result))
{
        $json['paid'][]=$row;
}
}else{
 $json="0";  }

echo json_encode($json);
mysql_close($con);

?>
----------------------------

<?php
   

   
$host="localhost";
$username="prathee1_lexisu";
$password=" ";
$db_name="  ";


$con=mysql_connect($host, $username, $password)or die(mysql_error());
mysql_select_db("$db_name")or die(mysql_error());

                            
        $month= mysql_real_escape_string($_REQUEST['month']);
        $date= mysql_real_escape_string($_REQUEST['today']);
    $year= mysql_real_escape_string($_REQUEST['year']);
    $grade= mysql_real_escape_string($_REQUEST['grade']);
    $subject_id= mysql_real_escape_string($_REQUEST['subject_id']);
   
     


$sql = "SELECT * FROM `payments` WHERE `year` = '".$year."' AND `month` = '".$month."' AND `date` = '".$date."' AND `grade` = '".$grade."' AND `subject_id` = '".$subject_id."'";

$result = mysql_query($sql);

$json = array();
if(mysql_num_rows($result))
{
while($row=mysql_fetch_assoc($result))
{
        $json['paid'][]=$row;
}
}

echo json_encode($json);
mysql_close($con);

?>