odbc_free_result_001.phpt 1.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950
  1. --TEST--
  2. odbc_free_result(): Basic test
  3. --SKIPIF--
  4. <?php include 'skipif.inc'; ?>
  5. --FILE--
  6. <?php
  7. include 'config.inc';
  8. $conn = odbc_connect($dsn, $user, $pass);
  9. odbc_exec($conn, 'CREATE DATABASE odbcTEST');
  10. odbc_exec($conn, 'CREATE TABLE FOO (TEST INT NOT NULL)');
  11. odbc_exec($conn, 'ALTER TABLE FOO ADD PRIMARY KEY (TEST)');
  12. odbc_exec($conn, 'INSERT INTO FOO VALUES (1)');
  13. odbc_exec($conn, 'INSERT INTO FOO VALUES (2)');
  14. $res = odbc_exec($conn, 'SELECT * FROM FOO');
  15. var_dump(odbc_fetch_row($res));
  16. var_dump(odbc_result($res, 'test'));
  17. var_dump(odbc_free_result($res));
  18. var_dump(odbc_free_result($conn));
  19. var_dump(odbc_free_result(NULL));
  20. var_dump(odbc_fetch_row($res));
  21. var_dump(odbc_result($res, 'test'));
  22. odbc_exec($conn, 'DROP TABLE FOO');
  23. odbc_exec($conn, 'DROP DATABASE odbcTEST');
  24. ?>
  25. --EXPECTF--
  26. bool(true)
  27. string(1) "1"
  28. bool(true)
  29. Warning: odbc_free_result(): supplied resource is not a valid ODBC result resource in %s on line %d
  30. bool(false)
  31. Warning: odbc_free_result() expects parameter 1 to be resource, null given in %s on line %d
  32. NULL
  33. Warning: odbc_fetch_row(): %d is not a valid ODBC result resource in %s on line %d
  34. bool(false)
  35. Warning: odbc_result(): %d is not a valid ODBC result resource in %s on line %d
  36. bool(false)