10pg_convert_json_array.phpt 663 B

12345678910111213141516171819202122232425262728293031323334353637
  1. --TEST--
  2. PostgreSQL pg_convert() and JSON/Array
  3. --SKIPIF--
  4. <?php
  5. include("skipif.inc");
  6. skip_server_version('9.2');
  7. ?>
  8. --FILE--
  9. <?php
  10. error_reporting(E_ALL);
  11. include 'config.inc';
  12. $db = pg_connect($conn_str);
  13. $fields = array(
  14. 'textary'=>'{"meeting", "lunch", "training", "presentation"}',
  15. 'jsn'=>'{"f1":1,"f2":"foo"}',
  16. );
  17. $converted = pg_convert($db, $table_name_92, $fields);
  18. var_dump($converted);
  19. if (!pg_insert($db, $table_name_92, $fields)) {
  20. echo "Error\n";
  21. } else {
  22. echo "OK\n";
  23. }
  24. ?>
  25. --EXPECT--
  26. array(2) {
  27. [""textary""]=>
  28. string(51) "E'{"meeting", "lunch", "training", "presentation"}'"
  29. [""jsn""]=>
  30. string(22) "E'{"f1":1,"f2":"foo"}'"
  31. }
  32. OK