Exemplos de QueryGenrator em PHP

Exemplo n.º 1

Arquivo: QueryTest.php Projeto: spandey2405/onlinecoder

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

Exemplo n.º 2

Arquivo: user_add.php Projeto: spandey2405/onlinecoder

/**
 * Created by PhpStorm.
 * User: root
 * Date: 21/11/15
 * Time: 5:42 PM
 */
function AddUser($Data)
{
    $table = 'userinfo';
    include '../common/Models/Database.php';
    include '../common/helpers/QueryGenrator.php';
    $QueryGen = new QueryGenrator();
    $DB = new DatabaseModel();
    $Query = $QueryGen->insert($table, $Data);
    $DBEntry = $DB->insert($Query);
    return $DBEntry;
}

Exemplo n.º 3

Arquivo: Username.php Projeto: spandey2405/onlinecoder

/**
 * 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;
}

Exemplo n.º 4

Arquivo: user_get.php Projeto: spandey2405/onlinecoder

/**
 * 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;
}

Exemplo n.º 5

Arquivo: add_file.php Projeto: spandey2405/onlinecoder

/**
 * Created by PhpStorm.
 * User: root
 * Date: 21/11/15
 * Time: 5:42 PM
 */
function AddFile($Data)
{
    $table = 'codes';
    require_once '../common/Models/Database.php';
    require_once '../common/helpers/QueryGenrator.php';
    $QueryGen = new QueryGenrator();
    $DB = new DatabaseModel();
    $Query = $QueryGen->insert($table, $Data);
    $DBEntry = $DB->insert($Query);
    if ($DBEntry == 200) {
        return 201;
    }
    return $DBEntry;
}

Exemplo n.º 6

Arquivo: Rename.php Projeto: spandey2405/onlinecoder

/**
 * Created by PhpStorm.
 * User: sp
 * Date: 25/11/15
 * Time: 2:04 PM
 */
function RenameFile($Data)
{
    require_once '../common/Models/Database.php';
    require_once '../common/helpers/QueryGenrator.php';
    $table = 'codes';
    $QueryGen = new QueryGenrator();
    $DB = new DatabaseModel();
    $File = $Data['File'];
    $Username = $Data['Username'];
    $Filename = $Data['Filename'];
    $data = array("Filename" => $Filename);
    $Query = $QueryGen->update($table, $data, $condition = $Condition = "WHERE `Username` = '{$Username}' AND `File` = '{$File}'");
    $DBEntry = $DB->update($Query);
    return $DBEntry;
}

Exemplo n.º 7

Arquivo: add_token.php Projeto: spandey2405/onlinecoder

/**
 * 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'];
}

Exemplo n.º 8

Arquivo: file_get.php Projeto: spandey2405/onlinecoder

/**
 * 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;
}