<?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);