<?php
header("Access-Control-Allow-Origin: *");
header('Content-Type: application/json');
include "config.php";

$slug=$_REQUEST['slug'];
if(isset($_REQUEST['slug'])){

$query="SELECT id,page_name,title,meta_keyword,focus_keyword,description,status FROM sp_page_keywords WHERE page_name='$slug' AND status='1'";
$sql=$db->prepare($query);
$sql->execute();
while($row=$sql->fetch())
{
$id=$row['id'];
$page_name=$row['page_name'];
$title=$row['title'];
$meta_keyword=$row['meta_keyword'];
$focus_keyword=$row['focus_keyword'];
$description=$row['description'];
$status=$row['status'];
}
$array1=array("id"=>$id,"page_name"=>$page_name,"title"=>$title,"meta_keyword"=>$meta_keyword,"focus_keyword"=>$focus_keyword,"description"=>$description,"status"=>$status);
$mainarray[]=$array1;

//$mainarray=array($array1,);
echo json_encode($mainarray);
}
?>