/**
* Directly executes SQL
* @param string $query
* @return sqlite_result
* @throws sqlite_exception
*/
public function exec($query)
{
try {
$query = preg_replace('/`(\\w+)`/is', '"$1"', $query);
if ($result = $this->con->query($query, SQLITE_BOTH, $error)) {
return $result;
} else {
throw new sqlite_exception($query, $error);
}
} catch (Exception $e) {
throw new sqlite_exception($query, $e->getMessage());
}
}
function open_db()
{
$db = new SQLiteDatabase("labels.db");
$q = $db->query('PRAGMA table_info(product)');
if ($q->numRows() == 0) {
$db->query('create table product(
id integer primary key,
title varchar(255),
subtitle varchar(255),
url varchar(255),
sku varchar(32))');
}
return $db;
}
function getTags($data)
{
$db = new SQLiteDatabase('sql/imgorg.db');
$image = $data->image;
$q = $db->query('SELECT t.text as text, t.id as id FROM Tags t INNER JOIN Images_Tags it ON t.id = it.tag_id WHERE it.image_id = "' . $image . '"');
return $q->fetchAll();
}
protected function Query($query)
{
// SPConfig::debOut( $query, false, false, true );
switch ($this->_driver) {
case 'SQLITE':
try {
if ($r = $this->_db->query($query, SQLITE_ASSOC)) {
$r = $r->fetch();
} else {
Sobi::Error('cache', sprintf('SQLite error on query: %s', $query), SPC::WARNING, 0, __LINE__, __FILE__);
return false;
}
} catch (SQLiteException $x) {
Sobi::Error('cache', sprintf('SQLite error: %s', $x->getMessage()), SPC::WARNING, 0, __LINE__, __FILE__);
$this->_enabled = false;
$this->cleanAll();
return false;
}
break;
case 'PDO':
if ($s = $this->_db->prepare($query)) {
$s->execute();
$r = $s->fetch(PDO::FETCH_ASSOC);
} else {
Sobi::Error('cache', sprintf('SQLite error on query: %s. Error %s', $query, implode("\n", $this->_db->errorInfo())), SPC::WARNING, 0, __LINE__, __FILE__);
$this->_enabled = false;
$this->cleanAll();
return false;
}
break;
}
return $r;
}
/**
* @return bool|SQLiteDatabase
* @throws Exception
*/
public function getSqlite()
{
// return existing object
if ($this->_sqlite) {
return $this->_sqlite;
}
// get the database name
if (!$this->database) {
$this->database = dirname(dirname(__FILE__)) . '/data/' . get_class($this) . '.db';
}
// create the folder
if (!file_exists(dirname($this->database))) {
if (!mkdir(dirname($this->database), $this->mode['folder'], true)) {
return false;
}
}
// connect to the database
$this->_sqlite = new SQLiteDatabase($this->database, $this->mode['file']);
if (!$this->_sqlite) {
throw new Exception(strtr('Unable to create sqlite database for {className}', array('{className}' => get_class($this))));
}
// create the table if needed
if (!$this->_sqlite->query("SELECT name FROM sqlite_master WHERE type='table' AND name='config'")->numRows()) {
$this->sqlite->queryExec("CREATE TABLE config(config_key text UNIQUE NOT NULL PRIMARY KEY, config_value text)");
}
return $this->_sqlite;
}
public function select($filter)
{
$sql = "SELECT * FROM {$this->name} WHERE " . $this->filterToSql($filter);
$res = self::$conn->query($sql);
if ($res === false) {
$error = self::$conn->errorInfo();
switch ($error[0]) {
case 'HY000':
throw new DataStoreNoTableError("Table [{$this->name}] doesn't exists in [{$sql}]");
break;
default:
throw new DataStoreError("Error {$error[2]} ({$error[0]}/{$error[1]}) in query {$sql}");
}
return false;
}
return $res->fetch();
}
function createMusicDB()
{
$dbFileName = "../db/musicDatabase.db";
if ($db = new SQLiteDatabase($dbFileName)) {
// first let the engine check table, and create it eventualy
$q = @$db->query('CREATE TABLE IF NOT EXISTS albums (id int PRIMARY KEY ASC, title TEXT, artist TEXT, cover TEXT, PRIMARY KEY (id))');
}
}
function getAllInfo($data)
{
$db = new SQLiteDatabase('sql/imgorg.db');
$res = $db->query('select * from Albums');
$json = array();
while ($o = $res->fetchObject()) {
$q = $db->query('SELECT * FROM Images WHERE album_id = "' . $o->id . '"');
$qres = $q->fetchObject();
if ($qres) {
$path = $qres->url;
$o->exif = exif_read_data('../' . $path);
$o->filename = $qres->filename;
}
$o->size = sizeof($q->fetchAll());
array_push($json, $o);
}
return $json;
}
function step_1()
{
if (file_exists(DB_FILE) == true) {
echo DB_FILE . " already exists, deleted\n";
unlink(DB_FILE);
}
$db = new SQLiteDatabase(DB_FILE);
return $db->query("CREATE TABLE fuu (" . "\t\t\t id INTEGER PRIMARY KEY," . "\t\t\t insult TEXT," . "\t\t\t audio_file CHAR(255)," . "\t\t\t nb_view INTEGER," . "\t\t\t nb_play INTEGER" . "\t );");
}
function getDB()
{
$dbFile = "filter-demo.db";
$hasDB = file_exists($dbFile);
$db = new SQLiteDatabase($dbFile);
if (!$hasDB) {
$db->query(readCreateSql());
}
return $db;
}
/**
* Returns whether or not the key exists and is not expired in the cache,
* i.e. there is a valid entry for this key
*
* @param string $key Cache key associated to the data
*
* @return boolean
*/
public function containsKey($key)
{
if (!$this->enabled) {
return false;
}
$result = $this->db->query("SELECT key FROM cache WHERE key='" . $this->key($key) . "' WHERE expire >= datetime('now')");
$has_key = $result->numRows() > 0;
$this->Logger->debug("Cache contains {$key}? " . $has_key ? 'TRUE' : 'FALSE');
return $has_key;
}
private function action()
{
if ($db = new SQLiteDatabase(_MINDSRC_ . '/mind3rd/SQLite/mind')) {
$result = $db->query("SELECT * FROM user where login='******' AND pwd='" . sha1($this->pwd) . "' AND status= 'A'");
$row = false;
while ($result->valid()) {
$row = $result->current();
$_SESSION['auth'] = JSON_encode($row);
$_SESSION['login'] = $row['login'];
break;
}
if (!$row) {
Mind::write('auth_fail', true);
return false;
}
} else {
die('Database not found!');
}
return $this;
}
function hitcounter($url)
{
//error_reporting(6143);
$hits = 0;
if ($db = new SQLiteDatabase('/home/a3253051/db/hitcounter.db')) {
$q = @$db->query("SELECT counter FROM rsshits WHERE url = '" . $url . "'");
if ($q === false) {
$db->queryExec('CREATE TABLE rsshits (url TEXT, counter int)');
//$hits = 1;
} else {
$result = $q->fetchSingle();
$hits = intval($result);
//$db->queryExec("INSERT INTO rsshits VALUES ('".$_GET['url']."',".$hits.")");
//$db->queryExec("UPDATE rsshits SET counter=".$hits." WHERE url='".$_GET['url']."'");
}
} else {
die($err);
}
return $hits;
}
function getInfo($data)
{
$db = new SQLiteDatabase("sql/imgorg.db");
$image = $data->image;
$q = $db->query('SELECT url FROM Images WHERE id = "' . $image . '"');
$path = $q->fetchObject()->url;
$ret = exif_read_data('../' . $path);
return $ret;
}
$width = $argv[3];
}
} else {
if (isset($_GET['sura']) && is_numeric($_GET['sura']) && isset($_GET['ayah']) && is_numeric($_GET['ayah'])) {
$sura = $_GET['sura'];
$ayah = $_GET['ayah'];
if (isset($_GET['width']) && is_numeric($_GET['width'])) {
$width = $_GET['width'];
}
}
}
$db = new SQLiteDatabase('./data/sura_ayah_page_text.sqlite2.db');
if (!$db) {
die("died");
}
$q = @$db->query("select page, text from sura_ayah_page_text where sura = {$sura} and ayah = {$ayah}");
$result = $q->fetch();
$page = $result[page];
$text = $result[text];
if ($page == 1 || $page == 2) {
$fontSize = 32;
} else {
$fontSize = 24;
}
//$fontSize = 1.6*$fontSize; // seems to overflow i.e. wrapping isn't perfect
$font = './data/fonts/QCF_P' . sprintf('%03d', $page) . '.TTF';
$words = split(';', $text);
$i = 0;
$max = count($words) - 1;
$min = 7;
$ayahText = array();
<?php
/* open connection to memory database */
$db = new SQLiteDatabase(":memory:");
/* execute a regular query */
$db->query("CREATE TABLE test(a,b)");
$db->query("INSERT INTO test VALUES('1','2')");
/* retrieve data using an unbuffered query */
$r = $db->unbufferedQuery("SELECT * FROM test", SQLITE_ASSOC);
echo '<pre>';
/* use object iterators to retrieve the data, without any additional functions */
foreach ($r as $row) {
print_r($row);
}
echo '</pre>';
<?php
// open database
$db = new SQLiteDatabase("./ip.db");
// begin transaction
$db->query("BEGIN");
$fp = fopen("./ip-to-country.csv", "r");
$query_str = '';
while ($row = fgetcsv($fp, 4096)) {
foreach ($row as $key => $val) {
// secure data
$row[$key] = sqlite_escape_string($val);
}
// check for existance of a country in db
if (!($country_id = $db->singleQuery("SELECT id FROM country_data WHERE cc_code_2='{$row[2]}'"))) {
// add new country
if (!$db->query("INSERT INTO country_data \n\t\t\t(cc_code_2, cc_code_3, country_name) \n\t\t\tVALUES('{$row[2]}', '{$row[3]}', '{$row[4]}')")) {
// fetch error
$err_code = $db->lastError();
printf("Query Failed %d:%s\n", $err_code, sqlite_error_string($err_code));
exit;
}
// get ID for the last inserted row
$country_id = $db->lastInsertRowid();
}
$query_str .= "INSERT INTO ip_ranges \n\t\t\t(ip_start, ip_end, country_code)\n\t\t\tVALUES({$row[0]}, {$row[1]}, {$country_id});";
}
// insert IP data via a chained query
$db->query($query_str);
// finalize transaction
$db->query("COMMIT");
try {
$db = new SQLiteDatabase($dbFile, 0666, $error);
$db->query("BEGIN;\n\t\t\tCREATE TABLE aloha (\n\t\t\t\tid INTEGER PRIMARY KEY,\n\t\t\t\tpageId CHAR(255),\n\t\t\t\tcontentId CHAR(255),\n\t\t\t\tcontent TEXT\n\t\t\t);\n\n\t\t\tINSERT INTO aloha \n\t\t\t\t(id, pageId, contentId, content)\n\t\t\tVALUES\n\t\t\t\t(NULL, NULL, NULL, 'Click to edit');\n\n\t\t\tCOMMIT;");
error_log("\n" . 'SQLite Database created ' . $dbFile, 3, "demo-app.log");
} catch (Exception $e) {
die($error);
}
} else {
// db already exists
$db = new SQLiteDatabase($dbFile, 0666, $error);
}
// check if we have already a data set for this and save data
// XSS handling required
$pageId = sqlite_escape_string($_REQUEST['pageId']);
$query = "SELECT * FROM aloha \n\tWHERE\n\t\tpageId = '" . $pageId . "';";
$result = $db->query($query, $error);
$exists = false;
$data = array();
while ($result->valid()) {
$exists = true;
$row = $result->current();
$data[] = $row;
$result->next();
error_log("\n" . 'data available for page ' . $pageId, 3, "demo-app.log");
}
error_log("\n" . 'error: ' . print_r($data, true), 3, "demo-app.log");
if (!empty($error)) {
error_log("\n" . 'error: ' . print_r($error, true), 3, "demo-app.log");
} else {
print_r(json_encode($data));
}
<!DOCTYPE html>
<html>
<?php
$sqlitedb = new SQLiteDatabase('mydb.sqli');
$sqlReturn = $sqlitedb->query("SELECT * FROM members WHERE name = \"John\"");
#
$is_admin = false;
$links = array();
if ($db = new SQLiteDatabase('links')) {
#
# If a new link is being entered, insert it into the DB.
#
if ($_GET['save'] && $is_admin) {
#
# Insert the row.
#
$url = sqlite_escape_string($_GET['save']);
$title = isset($_GET['title']) ? sqlite_escape_string($_GET['title']) : '';
$key = '';
$now = time();
$q = $db->query('INSERT INTO links (url, title, created, last_access) VALUES ("' . $url . '", "' . $title . '", ' . $now . ', ' . $now . ')');
if ($q === false) {
create_table($db);
$db->query('INSERT INTO links (url, title, created, last_access) VALUES ("' . $url . '", "' . $title . '", ' . $now . ', ' . $now . ')');
}
#
# Create the key.
#
$id = $db->lastInsertRowid();
$key = encode_key($id, $codeset);
$db->query('UPDATE links SET key="' . $key . '" WHERE id=' . $id);
#
# Get the title.
#
if ($title === '') {
$lines = array();
$invoice_id = intval($_GET['invoice_id']);
$product_url = '';
$price_in_usd = 0;
$price_in_btc = 0;
$amount_paid_btc = 0;
$amount_pending_btc = 0;
try {
//create or open the database
$database = new SQLiteDatabase('db.sqlite', 0666, $error);
} catch (Exception $e) {
die($error);
}
//find the invoice form the database
$query = "select price_in_usd, product_url, price_in_btc from Invoices where invoice_id = {$invoice_id}";
if ($result = $database->query($query, SQLITE_BOTH, $error)) {
if ($row = $result->fetch()) {
$product_url = $row['product_url'];
$price_in_usd = $row['price_in_usd'];
$price_in_btc = $row['price_in_btc'];
} else {
die('Invoice not found');
}
} else {
die($error);
}
//find the pending amount paid
$query = "select SUM(value) as value from pending_invoice_payments where invoice_id = {$invoice_id}";
if ($result = $database->query($query, SQLITE_BOTH, $error)) {
if ($row = $result->fetch()) {
$amount_pending_btc = $row['value'];
<?php
$list = <<<EOF
AD,Andorra;AE,United Arab Emirates;AF,Afghanistan;AG,Antigua & Barbuda;AI,Anguilla;AL,Albania;AM,Armenia;AN,Netherlands Antilles;AO,Angola;AQ,Antarctica;AR,Argentina;AS,American Samoa;AT,Austria;AU,Australia;AW,Aruba;AZ,Azerbaijan;BA,Bosnia and Herzegovina;BB,Barbados;BD,Bangladesh;BE,Belgium;BF,Burkina Faso;BG,Bulgaria;BH,Bahrain;BI,Burundi;BJ,Benin;BM,Bermuda;BN,Brunei Darussalam;BO,Bolivia;BR,Brazil;BS,Bahama;BT,Bhutan;BU,Burma (no longer exists);BV,Bouvet Island;BW,Botswana;BY,Belarus;BZ,Belize;CA,Canada;CC,Cocos (Keeling) Islands;CF,Central African Republic;CG,Congo;CH,Switzerland;CI,Côte D'ivoire (Ivory Coast);CK,Cook Iislands;CL,Chile;CM,Cameroon;CN,China;CO,Colombia;CR,Costa Rica;CS,Czechoslovakia (no longer exists);CU,Cuba;CV,Cape Verde;CX,Christmas Island;CY,Cyprus;CZ,Czech Republic;DD,German Democratic Republic (no longer exists);DE,Germany;DJ,Djibouti;DK,Denmark;DM,Dominica;DO,Dominican Republic;DZ,Algeria;EC,Ecuador;EE,Estonia;EG,Egypt;EH,Western Sahara;ER,Eritrea;ES,Spain;ET,Ethiopia;FI,Finland;FJ,Fiji;FK,Falkland Islands (Malvinas);FM,Micronesia;FO,Faroe Islands;FR,France;FX,France, Metropolitan;GA,Gabon;GB,United Kingdom (Great Britain);GD,Grenada;GE,Georgia;GF,French Guiana;GH,Ghana;GI,Gibraltar;GL,Greenland;GM,Gambia;GN,Guinea;GP,Guadeloupe;GQ,Equatorial Guinea;GR,Greece;GS,South Georgia and the South Sandwich Islands;GT,Guatemala;GU,Guam;GW,Guinea-Bissau;GY,Guyana;HK,Hong Kong;HM,Heard & McDonald Islands;HN,Honduras;HR,Croatia;HT,Haiti;HU,Hungary;ID,Indonesia;IE,Ireland;IL,Israel;IN,India;IO,British Indian Ocean Territory;IQ,Iraq;IR,Islamic Republic of Iran;IS,Iceland;IT,Italy;JM,Jamaica;JO,Jordan;JP,Japan;KE,Kenya;KG,Kyrgyzstan;KH,Cambodia;KI,Kiribati;KM,Comoros;KN,St. Kitts and Nevis;KP,Korea, Democratic People's Republic of;KR,Korea, Republic of;KW,Kuwait;KY,Cayman Islands;KZ,Kazakhstan;LA,Lao People's Democratic Republic;LB,Lebanon;LC,Saint Lucia;LI,Liechtenstein;LK,Sri Lanka;LR,Liberia;LS,Lesotho;LT,Lithuania;LU,Luxembourg;LV,Latvia;LY,Libyan Arab Jamahiriya;MA,Morocco;MC,Monaco;MD,Moldova, Republic of;MG,Madagascar;MH,Marshall Islands;ML,Mali;MN,Mongolia;MM,Myanmar;MO,Macau;MP,Northern Mariana Islands;MQ,Martinique;MR,Mauritania;MS,Monserrat;MT,Malta;MU,Mauritius;MV,Maldives;MW,Malawi;MX,Mexico;MY,Malaysia;MZ,Mozambique;NA,Namibia;NC,New Caledonia;NE,Niger;NF,Norfolk Island;NG,Nigeria;NI,Nicaragua;NL,Netherlands;NO,Norway;NP,Nepal;NR,Nauru;NT,Neutral Zone (no longer exists);NU,Niue;NZ,New Zealand;OM,Oman;PA,Panama;PE,Peru;PF,French Polynesia;PG,Papua New Guinea;PH,Philippines;PK,Pakistan;PL,Poland;PM,St. Pierre & Miquelon;PN,Pitcairn;PR,Puerto Rico;PT,Portugal;PW,Palau;PY,Paraguay;QA,Qatar;RE,Réunion;RO,Romania;RU,Russian Federation;RW,Rwanda;SA,Saudi Arabia;SB,Solomon Islands;SC,Seychelles;SD,Sudan;SE,Sweden;SG,Singapore;SH,St. Helena;SI,Slovenia;SJ,Svalbard & Jan Mayen Islands;SK,Slovakia;SL,Sierra Leone;SM,San Marino;SN,Senegal;SO,Somalia;SR,Suriname;ST,Sao Tome & Principe;SU,Union of Soviet Socialist Republics (no longer exists);SV,El Salvador;SY,Syrian Arab Republic;SZ,Swaziland;TC,Turks & Caicos Islands;TD,Chad;TF,French Southern Territories;TG,Togo;TH,Thailand;TJ,Tajikistan;TK,Tokelau;TM,Turkmenistan;TN,Tunisia;TO,Tonga;TP,East Timor;TR,Turkey;TT,Trinidad & Tobago;TV,Tuvalu;TW,Taiwan, Province of China;TZ,Tanzania, United Republic of;UA,Ukraine;UG,Uganda;UM,United States Minor Outlying Islands;US,United States of America;UY,Uruguay;UZ,Uzbekistan;VA,Vatican City State (Holy See);VC,St. Vincent & the Grenadines;VE,Venezuela;VG,British Virgin Islands;VI,United States Virgin Islands;VN,Viet Nam;VU,Vanuatu;WF,Wallis & Futuna Islands;WS,Samoa;YD,Democratic Yemen (no longer exists);YE,Yemen;YT,Mayotte;YU,Yugoslavia;ZA,South Africa;ZM,Zambia;ZR,Zaire;ZW,Zimbabwe;ZZ,Unknown or unspecified country
EOF;
if ($db = new SQLiteDatabase('test.db')) {
$q = @$db->query('SELECT * FROM countries LIMIT 0,1;');
if ($q === false) {
$l = split(';', $list);
$db->queryExec('CREATE TABLE countries (id int, code char, name char, PRIMARY KEY (id));');
foreach ($l as $k => $v) {
$tmp = split(',', $v);
$db->queryExec(sprintf('INSERT INTO countries VALUES (%s, "%s", "%s");', $k, $tmp[0], $tmp[1]));
}
}
} else {
die($err);
}
define('_HYGRID_TABLE_', 'countries');
define('_HYGRID_ALLOWED_TABLES', 'countries');
class hygrid
{
static $page, $rpp, $rows;
function __construct()
{
$this->total = 0;
$this->table = $_REQUEST['table'] ? $_REQUEST['table'] : _HYGRID_TABLE_;
$this->page = $_REQUEST['page'] ? $_REQUEST['page'] : 1;
$this->rpp = $_REQUEST['rpp'] ? $_REQUEST['rpp'] : false;
// total
}
<?php
/**
* Инициализация структуры и данных БД.
*
* @author Sergey S. Nevmerzhitsky (http://koteg.moikrug.ru/), 25.01.2012
* @since 25.01.2012
*/
$resource = new SQLiteDatabase(dirname(__FILE__) . '/../data/test.sqlite', 0666, $error);
if (empty($resource)) {
die("Cannot connect: {$error}");
}
$sqls = array();
//$sqls[] = 'DROP TABLE foobar';
$sqls[] = <<<SQL
CREATE TABLE foobar (
id INTEGER PRIMARY KEY ASC,
name TEXT NOT NULL,
foo TEXT NOT NULL,
bar TEXT NOT NULL
)
SQL;
foreach ($sqls as $sql) {
/* @var $result SQLiteResult */
$result = $resource->query($sql, SQLITE_ASSOC, $error);
if (!$result) {
die("Cannot execute query: {$error}");
}
}
<?php
$tasks_db = 'tasks.db';
define('CREATE_TASKS_SQL', "CREATE TABLE tasks (\n\t\t\tid integer primary key,\n\t\t\tparent_id integer not null,\n\t\t\ttask text not null,\n\t\t\tcreated_at datetime not null,\n\t\t\tcompleted_at datetime)");
define('CHECK_FOR_EXISTING_TASKS_TABLE_SQL', "SELECT name FROM sqlite_master\n\t\t WHERE type = 'table'\n\t\t AND name = 'tasks'");
define('CREATE_IMAGES_SQL', "CREATE table images (\n\t\t id integer primary key,\n\t\t name text not null,\n\t\t directory text not null,\n\t\t title text,\n\t\t created_at datetime,\n\t\t created_by text,\n\t\t caption text)");
/**
* Open the database or create if it does not exist
*/
$sqlite = new SQLiteDatabase($tasks_db);
// Does table exist?
$res = @$sqlite->query(CHECK_FOR_EXISTING_TASKS_TABLE_SQL);
// If not then create it
if (!$res->numRows()) {
@$sqlite->query(CREATE_TASKS_SQL);
}
/*
function table_exists($dbhandle,$table)
{
$sql = "SELECT * FROM sqlite_master
WHERE type='table'
AND name='". $sqlite_escape_string($table) . "'";
$res = $dbc->query($sql);
if($res->numRows()) {
return true;
}
return false;
} */
mkdir('stats');
}
include 'config.inc.php';
// Check for compatibility
if (!version_compare(PHP_VERSION, '5.0.0', '>=')) {
die("I need PHP version 5 or greater!\n");
}
if (!class_exists('SQLiteDatabase')) {
die("Cannot find PHP-SQLite extension!\n");
}
if (!file_exists(PWS_DATABASE)) {
die("The database file was not found!\n");
}
$db = new SQLiteDatabase(PWS_DATABASE);
/////////////////////// ENCRYPTED
$protected = $db->query('SELECT encrypted FROM accesspoints WHERE encrypted = 1')->numRows();
$unprotected = $db->query('SELECT encrypted FROM accesspoints WHERE encrypted = 0')->numRows();
$total = $protected + $unprotected;
$part_p = $protected / $total;
$part_u = $unprotected / $total;
$arc_p = $part_p * 360;
$arc_u = $part_u * 360;
$image = imagecreatetruecolor(380, 202);
// allocate some solors
$white = imagecolorallocate($image, 0xff, 0xff, 0xff);
$darkred = imagecolorallocate($image, 0x99, 0x0, 0x0);
$darkgreen = imagecolorallocate($image, 0x0, 0x99, 0x0);
imagefill($image, 0, 0, $white);
imagefilledarc($image, 100, 100, 200, 200, 0, $arc_p, $darkred, IMG_ARC_PIE);
imagefilledarc($image, 100, 100, 200, 200, $arc_p, 360, $darkgreen, IMG_ARC_PIE);
imagestring($image, 2, 220, 10, 'unprotected accesspoints', $darkgreen);
$dbhandle = sqlite_open('sqlitedb');
sqlite_close($dbhandle);
if ($db = sqlite_open('mysqlitedb', 0666, $sqliteerror)) {
sqlite_query($db, 'CREATE TABLE foo (bar varchar(10))');
sqlite_query($db, "INSERT INTO foo VALUES ('fnord')");
$result = sqlite_query($db, 'select bar from foo');
var_dump(sqlite_fetch_array($result));
} else {
die($sqliteerror);
}
$db = sqlite_open('mysqlitedb');
$result = sqlite_query($db, "SELECT * FROM mytable WHERE name='John Doe'");
$rows = sqlite_num_rows($result);
echo "Number of rows: {$rows}";
$db = new SQLiteDatabase('mysqlitedb');
$result = $db->query("SELECT * FROM mytable WHERE name='John Doe'");
$rows = $result->numRows();
echo "Number of rows: {$rows}";
$dbhandle = sqlite_open('mysqlitedb');
$query = sqlite_exec($dbhandle, "UPDATE users SET email='*****@*****.**' WHERE username='******'", $error);
if (!$query) {
exit("Error in query: '{$error}'");
} else {
echo 'Number of rows modified: ', sqlite_changes($dbhandle);
}
$dbhandle = new SQLiteDatabase('mysqlitedb');
$query = $dbhandle->queryExec("UPDATE users SET email='*****@*****.**' WHERE username='******'", $error);
if (!$query) {
exit("Error in query: '{$error}'");
} else {
echo 'Number of rows modified: ', $dbhandle->changes();
public static function setUpDbSqlLite()
{
// create new database (OO interface)
$db = new SQLiteDatabase("data/db.sqlite");
// create table foo and insert sample data
$db->query("BEGIN;\n\t\t\t\tCREATE TABLE IF NOT EXISTS short_urls(id INTEGER PRIMARY KEY AUTOINCRIMENT, long_url CHAR(255), short_url CHAR(100), date_created DATETIME);\n\t\t\t\tINSERT INTO short_urls (long_url, short_url, date_created) VALUES('http://example.com/long','http://example.com/short', '2009-10-20 00:00:00');\n\t\t\t\tCOMMIT;");
// execute a query
$result = $db->query("SELECT * FROM short_urls");
// iterate through the retrieved rows
while ($result->valid()) {
// fetch current row
$row = $result->current();
print_r($row);
// proceed to next row
$result->next();
}
// not generally needed as PHP will destroy the connection
unset($db);
}
id INTEGER PRIMARY KEY,
text STRING
);
INSERT INTO Tags (text) VALUES("Family");
INSERT INTO Tags (text) VALUES("Friends");
INSERT INTO Tags (text) VALUES("Other")');
// Images
// $db->queryExec('DROP TABLE Images');
$db->queryExec('CREATE TABLE Images (
id INTEGER PRIMARY KEY,
filename STRING,
url STRING,
album_id INTEGER,
description TEXT
)');
// $dir = "../../images/thumbs/";
// $images = array();
// $d = dir($dir);
// $i = 0;
// while($name = $d->read()){
// if(!preg_match('/\.(jpg|gif|png)$/', $name)) continue;
// $size = filesize($dir.$name);
// $lastmod = filemtime($dir.$name)*1000;
// $db->queryExec('INSERT INTO Images (filename, url) VALUES
// ("'.$name.'","images/thumbs/'.$name.'")');
// }
// $d->close();
echo json_encode($db->query('select * from Images')->fetchAll());
} else {
die($err);
}
include "config.php";
// Include the class
include "class.php";
// Initiate database
if ($preferredDatabase == "sqlite") {
$db = new SQLiteDatabase("db.sqlite");
} elseif ($preferredDatabase == "mysql") {
$socket = mysql_connect($mysqlHost, $mysqlUsername, $mysqlPassword) or die(mysql_error());
mysql_select_db($mysqlDatabase, $socket);
}
// If the form has not been submitted
if (!isset($_GET['submit'])) {
echo "<form method=\"GET\">\r\n\t\t\t\t<table>\r\n\t\t\t\t<tr><td>Plugin's exact name:</td><td><input type=\"text\" name=\"name\" value=\"" . $_GET['name'] . "\" /></td></tr>\r\n\t\t\t\t<tr><td>Plugin's forum URL:</td><td><input type=\"text\" name=\"url\" /></td></tr>\r\n\t\t\t\t<tr><td><input type=\"submit\" name=\"submit\" /></td></tr>\r\n\t\t\t\t</table>\r\n\t\t\t</form>";
} else {
// Secure the input
$name = secure_sql_input($_GET['name']);
$url = secure_sql_input($_GET['url']);
// Check whether the URL has the https protocol
if (substr_count($url, "https", 0, 5) > 0) {
// If it does have the https protocol we need to ensure it gets changed
$url = preg_replace("/https/i", "http", $url);
}
// Insert the URL into a new row in the database along with the name of the plugin
$sql = "INSERT INTO plugins (name, url) VALUES ('" . $name . "', '" . $url . "')";
if ($preferredDatabase == "sqlite") {
$db->query($sql);
} elseif ($preferredDatabase == "mysql") {
mysql_query($sql, $socket);
}
echo "<p>Plugin URL added, please <a href=\"plugins.php\">re-run the updater</a>!";
}
$mtime = $mtime[1] + $mtime[0];
$starttime = $mtime;
// Set the script execution limit
set_time_limit("120");
// Initiate the database
if ($preferredDatabase == "sqlite") {
$db = new SQLiteDatabase("db.sqlite");
} elseif ($preferredDatabase == "mysql") {
$socket = mysql_connect($mysqlHost, $mysqlUsername, $mysqlPassword) or die(mysql_error());
mysql_select_db($mysqlDatabase, $socket);
}
// Get a list of all plugins which already have a forum URL associated with them
$database = array();
$sql = "SELECT * FROM plugins";
if ($preferredDatabase == "sqlite") {
$query = $db->query($sql);
while ($query->valid()) {
$database[] = $query->current();
// Move pointer to next row
$query->next();
}
} elseif ($preferredDatabase == "mysql") {
$query = mysql_query($sql, $socket);
while ($row = mysql_fetch_array($query)) {
$database[] = $row;
}
}
$Iplugins = array();
// For each entry in the database, grab its corresponding array
foreach ($database as $id => $array) {
// For each one of these arrays, get the type (name of column) and its value
