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); }