|Last Updated|| ||Ratings|| ||Unique User Downloads|| ||Download Rankings|
|2018-02-28 (2 years ago) || 70%||Total: 249 ||All time: 7,771 This week: 345|
This class can query SQLite3 and output results in a HTML or XML.
It can take a handle of the result set of a SQL query executed on a SQLite 3 database and output the result values as HTML to be displayed on a page or a XML data string.
Prize: One official elePHPant Plush Mascott
|SQLite is a popular database system that can be used to create databases stored in local files, so they do not require to install and use a server to query the information in the database tables.
This package provides a Web based solution to perform queries on a SQLite database to inspect the contents of the tables of database with a fast user interface using AJAX to avoid reloading the Web pages.
SQLite3 has some not easy ways to obtain column names. In case of a table
there are several methods available for that purpose: Select from
sqlite_master, or PRAGMA table_info(table_name)...
But in case of a query this is of no use.
This simple class allows a program to get those names and compose a valid
XML using them as XML tags.
Also, on the client side, it generates a dynamic table from those data.
||Applications that use this package
No pages of applications that use this class were specified.
If you know an application of this package, send a message to the author to add a link here.