Slava Rozhnev

Argument #2 ($array) must be of type ?array, string given in

Аргумент #2 ($array) должен иметь тип ?array, строка указана в

echo implode(',', array_column($arr['domains'], 'fqdn'));

<?php
$html =" <span> 

123 </span>";

echo json_encode(["content"=>$html]);

$html =" <span> 

123 </span>";
echo   '{"content":'.json_encode  ($html) .'}';

SELECT count(*) from `runs` where `date` >= unix_timestamp(curdate());

SELECT count(distinct client) from `runs` where `date` >= unix_timestamp(curdate());

SELECT COUNT(*) FROM (
    SELECT 
        `client`, MIN(`date`) `first_run`
    FROM `runs` 
    GROUP BY `client` 
    HAVING `first_run` >= unix_timestamp(curdate())
) `todays_first_runs`;

<?php
function getTags($strTag) {
    return array_combine(
        array_map(
            fn($attribute) => array_shift(explode("=", $attribute)),
            explode(" ", trim($strTag))
        ),
        explode(" ", trim($strTag))
    );
}

function getAttributes($strTag) {
    return array_map(
        fn($attribute) => array_pop(explode("=", $attribute)),
        getTags($strTag)
    );
}

preg_match_all('/(?<=\<img).*?(?=>)/', $this->html, $match, PREG_PATTERN_ORDER);

$this->tags = array_map(
    fn($strTag) => [
        "original" => "<img " . $strTag . ">",
        "attributes" => getAttributes($strTag)
    ],
    $match[0]
);

CREATE SEQUENCE profiles_seq START 1;

CREATE OR REPLACE FUNCTION nextval_rand(regclass)
  RETURNS text AS
$func$
BEGIN
EXECUTE format('ALTER SEQUENCE profiles_seq INCREMENT %s', (random() * 100)::int + 1);
RETURN 'Пользователь #' || nextval($1)::text;
END
$func$ LANGUAGE plpgsql SECURITY DEFINER;

create table profiles (
  id uuid not null,
  username text default nextval_rand('profiles_seq'::regclass),
  primary key (id)
);

insert into profiles (id) values
(gen_random_uuid()), 
(gen_random_uuid()),
(gen_random_uuid()),
(gen_random_uuid()),
(gen_random_uuid());

select * from profiles;

SELECT [Case].[ID] 
FROM [Case]
JOIN [Instance] ON [Instance].[CaseID] = [Case].[ID]
GROUP BY [Case].[ID]
HAVING MAX([Level]) = 1;

select ch1.chat_id
from chat_user ch1
join chat_user ch2 using (chat_id)
where ch1.user_id = 1 and ch2.user_id = 2;

<?php
$input = 'value.id.price.data.get.value';

$result = [];

$r = &$result;
foreach(explode('.', $input) as $k) {
    $r[$k] = [];
    $r = &$r[$k];
}

print_r($result);

select * 
from a,
lateral (select * from b where b.a_id = a.id order by d desc limit 1) m;

select 
    problems.*, 
    case when coalesce(max(status_id), 2) = 2 then 'Not Completed' else 'Completed' end problem_status
from problems
left join tasks on tasks.problem_id = problems.id
group by problems.id, problems.title
order by problems.id;

with problem_status as (
    select 
        problems.*, 
        max(status_id) status_id
    from problems
    left join tasks on tasks.problem_id = problems.id
    group by problems.id, problems.title
) select problem_status.id, problem_status.title, statuses.title
from problem_status
left join statuses on statuses.id = problem_status.status_id
order by problem_status.id;