<?php
$servername = "mysql.idhostinger.com";
$username = "u826157781_yenni";
$password = "yenni123";

try {
    $conn = new PDO("mysql:host=$servername;dbname= u826157781_dbsi", $username, $password);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $sql = "SELECT * FROM tb_biomhs";

 //Execetute Query diatas
 $query = mysql_query($sql);
 while($dt=mysql_fetch_array($query)){
  $item[] = array(
   "id"=>$dt["id"],
   "nim"=>$dt["nim"],
   "nama"=>$dt["nama"],
   "jk"=>$dt["jk"],
   "hp"=>$dt["hp"]
  );
 }

 //Menampung data yang dihasilkan
 $json = array(
    'result' => 'Success',
    'item' => $item
   );

 //Merubah data kedalam bentuk JSON
 echo json_encode($json);

    }
catch(PDOException $e)
    {
    echo "Connection failed: " . $e->getMessage();
    }
?>