← Back to branch summary

~ubuntu-branches/ubuntu/quantal/php5/quantal

« back to all changes in this revision

Viewing changes to ext/pgsql/tests/18pg_escape_bytea.phpt

  • Committer: Bazaar Package Importer
  • Author(s): Sean Finney
  • Date: 2009-07-01 09:12:10 UTC
  • mto: (0.9.1) (1.1.17 upstream)
  • mto: This revision was merged to the branch mainline in revision 58.
  • Revision ID: james.westby@ubuntu.com-20090701091210-go0h6506p62on17r
Tags: upstream-5.3.0
Import upstream version 5.3.0

Show diffs side-by-side

added added

removed removed

Lines of Context:
ext/pgsql/tests/18pg_escape_bytea.phpt
 
1
--TEST--
 
2
PostgreSQL pg_escape_bytea() functions
 
3
--SKIPIF--
 
4
<?php include("skipif.inc"); ?>
 
5
--FILE--
 
6
<?php
 
7
// optional functions
 
8
 
 
9
include('config.inc');
 
10
 
 
11
$image = file_get_contents(dirname(__FILE__) . '/php.gif');
 
12
$esc_image = pg_escape_bytea($image);
 
13
 
 
14
$db = pg_connect($conn_str);
 
15
pg_query($db, 'INSERT INTO '.$table_name.' (num, bin) VALUES (9876, \''.$esc_image.'\');');
 
16
$result = pg_query($db, 'SELECT * FROM '.$table_name.' WHERE num = 9876');
 
17
$rows = pg_fetch_all($result);
 
18
$unesc_image = pg_unescape_bytea($rows[0]['bin']);
 
19
 
 
20
if ($unesc_image !== $image) {
 
21
        echo "NG";
 
22
}
 
23
else {
 
24
        echo "OK";
 
25
}
 
26
?>
 
27
--EXPECT--
 
28
OK