Gecko [ www.foryou-vip.com ]

Name	Size	Permission	Date
00version.phpt	964 B	-rw-rw-r--	2022-10-31 11:36
01createdb.phpt	747 B	-rw-rw-r--	2022-10-31 11:36
02connection.phpt	944 B	-rw-rw-r--	2022-10-31 11:36
03sync_query.phpt	1.85 KB	-rw-rw-r--	2022-10-31 11:36
04async_query.phpt	1.27 KB	-rw-rw-r--	2022-10-31 11:36
05large_object.phpt	2.04 KB	-rw-rw-r--	2022-10-31 11:36
06_bug73498.phpt	332 B	-rw-rw-r--	2022-10-31 11:36
06copy.phpt	299 B	-rw-rw-r--	2022-10-31 11:36
06copy_2.phpt	541 B	-rw-rw-r--	2022-10-31 11:36
07optional.phpt	460 B	-rw-rw-r--	2022-10-31 11:36
08escape.phpt	2.4 KB	-rw-rw-r--	2022-10-31 11:36
09notice.phpt	1.6 KB	-rw-rw-r--	2022-10-31 11:36
10pg_convert.phpt	459 B	-rw-rw-r--	2022-10-31 11:36
10pg_convert_9.phpt	524 B	-rw-rw-r--	2022-10-31 11:36
10pg_convert_json_array.phpt	663 B	-rw-rw-r--	2022-10-31 11:36
11pg_meta_data.phpt	1020 B	-rw-rw-r--	2022-10-31 11:36
12pg_insert.phpt	495 B	-rw-rw-r--	2022-10-31 11:36
12pg_insert_9.phpt	843 B	-rw-rw-r--	2022-10-31 11:36
13pg_select.phpt	655 B	-rw-rw-r--	2022-10-31 11:36
13pg_select_9.phpt	966 B	-rw-rw-r--	2022-10-31 11:36
14pg_update.phpt	711 B	-rw-rw-r--	2022-10-31 11:36
14pg_update_9.phpt	780 B	-rw-rw-r--	2022-10-31 11:36
15pg_delete.phpt	597 B	-rw-rw-r--	2022-10-31 11:36
16pg_result_status.phpt	362 B	-rw-rw-r--	2022-10-31 11:36
17result.phpt	1020 B	-rw-rw-r--	2022-10-31 11:36
18pg_escape_bytea_before.phpt	673 B	-rw-rw-r--	2022-10-31 11:36
18pg_escape_bytea_esc.phpt	668 B	-rw-rw-r--	2022-10-31 11:36
18pg_escape_bytea_hex.phpt	684 B	-rw-rw-r--	2022-10-31 11:36
19pg_ping.phpt	223 B	-rw-rw-r--	2022-10-31 11:36
20pg_get_pid.phpt	263 B	-rw-rw-r--	2022-10-31 11:36
21pg_get_notify.phpt	356 B	-rw-rw-r--	2022-10-31 11:36
22pg_fetch_object.phpt	649 B	-rw-rw-r--	2022-10-31 11:36
23sync_query_params.phpt	1.33 KB	-rw-rw-r--	2022-10-31 11:36
24sync_query_prepared.phpt	1.44 KB	-rw-rw-r--	2022-10-31 11:36
25async_query_params.phpt	1.64 KB	-rw-rw-r--	2022-10-31 11:36
26async_query_prepared.phpt	2.55 KB	-rw-rw-r--	2022-10-31 11:36
27large_object_oid.phpt	1.16 KB	-rw-rw-r--	2022-10-31 11:36
28large_object_import_oid.phpt	1.2 KB	-rw-rw-r--	2022-10-31 11:36
29nb_async_connect.phpt	908 B	-rw-rw-r--	2022-10-31 11:36
30nb_async_query_params.phpt	1.76 KB	-rw-rw-r--	2022-10-31 11:36
31nb_async_query_prepared.phpt	2.46 KB	-rw-rw-r--	2022-10-31 11:36
32nb_async_query.phpt	1.72 KB	-rw-rw-r--	2022-10-31 11:36
80_bug14383.phpt	1.17 KB	-rw-rw-r--	2022-10-31 11:36
80_bug24499.phpt	914 B	-rw-rw-r--	2022-10-31 11:36
80_bug27597.phpt	833 B	-rw-rw-r--	2022-10-31 11:36
80_bug32223.phpt	1.26 KB	-rw-rw-r--	2022-10-31 11:36
80_bug32223b.phpt	1.33 KB	-rw-rw-r--	2022-10-31 11:36
80_bug36625.phpt	930 B	-rw-rw-r--	2022-10-31 11:36
80_bug39971.phpt	587 B	-rw-rw-r--	2022-10-31 11:36
80_bug42783.phpt	620 B	-rw-rw-r--	2022-10-31 11:36
98old_api.phpt	674 B	-rw-rw-r--	2022-10-31 11:36
9999dropdb.phpt	318 B	-rw-rw-r--	2022-10-31 11:36
CONFLICTS	6 B	-rw-rw-r--	2022-10-31 11:36
README.md	700 B	-rw-rw-r--	2022-10-31 11:36
bug37100.phpt	976 B	-rw-rw-r--	2022-10-31 11:36
bug37100_9.phpt	928 B	-rw-rw-r--	2022-10-31 11:36
bug46408.phpt	506 B	-rw-rw-r--	2022-10-31 11:36
bug47199.phpt	1.51 KB	-rw-rw-r--	2022-10-31 11:36
bug60244.phpt	1.24 KB	-rw-rw-r--	2022-10-31 11:36
bug64609.phpt	526 B	-rw-rw-r--	2022-10-31 11:36
bug65119.phpt	646 B	-rw-rw-r--	2022-10-31 11:36
bug68638.phpt	1.16 KB	-rw-rw-r--	2022-10-31 11:36
bug71062.phpt	987 B	-rw-rw-r--	2022-10-31 11:36
bug71998.phpt	2.91 KB	-rw-rw-r--	2022-10-31 11:36
bug72028.phpt	1.02 KB	-rw-rw-r--	2022-10-31 11:36
bug72195.phpt	315 B	-rw-rw-r--	2022-10-31 11:36
bug72197.phpt	679 B	-rw-rw-r--	2022-10-31 11:36
bug75419.phpt	306 B	-rw-rw-r--	2022-10-31 11:36
bug76548.phpt	423 B	-rw-rw-r--	2022-10-31 11:36
bug77047.phpt	955 B	-rw-rw-r--	2022-10-31 11:36
bug81720.phpt	675 B	-rw-rw-r--	2022-10-31 11:36
close_default_link.phpt	276 B	-rw-rw-r--	2022-10-31 11:36
config.inc	964 B	-rw-rw-r--	2022-10-31 11:36
connect_after_close.phpt	323 B	-rw-rw-r--	2022-10-31 11:36
lcmess.inc	380 B	-rw-rw-r--	2022-10-31 11:36
nonblocking.inc	991 B	-rw-rw-r--	2022-10-31 11:36
pg_delete_001.phpt	2.2 KB	-rw-rw-r--	2022-10-31 11:36
pg_insert_001.phpt	868 B	-rw-rw-r--	2022-10-31 11:36
pg_insert_002.phpt	564 B	-rw-rw-r--	2022-10-31 11:36
pg_meta_data_001.phpt	2.37 KB	-rw-rw-r--	2022-10-31 11:36
pg_select_001.phpt	1.34 KB	-rw-rw-r--	2022-10-31 11:36
pg_update_001.phpt	1.24 KB	-rw-rw-r--	2022-10-31 11:36
php.gif	3.78 KB	-rw-rw-r--	2022-10-31 11:36
skipif.inc	1007 B	-rw-rw-r--	2022-10-31 11:36

Rename

--TEST--
Bug #71998 Function pg_insert does not insert when column type = inet
--SKIPIF--
<?php include("skipif.inc"); ?>
--FILE--
<?php
// Kudos for the IP regex to
// http://stackoverflow.com/a/17871737/3358424

include('config.inc');

$db = pg_connect($conn_str);

pg_query("CREATE TABLE tmp_statistics (id integer NOT NULL, remote_addr inet);");

$ips = array(
	/* IPv4*/
	"127.0.0.1",
	"10.0.0.1",
	"192.168.1.1",
	"0.0.0.0",
	"255.255.255.255",
	"192.168.1.35/24",

/* IPv6 */
	"::1",
	"::10.2.3.4",
	"::ffff:10.4.3.2",
	"1:2:3:4:5:6:7:8",
	"::ffff:10.0.0.1",
	"::ffff:1.2.3.4",
	"::ffff:0.0.0.0",
	"1:2:3:4:5:6:77:88",
	"::ffff:255.255.255.255",
	"fe08::7:8",
	"ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff",
	"::5:aef1:ffff/128",
	"2001:4f8:3:ba::/112",

);

$bad = array(
	/* bad */
	"256.257.258.259",
	"fe08::7:8interface",
	"schnitzel",
	"10002.3.4",
	"1.2.3.4.5",
	"256.0.0.0",
	"260.0.0.0",
);

$ips = array_merge($ips, $bad);
$i = 0;
$errors = 0;
foreach ($ips as $ip) {
	$data = array("id" => ++$i, "remote_addr" => $ip);
	$r = @pg_insert($db, 'tmp_statistics', $data);

if (!$r && in_array($ip, $bad)) {
		$errors++;
		//echo pg_last_error($db);
	}

//pg_query($db, "INSERT INTO tmp_statistics (id, remote_addr) VALUES (2, '127.0.0.1')"); // OK, record inserted
}

$r = pg_query($db, "SELECT * FROM tmp_statistics");
while (false != ($row = pg_fetch_row($r))) {
	var_dump($row);
}
echo $errors, " errors catched\n";

pg_query($db, "DROP TABLE tmp_statistics");
pg_close($db);

?>
==DONE==
--EXPECT--
array(2) {
  [0]=>
  string(1) "1"
  [1]=>
  string(9) "127.0.0.1"
}
array(2) {
  [0]=>
  string(1) "2"
  [1]=>
  string(8) "10.0.0.1"
}
array(2) {
  [0]=>
  string(1) "3"
  [1]=>
  string(11) "192.168.1.1"
}
array(2) {
  [0]=>
  string(1) "4"
  [1]=>
  string(7) "0.0.0.0"
}
array(2) {
  [0]=>
  string(1) "5"
  [1]=>
  string(15) "255.255.255.255"
}
array(2) {
  [0]=>
  string(1) "6"
  [1]=>
  string(15) "192.168.1.35/24"
}
array(2) {
  [0]=>
  string(1) "7"
  [1]=>
  string(3) "::1"
}
array(2) {
  [0]=>
  string(1) "8"
  [1]=>
  string(10) "::10.2.3.4"
}
array(2) {
  [0]=>
  string(1) "9"
  [1]=>
  string(15) "::ffff:10.4.3.2"
}
array(2) {
  [0]=>
  string(2) "10"
  [1]=>
  string(15) "1:2:3:4:5:6:7:8"
}
array(2) {
  [0]=>
  string(2) "11"
  [1]=>
  string(15) "::ffff:10.0.0.1"
}
array(2) {
  [0]=>
  string(2) "12"
  [1]=>
  string(14) "::ffff:1.2.3.4"
}
array(2) {
  [0]=>
  string(2) "13"
  [1]=>
  string(14) "::ffff:0.0.0.0"
}
array(2) {
  [0]=>
  string(2) "14"
  [1]=>
  string(17) "1:2:3:4:5:6:77:88"
}
array(2) {
  [0]=>
  string(2) "15"
  [1]=>
  string(22) "::ffff:255.255.255.255"
}
array(2) {
  [0]=>
  string(2) "16"
  [1]=>
  string(9) "fe08::7:8"
}
array(2) {
  [0]=>
  string(2) "17"
  [1]=>
  string(39) "ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff"
}
array(2) {
  [0]=>
  string(2) "18"
  [1]=>
  string(13) "::5:aef1:ffff"
}
array(2) {
  [0]=>
  string(2) "19"
  [1]=>
  string(19) "2001:4f8:3:ba::/112"
}
7 errors catched
==DONE==