WITH p AS (
SELECT
payments.*,
extract(EPOCH from (now() - updated_at::timestamp) / 60) AS minutes_passed
FROM public.payments
) SELECT
p.*,
CASE
WHEN 60 - minutes_passed > 0
AND 60 - minutes_passed <= 15 THEN 'expires'
WHEN 60 - minutes_passed > 15 THEN 'success'
ELSE 'expired'
END
AS exp_status
FROM p;$res = array_filter(
$arr,
fn($el)=>!in_array($el["uniq_id"], $filter)
);CREATE TABLE REQUESTS (
ID INT,
id_request INT NOT NULL,
time_request TIME WITH TIME ZONE NOT NULL
);<?php
$product = 'sweater';
$query = "select distinct color from products where product = ?;";
// get DB version using PDO
$stmt = $pdo->prepare($query);
$stmt->execute([$product]);
$colors = $stmt->fetchAll(PDO::FETCH_ASSOC);
print_r($colors);SELECT
task.id,
task.dc,
task.provider,
task.type,
task.url,
task.cost,
task.cost_bot,
task.last_start_msec,
task.url_id,
task.remains,
task.cat
FROM
Task task
WHERE
task.status = 'active'
AND task.type = 'follow_profile'
AND task.provider = 'insta'
AND task.cat = 3
AND NOT EXISTS(
SELECT 1 FROM TaskFlow flow
WHERE
flow.url_id = task.url_id
AND flow.executor_acc_id = $acc
);with d as (
select
date,
open_close,
lead(date) over (order by date asc) next_date,
lead(open_close) over (order by date asc) next_open_close
from moex_fin m
) select * from d
where open_close BETWEEN 3.15 * 0.985 AND 3.15 * 1.005
;create table tbl(id int primary key auto_increment, lang varchar(2));
insert into tbl(lang) values
('EN'),('ES'),('RU'), ('EN'),('ES'),('RU'), ('EN'),('ES'),('RU'), ('EN'),('ES'),('RU'), ('EN'),('ES'),('RU'),
('EN'),('ES'),('RU'), ('EN'),('ES'),('RU'), ('EN'),('ES'),('RU'), ('EN'),('ES'),('RU'), ('EN'),('ES'),('RU');
with data as (
select
id, lang,
row_number() over (partition by lang order by rand()) rn
from tbl
)
select id, lang from data
where rn < 11;create table class (
id int primary key auto_increment,
name varchar(64) unique key
);
create table subclass (
id int primary key auto_increment,
class_id int references class(id),
name varchar(64) unique key
);
create table items (
id int primary key auto_increment,
subclass_id int references subclass(id),
name varchar(64) unique key
);
insert into class (name) values ('Fruits'), ('Vegetables');
insert into subclass (class_id, name) values (1, 'Red'), (1, 'Orange'), (2, 'Green'), (2, 'Yellow');
insert into items (subclass_id, name) values
(1, 'Apple'), (2, 'Pineapple'), (3, 'Cucumber'), (3, 'Carrot');<?php
$query = 'select class.name class, subclass.name subclass, items.name item
from items
join subclass on items.subclass_id = subclass.id
join class on subclass.class_id = class.id;';
// get DB version using PDO
$stmt = $pdo->prepare($query);
$stmt->execute();
$res = [];
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
if (!isset($res[$row["class"]])) {
$res[$row["class"]] = [];
}
if (!isset($res[$row["class"]][$row["subclass"]])) {
$res[$row["class"]][$row["subclass"]] = [];
}
$res[$row["class"]][$row["subclass"]][] = $row["item"];
}
print_r(json_encode($res, JSON_PRETTY_PRINT));select * from resume order by id asc;
Вы определили колонку логин в базе данных как INTEGER (Целое число), но пытаетесь запихнуть туда строку
PHP Fatal error: Uncaught mysqli_sql_exception: Incorrect integer value: 'Timpixel2020' for column 'login' at row 1 in C:\OpenServer\domains\localhost\elements\signup.php:36
<?php
function isSequence3($num) {
if ($num < 123) return false;
$digits = str_split($num);
$seq = 1;
for($i=1; $i<count($digits); $i++) {
if ($digits[$i] == ($digits[$i - 1] + 1)) $seq++;
else $seq = 1;
}
return $seq > 2;
}
$sum = 0;
for ($n=1; $n<=10000; $n++) {
if (isSequence3($n)) $sum += $n;
}
printf("Sum: %d", $sum);printf(
"<p>Пользователь: %s %s</p>
<p><i>Контактные данные</i></p>
<p>E-mail: %s</p>
<p>Facebook: %s</p>
<p>Город: %s</p>
---------<br/>" // !!!!!!!!!!!! here
$row['first_name'], $row['last_name'], $row['email'], $row['facebook'], $row['otkuda']
);CREATE TABLE foo (
id VARCHAR(64) DEFAULT (uuid()) PRIMARY KEY,
val varchar(16)
);
INSERT INTO foo (val) VALUES ('Test');
SELECT * FROM foo;CREATE TABLE foo (
id VARCHAR(64) primary key,
val varchar(16)
);
INSERT INTO foo (id, val) VALUES (uuid(), 'Test');
SELECT * FROM foo;SELECT id, SUM(price) sum_price
FROM tbl
GROUP BY id
ORDER BY sum_price DESC;delete from news where description like 'Мы печем лучший % хлеб в стране.';// Тема письма
$mail->Subject = "Заявка с сайта" // <<<<<< точку запятую поставьте