Return to 18pg_escape_bytea.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / pgsql / tests

Annotation of embedaddon/php/ext/pgsql/tests/18pg_escape_bytea.phpt, revision 1.1

1.1     ! misho       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