public static function deleteCategory($id, Connection $connection)
{
echo "Категория удаляется<br>";
$stmt = $connection->prepare('DELETE FROM `categories` WHERE `id` = :id');
$result = $stmt->execute([':id' => $id]);
return $result;
}
public static function getProductsInOrder(Connection $connection, $order_id)
{
$stmt = $connection->prepare('SELECT * FROM `ordersproducts`
WHERE `order_id` = :order_id');
$stmt->execute([":order_id" => $order_id]);
return $stmt->fetchAll(\PDO::FETCH_ASSOC);
}
public static function getById($order_id, Connection $connection)
{
$statement = $connection->prepare('SELECT *
FROM `orders` WHERE `order_id` = :order_id');
$statement->execute([':order_id' => $order_id]);
return $statement->fetch(\PDO::FETCH_ASSOC);
}
public function __construct(Connection $connection, $uploadfile)
{
$now = new \DateTime();
$date = $now->format("Y-m-d H:i:s");
$uploadImageTable = $connection->prepare('INSERT INTO `images`' . '(`photo`,`created_at`)' . ' VALUES (:photo, :created_at)');
$uploadImageTable->execute([':photo' => $uploadfile, ':created_at' => $date]);
}
/**
* Удаление записей
*
* @param string $where
* @param array|null $params
* @return int
*/
public function delete($where, array $params = [])
{
$tableName = $this->tableName();
$sql = "DELETE FROM \"{$tableName}\"";
if ($where) {
$sql .= " WHERE {$where}";
}
return $this->connection->execute($sql, $params);
}
public static function getIdIfExists(Connection $connection, $username, $password)
{
$id = 0;
$stmt = $connection->prepare('SELECT * FROM `users`
WHERE `user_name` = :user_name');
$stmt->execute([':user_name' => $username]);
$user_info = $stmt->fetch(\PDO::FETCH_ASSOC);
if (password_verify($password, $user_info['hash_password'])) {
$id = $user_info['user_id'];
}
return $id;
}
public static function setOrder(Connection $connection)
{
$ord_comment = '';
if (isset($_POST['ord_comment'])) {
$ord_comment = $_POST['ord_comment'];
}
$num_order = uniqid();
$statment = $connection->prepare("INSERT INTO `orders`(`num_order`,`fio`, `address`, `email`, `ord_comment`, `created_at`) VALUES (:num_order,:fio, :address, :email, :ord_comment, now())");
$statment->execute(['num_order' => $num_order, 'fio' => $_POST['ord_fio'], 'address' => $_POST['ord_addr'], 'email' => $_POST['ord_email'], 'ord_comment' => $ord_comment]);
//сохранение товаров, входящих в заказ
$productsInCart = $_COOKIE['products'];
foreach ($productsInCart as $id => $value) {
$statment = $connection->prepare("INSERT INTO `order_product`(`num_order`,`id_prod`, `amount_prod`) VALUES (:num_order,:id_prod, :amount_prod)");
$statment->execute(['num_order' => $num_order, 'id_prod' => $id, 'amount_prod' => $value]);
}
//после сохранения заказа очищаем куки
setcookie("products", "", time() - 3600);
}
public static function deleteCategoryId($category_id, Connection $connection)
{
$deleteCategoryId = $connection->prepare('UPDATE `products` SET `category_id` = null WHERE `category_id` = :category_id');
$result = $deleteCategoryId->execute([":category_id" => $category_id]);
return $result;
}
function find()
{
$app = Slim::getInstance();
$request = $app->request->get();
try {
$db = new Connection();
$sql = "SELECT * FROM laptops ";
$where = [];
foreach ($request as $name => $value) {
$where[] = $name . " = :" . $name;
}
if (count($where) > 0) {
$sql .= 'WHERE ' . implode(' AND ', $where);
}
$sth = $db->prepare($sql);
foreach ($request as $name => $value) {
$sth->bindParam($name, $value);
}
$sth->execute();
$laptop = $sth->fetchAll(PDO::FETCH_OBJ);
if ($laptop) {
$app->response->setStatus(200);
$app->response()->headers->set('Content-Type', 'application/json');
echo json_encode($laptop);
} else {
throw new PDOException('No records found.');
}
} catch (PDOException $e) {
$app->response()->setStatus(404);
echo '{"error":{"text":' . $e->getMessage() . '}}';
}
}
function find()
{
$app = Slim::getInstance();
$request = $app->request->get();
try {
$db = new Connection();
$sql = "SELECT * FROM {$this->tableName} ";
$where = [];
foreach ($request as $name => $value) {
$where[] = $name . " = :" . $name;
}
if (count($where) > 0) {
$sql .= 'WHERE ' . implode(' AND ', $where);
}
$sth = $db->prepare($sql);
foreach ($request as $name => $value) {
$sth->bindValue($name, $value);
}
$sth->execute();
$laptop = $sth->fetchAll(PDO::FETCH_ASSOC);
if ($laptop) {
$app->response->setStatus(200);
$app->contentType('application/json');
echo json_encode($laptop);
$db = null;
} else {
throw new PDOException('No records found.');
}
} catch (PDOException $e) {
$app->response()->setStatus(404);
$app->contentType('application/json');
echo json_encode(['status' => 'error', 'message' => $e->getMessage()]);
}
}
public static function get($id, Connection $connection)
{
$statment = $connection->prepare("SELECT * FROM `categories` WHERE `categories`.`id` = :id");
$statment->execute(['id' => $id]);
return $statment->fetch(\PDO::FETCH_ASSOC);
}
