db_json.php

<?php
// tukar jadi data json dari main website
##############################################
include "db_buka.php";// buka pangkalan data #
##############################################
$mysqli = new mysqli($myServer, $myUser, $myPass, $myDB);

$myArray = array();

if ($result = $mysqli->query('SELECT `id`, `bahagian`, `nama`, `link`, `target` FROM link')) 
{
  while($row = $result->fetch_array(MYSQL_ASSOC)) 
  {
    $myArray[] = $row;
  }
  echo json_encode($myArray);
}

$result->close();
$mysqli->close();

?>