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()))); } }
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(); }
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; } }
} 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];
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())); } }