home *** CD-ROM | disk | FTP | other *** search
/ PC Professionell 2005 June / PCpro_2005_06.ISO / files / opensource / xamp / xampp-win32.exe / xampp / .tmpsqlite_012.phpt < prev    next >
Encoding:
Text File  |  2004-03-24  |  734 b   |  36 lines
  1. --TEST--
  2. sqlite: read field names
  3. --INI--
  4. sqlite.assoc_case=0
  5. --SKIPIF--
  6. <?php # vim:ft=php
  7. if (!extension_loaded("sqlite")) print "skip"; ?>
  8. --FILE--
  9. <?php 
  10. include "blankdb.inc";
  11.  
  12. sqlite_query("CREATE TABLE strings(foo VARCHAR, bar VARCHAR, baz VARCHAR)", $db);
  13.  
  14. echo "Buffered\n";
  15. $r = sqlite_query("SELECT * from strings", $db);
  16. for($i=0; $i<sqlite_num_fields($r); $i++) {
  17.     var_dump(sqlite_field_name($r, $i));
  18. }
  19. echo "Unbuffered\n";
  20. $r = sqlite_unbuffered_query("SELECT * from strings", $db);
  21. for($i=0; $i<sqlite_num_fields($r); $i++) {
  22.     var_dump(sqlite_field_name($r, $i));
  23. }
  24. echo "DONE!\n";
  25. ?>
  26. --EXPECT--
  27. Buffered
  28. string(3) "foo"
  29. string(3) "bar"
  30. string(3) "baz"
  31. Unbuffered
  32. string(3) "foo"
  33. string(3) "bar"
  34. string(3) "baz"
  35. DONE!
  36.