function reportList() { $db = new DB_Functions(); $reportNames = $db->getAllReportList(); if ($reportNames != false) { $no_of_reports = mysql_num_rows($reportNames); } else { $no_of_reports = 0; } echo '<li><a>NA</a></li>'; if ($no_of_reports > 0) { while ($row = mysql_fetch_array($reportNames)) { echo '<li><a >' . $row["ReportName"] . '</a></li>'; } } else { echo '<li>No Reports Added Yet!</li>'; } }
$result = $db->deleteUser($_POST["DeleteUserId"]); } if (isset($_POST["DeleteReport"])) { $result = $db->deleteReportRow($_POST["DeleteReport"]); } if (isset($_POST["ChangePassword"])) { $result = $db->changePassword($_POST["ChangePassword"], $_POST["Email"], $_POST["Pass"]); } if (isset($_POST["replaceName"])) { $result = $db->replaceResponsible($_POST["replaceName"], $_POST["newName"]); } if (isset($_POST["ChangeEmailId"])) { $result = $db->editEmail($_POST["ChangeEmailId"], $_POST["NewEmailId"]); } if (isset($_POST["ChangePasswordId"])) { $result = $db->editPasswordById($_POST["ChangePasswordId"], $_POST["NewPassword"]); } if (isset($_POST["selectUser"])) { if ($_POST["selectUser"] == "All") { $result = $db->getAllReportList(); } else { $result = $db->getReportList($_POST["selectUser"]); } $arr = array(); $count = 0; while ($row = mysql_fetch_object($result)) { $arr[$count] = array('name1' => $row->ReportName); $count++; } echo json_encode($arr); }