/
vshmidt
/
php
Обзор
Документация
Войти
/
vshmidt
/
php
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
ext/pgsql/tests/18pg_escape_bytea_hex.phpt
46 строк
1020 B
KentarouTakeda
ext/pgsql: Refactor tests (#12608)
07 ноя 2023, 01:36
Не верифицирован
07 ноя 2023, 01:36
c15988a
Код
Авторство
О чём код?
--TEST-- PostgreSQL pg_escape_bytea() functions (hex format) --EXTENSIONS-- pgsql --SKIPIF-- <?php include("inc/skipif.inc"); skip_bytea_not_hex(); ?> --FILE-- <?php // optional functions include('inc/config.inc'); $table_name = "table_18pg_escape_bytea_hex"; $db = pg_connect($conn_str); pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)"); @pg_query($db, "SET bytea_output = 'hex'"); $image = file_get_contents(__DIR__ . '/php.gif'); $esc_image = pg_escape_bytea($db, $image); pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, \''.$esc_image.'\');'); $result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876'); $rows = pg_fetch_all($result); $unesc_image = pg_unescape_bytea($rows[0]['bin']); if ($unesc_image !== $image) { echo "NG"; } else { echo "OK"; } ?> --CLEAN-- <?php include('inc/config.inc'); $table_name = "table_18pg_escape_bytea_hex"; $db = pg_connect($conn_str); pg_query($db, "DROP TABLE IF EXISTS {$table_name}"); ?> --EXPECT-- OK