CREATE FUNCTION textDecrypt (input TEXT)
RETURNS TEXT DETERMINISTIC
BEGIN
DECLARE crypt_str BLOB;
DECLARE key_str BINARY(32);
DECLARE init_vector BINARY(16);
SET crypt_str = FROM_BASE64(input);
SET key_str = UNHEX(SHA2('marks', 256));
SET init_vector = REPEAT('\0', 16);
SET block_encryption_mode = 'aes-256-cbc';
RETURN AES_DECRYPT(crypt_str, key_str, init_vector);
END
$sth = $dbh->prepare("SELECT * FROM `catalog` WHERE `id` = ? ORDER BY `date_add` DESC");
$sth->execute([intval($_GET['id'])]);
$id = intval($_GET['id']);
$sth = $dbh->prepare("SELECT * FROM `catalog` WHERE `id` = :id ORDER BY `date_add` DESC");
$sth->bindParam('id', $id, PDO::PARAM_INT);
$sth->execute();