Файловый менеджер - Редактировать - /home/skymarketplace/public_html/models/CartModel.php
Назад
<?php namespace App\models; use App\core\Database; class CartModel { protected \PDO $db; public function __construct() { $this->db = Database::connect(); } public function add($userId, $productId, $quantity): bool { $stmt = $this->db->prepare("INSERT INTO cart (user_id, product_id, quantity) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE quantity = quantity + VALUES(quantity)"); return $stmt->execute([$userId, $productId, $quantity]); } public function remove($userId, $itemId): bool { $stmt = $this->db->prepare("DELETE FROM cart WHERE user_id = ? AND id = ?"); return $stmt->execute([$userId, $itemId]); } public function getItems($userId): array { $stmt = $this->db->prepare("SELECT * FROM cart WHERE user_id = ?"); $stmt->execute([$userId]); return $stmt->fetchAll(\PDO::FETCH_ASSOC); } public function clear($userId): bool { $stmt = $this->db->prepare("DELETE FROM cart WHERE user_id = ?"); return $stmt->execute([$userId]); } }
| ver. 1.4 |
Github
|
.
| PHP 8.1.31 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка