function __construct() { parent::__construct(); $table = 'lib_statistics'; $sqlite = new sqlite($table); $this->sqlite = $sqlite; $data = $sqlite->select(); if (isset($_SERVER['HTTP_USER_AGENT'])) { $this->user_agent = $_SERVER['HTTP_USER_AGENT']; $this->language = $_SERVER['HTTP_ACCEPT_LANGUAGE']; } else { $this->user_agent = 'UPDATING'; $this->language = 'UPDATING'; } if (!$data) { $stmt = "CREATE TABLE IF NOT EXISTS {$table} (\n\t\t\t\t\t\tid INTEGER NOT NULL,\n\t\t\t\t\t\tip TEXT(15) NOT NULL,\n\t\t\t\t\t\tuser_agent TEXT(100) NOT NULL,\n\t\t\t\t\t\tlanguage TEXT(100) NOT NULL,\n\t\t\t\t\t\tfirst_access TEXT(19) NOT NULL,\n\t\t\t\t\t\tlast_access TEXT(19) NOT NULL,\n\t\t\t\t\t\tPRIMARY KEY ('id')\n\t\t\t\t\t);"; $sqlite->exec($stmt); } $data = $sqlite->selectWhere('ip = "' . $_SERVER['REMOTE_ADDR'] . '"'); if (!$data) { $this->insert(); } else { if ($data['user_agent'] != $this->user_agent) { $this->insert(); } else { $this->update($data['id']); } } }
public static function delete() { $input = json_decode(file_get_contents('php://input')); $statement = 'DELETE FROM tasks WHERE taskId = :taskId'; $parameters = array(':taskId' => $input->taskId); $sqlite = new sqlite(); return $sqlite->exec($statement, $parameters); }
public static function convert_table($source, $target) { $sqlite = new sqlite(); // Get source fields $pragma = $sqlite->query("PRAGMA table_info({$source})"); foreach ($pragma as $k => $v) { $fieldcsv .= $v->name . ','; } $fieldcsv = rtrim($fieldcsv, ","); // Copy records $sql = "INSERT INTO {$target} ({$fieldcsv}) SELECT {$fieldcsv} FROM {$source}"; $sqlite->exec($sql); echo "{$sql} \r\n"; echo "Table {$source} converted to {$target}.\r\n"; }
public static function create_table() { $sqlite = new sqlite(); return $sqlite->exec("\n create table tokens (\n tokenid INTEGER PRIMARY KEY,\n username varchar(255) NULL DEFAULT '',\n token varchar(255) NULL DEFAULT '',\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL\n )\n "); }
public static function create_table() { $sqlite = new sqlite(); return $sqlite->exec("\n create table users (\n UserId INTEGER PRIMARY KEY,\n Username varchar(255) NULL DEFAULT '',\n Password varchar(255) NULL DEFAULT ''\n )\n "); }