1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
|
--TEST--
PostgreSQL pg_insert() (9.0+)
--SKIPIF--
<?php
include("skipif.inc");
skip_bytea_not_hex();
?>
--FILE--
<?php
error_reporting(E_ALL);
include 'config.inc';
$db = pg_connect($conn_str);
pg_query($db, "SET standard_conforming_strings = 0");
$fields = array('num'=>'1234', 'str'=>'AAA', 'bin'=>'BBB');
pg_insert($db, $table_name, $fields) or print "Error in test 1\n";
echo pg_insert($db, $table_name, $fields, PGSQL_DML_STRING)."\n";
echo pg_insert($db, $table_name, $fields, PGSQL_DML_STRING|PGSQL_DML_ESCAPE)."\n";
var_dump( pg_insert($db, $table_name, $fields, PGSQL_DML_EXEC) ); // Return resource
/* Invalid values */
try {
$converted = pg_insert($db, $table_name, [5 => 'AAA']);
} catch (\ValueError $e) {
echo $e->getMessage(), \PHP_EOL;
}
try {
$converted = pg_insert($db, $table_name, ['AAA']);
} catch (\ValueError $e) {
echo $e->getMessage(), \PHP_EOL;
}
try {
$converted = pg_insert($db, $table_name, ['num' => []]);
} catch (\TypeError $e) {
echo $e->getMessage(), \PHP_EOL;
}
try {
$converted = pg_insert($db, $table_name, ['num' => new stdClass()]);
} catch (\TypeError $e) {
echo $e->getMessage(), \PHP_EOL;
}
try {
$converted = pg_insert($db, $table_name, ['num' => $db]);
var_dump($converted);
} catch (\TypeError $e) {
echo $e->getMessage(), \PHP_EOL;
}
echo "Ok\n";
?>
--EXPECTF--
INSERT INTO "php_pgsql_test" ("num","str","bin") VALUES (1234,E'AAA',E'\\x424242');
INSERT INTO "php_pgsql_test" ("num","str","bin") VALUES ('1234','AAA','BBB');
resource(%d) of type (pgsql result)
Array of values must be an associative array with string keys
Array of values must be an associative array with string keys
Values must be of type string|int|float|bool|null, array given
Values must be of type string|int|float|bool|null, stdClass given
Values must be of type string|int|float|bool|null, resource given
Ok
|
