<?php
require_once "c_transactions.php";
$db = new db_transactions();
$sql = "SELECT \nvariables_id AS VariableID, \nv_study_id AS StudyID,\ntb_status AS TB_Status, \npreg_status AS Preg_Status,\nedd AS EDD,\nfp_status AS FP_status, \ndisclosure AS HIV_Disclosure,\nnext_visit_date AS Next_visit_date\nFROM variables";
$data = $db->getAssoArray($sql);
$results = array("sEcho" => 1, "iTotalRecords" => count($data), "iTotalDisplayRecords" => count($data), "aaData" => $data);
/*while($row = $result->fetch_array(MYSQLI_ASSOC)){
$results["data"][] = $row ;
}*/
echo json_encode($results);
