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