Annotation of embedaddon/php/ext/pgsql/tests/03sync_query.phpt, revision 1.1
1.1 ! misho 1: --TEST--
! 2: PostgreSQL sync query
! 3: --SKIPIF--
! 4: <?php include("skipif.inc"); ?>
! 5: --FILE--
! 6: <?php
! 7:
! 8: include('config.inc');
! 9:
! 10: $db = pg_connect($conn_str);
! 11:
! 12: $result = pg_query($db, "SELECT * FROM ".$table_name.";");
! 13: if (!($rows = pg_num_rows($result)))
! 14: {
! 15: echo "pg_num_row() error\n";
! 16: }
! 17: for ($i=0; $i < $rows; $i++)
! 18: {
! 19: pg_fetch_array($result, $i, PGSQL_NUM);
! 20: }
! 21: for ($i=0; $i < $rows; $i++)
! 22: {
! 23: pg_fetch_object($result);
! 24: }
! 25: for ($i=0; $i < $rows; $i++)
! 26: {
! 27: pg_fetch_row($result, $i);
! 28: }
! 29: for ($i=0; $i < $rows; $i++)
! 30: {
! 31: pg_fetch_result($result, $i, 0);
! 32: }
! 33:
! 34: pg_result_error($result);
! 35: if (function_exists('pg_result_error_field')) {
! 36: pg_result_error_field($result, PGSQL_DIAG_SEVERITY);
! 37: pg_result_error_field($result, PGSQL_DIAG_SQLSTATE);
! 38: pg_result_error_field($result, PGSQL_DIAG_MESSAGE_PRIMARY);
! 39: pg_result_error_field($result, PGSQL_DIAG_MESSAGE_DETAIL);
! 40: pg_result_error_field($result, PGSQL_DIAG_MESSAGE_HINT);
! 41: pg_result_error_field($result, PGSQL_DIAG_STATEMENT_POSITION);
! 42: if (defined('PGSQL_DIAG_INTERNAL_POSITION'))
! 43: {
! 44: pg_result_error_field($result, PGSQL_DIAG_INTERNAL_POSITION);
! 45: }
! 46: if (defined('PGSQL_DIAG_INTERNAL_QUERY'))
! 47: {
! 48: pg_result_error_field($result, PGSQL_DIAG_INTERNAL_QUERY);
! 49: }
! 50: pg_result_error_field($result, PGSQL_DIAG_CONTEXT);
! 51: pg_result_error_field($result, PGSQL_DIAG_SOURCE_FILE);
! 52: pg_result_error_field($result, PGSQL_DIAG_SOURCE_LINE);
! 53: pg_result_error_field($result, PGSQL_DIAG_SOURCE_FUNCTION);
! 54: }
! 55: pg_num_rows(pg_query($db, "SELECT * FROM ".$table_name.";"));
! 56: pg_num_fields(pg_query($db, "SELECT * FROM ".$table_name.";"));
! 57: pg_field_name($result, 0);
! 58: pg_field_num($result, $field_name);
! 59: pg_field_size($result, 0);
! 60: pg_field_type($result, 0);
! 61: pg_field_prtlen($result, 0);
! 62: pg_field_is_null($result, 0);
! 63:
! 64: $result = pg_query($db, "INSERT INTO ".$table_name." VALUES (9999, 'ABC');");
! 65: pg_last_oid($result);
! 66:
! 67: pg_free_result($result);
! 68: pg_close($db);
! 69:
! 70: echo "OK";
! 71: ?>
! 72: --EXPECT--
! 73: OK
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>