Example #1
0
<?php

include_once 'DBconnection.php';
$classID = $_GET['classID'];
$myDBconnection = new DBconnection();
$myDBconnection->ConnectToDB();
// echo $classID.'<br>';
$myresponse = $myDBconnection->db->prepare('SELECT DISTINCT class_date FROM ' . $classID);
$myresponse->execute();
$result = $myresponse->fetchAll();
$output = array();
// echo json_encode($result);
foreach ($result as $row) {
    array_push($output, $row['class_date']);
}
// echo $myresponse->rowCount();
// echo $result[0]['class_date'];
// return json_encode($myresponse->rowCount());
echo json_encode($output);
// echo '<br>'.$output[0];