summaryrefslogtreecommitdiff
path: root/ext/pgsql/tests/08escape.phpt
diff options
context:
space:
mode:
Diffstat (limited to 'ext/pgsql/tests/08escape.phpt')
-rw-r--r--ext/pgsql/tests/08escape.phpt72
1 files changed, 36 insertions, 36 deletions
diff --git a/ext/pgsql/tests/08escape.phpt b/ext/pgsql/tests/08escape.phpt
index 6b0d1899d4..6b510aef73 100644
--- a/ext/pgsql/tests/08escape.phpt
+++ b/ext/pgsql/tests/08escape.phpt
@@ -14,13 +14,13 @@ $expect = "ABC\\\\ABC\\'";
$expect2 = "ABC\\\\ABC\\\\''"; //the way escape string differs from PostgreSQL 9.0
$after = pg_escape_string($before);
if ($expect === $after || $expect2 === $after) {
- echo "pg_escape_string() is Ok\n";
+ echo "pg_escape_string() is Ok\n";
}
else {
- echo "pg_escape_string() is NOT Ok\n";
- var_dump($before);
- var_dump($after);
- var_dump($expect);
+ echo "pg_escape_string() is NOT Ok\n";
+ var_dump($before);
+ var_dump($after);
+ var_dump($expect);
}
// pg_escape_bytea() test
@@ -28,13 +28,13 @@ $before = "ABC\\ABC";
$expect = "ABC\\\\\\\\ABC";
$after = pg_escape_bytea($before);
if ($expect === $after) {
- echo "pg_escape_bytea() is Ok\n";
+ echo "pg_escape_bytea() is Ok\n";
}
else {
- echo "pg_escape_byte() is NOT Ok\n";
- var_dump($before);
- var_dump($after);
- var_dump($expect);
+ echo "pg_escape_byte() is NOT Ok\n";
+ var_dump($before);
+ var_dump($after);
+ var_dump($expect);
}
// Test using database
@@ -49,23 +49,23 @@ pg_query($db, $sql);
// Retrieve binary from DB
for ($i = 0; $i < 2; $i++) {
- $sql = "SELECT bin::bytea FROM ".$table_name." WHERE num = 10000";
- $result = pg_query($db, $sql);
- $row = pg_fetch_array($result, 0, PGSQL_ASSOC);
+ $sql = "SELECT bin::bytea FROM ".$table_name." WHERE num = 10000";
+ $result = pg_query($db, $sql);
+ $row = pg_fetch_array($result, 0, PGSQL_ASSOC);
- if ($data === pg_unescape_bytea($row['bin'])) {
- echo "pg_escape_bytea() actually works with database\n";
- break;
- }
- elseif (!$i) {
- // Force bytea escaping and retry
- @pg_query($db, "SET bytea_output = 'escape'");
- }
- else {
- $result = pg_query($db, $sql);
- echo "pg_escape_bytea() is broken\n";
- break;
- }
+ if ($data === pg_unescape_bytea($row['bin'])) {
+ echo "pg_escape_bytea() actually works with database\n";
+ break;
+ }
+ elseif (!$i) {
+ // Force bytea escaping and retry
+ @pg_query($db, "SET bytea_output = 'escape'");
+ }
+ else {
+ $result = pg_query($db, $sql);
+ echo "pg_escape_bytea() is broken\n";
+ break;
+ }
}
// pg_escape_literal/pg_escape_identifier
@@ -73,26 +73,26 @@ $before = "ABC\\ABC\'";
$expect = " E'ABC\\\\ABC\\\\'''";
$after = pg_escape_literal($before);
if ($expect === $after) {
- echo "pg_escape_literal() is Ok\n";
+ echo "pg_escape_literal() is Ok\n";
}
else {
- echo "pg_escape_literal() is NOT Ok\n";
- var_dump($before);
- var_dump($after);
- var_dump($expect);
+ echo "pg_escape_literal() is NOT Ok\n";
+ var_dump($before);
+ var_dump($after);
+ var_dump($expect);
}
$before = "ABC\\ABC\'";
$expect = "\"ABC\ABC\'\"";
$after = pg_escape_identifier($before);
if ($expect === $after) {
- echo "pg_escape_identifier() is Ok\n";
+ echo "pg_escape_identifier() is Ok\n";
}
else {
- echo "pg_escape_identifier() is NOT Ok\n";
- var_dump($before);
- var_dump($after);
- var_dump($expect);
+ echo "pg_escape_identifier() is NOT Ok\n";
+ var_dump($before);
+ var_dump($after);
+ var_dump($expect);
}
?>