1--TEST-- 2PostgreSQL old api 3--EXTENSIONS-- 4pgsql 5--SKIPIF-- 6<?php include("inc/skipif.inc"); ?> 7--FILE-- 8<?php 9 10include('inc/config.inc'); 11$table_name = "table_98old_api"; 12 13$db = pg_connect($conn_str); 14pg_query($db, "CREATE TABLE {$table_name} (num int, str text, bin bytea)"); 15pg_query($db, "INSERT INTO {$table_name} DEFAULT VALUES"); 16 17$result = pg_exec($db, "SELECT * FROM ".$table_name); 18pg_numrows($result); 19pg_numfields($result); 20pg_fieldname($result, 0); 21pg_fieldsize($result, 0); 22pg_fieldtype($result, 0); 23pg_fieldprtlen($result, 0); 24pg_fieldprtlen($result, null, 0); 25pg_fieldisnull($result, 0); 26pg_fieldisnull($result, null, 0); 27pg_result($result,0,0); 28pg_result($result,null,0); 29 30$result = pg_exec($db, "INSERT INTO ".$table_name." VALUES (7777, 'KKK')"); 31$oid = pg_getlastoid($result); 32pg_freeresult($result); 33pg_errormessage($db); 34$result = pg_exec($db, "UPDATE ".$table_name." SET str = 'QQQ' WHERE str like 'RGD';"); 35pg_cmdtuples($result); 36 37echo "OK"; 38?> 39--CLEAN-- 40<?php 41include('inc/config.inc'); 42$table_name = "table_98old_api"; 43 44$db = pg_connect($conn_str); 45pg_query($db, "DROP TABLE IF EXISTS {$table_name}"); 46?> 47--EXPECTF-- 48Deprecated: Function pg_numrows() is deprecated in %s on line %d 49 50Deprecated: Function pg_numfields() is deprecated in %s on line %d 51 52Deprecated: Function pg_fieldname() is deprecated in %s on line %d 53 54Deprecated: Function pg_fieldsize() is deprecated in %s on line %d 55 56Deprecated: Function pg_fieldtype() is deprecated in %s on line %d 57 58Deprecated: Function pg_fieldprtlen() is deprecated in %s on line %d 59 60Deprecated: Function pg_fieldprtlen() is deprecated in %s on line %d 61 62Deprecated: pg_fieldprtlen(): Passing null to parameter #2 ($row) of type int is deprecated in %s on line %d 63 64Deprecated: Function pg_fieldisnull() is deprecated in %s on line %d 65 66Deprecated: Function pg_fieldisnull() is deprecated in %s on line %d 67 68Deprecated: pg_fieldisnull(): Passing null to parameter #2 ($row) of type int is deprecated in %s on line %d 69 70Deprecated: Function pg_result() is deprecated in %s on line %d 71 72Deprecated: Function pg_result() is deprecated in %s on line %d 73 74Deprecated: pg_result(): Passing null to parameter #2 ($row) of type int is deprecated in %s on line %d 75 76Deprecated: Function pg_getlastoid() is deprecated in %s on line %d 77 78Deprecated: Function pg_freeresult() is deprecated in %s on line %d 79 80Deprecated: Function pg_errormessage() is deprecated in %s on line %d 81 82Deprecated: Function pg_cmdtuples() is deprecated in %s on line %d 83OK 84
