<?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";
$q = "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, familyname as family from vehicle join aa on name=aa.ve join mind on name=mind.ve join maxd on maxd.ve=name where aa.co>10 and 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($q);

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

?>