ibase_trans_002.phpt 561 B

12345678910111213141516171819202122232425262728293031323334
  1. --TEST--
  2. ibase_trans(): Basic operations
  3. --SKIPIF--
  4. <?php include("skipif.inc"); ?>
  5. --FILE--
  6. <?php
  7. require("interbase.inc");
  8. $x = ibase_connect($test_base);
  9. $trans = ibase_trans(IBASE_DEFAULT, $x);
  10. $sth = ibase_prepare($trans, 'INSERT INTO test1 VALUES (?, ?)');
  11. $res = ibase_execute($sth, 100, 100);
  12. var_dump($res);
  13. ibase_commit($trans);
  14. $rs = ibase_query($x, 'SELECT * FROM test1 WHERE i = 100');
  15. var_dump(ibase_fetch_assoc($rs));
  16. ibase_free_query($sth);
  17. unset($res);
  18. ?>
  19. --EXPECT--
  20. int(1)
  21. array(2) {
  22. ["I"]=>
  23. int(100)
  24. ["C"]=>
  25. string(3) "100"
  26. }