File: /var/www/nclive/technc/seo_contentedit.php
<?php
header('Content-Type: application/json');
include "config.php";
$id=$_REQUEST['id'];
$query="select ps.id,ps.title,ps.keywords,ps.meta_keywords,ps.meta_description,ps.exam_id,ps.category_id,e.exam_name,ec.name from sp_pages_seo as ps
left join sp_exam as e on e.exam_id=ps.exam_id
left join sp_exam_category as ec on ec.cat_id=ps.category_id
where ps.id='$id'";
$sql=$db->prepare($query);
$sql->execute();
$row=$sql->fetch();
echo json_encode($row,TRUE);
?>