function DBUCKET($db, $sql) { $search = array('CAN I PLZ GET ', ' ALL UP IN ', ' OMG '); $replace = array('SELECT ', ' FROM ', ' WHERE '); $sql = str_replace($search, $replace, $sql); return sqlite_array_query($db, $sql); }
function loadIndexes() { if (!$this->isExisting || $this->isIndexesLoaded) { return; } $this->loadColumns(); $connection_id = $this->database->getConnection()->getConnectionId(); $rs = sqlite_array_query($connection_id, "PRAGMA index_list('{$this->name}')", SQLITE_ASSOC); foreach ($rs as $item) { $index = new lmbSqliteIndexInfo(); $index->table = $this; $index->name = $item['name']; list($index_info) = sqlite_array_query($connection_id, "PRAGMA index_info('{$index->name}')", SQLITE_ASSOC); $index->column_name = $index_info['name']; if (1 == $item['unique']) { // if column is defined exactly as INTEGER PRIMARY KEY, primary index is not created // instead it becomes an alias of system ROWID, see http://www.sqlite.org/lang_createtable.html#rowid for more info $index->type = in_array($index['column_name'], $this->pk) ? lmbDbIndexInfo::TYPE_PRIMARY : lmbDbIndexInfo::TYPE_UNIQUE; } else { $index->type = lmbDbIndexInfo::TYPE_COMMON; } $this->indexes[$index->name] = $index; } $this->isIndexesLoaded = true; }
function array_query($sqlString, $result_type = SQLITE_BOTH, $decode_binary = true) { if (DEBUG) { return sqlite_array_query($this->connId, $sqlString, $result_type, $decode_binary); } else { return @sqlite_array_query($this->connId, $sqlString, $result_type, $decode_binary); } }
/** * Executes a query that might return just one row. * @param $query the query. * @return an array with the requested row data. */ public function singleQuery($query) { checkQuery($query); #echo "$query\n"; $ret = sqlite_array_query($query, $this->link, SQLITE_ASSOC); if (count($ret)) { return $ret[0]; } }
public function iteratorKeys() { $data = sqlite_array_query($this->db, 'SELECT keystr FROM is4c_local', SQLITE_NUM); $keys = array(); foreach ($data as $row) { $keys[] = $row[0]; } return array_merge(parent::iteratorKeys(), $keys); }
function get_stats() { global $db; $query = "SELECT SUM(nb_view) AS nb_views, SUM(nb_play) AS nb_plays FROM fuu WHERE 1"; $res = sqlite_array_query($db, $query, SQLITE_ASSOC); if (count($res) > 0) { return $res[0]; } return array('nb_views' => 0, 'nb_plays' => 0); }
public function SingleQuery($query) { if (!$this->IsConnected()) { throw new Exception("Not Connected to DB."); } #echo "$query\n"; $ret = sqlite_array_query($query, $this->link, SQLITE_ASSOC); if (count($ret)) { return $ret[0]; } }
public function getProducts() { try { $db = new dbHandler(); $link = $db->getDbHandler(); /*String*/ $query = "SELECT Name, Price FROM Products"; $result = sqlite_array_query($link, $query, SQLITE_ASSOC); $db->close(); return $result; } catch (Exception $exception) { Log::log(LoggingConstants::EXCEPTION, $exception); } return null; }
function getRecords() { global $dbPath, $dbHandle; if ($dbHandle == 0) { $dbHandle = sqlite_open($dbPath, 0666, $sqliteError) or die("SQL error: {$sqliteError}"); } //NO! $ra = sqlite_fetch_array(dbQuery("select id from list")); $ra = sqlite_array_query($dbHandle, 'SELECT * FROM list LIMIT 200'); /* echo "<pre>\n"; print_r($ra); echo "<pre>\n"; //var_dump(sqlite_fetch_array($result)); */ return $ra; }
echo "Time Taken: ".($e-$s)."\n"; $s = getmicrotime(); $r = sqlite_unbuffered_query("SELECT * FROM foo", $db); while (sqlite_fetch_array($r, SQLITE_NUM)); $e = getmicrotime(); echo "Time Taken: ".($e-$s)."\n"; $db = new sqlite_db("db2.sqlite"); $s = getmicrotime(); $r = $db->unbuffered_query("SELECT * FROM foo", SQLITE_NUM); foreach($r as $row); $e = getmicrotime(); echo "Time Taken: ".($e-$s)."\n"; sqlite_query("DROP TABLE messages", $db); sqlite_query("CREATE TABLE messages ( timestamp INTEGER, title VARCHAR(255) )", $db); sqlite_query("DROP TABLE profile", $db); sqlite_query("CREATE TABLE profile ( time_format VARCHAR(255), login VARCHAR(255) )", $db); sqlite_query("INSERT INTO profile (login, time_format) VALUES('ilia', 'l dS of F Y h:i:s A')", $db); for ($i = 0; $i < 5; $i++) { sqlite_query("INSERT INTO messages (timestamp, title) VALUES(".rand(time(), (time() + 86400 * 365)).", 'message #{$i}')", $db); } */ sqlite_query("PRAGMA show_datatypes = ON", $db); // sqlite_query("PRAGMA full_column_names = ON", $db); print_r(sqlite_array_query("SELECT * FROM messages", $db)); sqlite_close($db);
echo "<rejectWithBusy>".checkRejectWithBusy()."</rejectWithBusy>"; echo "<ifRecordFound>".getOnANIMatchCondition()."</ifRecordFound>"; if(getOnANIMatchCondition()=="acceptCall"){ print('<rejectCallWithBusy value="false">' . getRedirectRoute("acceptCall") . '</rejectCallWithBusy>'); }else{ if(checkRejectWithBusy()=='false'){ print('<rejectCallWithBusy value="false">' . getRedirectRoute("rejectCall") . '</rejectCallWithBusy>'); }else{ print('<rejectCallWithBusy value="true"/>'); } } echo("<queryResults recordsFound=\"".$recordsFound."\">"); echo('<!-- Multiple Records Found-->'); // Print out records found if there are more then one $query = "SELECT * FROM userRecords WHERE (ANI='".$_REQUEST['callerID']."') ORDER BY 1 DESC"; $dbhandle = sqlite_open($dbPath,0666); $result = sqlite_array_query($dbhandle,$query, SQLITE_ASSOC); foreach ($result as $entry) { echo "<recordName number=\"" . $recordCounterVar . "\">". ($entry['firstName'])." ".($entry['lastName']). "</recordName>"; $recordCounterVar++; } echo "</queryResults>"; } print('</xmlData>'); exit; ?>
<?php require "../config/main.php"; $rows = sqlite_array_query($dbmain, "SELECT database,nombre FROM tbempresas where codigo='" . $_POST["login-empresa"] . "' limit 1", SQLITE_ASSOC); foreach ($rows as $row) { mssql_select_db($row[database]); ///falta la clave $sql = mssql_query("select OBJECT_ID('dbo.VBENCRIPTA')"); if (mssql_result($sql, 0, 0) == '') { mssql_query("\n\t\t\tCREATE FUNCTION [dbo].[VBENCRIPTA](@str VARCHAR(50))\n\t\t\tRETURNS VARCHAR(50)\n\t\t\tAS\n\t\t\tBEGIN\n\t\t\t\tdeclare @istr as int;\n\t\t\t\tdeclare @strend as nvarchar(50);\n\t\t\t\tset @istr = 0;\n\t\t\t\tset @strend = '';\n\t\t\t\twhile len(@str)>@istr\n\t\t\t\tbegin\n\t\t\t\t\tset @strend = @strend + CHAR(ASCII(substring(@str,@istr+1,1))+80);\n\t\t\t\t\tset @istr = @istr+1;\n\t\t\t\tend\n\t\t\t\treturn @strend;\n\t\t\tEND"); } if ($sql = @mssql_query("select * from tbusuarios where LOGIN='******' and CLAVE=dbo.VBENCRIPTA('" . $_POST["login-pass"] . "') and inactivo=0")) { if (mssql_num_rows($sql) > 0) { $rowu = sqlite_array_query($dbmain, "SELECT * FROM tbsession where user='******' limit 1", SQLITE_ASSOC); if (count($rowu) == 0 || time() - $rowu[0][time] > 25) { sqlite_exec($dbmain, "delete from tbsession where user='******'"); sqlite_exec($dbmain, "insert into tbsession (id,user,time) values ('" . session_id() . "','" . md5(strtoupper($_POST["login-user"])) . "','" . time() . "')"); session_register("octa-lite-empresa"); $_SESSION["octa-lite-empresa"]["codigo"] = $_POST["login-empresa"]; $_SESSION["octa-lite-empresa"]["database"] = $row[database]; $_SESSION["octa-lite-empresa"]["nombre"] = $row[nombre]; session_register("octa-lite-user"); $_SESSION["octa-lite-user"] = mssql_fetch_array($sql, MSSQL_ASSOC); $_SESSION["octa-lite-user"]["CLAVE"] = "+++++"; echo "logged"; } else { echo utf8_encode("Este usuario ya esta activo en otro equipo!"); } } else { echo "Contraseña inválida!"; }
/** * Returns information about a table * * @param string $result a string containing the name of a table * @param int $mode a valid tableInfo mode * * @return array an associative array with the information requested. * A DB_Error object on failure. * * @see DB_common::tableInfo() * @since Method available since Release 1.7.0 */ function tableInfo($result, $mode = null) { if (is_string($result)) { /* * Probably received a table name. * Create a result resource identifier. */ $id = @sqlite_array_query($this->connection, "PRAGMA table_info('{$result}');", SQLITE_ASSOC); $got_string = true; } else { $this->last_query = ''; return $this->raiseError(DB_ERROR_NOT_CAPABLE, null, null, null, 'This DBMS can not obtain tableInfo' . ' from result sets'); } if ($this->options['portability'] & DB_PORTABILITY_LOWERCASE) { $case_func = 'strtolower'; } else { $case_func = 'strval'; } $count = count($id); $res = array(); if ($mode) { $res['num_fields'] = $count; } for ($i = 0; $i < $count; $i++) { if (strpos($id[$i]['type'], '(') !== false) { $bits = explode('(', $id[$i]['type']); $type = $bits[0]; $len = rtrim($bits[1], ')'); } else { $type = $id[$i]['type']; $len = 0; } $flags = ''; if ($id[$i]['pk']) { $flags .= 'primary_key '; if (strtoupper($type) == 'INTEGER') { $flags .= 'auto_increment '; } } if ($id[$i]['notnull']) { $flags .= 'not_null '; } if ($id[$i]['dflt_value'] !== null) { $flags .= 'default_' . rawurlencode($id[$i]['dflt_value']); } $flags = trim($flags); $res[$i] = array('table' => $case_func($result), 'name' => $case_func($id[$i]['name']), 'type' => $type, 'len' => $len, 'flags' => $flags); if ($mode & DB_TABLEINFO_ORDER) { $res['order'][$res[$i]['name']] = $i; } if ($mode & DB_TABLEINFO_ORDERTABLE) { $res['ordertable'][$res[$i]['table']][$res[$i]['name']] = $i; } } return $res; }
<?php $db = sqlite_open(dirname(__FILE__) . "/db2.sqlite"); /* arguments: * 1 database resource * 2 sqlite function name * 3 php function name * 4 number of arguments (optional) */ sqlite_create_function($db, "my_date", "date", 2); /* * The above function makes PHP date() avaliable * from SQLite as my_date() and for highest * performance indicates that it requires * exactly 2 arguments */ $res = sqlite_array_query("\n\tSELECT title, \n\tmy_date((SELECT time_format FROM profile WHERE login='******'), timestamp) AS date\n\tFROM messages", $db, SQLITE_ASSOC); foreach ($res as $v) { echo $v['title'] . " was posted on " . $v['date'] . "<br />\n"; }
public function queryAll($sql) { $result = sqlite_array_query($this->lnk, $sql, SQLITE_ASSOC); return $result; }
if ($dbhandle) { // SQLite 3.3 supports CREATE TABLE IF NOT EXISTS $result = sqlite_array_query($dbhandle, "SELECT COUNT(*) FROM requests"); if ($result === false) { try { $query = sqlite_exec($dbhandle, 'CREATE TABLE requests (token TEXT, ip TEXT, ts TEXT, uri TEXT, referer TEXT, ua TEXT);'); } catch (Exception $e) { } } } if (isset($_GET['results'])) { $token = $_GET['results']; $ua = $_SERVER['HTTP_USER_AGENT']; echo "<html><head><title>{$token}</title></head><body>\n"; // $result = sqlite_array_query($dbhandle, "SELECT uri FROM requests"); $result = sqlite_array_query($dbhandle, "SELECT uri FROM requests WHERE token = \"{$token}\" AND ua = \"{$ua}\""); if ($result !== false) { $nofRows = count($result); echo "<span>{$nofRows}</span>\n"; foreach ($result as $entry) { echo "<span>" . $entry['uri'] . "</span>\n"; } } echo "</body></html>\n"; } else { if (!isset($_GET['data'])) { header("HTTP/1.0 400 Bad Request"); } else { $data = json_decode($_GET['data']); $token = isset($data->token) ? $data->token : ''; $ip = $_SERVER['REMOTE_ADDR'];
<?php $b = sqlite_array_query($db, "SELECT * FROM bar WHERE id=(SELECT id FROM foo WHERE name='ilia')");
<?php $con = sqlite_open("pos.db", 0666, $e); if ($e) { die("db error"); } $sql = "select * from pos"; $data = sqlite_array_query($con, $sql, SQLITE_ASSOC); sqlite_close($con); $json = json_encode($data); header("Content-Type: application/json"); echo $json;
<?php require "../config/main.php"; $rows = sqlite_array_query($dbmain, "SELECT * FROM tbempresas", SQLITE_ASSOC); foreach ($rows as $row) { mssql_select_db($row[database]); if ($sql = mssql_query("select count(*) from tbusuarios where login='******'")) { $count = mssql_result($sql, 0, 0); if ($count > 0) { $logbase[$row[codigo]][id] = $row[codigo]; $logbase[$row[codigo]][nombre] = $row[nombre]; } } } ///*$sql=mssql_query("SELECT * FROM master.dbo.sysdatabases"); echo json_encode($logbase); mssql_close(); end;
<?php chdir(dirname(__FILE__)); // pres2 hack $ip_int = sprintf("%u", ip2long("24.100.195.79")); $db = sqlite_open("./ip.db"); // attach to another database sqlite_query("ATTACH DATABASE './flag.db' AS 'flags'", $db); $data = sqlite_array_query($db, "\nSELECT country_name, flag_file\nFROM ip_ranges ir \nINNER JOIN country_data cd ON ir.country_code=cd.id\nINNER JOIN flags.flag_db f ON f.country_id=cd.id\nWHERE {$ip_int} BETWEEN ip_start AND ip_end", SQLITE_ASSOC); // detach from attached database sqlite_query("DETACH DATABASE flags", $db); echo "User is located in {$data[0]['country_name']}"; // pres2 hackery $path = dirname($_SERVER['PHP_SELF']) . "/../../presentations/slides/sqlite_adm/"; echo " <img src='{$path}{$data[0]['flag_file']}' />";
public function findPlayListItem($type = CONTENT_SHOW, $timeslot = "other", $show = "", $bumperType = "", $rotationType = "", $maxTimeToFill = 0) { // 1: search for content // 2: select the content that is least played, and first in queue // 3: create a playlistitem // 4: update the database that this file is queued // its a show we are after, so lets search one we haven't played yet, and matches the thing we want to see. if (!empty($show)) { // only play the least broadcasted shows. The counter should increment once per season. So when you played everything from one season, it starts over. // sqlite doesnt do min and max /// episode 1 played 5 times /// episode 2 played 5 times /// episode 3 played 4 times /// episode 4 played 4 times // will get episode 3. In case all have been played the same number, it gets episode 1. // SQLITE doesnt do MIN or MAX in decent queries, so we have to walk through the resultset to determine the minimum play count value $foundContent = array(); $sql = "select * from content \n where showName = '" . $show->get_name() . "' \n and timeslot = '" . $show->get_timeslot() . "' \n and category= '" . CONTENT_SHOW . "' \n order by filename ASC, statistics_playcount ASC;"; $foundContent = sqlite_array_query($this->db, $sql); // in case the show is not in the crrect timeslot, we have to check the "other" directory... /** showName = '".$show->get_name()."' and timeslot = 'other' and */ if (empty($foundShows)) { $sql = "select * from content \n where showName = '" . $show->get_name() . "' \n and timeslot = 'other' \n and category = '" . CONTENT_SHOW . "' \n order by filename ASC, statistics_playcount ASC;"; $foundContent = sqlite_array_query($this->db, $sql); //print $sql; //print_r($foundContent); } } // other content might have a time constraint... if ($maxTimeToFill > 0) { $timeConstraint = " and metadata_duration_in_seconds <= " . $maxTimeToFill . " "; } else { // no time limitations... $timeConstraint = ""; } // if its not a show then we might choose from two nearly the same random pools: funny movies and commercials. Both implementations // look a lot like previous code... so an abstraction will be possible. (this has no showname) if ($type == CONTENT_COMMERCIAL or $type == CONTENT_FUNNY) { // verwacht hier een paar 100 commercials, jammer dat MIN niet werkt... // ordering filenames hoeft niet, het mag random (maar dat ondersteunt sqllite ook niet.) $foundContent = array(); $sql = "select * from content \n where timeslot = '" . $timeslot . "' \n and category= '" . $type . "' \n " . $timeConstraint . "\n order by RANDOM(), statistics_playcount ASC;"; $foundContent = sqlite_array_query($this->db, $sql); if (empty($foundContent)) { $sql = "select * from content \n where timeslot = 'other' \n and category= '" . $type . "' \n " . $timeConstraint . "\n order by RANDOM(), statistics_playcount ASC;"; $foundContent = sqlite_array_query($this->db, $sql); } } // Bumper types: // Commercial_Start // Commercial_End // StationPromo if ($type == CONTENT_BUMPER) { $foundContent = array(); $sql = "select * from content \n where timeslot = '" . $timeslot . "' \n and category= '" . $type . "' "; if ($bumperType == BUMPER_COMMERCIAL_END || $bumperType == BUMPER_COMMERCIAL_START) { $sql .= "and showName like '%" . $bumperType . "%'"; } else { $sql .= "and showName not like '%" . $bumperType . "%'"; } $sql .= "" . $timeConstraint . "\n order by RANDOM(), statistics_playcount ASC;"; $foundContent = sqlite_array_query($this->db, $sql); if (empty($foundContent)) { $sql = "select * from content \n where timeslot = 'other' \n and category= '" . $type . "' "; if ($bumperType == BUMPER_COMMERCIAL_END || $bumperType == BUMPER_COMMERCIAL_START) { $sql .= "and showName like '%" . $bumperType . "%'"; } else { $sql .= "and showName not like '%" . $bumperType . "%'"; } $sql .= "" . $timeConstraint . "\n order by RANDOM(), statistics_playcount ASC;"; $foundContent = sqlite_array_query($this->db, $sql); } } // announcements worden on the fly gemaakt, met een custom tijdspanne afhankelijk van de lengte van de bumpers enzo. Dat is de dynamische tijdvuller. // noooooo!!! its impossible... just download some stuff from youtube and get your stuff in order // no show to our liking? then just fill the time being with commercials and funny movies... // this might call for a better database updating algorithm. (or we can write a file with playcount per show, but thats anoying) $showName = ""; if (!empty($show)) { $showName = $show->get_name(); } if (empty($foundContent)) { print "Warning: Could not find a contentitem with these parameters: " . "ContentType: " . $type . " - Timeslot: " . $timeslot . " - Show: " . $showName . " - Bumpertyupe:" . $bumperType . " - Rotation:" . $rotationType . " - Length: " . $maxTimeToFill . " \n"; //debug_print_backtrace(); // an empty playlistitem can be used to break out the while loop looking for content. $emptyPlayListItem = new playListItem(); $emptyPlayListItem->fileLocation = ""; $emptyPlayListItem->debugInfo = "Could not find a contentitem with these parameters: " . "ContentType: " . $type . " - Timeslot: " . $timeslot . " - Show: " . $showName . " - Bumpertyupe:" . $bumperType . " - Rotation:" . $rotationType . " - Length: " . $maxTimeToFill . ""; return $emptyPlayListItem; } // this is like an infinite loop now... //print "we found content!"; // var_dump($foundContent); // niet alles tonen, tis nogal veel... //print_r($foundContent); // now we have to traverse the shows to see what is the lowest playcount $lowestPlayCount = 90000; foreach ($foundContent as $content) { if ($content['statistics_playcount'] < $lowestPlayCount) { $lowestPlayCount = $content['statistics_playcount']; } } // now we get the first show with this awesome low playcount foreach ($foundContent as $content) { if ($content['statistics_playcount'] == $lowestPlayCount) { $playListItem = new playListItem(); $playListItem->fileLocation = $content['filename']; $playListItem->duration = $content['metadata_duration_in_seconds']; $playListItem->debugInfo = "Found: " . $content['filename'] . " ContentType: " . $type . " - Timeslot: " . $timeslot . " - Show: " . $showName . " - Bumpertyupe:" . $bumperType . " - Rotation:" . $rotationType . " - Length: " . $maxTimeToFill . ""; } } // TODO: filelocation is nog leeg hier... // debug... //print "Found content item. Duration: ".$playListItem->duration." filelocation:".$playListItem->fileLocation." \n"; if ($playListItem->duration == 0) { /*print "warning: you are trying to retrieve content that doesn't fill the timeslot \n". "ContentType: ".$type." - Timeslot: ".$timeslot. " - Show: ".$showName." - Bumpertyupe:".$bumperType. " - Rotation:".$rotationType." - Length: ".$maxTimeToFill." \n";*/ } //var_dump($playListItem); // update the database $sql = "UPDATE content SET statistics_playcount = " . ($lowestPlayCount + 1) . " WHERE id = " . $content['id'] . ";"; sqlite_query($this->db, $sql); // done! return $playListItem; }
<?php sqlite_array_query("handle", "SELECT * FROM table WHERE field='{$_GET['query']}'");
<?php $db = sqlite_open(dirname(__FILE__) . "/db.sqlite"); echo '<pre>'; /* array sqlite_array_query(string query, resource db [ , int result_type [, bool decode_binary]]) */ var_dump(sqlite_array_query("SELECT * FROM auth_tbl", $db, SQLITE_ASSOC)); echo '</pre>'; sqlite_close($db);
function ping() { global $dbmain; /* $sql=mssql_query("select codigo_cit, (select nombre_pac from tbpacientes where codigo_pac=paciente_cit) as nombre, (select rtrim(ltrim(codareatel1_pac))+rtrim(ltrim(telefono1_pac)) from tbpacientes where codareatel1_pac like '04%' and codigo_pac=paciente_cit) as telefono, (select nombre_prv from tbproveedores where codigo_prv=proveedor_cit) as medico, dbo.GetDayName(fecha_cit) dial, day(fecha_cit) dian, datename(month,fecha_cit) mes, year(fecha_cit) anno from tbcitas where isnull(sms_cit,0)=0 and isnull((select codareatel1_pac+telefono1_pac from tbpacientes where codareatel1_pac like '04%' and codigo_pac=paciente_cit),'') <> ''"); if(mssql_num_rows($sql)>0){ $i=0; $datasms["key"]='4eac12fbfe5c923d67f1fd904ac04d19'; $datasms["cli"]="J313611069"; $rifcli=$datasms["cli"]; while($row=mssql_fetch_array($sql)){ $datasms["sms"][$i]["t"]=preg_replace("/[^0-9]/","",$row["telefono"]); $datasms["sms"][$i]["m"]=utf8_decode(utf8_encode("Sr(a) ".stripAccents(utf8_encode($row[nombre])).", registramos su cita para el ".stripAccents(utf8_encode($row[dial]))." ".$row[dian]." de ".$row[mes]." con el Dr(a). ".stripAccents(utf8_encode($row[medico])).", su codigo de confirmacion es: ".$row[codigo_cit])); $datasms["sms"][$i]["s"]="true"; mssql_query("update tbcitas set sms_cit = getdate() where codigo_cit='".$row["codigo_cit"]."'"); $i++; } if(count($datasms)>0){ $json=urlencode(base64_encode(json_encode($datasms))); $ch = curl_init(); curl_setopt($ch,CURLOPT_URL, 'http://rtx.w3sistemas.com/sms/send/massive.php?key=4eac12fbfe5c923d67f1fd904ac04d19&cli='.$rifcli); curl_setopt($ch,CURLOPT_POST, 1); curl_setopt($ch,CURLOPT_USERPWD,"w3sms:sistemaoctartx"); curl_setopt($ch,CURLOPT_POSTFIELDS, 'data='.$json); curl_setopt($ch,CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch,CURLOPT_TIMEOUT,10000); $result = curl_exec($ch); curl_close($ch); } } $sql=mssql_query("select codigo_cit, (select codigo_cit from tbcitas2 where notificado_cit=0 and convert(nvarchar,tbcitas.fecha_cit,103)=convert(nvarchar,tbcitas2.fecha_cit,103) and tbcitas2.proveedor_cit=tbcitas.proveedor_cit ) as anulacion, (select nombre_pac from tbpacientes where codigo_pac=paciente_cit) as nombre, (select rtrim(ltrim(codareatel1_pac))+rtrim(ltrim(telefono1_pac)) from tbpacientes where codareatel1_pac like '04%' and codigo_pac=paciente_cit) as telefono, (select nombre_prv from tbproveedores where codigo_prv=proveedor_cit) as medico, datename(weekday,fecha_cit) dial, day(fecha_cit) dian, datename(month,fecha_cit) mes, year(fecha_cit) anno from tbcitas where isnull((select codareatel1_pac+telefono1_pac from tbpacientes where codareatel1_pac like '04%' and codigo_pac=paciente_cit),'') <> '' and exists (select proveedor_cit from tbcitas2 where notificado_cit=0 and convert(nvarchar,tbcitas.fecha_cit,103)=convert(nvarchar,tbcitas2.fecha_cit,103) and tbcitas2.proveedor_cit=tbcitas.proveedor_cit and (tbcitas2.baremo_cit=tbcitas.baremo_cit or isnull(tbcitas2.baremo_cit,'')='')) "); if(mssql_num_rows($sql)>0){ $i=0; $datasms["key"]='4eac12fbfe5c923d67f1fd904ac04d19'; $datasms["cli"]="J313611069"; $rifcli=$datasms["cli"]; while($row=mssql_fetch_array($sql)){ $datasms["sms"][$i]["t"]=$row["telefono"]; $datasms["sms"][$i]["m"]=utf8_decode(utf8_encode("Presalud Info.:Sr(a) ".stripAccents(utf8_encode($row[nombre])).", El Dr(a). ".stripAccents(utf8_encode($row[medico]))." no asistira el ".stripAccents(utf8_encode($row[dial]))." ".$row[dian]." de ".$row[mes].", debera registrar otra cita, disculpe las molestias ocasionadas.")); $datasms["sms"][$i]["s"]="true"; //mssql_query("update tbcitas set sms_cit = getdate() where codigo_cit='".$row["codigo_cit"]."'"); mssql_query("update tbcitas2 set notificado_cit=1 where codigo_cit='".$row["anulacion"]."'"); $i++; } if(count($datasms)>0){ $json=urlencode(base64_encode(json_encode($datasms))); $ch = curl_init(); curl_setopt($ch,CURLOPT_URL, 'http://rtx.w3sistemas.com/sms/send/massive.php?key=4eac12fbfe5c923d67f1fd904ac04d19&cli='.$rifcli); curl_setopt($ch,CURLOPT_POST, 1); curl_setopt($ch,CURLOPT_USERPWD,"w3sms:sistemaoctartx"); curl_setopt($ch,CURLOPT_POSTFIELDS, 'data='.$json); curl_setopt($ch,CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch,CURLOPT_TIMEOUT,10000); $result = curl_exec($ch); curl_close($ch); } } */ $rowssqle = sqlite_array_query($dbmain, "SELECT count(*) as count FROM tbsession where user='******' and id='" . session_id() . "' limit 1", SQLITE_ASSOC); if ($rowssqle[0]['count'] == 0) { return "logout"; } else { sqlite_exec($dbmain, "update tbsession set time='" . time() . "' where id='" . session_id() . "'"); return "ok"; } }
/** * Web based SQLite management * Wrapper for Default SQLite 2.x Module * @package SQLiteManager * @author Tanguy Pruvot * @version $Id: sqlite2.inc.php,v 1.2 2004/12/04 18:14:49 tpruvot Exp $ $Revision: 1.2 $ */ function sqlitem_array_query($dhb, $query, $result_type = SQLITE_BOTH, $decode_binary = TRUE) { return sqlite_array_query($dhb, $query, $result_type, $decode_binary); }
} write_log(LOGFILE_CRONT_BATCH_PROCESS, basename(__FILE__) . ' line:' . __LINE__ . "[Path to the cache is not defined]"); exit; } if (!file_exists($A2B->config["global"]['cache_path'])) { if ($verbose_level >= 1) { echo "[File doesn't exist or permission denied]\n"; } write_log(LOGFILE_CRONT_BATCH_PROCESS, basename(__FILE__) . ' line:' . __LINE__ . "[File doesn't exist or permission denied]"); exit; } // Open Sqlite if ($db = sqlite_open($A2B->config["global"]['cache_path'], 0666, $sqliteerror)) { for (;;) { // Select CDR $result = sqlite_array_query($db, "SELECT rowid , * from cc_call limit {$nb_record}", SQLITE_ASSOC); if (sizeof($result) > 0) { $column = ""; $values = ""; $delete_id = "( "; for ($i = 0; $i < sizeof($result); $i++) { $j = 0; if ($i == 0) { $values .= "( "; } else { $values .= ",( "; } $delete_id .= $result[$i]['rowid']; if (sizeof($result) > 0 && $i < sizeof($result) - 1) { $delete_id .= " , "; }
public function getUserRoles($userName) { $arr = sqlite_array_query($this->link, "SELECT Role FROM Security where UserName = '******'", SQLITE_NUM); return $arr[0]; }
echo "in callback, original string is {$string}\n"; return strrev(md5($string)); } $sql = 'SELECT md5rev(my_string) FROM mytable'; $rows = sqlite_array_query($db, $sql); var_dump($rows); /// aggregate $data = array('one', 'two', 'three', 'four', 'five', 'six', 'seven', 'eight', 'nine', 'ten'); sqlite_query($db, "CREATE TABLE strings(a)"); foreach ($data as $str) { $str = sqlite_escape_string($str); sqlite_query($db, "INSERT INTO strings VALUES ('{$str}')"); } function max_len_step(&$context, $string) { echo "in max_len_step: {$string}\n"; if (strlen($string) > $context) { $context = strlen($string); } } function max_len_finalize(&$context) { echo "in finalize, context is: {$context}\n"; var_dump($context); return $context; } var_dump(sqlite_array_query($db, 'SELECT max_len(a) from strings')); $r = sqlite_close($db); ?>
function getbyid($table, $id) { // RETURNS array of 'data1' from a specific record identified by idx number $str = "SELECT idx, data1 FROM {$table} where idx = {$id}"; $arr = sqlite_array_query($this->handle, $str, SQLITE_ASSOC); //one record only $idq['idx'] = $arr[0]['idx']; $arrrec = unserialize($arr[0]['data1']); if ($idq) { $reconly = array_merge($idq, $arrrec); } else { $reconly = null; } return $reconly; }
/** * 按SQL语句获取记录结果,返回数组 * @param sql 执行的SQL语句 */ public function getArray($sql) { $this->arrSql[] = $sql; return sqlite_array_query($this->conn, $sql, SQLITE_ASSOC); }