public function get_ancestors()
{
$db = Database::get_connection();
$statement = $db->prepare('SELECT id, name, parent_id FROM categories WHERE id = ?');
$category_id = $this->id;
$ancestors = array();
while ($category_id != 0) {
$statement->execute(array($category_id));
$category = $statement->fetch(PDO::FETCH_OBJ);
array_unshift($ancestors, $category);
$category_id = $category->parent_id;
}
$root = new stdClass();
$root->id = 0;
$root->name = 'Catalog';
array_unshift($ancestors, $root);
return $ancestors;
}
<?php
include_once './config/Database.php';
$database = new Database();
$conn = $database->get_connection();
$_SERVER['CONTENT_TYPE'] = "application/x-www-form-urlencoded";
$content = json_decode(file_get_contents('php://input'), TRUE);
if ($_GET['type'] == "add") {
$user_id = $content['userid'];
$product_id = $content['productid'];
$product_type = $content['producttype'];
$udate = $content['udate'];
if ($conn->query("insert into user_products (user_id, product_id, product_type, udate) values ({$user_id}, '{$product_id}', '{$product_type}', '{$udate}')")) {
$response = array('success' => TRUE);
} else {
$response = array('success' => FALSE);
}
echo json_encode($response);
} else {
if ($_GET['type'] == "get") {
$sql = "SELECT * from user_products where user_id=" . $_GET['user_id'] . " order by uproduct_id desc";
$result = $conn->query($sql);
$products_array = array();
while ($row = $result->fetch_assoc()) {
$row['is_available'] = is_available($row['product_id'], $conn);
$products_array[] = $row;
}
echo json_encode($products_array);
} else {
if ($_GET['type'] == "edit") {
$uproduct_id = $_GET['uproduct_id'];
<?php
$db = new Database();
$connect = $db->get_connection();
function redirect_to($new_location)
{
header("Location: " . $new_location);
exit;
}
function check_query($result)
{
if (!$result) {
die("Upit nije moguce izvrsiti.");
}
}
function find_all_subjects()
{
global $connect;
$query = "SELECT * ";
$query .= "FROM subjects ";
$query .= "WHERE visible=1 ";
$query .= "ORDER BY position ASC";
$result = $connect->query($query);
check_query($result);
return $result;
}
function find_pages_for_subjects($subject_id)
{
global $connect;
$query = "SELECT * ";
$query .= "FROM pages ";
