Дмитрий

$sku['stock'] = array_fill_keys($stock_complement&&is_array($stock_complement)?$stock_complement:[], 0);

SELECT materials.id,
       materials.title,
       materials.author,
       materials.description,
       types.name      AS type,
       categories.name AS category
FROM materials
         LEFT JOIN categories
                   ON materials.id_category = categories.id
         LEFT JOIN types
                   ON materials.id_type = types.id
         LEFT JOIN tags_to_materials
                   ON materials.id = tags_to_materials.material_id
         LEFT JOIN tags
                   ON tags.id = tags_to_materials.tag_id
WHERE materials.author LIKE '$str%'
   OR materials.title LIKE '$str%'
   OR categories.name LIKE '$str%'
   OR tags.name LIKE '$str%'

select materials.id,
       materials.title,
       materials.author,
       materials.description,
       types.name      AS type,
       categories.name AS category
FROM materials
         LEFT JOIN categories
                   ON materials.id_category = categories.id
         LEFT JOIN types
                   ON materials.id_type = types.id
         LEFT JOIN tags_to_materials
                   ON materials.id = tags_to_materials.material_id
         LEFT JOIN tags
                   ON tags.id = tags_to_materials.tag_id
where materials.id in (
    SELECT materials.id
    FROM materials
             LEFT JOIN categories
                       ON materials.id_category = categories.id
             LEFT JOIN types
                       ON materials.id_type = types.id
             LEFT JOIN tags_to_materials
                       ON materials.id = tags_to_materials.material_id
             LEFT JOIN tags
                       ON tags.id = tags_to_materials.tag_id
    WHERE materials.author LIKE '$str%'
       OR materials.title LIKE '$str%'
       OR categories.name LIKE '$str%'
       OR tags.name LIKE '$str%' group by materials.id);

class Single
{
    public array $data = [];
    public static $instance;

    PRIVATE function __construct()
    {
    }

    public static function getInstance()
    {
        if (empty(self::$instance)) {
            self::$instance = new Single();
        }
        return self::$instance;
    }

    public function __get(string $key)
    {
        return $this->data[$key]??null;
    }

    public function __set(string $key, $value)
    {
        $this->data[$key] = $value;
    }
}

class A
{
    public static function tryW()
    {
        Single::getInstance()->some = 1;
    }
}

class B
{
    public static function tryR()
    {
        var_dump(Single::getInstance()->some);
    }
}

$a = new A();
$a->tryW();

$b = new B();
$b->tryR();

$text = 'Это очень длинний текст, в нем нужно найти определенное слово и обрезать строку по нему. Так же добавить три точки до и после';
echo preg_replace('/.{20}\S*(.*)\s.{20}.*/u', '...$1...', $text);

DB::table('MYTABLE')->insert([
                    'id' => $id,
                    'description' => mb_substr($description, 0, 255)
                ]);

For STRICT_TRANS_TABLES, MySQL converts an invalid value to the closest valid value for the column and inserts the adjusted value. If a value is missing, MySQL inserts the implicit default value for the column data type. In either case, MySQL generates a warning rather than an error and continues processing the statement. Implicit defaults are described in Section 11.6, “Data Type Default Values”.

Среди работников милиции провели тест на сообразительность. Суть теста: в металлической пластине вырезаны отверстия различной формы (квадрат, круг, треугольник и т. д. ), в них нужно вставить соответствующие металлические тела. По результатам теста работники милиции разделились на две группы:
1. Тупые.
2. Очень сильные.

curl 'https://www.proficosmetics.ru/bitrix/services/main/ajax.php?mode=ajax&c=krasivoereshenie%3Auser.auth&action=login' -X POST -H 'Accept: */*'-H 'Accept-Encoding: gzip, deflate, br' -H 'Referer: https://www.proficosmetics.ru/auth/' -H 'Bx-ajax: true' -H 'Content-Type: application/x-www-form-urlencoded' --data-raw 'login=123&password=123&remember=Y&SITE_ID=s1'

LIKE '%$SearchTitle%' ORDER BY `number_of_eavesdroppers` DESC LIMIT $SearchFrom, 20");