PageRenderTime 52ms CodeModel.GetById 27ms RepoModel.GetById 0ms app.codeStats 0ms

/ext/sqlite/sqlite.php

http://github.com/infusion/PHP
PHP | 36 lines | 27 code | 9 blank | 0 comment | 4 complexity | 916411a7f0a6237683c4b64b646dd673 MD5 | raw file
Possible License(s): MPL-2.0-no-copyleft-exception, LGPL-2.1, BSD-3-Clause
  1. <?php
  2. if (!extension_loaded("sqlite")) {
  3. dl("sqlite.so");
  4. if (!extension_loaded("sqlite")) {
  5. exit("Please enable SQLite support\n");
  6. }
  7. }
  8. debug_zval_dump(sqlite_libversion());
  9. debug_zval_dump(sqlite_libencoding());
  10. $s = sqlite_open("weztest.sqlite", 0666, $err);
  11. debug_zval_dump($err);
  12. debug_zval_dump($s);
  13. $r = sqlite_query("create table foo (a INTEGER PRIMARY KEY, b INTEGER )", $s);
  14. debug_zval_dump(sqlite_last_error($s));
  15. debug_zval_dump(sqlite_error_string(sqlite_last_error($s)));
  16. $r = sqlite_query("select *, php('md5', sql) as o from sqlite_master", $s);
  17. debug_zval_dump($r);
  18. debug_zval_dump(sqlite_num_rows($r));
  19. debug_zval_dump(sqlite_num_fields($r));
  20. for ($j = 0; $j < sqlite_num_fields($r); $j++) {
  21. echo "Field $j is " . sqlite_field_name($r, $j) . "\n";
  22. }
  23. while ($row = sqlite_fetch_array($r, SQLITE_ASSOC)) {
  24. print_r($row);
  25. }
  26. sqlite_close($s);
  27. ?>