Slava Rozhnev

fetch('site2.ru', {
        method : "GET",
    }).then(
        (response) => {
            if (response.text() === '157') {
                window.location.replace("site2.ru");
            }
    )

usort(
	$data,
	fn($a, $b) => $a['app'] <=> $b['app']
);

php editor online

CREATE TABLE test (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  s TEXT,
  t TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO test(s) VALUES ('string');

SELECT * FROM test;

sql online editor

UPDATE users 
INNER JOIN api_tokens ON api_tokens.user_id=users.id 
SET users.first_name = (?),  users.last_name = (?),  users.email = (?)  
WHERE api_tokens.token IN (?)

UPDATE `notice` 
SET `time_update` = ?, `current_value` = ? 
WHERE `id` = ? AND  `time_update` = `time`;

run php online

select * from names where name not rlike '[0-9]';

run sql online

Если Вы используете MySQL то запрос может быть таким:

SELECT id, (c1=1) + (c2=0) + (c3=1) + (c4=1) + (c5=1) + (c6=1) + (c7=1) FROM test 
WHERE ((c1=1) + (c2=0) + (c3=1) + (c4=1) + (c5=1) + (c6=1) + (c7=1)) >= 6
;

run sql online

Implement Redis Queue and Worker with PHP
Redis Simple Message Queue

SELECT DISTINCT
	id,
	coalesce(devices.name, call_list.num2)  "client_num",
FROM call_list
left join devices ON devices.name = call_list.num;

$ages = array_column($arr, 'age');

print_r($ages);

run php online

оператор конкатенации ('.')

<?php
$a = 0.5;
$b = "0.5";
$c = $a.$b;
echo $c;

run php online

Разбить на 2 массива:

$products_5 = array_slice($products, 0, 5);
$products_more = array_slice($products, 5);

run php online

SELECT "conversations".id 
FROM  "conversations"
JOIN "usersConversations" "uC1" ON "conversations".id = "uC1".conversation_id AND "uC1".user_id = 1
JOIN "usersConversations" "uC2" ON "conversations".id = "uC2".conversation_id AND "uC2".user_id = 2
WHERE  "conversations"."isPrivate" = true 
ORDER BY "conversations".id DESC 
LIMIT 1;

SELECT "conversations".id 
FROM  "conversations"
WHERE  "conversations"."isPrivate" = true
AND EXISTS (SELECT 1 FROM  "usersConversations" WHERE "conversations".id = "usersConversations".conversation_id AND "usersConversations".user_id = 1) 
AND EXISTS (SELECT 1 FROM  "usersConversations" WHERE "conversations".id = "usersConversations".conversation_id AND "usersConversations".user_id = 2) 
ORDER BY "conversations".id DESC 
LIMIT 1;

Как поменять пароль в БД mysql

В отличии от MySQL где TRUNCATE TABLE автоматически сбрасывает авто инкремент, в PostgreSQL нужно добавить ключ RESTART IDENTITY
TRUNCATE TABLE tbl RESTART IDENTITY;

run sql oline