function querySingle($query, $all = false)
{
$this->error = "";
if ($this->versi == 3) {
return $this->db->querySingle($query, $all);
} else {
return sqlite_single_query($this->db, $query, $all);
}
}
function insert_in_db($tag)
{
global $array, $idx;
$sql = '';
foreach ($array as $key => $data) {
if (sqlite_single_query($idx, "SELECT name FROM changelog WHERE name='{$key}'")) {
$sql .= "UPDATE changelog SET {$tag}='{$data[1]}' WHERE name='{$key}';";
} else {
$sql .= "INSERT INTO changelog (name, {$tag}) VALUES ('{$key}', '{$data[1]}');";
}
$sql .= "REPLACE INTO last_seen_values (name, defaultval, permissions) VALUES ('{$key}', '" . sqlite_escape_string(expand_macros($data[0])) . "', '{$data['1']}');";
}
if ($sql) {
sqlite_query($idx, $sql);
}
}
<?php
chdir(dirname(__FILE__));
// pres2 hack
// sample IP
$_SERVER['REMOTE_ADDR'] = "24.100.195.79";
$ip_int = sprintf("%u", ip2long($_SERVER['REMOTE_ADDR']));
$country = sqlite_single_query("\nSELECT country_name \nFROM ip_ranges ir \nINNER JOIN country_data cd ON ir.country_code=cd.id\nWHERE {$ip_int} BETWEEN ip_start AND ip_end", sqlite_open("./ip.db"));
echo "User is located in {$country}";
function write_data($table_name)
{
global $db;
static $proper;
if (is_null($proper)) {
$proper = version_compare(PHP_VERSION, '5.1.3', '>=');
}
if ($proper) {
$col_types = sqlite_fetch_column_types($db->db_connect_id, $table_name);
} else {
$sql = "SELECT sql\n\t\t\t\tFROM sqlite_master\n\t\t\t\tWHERE type = 'table'\n\t\t\t\t\tAND name = '" . $table_name . "'";
$table_data = sqlite_single_query($db->db_connect_id, $sql);
$table_data = preg_replace('#CREATE\\s+TABLE\\s+"?' . $table_name . '"?#i', '', $table_data);
$table_data = trim($table_data);
preg_match('#\\((.*)\\)#s', $table_data, $matches);
$table_cols = explode(',', trim($matches[1]));
foreach ($table_cols as $declaration) {
$entities = preg_split('#\\s+#', trim($declaration));
$column_name = preg_replace('/"?([^"]+)"?/', '\\1', $entities[0]);
// Hit a primary key, those are not what we need :D
if (empty($entities[1]) || strtolower($entities[0]) === 'primary' && strtolower($entities[1]) === 'key') {
continue;
}
$col_types[$column_name] = $entities[1];
}
}
$sql = "SELECT *\n\t\t\tFROM {$table_name}";
$result = sqlite_unbuffered_query($db->db_connect_id, $sql);
$rows = sqlite_fetch_all($result, SQLITE_ASSOC);
$sql_insert = 'INSERT INTO ' . $table_name . ' (' . implode(', ', array_keys($col_types)) . ') VALUES (';
foreach ($rows as $row) {
foreach ($row as $column_name => $column_data) {
if (is_null($column_data)) {
$row[$column_name] = 'NULL';
} else {
if ($column_data == '') {
$row[$column_name] = "''";
} else {
if (strpos($col_types[$column_name], 'text') !== false || strpos($col_types[$column_name], 'char') !== false || strpos($col_types[$column_name], 'blob') !== false) {
$row[$column_name] = sanitize_data_generic(str_replace("'", "''", $column_data));
}
}
}
}
$this->flush($sql_insert . implode(', ', $row) . ");\n");
}
}
}
}
/* check for/create the queue file */
if (file_exists($queuefile) && filesize($queuefile) < 3000) {
unlink($queuefile);
}
clearstatcache();
if (!file_exists($queuefile)) {
$db = sqlite_open($queuefile);
sqlite_query($db, "BEGIN;\n\t\t\tCREATE TABLE notes( \n\t\t\t\tid INTEGER PRIMARY KEY, \n\t\t\t\tpage CHAR(100), \n\t\t\t\tlang CHAR(5),\n\t\t\t\tdate INT(11), \n\t\t\t\temail CHAR(700), \n\t\t\t\tdisplay CHAR(700),\n\t\t\t\tcomment CHAR(4000)); \n\t\t\tCOMMIT;");
sqlite_close($db);
}
/* check for/create the last_id file while we're at it */
if (!file_exists($last_id) || !file_get_contents($last_id) || file_get_contents($last_id == '0')) {
$db = sqlite_open($notesfile);
$estimate = sqlite_single_query($db, "SELECT COUNT(*) FROM notes");
$setid = sqlite_query($db, "SELECT id FROM notes WHERE id > '{$estimate}'", SQLITE_ASSOC);
if ($setid && sqlite_num_rows($setid) > 0) {
while (sqlite_valid($setid)) {
$rowid = sqlite_fetch_single($setid);
}
} else {
$rowid = $estimate;
}
file_put_contents($last_id, $rowid);
sqlite_close($db);
}
}
/* ============================ PREVIEW ONLY ========================= */
if (isset($_POST['preview'])) {
print "<br />\n<p>\nThis is what your entry will look like, roughly:\n</p>\n";
/**
* Removes items from the cache by conditions & garbage collector.
* @param array conditions
* @return void
*/
public function clean(array $conds)
{
$all = !empty($conds[Cache::ALL]);
$collector = empty($conds);
// cleaning using file iterator
if ($all || $collector) {
$now = time();
$base = $this->dir . DIRECTORY_SEPARATOR . 'c';
$iterator = new RecursiveIteratorIterator(new RecursiveDirectoryIterator($this->dir), RecursiveIteratorIterator::CHILD_FIRST);
foreach ($iterator as $entry) {
$path = (string) $entry;
if (strncmp($path, $base, strlen($base))) {
// skip files out of cache
continue;
}
if ($entry->isDir()) {
// collector: remove empty dirs
@rmdir($path);
// @ - removing dirs is not necessary
continue;
}
if ($all) {
$this->delete($path);
} else {
// collector
$meta = $this->readMeta($path, LOCK_SH);
if (!$meta) {
continue;
}
if (!empty($meta[self::META_EXPIRE]) && $meta[self::META_EXPIRE] < $now) {
$this->delete($path, $meta[self::HANDLE]);
continue;
}
fclose($meta[self::HANDLE]);
}
}
if ($all && extension_loaded('sqlite')) {
sqlite_exec("DELETE FROM cache", $this->getDb());
}
return;
}
// cleaning using journal
if (!empty($conds[Cache::TAGS])) {
$db = $this->getDb();
foreach ((array) $conds[Cache::TAGS] as $tag) {
$tmp[] = "'" . sqlite_escape_string($tag) . "'";
}
$query[] = "tag IN (" . implode(',', $tmp) . ")";
}
if (isset($conds[Cache::PRIORITY])) {
$query[] = "priority <= " . (int) $conds[Cache::PRIORITY];
}
if (isset($query)) {
$db = $this->getDb();
$query = implode(' OR ', $query);
$files = sqlite_single_query("SELECT file FROM cache WHERE {$query}", $db, FALSE);
foreach ($files as $file) {
$this->delete($file);
}
sqlite_exec("DELETE FROM cache WHERE {$query}", $db);
}
}
<?php
define('sqlite_r', sqlite_open("./ip.db"));
function safe_query($query)
{
$res = sqlite_query($query, sqlite_r);
if (!$res) {
$err_code = sqlite_last_error(sqlite_r);
printf("Query Failed %d:%s\n", $err_code, sqlite_error_string($err_code));
exit;
}
return $res;
}
sqlite_query("BEGIN", sqlite_r);
$fp = fopen("./ip-to-country.csv", "r");
$query_str = '';
while ($row = fgetcsv($fp, 4096)) {
foreach ($row as $key => $val) {
$row[$key] = sqlite_escape_string($val);
}
if (!($country_id = sqlite_single_query("SELECT id FROM country_data WHERE cc_code_2='{$row[2]}'", sqlite_r))) {
$res = safe_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]}')");
$country_id = sqlite_last_insert_rowid(sqlite_r);
}
$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});";
}
safe_query($query_str, sqlite_r);
sqlite_query("COMMIT", sqlite_r);
fclose($fp);
sqlite_close(sqlite_r);
// close database
<?php
chdir(dirname(__FILE__));
// pres2 hack
$db = sqlite_open("./ip.db");
$result = sqlite_single_query("SELECT country_name FROM country_data WHERE country_name LIKE 'U%'", $db);
foreach ($result as $country) {
echo $country . "<br />\n";
}
public function Insert($Datos, $tabla, $AntiHack = true)
{
$this->Datos = $Datos;
$this->Cadena1 = "INSERT INTO " . $tabla . " ( ";
$this->Cadena2 = " VALUES ( ";
$this->total_valores = count($this->Datos);
$i = 0;
foreach ($this->Datos as $nombre => $valor) {
if ($i < $this->total_valores - 1) {
$this->Cadena1 .= "`" . $nombre . "` , ";
$this->Cadena2 .= "'" . $valor . "' , ";
} else {
$this->Cadena1 .= "`" . $nombre . "` ) ";
$this->Cadena2 .= "'" . $valor . "' ) ";
}
$i++;
}
$this->Sentencia = $this->Cadena1 . $this->Cadena2;
if ($AntiHack) {
$this->Sentencia = $this->AntiHack($this->Sentencia);
}
if ($this->DbType == 'mysql') {
$this->resultado_insert = @mysql_query($this->Sentencia);
if ($this->resultado_insert) {
$this->resultado6['msg'] = "Dato Insertado Correctamente";
$this->resultado6['bandera'] = true;
$this->resultado6['affected_rows'] = mysql_affected_rows();
$this->resultado6['insert_id'] = mysql_insert_id();
} else {
$this->resultado6['msg'] = "Dato Insertado Erroneamente : " . mysql_error();
$this->resultado6['bandera'] = false;
}
@mysql_free_result($this->resultado_insert);
return $this->resultado6;
}
if ($this->DbType == 'sqlite') {
$this->resultado_insert = @sqlite_single_query($this->SqliteDB, $this->Sentencia);
print_r($this->resultado_insert);
if ($this->resultado_insert) {
$this->resultado['msg'] = "Dato Insertado Correctamente";
$this->resultado['bandera'] = true;
$this->resultado['insert_id'] = @sqlite_last_insert_rowid($this->resultado_insert);
} else {
$this->resultado['msg'] = "Dato Insertado Erroneamente";
$this->resultado['bandera'] = false;
$this->resultado['insert_id'] = @sqlite_last_insert_rowid($this->resultado_insert);
}
return $this->resultado;
}
}
<pre>
<?php
$db = sqlite_open(dirname(__FILE__) . "/db.sqlite");
print_r(sqlite_single_query("SELECT login FROM auth_tbl", $db));
sqlite_close($db);
?>
</pre>
protected function _returnResultRow($sql, $class = null, $lockRows = false)
{
$this->_connect();
if (!($query = sqlite_query($this->_conn, $sql))) {
return null;
}
if (sqlite_num_rows($query) <= 0) {
return null;
}
$row = sqlite_single_query($query, true);
if (is_null($class)) {
return $row;
}
return $this->_returnEntity($row, $class);
}
<?php
function most_similar(&$context, $string, $source_str)
{
/* Calculate the similarity between two strings */
$sim = similar_text($string, $source_str);
if (empty($context) || $sim > $context['sim']) {
$context = array('sim' => $sim, 'title' => $string);
}
}
function most_similar_finalize(&$context)
{
return $context['title'];
}
$db = sqlite_open(dirname(__FILE__) . "/db2.sqlite");
/* bool sqlite_create_aggregate (resource dbhandle, string function_name, mixed step_func, mixed finalize_func [, int num_args]) */
sqlite_create_aggregate($db, 'similar_text', 'most_similar', 'most_similar_finalize', 2);
$title = 'mesg #2';
echo "Most Similar title to '{$title}' according to similar_text() is: ";
echo sqlite_single_query("SELECT similar_text(title, '{$title}') FROM messages", $db);
echo "<br />\n";
function check_if_exists($cc)
{
return sqlite_single_query("SELECT id FROM country_data WHERE cc_code_2='{$cc}'", sqlite_r);
}
<?php
require "./fav_settings.php";
require "./fav_strings.php";
$conn = sqlite_popen($sqlite_file);
if ($_GET['id'] > 0) {
$qry = "SELECT name FROM Fav WHERE id=" . $_GET['id'];
$container = sqlite_single_query($conn, $qry);
} elseif ($_GET['id'] == -1) {
$container = $MyFav_Order_CatOrd;
} else {
$container = $MyFav_Order_RootOrd;
}
$qry = "SELECT id,name FROM Fav WHERE " . ($_GET['id'] == -1 ? 'cat = 1' : 'catid=' . $_GET['id']) . (!$_GET['id'] ? ' AND cat = 0' : '') . " ORDER BY ord,id";
$rs = sqlite_query($conn, $qry);
$rcnt = sqlite_num_rows($rs);
$MM_RedirectUrl = $homeURL . $SidebarSuffix1;
if (isset($_SESSION['isLogined']) && isset($_POST["MM_reorder"]) && $_POST["MM_reorder"] == "form1") {
$Command1_CommandText = '';
$order = explode("|", $_POST['newOrder']);
array_pop($order);
foreach ($order as $ord => $id) {
$Command1_CommandText .= "UPDATE Fav SET ord = " . sqlite_escape_string($ord) . " WHERE id = " . sqlite_escape_string($id) . ";";
}
sqlite_exec($Command1_CommandText, $conn);
header("Location: " . $MM_RedirectUrl);
exit;
}
echo '<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
for ($i = 0; $i < sqlite_num_fields($rh); $i++) {
$n = sqlite_field_name($rh, $i);
$c = sqlite_column($rh, $i);
var_dump($c);
$c = sqlite_column($rh, $n);
var_dump($c);
}
// fetch_all
$r = sqlite_fetch_all($rh);
var_dump($r);
// fetch single
sqlite_rewind($rh);
$r = sqlite_fetch_string($rh);
var_dump($r);
} else {
echo "bad query: " . sqlite_error_string($db);
}
// array_query
$val = sqlite_array_query($db, 'SELECT * FROM mytable');
var_dump($val);
// single query
$val = sqlite_single_query($db, 'SELECT * FROM mytable');
var_dump($val);
$val = sqlite_single_query($db, 'SELECT * FROM mytable LIMIT 1', true);
var_dump($val);
$val = sqlite_single_query($db, 'SELECT * FROM mytable LIMIT 1', false);
var_dump($val);
$r = sqlite_close($db);
?>
