File: /var/www/nclive/backend/sp_other_links_data.php
<?php
header("Access-Control-Allow-Origin: *");
header('Content-Type: application/json');
include "config.php";
$json = file_get_contents('php://input');
$data = json_decode($json);
$post_slug = $data->post;
$query="SELECT id,post_name,post_slug,logo,summary,description,status FROM sp_other_links WHERE post_slug='$post_slug'";
$sql=$db->prepare($query);
$sql->execute();
$mainarray=array();
while($row=$sql->fetch()){
$id=$row['id'];
$post_name=$row['post_name'];
$post_slug=$row['post_slug'];
$logo=$row['logo'];
$summary=$row['summary'];
$description=$row['description'];
$status=$row['status'];
$array=array("id"=>$id,"post_name"=>$post_name,"post_slug"=>$post_slug,"logo"=>$logo,"summary"=>$summary,"description"=>$description,"status"=>$status);
$mainarray[]=$array;
}
echo json_encode($mainarray);
?>