SELECT COUNT(DISTINCT `leads`.`PHONE`)
FROM `leads`
LEFT JOIN `sites` ON `sites`.`SOURCE_ID` = `leads`.`SOURCE_ID`
WHERE `leads`.`PHONE` != '9 (999) 999 99-99'
AND `leads`.`NAME` != 'тест'
AND `leads`.`SOURCE_ID` IN (1,3,4,5,6,7,8,10,11,12,14,15)
AND `DATE_CREATE` BETWEEN '2020-06-01' AND '2020-06-30'
$mysql = new mysqli('localhost', 'root', '', 'register');
$stmt = $mysql->prepare("SELECT `password` FROM `users` WHERE `login` = ?");
$stmt->bind_param('s', $login);
$stmt->execute();
$stms->bind_result($hash);
if (!$stmt->fetch() || !password_verify($password, $hash)) {
echo 'Error';
}
$str = "Закодированная строка";
print base64_encode($str);
// 0JfQsNC60L7QtNC40YDQvtCy0LDQvdC90LDRjyDRgdGC0YDQvtC60LA=
function atou(b64) {
return decodeURIComponent(escape(atob(b64)));
}
const b64 = '0JfQsNC60L7QtNC40YDQvtCy0LDQvdC90LDRjyDRgdGC0YDQvtC60LA='
console.log(atou(b64))
// Закодированная строка