13pg_select.phpt 676 B

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