df12

{product:id}-

{product:slug}.html

select name, case when is_hidden_price = 1 then 0 else price end as price
from products
order by price, name;

const words = ['Азбука', 'Ананас', 'Зелень'];
const letters = 'аБ'.toLowerCase().split('');
const result = words.filter(
  (word) => {
    const lWord = word.toLowerCase();
    return letters.every((letter) => lWord.includes(letter))
  }
);
console.log(result);
// Array [ "Азбука" ]

const arr = ['Hello', 'World', 'John Doe', 'Hakuna Matata', 'Mosakusa'];
let input = 'da' 
let arrInput = input.split(''); // ['d', 'a']
arr.filter(str => arrInput.every(char => str.includes(char))); // []
input = 'ao', arrInput = input.split('');
arr.filter(str => arrInput.every(char => str.includes(char))); // ['Mosakusa']

<?php
$query = 'SELECT
		`methods`.* 
	FROM `methods` 
	LEFT JOIN `groups` ON `groups`.`id` = `methods`.`group_id` 
	WHERE 
		`methods`.`active` = ? AND 
		`groups`.`active` = ? 
	ORDER BY `methods`.`group_id`, `methods`.`position`;';

// get DB version using PDO
$stmt = $pdo->prepare($query);
$stmt->execute([1, 1]);

if ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
	$group_id = $row['group_id'];
	
	printf(
		'<ul data-group_id="%d">' . PHP_EOL . '    <li data-id="%d">%s</li>' . PHP_EOL, 
		$group_id, $row['id'], $roe['name']
	);
	
	while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
		if ($group_id != $row['group_id']) {
			$group_id = $row['group_id'];
			printf(
				'</ul><ul data-group_id="%d">' . PHP_EOL, 
				$group_id
			);
		}
		printf('    <li data-id="%d">%s</li>' . PHP_EOL, $row['id'], $roe['name']);
	}
	
	printf('</ul>');
}