function select_test($table, $data, $condition) { include '../helpers/QueryGenrator.php'; $QueryGen = new QueryGenrator(); include '../Models/Database.php'; $DB = new DatabaseModel(); $Query = $QueryGen->select($table, $data, $condition); $DBEntry = $DB->select($Query); print_r($DBEntry); }
/** * Created by PhpStorm. * User: sp * Date: 25/11/15 * Time: 3:56 PM */ function GetUsername($Data) { $table = 'userinfo'; require_once '../common/Models/Database.php'; require_once '../common/helpers/QueryGenrator.php'; $QueryGen = new QueryGenrator(); $DB = new DatabaseModel(); $Username = $Data['Username']; $Query = $QueryGen->select($table, $Data = "None", $Condition = "WHERE `Username` = '{$Username}'"); $DBEntry = $DB->select($Query); return $DBEntry; }
/** * Created by PhpStorm. * User: root * Date: 21/11/15 * Time: 5:42 PM */ function GetUser($Data) { $table = 'userinfo'; include '../common/Models/Database.php'; include '../common/helpers/QueryGenrator.php'; $QueryGen = new QueryGenrator(); $DB = new DatabaseModel(); $Token = $Data['Token']; $Query = $QueryGen->select($table, $Data = "None", $Condition = "WHERE `AccessToken` = '{$Token}'"); $DBEntry = $DB->select($Query); return $DBEntry; }
/** * Created by PhpStorm. * User: root * Date: 21/11/15 * Time: 5:42 PM */ function AddToken($Data) { include '../common/Models/Database.php'; include '../common/helpers/QueryGenrator.php'; $table = 'userinfo'; $QueryGen = new QueryGenrator(); $DB = new DatabaseModel(); $data = array("AccessToken" => getGUID()); $Email = $Data['Email']; $Password = $Data['Password']; $condition = "WHERE Email = '{$Email}' AND Password = '******'"; $QueryCheck = $Query = $QueryGen->select($table, $DATA = "None", $condition); $CheckInfo = $DB->select($QueryCheck); if ($CheckInfo == ERROR_DATA_NOT_FOUND) { return ERROR_DATA_NOT_FOUND; } $Query = $QueryGen->update($table, $data, $condition); $DBEntry = $DB->update($Query); return $data['AccessToken']; }
/** * Created by PhpStorm. * User: root * Date: 21/11/15 * Time: 5:42 PM */ function GetFile($Username) { $table = 'codes'; require_once '../common/Models/Database.php'; require_once '../common/helpers/QueryGenrator.php'; $QueryGen = new QueryGenrator(); $DB = new DatabaseModel(); $Query = $QueryGen->select($table, $Data = "None", $Condition = "WHERE `Username` = '{$Username}'"); $GetResponse = $DB->select($Query); if ($GetResponse != 903) { $Response["STATUS"] = "True"; $Response["STATUS CODE"] = 200; $Response['Payloads'] = $GetResponse; } else { $Response["STATUS"] = "True"; $Response["STATUS CODE"] = 903; $Response["Message"] = "No Data Found"; } return $Response; }