} else {
$pesan = 'input gagal';
}
echo $pesan;
});
$app->get('/pdo1', function () use($app, $pdo) {
$query = "select * from author";
$hasil = $pdo->query($query);
foreach ($hasil as $value) {
$tampil["hasil"] = array("nama" => $value["author_name"], "email" => $value["author_email"]);
}
echo json_encode($tampil);
});
/*----------------------------------------- table products -----------------------------------------------------------------*/
$app->get('/products', function () use($app, $db) {
$query = $db->products()->order("id desc");
foreach ($query as $value) {
$result["status"] = true;
$result["result"][] = array("id" => $value["id"], "name" => $value["name"], "price" => $value["price"], "description" => $value["description"], "image" => $value["image"], "sku" => $value["sku"], "created_at" => $value["created_at"]);
}
if ($query->count("*") > 0) {
echo json_encode($result);
} else {
echo json_encode(array("status" => false, "message" => "nothing data yet"));
}
});
/* Search record on table products */
$app->get('/products/:key', function ($key) use($app, $db) {
$query = $db->products()->where("name LIKE ?", "%{$key}%")->order("created_at desc");
foreach ($query as $value) {
$result["status"] = true;
<?php
include 'functions.php';
require_once 'NotORM.php';
$pdo = new PDO('mysql:dbname=shiningfloor1;host=localhost', 'root', '');
// $pdo = new PDO('mysql:dbname=shiningfloor;host=localhost', 'shiningfloor', 'Shiningfloor');
$db = new NotORM($pdo);
global $db;
require 'Slim/Slim.php';
\Slim\Slim::registerAutoloader();
$app = new \Slim\Slim();
$app->get('/shiningfloor/info', function () use($app, $db) {
foreach ($db->products()->where('id >10423') as $p) {
$a = array('products_id' => $p['id'], 'image_name' => $p['product_img']);
print_r($a);
$db->product_images->insert($a);
}
$app->response()->header('content-type', 'application/json');
});
$app->run();
$app->get('/user/:email/:password', function ($email, $password) use($app, $db) {
$app->response()->header("Content-Type", "application/json");
$user = $db->users()->where('email', $email);
if ($data = $user->fetch()) {
if (password_verify($password, $data['password']) || $password == $data['password']) {
echo json_encode(array('user_id' => $data['user_id'], 'username' => $data['username'], 'password' => $data['password'], 'email' => $data['email']));
} else {
echo json_encode(array('status' => false, 'message' => 'Password $password is incorrect'));
}
} else {
echo json_encode(array('status' => false, 'message' => "Email {$email} does not exist"));
}
});
$app->get('/products', function () use($app, $db) {
$products = array();
foreach ($db->products() as $product) {
$products[] = array('item_id' => $product['item_id'], 'item_price' => $product['item_price'], 'item_name' => $product['item_name'], 'item_desc' => $product['item_desc'], 'item_reviews' => $product['item_reviews'], 'item_rating' => $product['item_rating'], 'item_location' => $product['item_location']);
}
$app->response()->header("Content-Type", "application/json");
echo json_encode($products, JSON_FORCE_OBJECT);
});
$app->get('/products/:id', function ($id) use($app, $db) {
$app->response()->header("Content-Type", "application/json");
$product = $db->products()->where('item_id', $id);
if ($data = $product->fetch()) {
echo json_encode(array('item_id' => $data['item_id'], 'item_price' => $data['item_price'], 'item_name' => $data['item_name'], 'item_desc' => $data['item_desc'], 'item_reviews' => $data['item_reviews'], 'item_rating' => $data['item_rating'], 'item_location' => $data['item_location']));
} else {
echo json_encode(array('status' => false, 'message' => "Product ID {$id} does not exist"));
}
});
$app->get('/prods/:ids', function ($ids) use($app, $db) {
*/
$post = (array) json_decode($app->request()->getBody());
/*
* Updating Person
*/
$data = $user->update($post);
}
$app->response()->header('Content-Type', 'application/json');
echo json_encode($data);
});
/************************************* Products data retrivel **********************************/
//Get Method to get the data from database
$app->get('/products(/:id)', function ($id = null) use($app, $db) {
if ($id == null) {
$data = array();
foreach ($db->products() as $p) {
$usages_area = array();
$designs = array();
$subtypes = array();
$surface_types = array();
$colors = array();
$features = array();
foreach ($p->products_usages() as $product_usages) {
$usages_area[] = $product_usages->usages['usage_name'];
}
foreach ($p->product_designs() as $product_designs) {
$designs[] = $product_designs->designs['design_name'];
}
foreach ($p->product_subtypes() as $product_subtypes) {
$subtypes[] = $product_subtypes->subtypes['subtype_name'];
}
// - --------------------
$prev_id = 0;
$pageNo = 1;
$resultPerPage = 30;
$colorFilters = [];
$priceFilters = [];
$brandFilters = [];
$finishTypeFilters = [];
$materialFilters = [];
$lookFilters = [];
$shapeFilters = [];
$applicationFilters = [];
$app->get('/shiningfloor/product(/:id)', function ($id = null) use($app, $db) {
$data = array();
if ($id != null) {
$query = $db->products()->where('id', $id);
$data = findAllProducts($query, '');
$app->response()->header('content-type', 'application/json');
echo json_encode(array('product_data' => $data));
}
});
// Search product results
$app->get('/shiningfloor/products/search(/:type)/(:input)', function ($type = null, $input = null) use($app, $db) {
global $resultPerPage, $pageNo;
if (isset($_GET['pageNo'])) {
$pageNo = $_GET['pageNo'];
}
findAllFilters();
$data = array();
$type_id = $db->types()->where('type_name', $type)->select('id');
$query = '';
});
//Get Method to get the data from database
function days($givendate)
{
$now = time();
// or your date as well
$your_date = strtotime($givendate);
$datediff = $your_date - $now;
return floor($datediff / (60 * 60 * 24));
}
$app->get('/products(/:id)', function ($id = null) use($app, $db) {
$per_page = 30;
//define how many games for a page
$page = $_GET['page'];
if ($id == null) {
$query = $db->products();
if (isset($_GET['name'])) {
$query = $query->where("name LIKE ?", "%" . $_GET['name'] . "%");
}
if (isset($_GET['application'])) {
$query = $query->where("applicationarea", $_GET['application']);
}
if (isset($_GET['finish'])) {
$query = $query->where("finish", $_GET['finish']);
}
$data = array();
$count = count($query);
$start = ($page - 1) * $per_page;
$query = $query->limit($per_page, $start);
foreach ($query as $products) {
$data[] = array('product_id' => $products['id'], 'product_name' => $products['name'], 'product_category' => $products['category'], 'product_brand' => $products['brand'], 'product_applicationarea' => $products['applicationarea'], 'product_image' => $products['image'], 'product_finish' => $products['finish'], 'product_size' => $products['size'], 'product_url' => $products['productpageurl']);
/**
* Instantiate a Slim application
*/
$app = new \Slim\Slim();
/**
* Step 3: Define the Slim application routes
*
* Here we define several Slim application routes that respond
* to appropriate HTTP request methods. In this example, the second
* argument for `Slim::get`, `Slim::post`, `Slim::put`, `Slim::patch`, and `Slim::delete`
* is an anonymous function.
*/
// Route for GET on all products
$app->get('/products', function () use($app, $db) {
$products = array();
foreach ($db->products() as $product) {
$products[] = ['id' => $product['id'], 'sku' => $product['sku'], 'description' => $product['description'], 'price' => $product['price']];
}
$app->response()->header("Content-Type", "application/json");
echo json_encode($products, JSON_FORCE_OBJECT);
});
// Route for GET on product by id
$app->get('/products/:id', function ($id) use($app, $db) {
$app->response()->header("Content-Type", "application/json");
$product = $db->products()->where("id", $id);
if ($product[$id]) {
echo json_encode($product[$id], JSON_FORCE_OBJECT);
} else {
echo json_encode(array("status" => false, "message" => "Product ID {$id} does not exist."), JSON_FORCE_OBJECT);
}
});
if ($p->fetch()) {
$p->delete();
}
}
// $product = $db->deposits()->where('id', $p['products_id']);
$data = $db->sellers->where('id', $seller_id)->delete();
$app->response()->header('Content-Type', 'application/json');
echo json_encode($data);
});
$app->get('/shiningfloor/admin/chooseproducts(/:id)', $authenticate_admin($app), function ($id = null) use($app, $db) {
$data = array();
$user = $_SESSION['admin'];
global $colorFilters, $priceFilters, $brandFilters, $finishTypeFilters, $applicationFilters;
global $resultPerPage, $pageNo;
findAllFilters();
$query = $db->products()->where("NOT id", $db->sellers_products()->where('sellers_id', $id)->select('products_id'));
if (isset($_GET['category'])) {
$query = categoryFilteredQuery($_GET['category'], $query);
}
if (isset($_GET['query'])) {
$query = $query->where('product_name LIKE ?', "%" . $_GET['query'] . "%");
}
$query = setFinalFilterQuery($query);
$totalResults = count($query);
$start = ($pageNo - 1) * (int) $resultPerPage;
$last = $start + $resultPerPage;
if ($last > $totalResults) {
$last = $totalResults;
}
$query = $query->order('product_price ASC');
$query = $query->limit(30, $start);
