PHP dbHelper::selectの例

コード例 #1

ファイル: index.php プロジェクト: raks437/angularjs-slim-api-product-manager

<?php

require '.././libs/Slim/Slim.php';
require_once 'dbHelper.php';
\Slim\Slim::registerAutoloader();
$app = new \Slim\Slim();
$app = \Slim\Slim::getInstance();
$db = new dbHelper();
$app->get('/products', function () {
    global $db;
    $rows = $db->select("products", "id,sku,name,description,price,mrp,stock,image,packing,status", array());
    echoResponse(200, $rows);
});
$app->post('/products', function () use($app) {
    $data = json_decode($app->request->getBody());
    $mandatory = array('name');
    global $db;
    $rows = $db->insert("products", $data, $mandatory);
    if ($rows["status"] == "success") {
        $rows["message"] = "Product added successfully.";
    }
    echoResponse(200, $rows);
});
$app->put('/products/:id', function ($id) use($app) {
    $data = json_decode($app->request->getBody());
    $condition = array('id' => $id);
    $mandatory = array();
    global $db;
    $rows = $db->update("products", $data, $condition, $mandatory);
    if ($rows["status"] == "success") {
        $rows["message"] = "Product information updated successfully.";

コード例 #2

ファイル: index.php プロジェクト: rvyasg821/test

$app = new \Slim\Slim();
$app = \Slim\Slim::getInstance();
$db = new dbHelper();
/**
 * Database Helper Function templates
 */
/*
select(table name, where clause as associative array)
insert(table name, data as associative array, mandatory column names as array)
update(table name, column names as associative array, where clause as associative array, required columns as array)
delete(table name, where clause as array)
*/
// Companies
$app->get('/companies', function () {
    global $db;
    $rows = $db->select("companies", "CompanyID,Name,Address,City,Country,Email,Phone,status,Directors", array());
    echoResponse(200, $rows);
});
$app->post('/companies', function () use($app) {
    $data = json_decode($app->request->getBody());
    $mandatory = array('Name', 'Address', 'City', 'Country');
    global $db;
    $rows = $db->insert("companies", $data, $mandatory);
    if ($rows["status"] == "success") {
        $rows["message"] = "Company added successfully.";
    }
    echoResponse(200, $rows);
});
$app->put('/companies/:id', function ($id) use($app) {
    $data = json_decode($app->request->getBody());
    $condition = array('CompanyID' => $id);

コード例 #3

ファイル: index.php プロジェクト: softwaretailoring/php-auth

$db = new dbHelper();
$debugcheck = strpos($_SERVER['SERVER_NAME'], "dev.");
if ($debugcheck === false) {
    error_reporting(0);
}
// Register
$app->post('/Mobile/v1_0/Register', function () use($app) {
    try {
        $data = json_decode($app->request->getBody());
        require_once 'passwordHash.php';
        $userusername = $data->UserName;
        $userpassword = $data->NewPassword;
        $userfullname = $data->FullName;
        $useremail = $data->EmailAddress;
        global $db;
        $usernamecheck = $db->select("users", "uid", array('username' => $userusername));
        $emailcheck = $db->select("users", "uid", array('email' => $useremail));
        $ir = null;
        if ($userusername === "" || strlen($userusername) < 3 || strlen($userusername) > 20) {
            $ir = new InvalidRequest();
            $ir->ModelState->ErrorCode = array("1");
            $ir->ModelState->ErrorMessage = array("Wrong UserName.");
        } elseif ($useremail === "" || strlen($useremail) > 254) {
            $ir = new InvalidRequest();
            $ir->ModelState->ErrorCode = array("2");
            $ir->ModelState->ErrorMessage = array("Wrong EmailAddress.");
        } elseif ($userfullname === "" || strlen($userfullname) > 100) {
            $ir = new InvalidRequest();
            $ir->ModelState->ErrorCode = array("3");
            $ir->ModelState->ErrorMessage = array("Wrong FullName.");
        } elseif ($userpassword === "" || strlen($userpassword) < 6) {

コード例 #4

ファイル: index.php プロジェクト: Returtless/angular

<?php

require '.././libs/Slim/Slim.php';
require_once 'dbHelper.php';
// Get Slim instance
\Slim\Slim::registerAutoloader();
$app = new \Slim\Slim();
$app = \Slim\Slim::getInstance();
// call our own dbHelper class
$db = new dbHelper();
/************ This can be called via http://localhost/angularcode-megamenu/api/v1/categories
List all categories where parent=0 and its sub categories ************/
$app->get('/categories', function () {
    global $db;
    $rows = $db->select("categories", "category cat_id,parent,link,description", array('parent' => 0), "ORDER BY description");
    // parent categories node
    $categories = array();
    foreach ($rows["data"] as $row) {
        $cat_id = $row["cat_id"];
        // select (TABLE_NAME,COLUMNS,CONDITION,WHERE_CLAUSE)
        $cr = $db->select("categories", "category cat_id,parent,link,description", array('parent' => $cat_id), "ORDER BY description");
        $category = array();
        // temp array
        $category["cat_id"] = $row["cat_id"];
        $category["description"] = $row["description"];
        $category["link"] = $row["link"];
        $category["sub_categories"] = array();
        // subcategories again an array
        foreach ($cr["data"] as $srow) {
            $subcat = array();
            // temp array

コード例 #5

ファイル: index.php プロジェクト: Ernestrod/hackathon-wun-huesped

\Slim\Slim::registerAutoloader();
$app = new \Slim\Slim();
$app = \Slim\Slim::getInstance();
$db = new dbHelper();
/**
 * Database Helper Function templates
 */
/*
select(table name, where clause as associative array)
insert(table name, data as associative array, mandatory column names as array)
update(table name, column names as associative array, where clause as associative array, required columns as array)
delete(table name, where clause as array)
*/
$app->get('/bolas', function () {
    global $db;
    $rows = $db->select("bolas", "*", array());
    echoResponse(200, $rows);
});
$app->post('/bolas', function () use($app) {
    $data = json_decode($app->request->getBody());
    $mandatory = array('code');
    global $db;
    $rows = $db->insert("bolas", $data, $mandatory);
    if ($rows["status"] == "success") {
        $rows["message"] = "Product added successfully.";
    }
    echoResponse(200, $rows);
});
$app->put('/bolas/:id', function ($id) use($app) {
    $data = json_decode($app->request->getBody());
    $condition = array('id' => $id);

コード例 #6

ファイル: index.php プロジェクト: jspautsch/Soku

require_once 'dbHelper.php';
// Get Slim instance
\Slim\Slim::registerAutoloader();
$app = new \Slim\Slim();
$app = \Slim\Slim::getInstance();
// call our own dbHelper class
$db = new dbHelper();
// Constants
$GRID_SIZE = 64;
$GRID_COLUMNS = 8;
// What pieces are there to play, ever?
$validPieces = array(array('piece' => 'king-0', 'type' => 'king', 'category' => 'defense'), array('piece' => 'knight-0', 'type' => 'knight', 'category' => 'defense'), array('piece' => 'knight-1', 'type' => 'knight', 'category' => 'defense'), array('piece' => 'queen-0', 'type' => 'queen', 'category' => 'offense'), array('piece' => 'bishop-0', 'type' => 'bishop', 'category' => 'offense'), array('piece' => 'bishop-1', 'type' => 'bishop', 'category' => 'offense'), array('piece' => 'rook-0', 'type' => 'rook', 'category' => 'offense'), array('piece' => 'rook-1', 'type' => 'rook', 'category' => 'offense'), array('piece' => 'pawn-0', 'type' => 'pawn', 'category' => 'neutral'), array('piece' => 'pawn-1', 'type' => 'pawn', 'category' => 'neutral'), array('piece' => 'pawn-2', 'type' => 'pawn', 'category' => 'neutral'), array('piece' => 'pawn-3', 'type' => 'pawn', 'category' => 'neutral'), array('piece' => 'pawn-4', 'type' => 'pawn', 'category' => 'neutral'), array('piece' => 'pawn-5', 'type' => 'pawn', 'category' => 'neutral'), array('piece' => 'pawn-6', 'type' => 'pawn', 'category' => 'neutral'), array('piece' => 'pawn-7', 'type' => 'pawn', 'category' => 'neutral'));
// API functions
$app->get('/player/:gameID', function ($gameID) {
    global $db;
    $rows = $db->select("game", "turn", array('gameID' => $gameID), '');
    foreach ($rows["data"] as $row) {
        $playerTurn = $row['turn'];
    }
    echoResponse(200, $playerTurn);
});
$app->get('/player/:gameID/:player', function ($gameID, $player) {
    global $db;
    $rows = $db->select("game", "turn", array('gameID' => $gameID), '');
    foreach ($rows["data"] as $row) {
        $playerTurn = $row['turn'];
    }
    $isTurn = $player === $playerTurn;
    echoResponse(200, $isTurn);
});
$app->get('/playable/:gameID/:piece', function ($gameID, $piece) {

コード例 #7

ファイル: test.php プロジェクト: devCPXL/gestion_stock_old

<?php

/**
 * Created by PhpStorm.
 * User: lakroubassi.n
 * Date: 23/03/2015
 * Time: 08:25
 */
require_once '../api/v1/dbHelper.php';
$db = new dbHelper();
$rows = $db->select("gestion_article", "id_article,nom,code_barre,description_f,quantite,unite,status", array());
foreach ($rows['data'] as $row) {
    var_dump($row['nom']);
}

コード例 #8

ファイル: index.php プロジェクト: Bridgevine/SampleBFlowResults-AngularJS

<?php

require '.././libs/Slim/Slim.php';
require_once 'dbHelper.php';
\Slim\Slim::registerAutoloader();
$app = new \Slim\Slim();
$app = \Slim\Slim::getInstance();
$db = new dbHelper();
// Products
$app->get('/products', function () {
    global $db;
    $rows = $db->select("products", "id,sku,name,price,features,promos,logo,status", array());
    echoResponse(200, $rows);
});
function echoResponse($status_code, $response)
{
    global $app;
    $app->status($status_code);
    $app->contentType('application/json');
    echo json_encode($response, JSON_NUMERIC_CHECK);
}
$app->run();

コード例 #9

ファイル: index.php プロジェクト: kashar/product-manager

$app = new \Slim\Slim();
$app = \Slim\Slim::getInstance();
$db = new dbHelper();
/**
 * Database Helper Function templates
 */
/*
select(table name, where clause as associative array)
insert(table name, data as associative array, mandatory column names as array)
update(table name, column names as associative array, where clause as associative array, required columns as array)
delete(table name, where clause as array)
*/
// Products
$app->get('/products', function () {
    global $db;
    $rows = $db->select("inventory", "id,environment,application,component,server_name,server_description,status,connectivity,server_ip_ctl,server_ip_nab,description,version,url", array());
    echoResponse(200, $rows);
});
$app->post('/products', function () use($app) {
    $data = json_decode($app->request->getBody());
    //    $mandatory = array('name');
    global $db;
    $rows = $db->insert("inventory", $data, $mandatory);
    if ($rows["status"] == "success") {
        $rows["message"] = "Product added successfully.";
    }
    echoResponse(200, $rows);
});
$app->put('/products/:id', function ($id) use($app) {
    $data = json_decode($app->request->getBody());
    $condition = array('id' => $id);

コード例 #10

ファイル: index.php プロジェクト: gilbertlucas46/units_inventory

$app = new \Slim\Slim();
$app = \Slim\Slim::getInstance();
$db = new dbHelper();
/**
 * Database Helper Function templates
 */
/*
select(table name, where clause as associative array)
insert(table name, data as associative array, mandatory column names as array)
update(table name, column names as associative array, where clause as associative array, required columns as array)
delete(table name, where clause as array)
*/
// Products
$app->get('/products', function () {
    global $db;
    $rows = $db->select("products", "id,sku,name,description,monitora,mrp,monitorb,image,packing,status", array());
    echoResponse(200, $rows);
});
$app->post('/products', function () use($app) {
    $data = json_decode($app->request->getBody());
    $mandatory = array('name');
    global $db;
    $rows = $db->insert("products", $data, $mandatory);
    if ($rows["status"] == "success") {
        $rows["message"] = "Product added successfully.";
    }
    echoResponse(200, $rows);
});
$app->put('/products/:id', function ($id) use($app) {
    $data = json_decode($app->request->getBody());
    $condition = array('id' => $id);