<?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;
}

$domain =$_POST["domain"];

 $query= "select title, messagedetails,dateCreated,link,linktitle,linkurl from penpalnotifications where domain ='$domain' order by sn desc ";
 //echo $query;
 $cnt ="#";

       $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))
   {
     	
	
        $items[] = [
       'title' => $row[0],
	'messageDetails' => $row[1],	
       'dateCreated' => $row[2],
       'link' => $row[3],
       'linkTitle' => $row[4],
       'linkUrl' => $row[5]
	
    ];

	

   }
   echo json_encode($items);

   mysqli_close($con);
   return $cnt;
 }


?>