<?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);

    $query = "SELECT * FROM tb_biomhs";

 $stmt = $DBcon->prepare($query);
 $stmt->execute();

 $userData = array();

 while($row=$stmt->fetch(PDO::FETCH_ASSOC)){

  $userData['yenni'][] = $row;
 }

 //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();
    }
?>