Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- function baza($dbname,$tdname,$tdatr)
- {
- $_db="baz/$dbname.db";
- $dbl="db_".$dbname;
- global $$dbl;
- if (!file_exists($_db))
- {
- $list="";
- $td=array_combine($tdname,$tdatr);
- foreach($td as $k=>$lis) {$list.="$k $lis,";}
- $list=preg_replace("/(.*),$/",'\1',$list);
- $$dbl = new SQLite3($_db);
- $$dbl->busyTimeout(5000);
- $$dbl->exec('PRAGMA journal_mode=WAL;');
- $$dbl->exec("CREATE TABLE IF NOT EXISTS $dbname ($list);");
- $$dbl->close();
- }
- $$dbl = new SQLite3($_db);
- $$dbl->busyTimeout(5000);
- $$dbl->exec('PRAGMA journal_mode=WAL;');
- }
- /////////////////////////////////////////////
- // вызов функции и запрос на нужную базу
- $tdname=array("id", "txt", "sitebar", "bl2br", "count");
- $tdatr=array("INTEGER PRIMARY KEY", "TEXT", "TEXT", "INTEGER", "INTEGER");
- $dbname=preg_replace("/([a-z0-9]).php$/",'\1',basename(__FILE__));
- baza($dbname,$tdname,$tdatr);
- $sitebarcount= $db_sitebar->querySingle("SELECT count(*) FROM $dbname"); // база для модуля sitebar.php
- ?>
Advertisement
Add Comment
Please, Sign In to add comment