<?php

$db_name = "mydatabase";
$mysql_username = "root";
$mysql_password = "";
$server_name = "localhost";


$conn = mysqli_connect($server_name,$mysql_username,$mysql_password,$db_name);

$query = mysqli_query($conn,"SELECT * FROM firsttable INNER JOIN secondtable ON firsttable.secondtable_id = secondtable.secondtable_id");

    while($row = mysqli_fetch_array($query))
    {
      $flag[] = $row;
    }

    print(json_encode($flag));
mysqli_close($conn);

?>