<?php

include "general.php";
include "connect.php";


if ($_SERVER['REQUEST_METHOD'] == 'OPTIONS') {
    header('Access-Control-Allow-Origin : *');
    header('Access-Control-Allow-Methods : POST, GET, OPTIONS, PUT, DELETE');
    header('Access-Control-Allow-Headers : *');
    exit;
}
//****************** Function starts
function getMessageJSON( $email_u,$email_f,$domain)
{
$query ="select name from penpal where email ='$email_u' and domain ='$domain'";
//echo $query;
$myName = getQuery1($query); 
$query ="select name from penpal where email ='$email_f' and domain ='$domain'";
$myFriendName = getQuery1($query); 
$query= "select email_u,email_f,message,sentby,datecreated,messageread,domain,image,sn,messagedeleted from penpalchat where (email_u ='$email_u' and email_f='$email_f' and domain='$domain') or (email_u ='$email_f' and email_f='$email_u' and domain='$domain')";
$con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
       ///Check connection
 if (mysqli_connect_errno())
 {
         // //echo mysqli_error($con);
         //echo "-1";
         return '#';
         die();
 }
 if(!$result= mysqli_query($con,$query))
 {
       mysqli_close($con);
     return "#";
 }
 else
 {

    $items= [];
   while($row = mysqli_fetch_array($result))
   {   
       if($row[7] !=""){
        $items[] = [
          'email_u' => $row[0],'email_f' => $row[1],	'text' => str_replace("^","'", $row[2]), 'sentby' => $row[3],	'datecreated' => $row[4],'read' =>$row[5],'myName' => $myName,	'myFriendName' =>  $myFriendName,'image'=>$row[7],'sn' =>$row[8],'messagedeleted' =>$row[9]
      ];

       }else{
        $items[] = [
          'email_u' => $row[0],'email_f' => $row[1],	'text' => str_replace("^","'", $row[2]), 'sentby' => $row[3],	'datecreated' => $row[4],'read' =>$row[5],'myName' => $myName,	'myFriendName' =>  $myFriendName ,'sn' =>$row[8],'messagedeleted' =>$row[9]
      ];
       }
    
        
  }
	
  echo json_encode($items);
   
}

   mysqli_close($con);
   return "0";
 
}//getUserJSON

//********************** Function ends


//$response = array();


$email_u=$_POST["email_u"];
$email_f=$_POST["email_f"];
$domain =$_POST["domain"];


getMessageJSON ($email_u,$email_f,$domain);



?>