<?php
$conn = new mysqli("localhost","gtstudent", "", "rocket");
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
if (array_key_exists("diff", $_REQUEST)) {
    $hard = $_REQUEST["diff"];
} else {
    $hard=1; 
}
//$q = "select name, manufacturer, length, diameter, launchmass, thrust from vehicle where leopayload>0 order by name asc";
$qq = "with aa(co, ve) as (select count(*),vehicle from launch group by vehicle), mind(mind, ve) as (select min(date), vehicle from launch group by vehicle), maxd(maxd, ve) as (select max(date), vehicle from launch group by vehicle) select vehicle.name as name, aa.co as count, mind.mind as first, maxd.maxd as recent  from vehicle join aa on name=aa.ve join mind on name=mind.ve join maxd on maxd.ve=name where aa.co>100 and leopayload=0 order by name asc";
//echo $q . "\n"; 
$result = $conn->query($qq);

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

?>