<?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.";
$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);
$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) {
<?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
\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);
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) {
<?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']);
}
<?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();
$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);
$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);
