Advertisement
Guest User

Untitled

a guest
Mar 27th, 2013
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.79 KB | None | 0 0
  1. <?php
  2.  
  3. echo phpversion()."\n";
  4.  
  5. try
  6. {
  7.     $db=new PDO('sqlite::memory:');
  8.     var_dump($db->query('select sqlite_version()')->fetchAll());
  9.     echo "\n";
  10.    
  11.     $db->query('pragma foreign_keys=0');
  12.     $db->query('pragma foreign_keys=1');
  13.     $db->query('pragma foreign_keys=NO');
  14.     $db->query('pragma foreign_keys=YES');
  15. }
  16. catch(Exception $e)
  17. {
  18.     echo $e->getMessage();
  19.     die;
  20. }
  21. echo $db->errorCode()."\n";
  22.  
  23. try
  24. {
  25.     @unlink('./test.db');
  26.     $db=new PDO('sqlite:./test.db');
  27.     var_dump($db->query('select sqlite_version()')->fetchAll());
  28.     echo "\n";
  29.    
  30.     $db->query('pragma foreign_keys=0');
  31.     $db->query('pragma foreign_keys=1');
  32.     $db->query('pragma foreign_keys=NO');
  33.     $db->query('pragma foreign_keys=YES');
  34. }
  35. catch(Exception $e)
  36. {
  37.     echo $e->getMessage();
  38.     die;
  39. }
  40. echo $db->errorCode()."\n";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement