ALTER TABLE `sellers`
ADD UNIQUE `seller` (`first_name`, `last_name`, `phone`);
INSERT IGNORE INTO `sellers` (`firt_name`, `last_name`, `phone`)
VALUES (:firstName, :lastName, :phone);
SELECT `id` FROM `sellers`
WHERE `first_name` = :firstName
AND `last_name` = :lastName
AND `phone` = :phone;
INSERT INTO `objects` ...$request = $mysqli->prepare("SELECT `name` FROM `category` WHERE `id` = ?");
$request->bind_param('i', $_GET['category']);
$request->bind_result($title_name);
$request->execute();
while ($request->fetch()) {
$title = $title_name.' — Решебник онлайн';
}
$request->close();SELECT *
FROM (
SELECT DISTINCT `date_create`
FROM `ordres`
UNION SELECT `date_modified`
FROM `ordres`
WHERE `status` IN (2, 3)
) AS `date`
LEFT JOIN (
SELECT COUNT(*) AS `count`, `date_create`
FROM `ordres`
GROUP BY `date_create`
) AS `all` ON `all`.`date_create` = `date`.`date_create`
LEFT JOIN (
SELECT COUNT(*) AS `count`, `date_modified`
FROM `ordres`
WHERE `status` = 2
GROUP BY `date_modified`
) AS `succ` ON `succ`.`date_modified` = `date`.`date_create`
LEFT JOIN (
SELECT COUNT(*) AS `count`, `date_modified`
FROM `ordres`
WHERE `status` = 3
GROUP BY `date_modified`
) AS `canc` ON `canc`.`date_modified` = `date`.`date_create`UPDATE `public`.`users`
SET `id` = :id, `surname` = :surname::varchar(20)
WHERE `surname` = :surname::varchar(20)