skray

function baza

Sep 2nd, 2016
169
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.05 KB | None | 0 0
  1.  <?php
  2.  
  3. function baza($dbname,$tdname,$tdatr)
  4. {
  5.     $_db="baz/$dbname.db";
  6.     $dbl="db_".$dbname;
  7.     global $$dbl;
  8.     if (!file_exists($_db))
  9.     {
  10.         $list="";
  11.         $td=array_combine($tdname,$tdatr);
  12.         foreach($td as $k=>$lis) {$list.="$k $lis,";}
  13.         $list=preg_replace("/(.*),$/",'\1',$list);
  14.         $$dbl = new SQLite3($_db);
  15.         $$dbl->busyTimeout(5000);
  16.         $$dbl->exec('PRAGMA journal_mode=WAL;');   
  17.         $$dbl->exec("CREATE TABLE IF NOT EXISTS $dbname ($list);");
  18.         $$dbl->close();
  19.     }
  20.     $$dbl = new SQLite3($_db);
  21.     $$dbl->busyTimeout(5000);
  22.     $$dbl->exec('PRAGMA journal_mode=WAL;');   
  23. }
  24.  
  25. /////////////////////////////////////////////
  26.  
  27. // вызов функции и запрос на нужную базу
  28.  
  29. $tdname=array("id", "txt", "sitebar", "bl2br", "count");
  30. $tdatr=array("INTEGER PRIMARY KEY", "TEXT", "TEXT", "INTEGER", "INTEGER");
  31. $dbname=preg_replace("/([a-z0-9]).php$/",'\1',basename(__FILE__));
  32.  
  33. baza($dbname,$tdname,$tdatr);
  34.  
  35. $sitebarcount= $db_sitebar->querySingle("SELECT count(*) FROM $dbname"); // база для модуля sitebar.php
  36.  
  37. ?>
Advertisement
Add Comment
Please, Sign In to add comment