/
vshmidt
/
php
Обзор
Документация
Войти
/
vshmidt
/
php
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
ext/pgsql/tests/17result.phpt
81 строка
1 KB
KentarouTakeda
ext/pgsql: Refactor tests (#12608)
07 ноя 2023, 01:36
Не верифицирован
07 ноя 2023, 01:36
c15988a
Код
Авторство
О чём код?
--TEST-- PostgreSQL pg_fetch_*() functions --EXTENSIONS-- pgsql --SKIPIF-- <?php include("inc/skipif.inc"); ?> --FILE-- <?php error_reporting(E_ALL); include 'inc/config.inc'; $table_name = "table_17result"; $db = pg_connect($conn_str); pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)"); pg_query($db, "INSERT INTO {$table_name} VALUES(1, 'ABC', null)"); pg_query($db, "INSERT INTO {$table_name} VALUES(1, 'ABC', null)"); $sql = "SELECT * FROM $table_name ORDER BY num"; $result = pg_query($db, $sql) or die('Cannot query db'); $rows = pg_num_rows($result); var_dump(pg_result_seek($result, 1)); var_dump(pg_fetch_object($result)); var_dump(pg_fetch_array($result, 1)); var_dump(pg_fetch_row($result, 1)); var_dump(pg_fetch_assoc($result, 1)); var_dump(pg_result_seek($result, 0)); echo "Ok\n"; ?> --CLEAN-- <?php include('inc/config.inc'); $table_name = "table_17result"; $db = pg_connect($conn_str); pg_query($db, "DROP TABLE IF EXISTS {$table_name}"); ?> --EXPECTF-- bool(true) object(stdClass)#%d (3) { ["num"]=> string(1) "1" ["str"]=> string(3) "ABC" ["bin"]=> NULL } array(6) { [0]=> string(1) "1" ["num"]=> string(1) "1" [1]=> string(3) "ABC" ["str"]=> string(3) "ABC" [2]=> NULL ["bin"]=> NULL } array(3) { [0]=> string(1) "1" [1]=> string(3) "ABC" [2]=> NULL } array(3) { ["num"]=> string(1) "1" ["str"]=> string(3) "ABC" ["bin"]=> NULL } bool(true) Ok