Beispiel #1
0
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>';
    }
}
Beispiel #2
0
    $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);
}