Rsa97

$user = 170;
$query->bind_param('ssi', $message, $date, $user);

$query = $database->prepare("INSERT INTO messages(message,date,id_user) VALUES(?, ?, 170)");

WHERE '{$date}' BETWEEN DATE(`ed`.`date_start`) 
                AND DATE(`ed`.`date_end`)

SELECT DISTINCT `c`.`id`
  FROM `Category` AS `c`
  LEFT JOIN (
    SELECT DISTINCT `c1`.`id` AS `id`
      FROM  `Category` AS `c1`
      LEFT JOIN `Special` AS `s1` ON `s1`.`Product_id` = `c1`.`Product_id`
      WHERE `s1`.`Product_id` IS NULL
  ) AS `s` ON `s`.`id` = `c`.`id`
  WHERE `s`.`id` IS NULL

Шаг 1. 
  $i = 0. 
  Удаляем атрибут 0.
  Атрибуты 1 и 2 получают номера 0 и 1.
Шаг 2.
  $i = 1.
  Удаляем атрибут 1.
  Остался атрибут 0.

foreach ($this->allowableTags as $tag) {
  foreach ($doc->getElementsByTagName($tag) as $element) {
    $attributes = $element->attributes;
    while ($attributes->length > 0) {
      $attr = $attributes->item(0);
      $this->clearElement($element, $attr);
    }
  }
}