Code/Resource
Windows Develop
Linux-Unix program
Internet-Socket-Network
Web Server
Browser Client
Ftp Server
Ftp Client
Browser Plugins
Proxy Server
Email Server
Email Client
WEB Mail
Firewall-Security
Telnet Server
Telnet Client
ICQ-IM-Chat
Search Engine
Sniffer Package capture
Remote Control
xml-soap-webservice
P2P
WEB(ASP,PHP,...)
TCP/IP Stack
SNMP
Grid Computing
SilverLight
DNS
Cluster Service
Network Security
Communication-Mobile
Game Program
Editor
Multimedia program
Graph program
Compiler program
Compress-Decompress algrithms
Crypt_Decrypt algrithms
Mathimatics-Numerical algorithms
MultiLanguage
Disk/Storage
Java Develop
assembly language
Applications
Other systems
Database system
Embeded-SCM Develop
FlashMX/Flex
source in ebook
Delphi VCL
OS Develop
MiddleWare
MPI
MacOS develop
LabView
ELanguage
Software/Tools
E-Books
Artical/Document
Tags.php
Package: ext-3.1.0.zip [view]
Upload User: dawnssy
Upload Date: 2022-08-06
Package Size: 9345k
Code Size: 1k
Category:
JavaScript
Development Platform:
JavaScript
- <?php
- class Tags {
- function load($data){
- $db = new SQLiteDatabase('sql/imgorg.db');
- // use $query for type-ahead
- $query = $data->query;
- $qryStr = 'SELECT * FROM Tags';
- if ($query) {
- $qryStr .= ' where text like "'.$query.'%"';
- }
- $q = $db->query($qryStr);
- return $q->fetchAll();
- }
- 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();
- }
- }