<?php
$conn = new mysqli("localhost","gtstudent", "", "rocket");
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
if (array_key_exists("veh", $_REQUEST)) {
    $veh = $_REQUEST["veh"];
} else {
    $veh='Titan 34B'; 
}
$q = "select * from launch where vehicle='$veh' order by date asc";
//echo $q . "\n"; 
$result = $conn->query($q);

$arr = array(); 
$count=0;
while ($row = $result->fetch_assoc()) {
    $arr[$count++]= $row;
    if ($count>1000) {
    break;
    }
}
 
$myJSON = json_encode($arr);
echo $myJSON;

?>