function DeleteUser($DeleteUserName)
{
    if ($DeleteUserName != '') {
        $DBH = GetDBHandle();
        $DelUserQuery = $DBH->prepare("delete from login where username = ?");
        $DelUserQuery->bindParam(1, $DeleteUserName, PDO::PARAM_STR);
        $DelUserQuery->execute();
        print_r(json_encode(array("DeletedUsers" => $DelUserQuery->rowCount())));
    }
}
Example #2
0
function FetchColumn($table, $column)
{
    $DBH = GetDBHandle();
    $QuerySelect = '';
    // echo "Connected";
    // echo "Connected";
    if ($DBH != null) {
        // echo "Connected";
        $QuerySelect = $DBH->prepare("select " . $column . " from " . $table);
        $QuerySelect->execute();
    }
    // return json_encode($QuerySelect->fetchAll());
    return $QuerySelect->fetchAll();
}
Example #3
0
function FetchColumn($table, $column)
{
    $DBH = GetDBHandle();
    // $DBH = new PDO("mysql:host=".$host.";dbname=".$dbname,$username,$password) or die("Not able to connect");
    // $DBH->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
    if ($DBH != null) {
        // echo "Connected";
        $query = "select " . $column . " from " . $table;
        $QuerySelect = $DBH->prepare($query) or die("error");
        $QuerySelect->execute();
        $res = $QuerySelect->fetchAll() or die;
        //echo count($res);
        // foreach($res as $r)
        // echo $r[0];
        return $res;
    }
}
Example #4
0
    } else {
        echo "";
    }
} else {
    if ($logout) {
        $_SESSION['LoggedInUser'] = "";
        $_SESSION['UserRole'] = "";
        if ($_SESSION) {
            session_start();
            session_destroy();
        }
    } else {
        $loginusername = $_POST['username'];
        $loginhash = $_POST['passwordhash'];
        // echo "mysql:host=".$host.";dbname=".$dbname."$loginusername"."$loginhash"; //.";port=".$port
        $DBH = GetDBHandle();
        //new PDO("mysql:host=".$host.";dbname=".$dbname.";port=".$port,$username,$password) or die("Not able to connect"); //<!--.";port=".$port-->
        // $DBH->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
        if ($DBH != null) {
            $checkuser = $DBH->prepare("CALL sp_CheckUser(?,?)");
            $checkuser->bindParam(1, $loginusername, PDO::PARAM_STR);
            $checkuser->bindParam(2, $loginhash, PDO::PARAM_STR);
            // echo "loginhash ".$loginhash;
            $checkuser->execute();
            // echo $checkuser->rowCount();
            if ($checkuser->rowCount() == '1') {
                echo "count:" . $checkuser->rowCount();
                $row = $checkuser->fetch();
                //All(PDO::FETCH_ASSOC);
                session_start();
                // echo $row[1];
Example #5
0
function GetBillItems($BillID)
{
    if ($BillID != '' && $BillID != null) {
        $DBH = GetDBHandle();
        $ItemDetailsQuery = $DBH->prepare("select * from billitems where BillID = ?");
        $ItemDetailsQuery->bindParam(1, $BillID, PDO::PARAM_INT);
        $ItemDetailsQuery->execute();
        print_r(json_encode($ItemDetailsQuery->fetchAll()));
    }
}