$t = unserialize('a:2:{i:0;s:15:"_identity-admin";i:1;s:14:"[3,null,21600]";}');
var_dump($t);
// array(2) {
// [0] => string(15) "_identity-admin"
// [1] => string(14) "[3,null,21600]"
// }
SELECT user_id, count(distinct created)
FROM orders
WHERE created > DATE_SUB(CURRENT_DATE, INTERVAL 30 DAY) -- get last 30 day orders
GROUP BY user_id
HAVING count(distinct created) = 30 -- check user have orders in 30 different days
;
update table_name
set value = replace(value, char(код символа ¶), concat(char(код символа \r), char(код символа\n)))select value,
replace(value, char(код символа ¶), concat(char(код символа \r), char(код символа\n))) as new_value
from table_name
<?php
session_start();
require_once 'connect.php';
$key = $_POST["key"];
$stmt = $connect->prepare("SELECT * FROM `keys` WHERE `key` = ?");
$stmt->bind_param("s", $key);
$stmt->execute();
$result = $stmt->get_result();
$user = $result->fetch_assoc();
if ($user) {
$_SESSION['key'] = $user;
header('Location: ../profile.php');
exit;
} else {
$_SESSION['msg'] ='Неправильный ключ';
header('Location: ../index.php');
exit;
}
WHEREid>=1 AND id <= 10000WHERE id >=1 AND id <= 10000UPDATE table SET field=field*2 WHERE id >=1 AND id <= 10000
find /path/to/bad/files/dir -iname "*.jpg" -exec cp -v /path/to/good.jpg {} \;
