13pg_select.phpt 655 B

12345678910111213141516171819202122232425262728293031323334353637
  1. --TEST--
  2. PostgreSQL pg_select()
  3. --SKIPIF--
  4. <?php
  5. include("skipif.inc");
  6. skip_server_version('8.5dev', '>=');
  7. ?>
  8. --FILE--
  9. <?php
  10. error_reporting(E_ALL);
  11. include 'config.inc';
  12. $db = pg_connect($conn_str);
  13. $fields = array('num'=>'1234', 'str'=>'ABC', 'bin'=>'XYZ');
  14. $ids = array('num'=>'1234');
  15. $res = pg_select($db, $table_name, $ids) or print "Error\n";
  16. var_dump($res);
  17. echo pg_select($db, $table_name, $ids, PGSQL_DML_STRING)."\n";
  18. echo "Ok\n";
  19. ?>
  20. --EXPECT--
  21. array(1) {
  22. [0]=>
  23. array(3) {
  24. ["num"]=>
  25. string(4) "1234"
  26. ["str"]=>
  27. string(3) "AAA"
  28. ["bin"]=>
  29. string(3) "BBB"
  30. }
  31. }
  32. SELECT * FROM "php_pgsql_test" WHERE "num"=1234;
  33. Ok