<?php

 /*
 * Created by Belal Khan
 * website: www.simplifiedcoding.net
 * Retrieve Data From MySQL Database in Android
 */

 //database constants
 define('DB_HOST', 'localhost');
 define('DB_USER', 'smsEngine');
 define('DB_PASS', 'guEnaR28T');
 define('DB_NAME', 'smartsmsrouter');

 //connecting to database and getting the connection object
 $conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);

 //Checking if any error occured while connecting
 if (mysqli_connect_errno()) {
 echo "Failed to connect to MySQL: " . mysqli_connect_error();
 die();
 }

  $serial =$_GET["sn"];
  
  if($serial != ""){

      $query = "select sn, newstitle,newsdetails,newsdate from  penpalamericanews where sn ='$serial' order by sn desc limit 200";
  }else{

      $query = "select sn, newstitle,newsdetails,newsdate from  penpalamericanews order by sn desc limit 200";
    }
 //creating a query
 $stmt = $conn->prepare($query);

 //executing the query
 $stmt->execute();

 //binding results to the query
 $stmt->bind_result($sn,$newstittle,$newsdetails,$newsdate );
  //$response["goal"] = array();
 $news["penpalafricanews"] = array();
 //traversing through all the result
 while($stmt->fetch()){
 $temp = array();
 $temp['sn']=$sn;
 $temp['newstitle'] = trim($newstittle);
 $temp['newsdetails'] = trim($newsdetails);
 $temp['newsdate'] = date("d-m-Y", strtotime($newsdate));
 array_push($news["penpalafricanews"], $temp);
 }

 //displaying the result in json format
 echo json_encode($news);

?>