$query = "UPDATE `users` SET `address`= ?,`phone_number`=? WHERE email=?";
$params = [
$address,
$phone_number,
$email,
];
$stmt = $pdo->prepare($query);
$stmt->execute($params);$id = $_SESSION['id'];
$sql = "INSERT INTO zakaz (iduser,idkat) SELECT iduser, idkat FROM corzina WHERE iduser=?";
$stmt = $bd->prepare($sql);
$stmt->bind_param('i', $id);
$stmt->execute($res);Хотелось бы понять как можно ускорить поиск товаров в базе данных MySQL, когда приходится использовать большое количество Id категорий в in.
error_reporting(E_ALL);mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);ini_set('display_errors',1);ini_set('display_errors', 0);
ini_set('log_errors', 1);$this->database()->query('UPDATE ' . $this->database()->getTable('ad') . ' SET view = 0 WHERE ad_id = 34');
$this->database()->query('UPDATE ' . $this->database()->getTable('ad') . ' SET view = 1 WHERE ad_id = 35');
$this->database()->query('UPDATE ' . $this->database()->getTable('ad') . ' SET view = 2, amount=466 WHERE ad_id = 36');ssh user@host.commysql -u -p -h -Pssh -N -f -L 3366:127.0.0.1:3306 user@host.com
SELECT * FROM users WHERE DATE(created_at) = '2024-04-14'SELECT * FROM users WHERE created_at BETWEEN '2024-04-14 00:00:00' AND '2024-04-14 23:59:59'$result = $mysql->query("SELECT * FROM `postavshik`");
while ($row = $result->fetch_assoc()) {
echo "<option>" . htmlspecialchars($row['Name_pred']). "</option>\n";
}copy *.sql fulldump.sql
<?php
# Настройка ошибок
# Для локального сервера
ini_set('display_errors', 1);
# Всегда
error_reporting(E_ALL);
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);UPDATE link_count SET count=count+? WHERE link_id=? and number=?