PHP Classes

PHP SQLite Export: Query SQLite3 and output results in a HTML or XML

Recommend this page to a friend!
     
  Info   Documentation   Screenshots   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 70%Total: 290 All time: 7,505 This week: 47Up
Version License PHP version Categories
sqlite3xml 1.0.0BSD License5HTML, XML, PHP 5, Databases, AJAX
Description 

Author

Nikola Crnogorac

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.

The class outputs the HTML with JavaScript code that can perform AJAX requests to retrieve the results table dynamically.

Innovation Award
PHP Programming Innovation award winner
May 2018
Winner

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.

Manuel Lemos
Picture of Nikola Crnogorac
  Performance   Level  
Name: Nikola Crnogorac <contact>
Classes: 1 package by
Country: United States United States
Age: 24
All time rank: 3859503 in United States United States
Week rank: 195 Up19 in United States United States Up

Level 1 Star

 Innovation award
Innovation award
Nominee: 1x

Winner: 1x

Documentation

#SQLite3 XML#

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.


Screenshots (2)  
  • ExampleTable
  • ExampleXML
  Files folder image Files (4)  
File Role Description
Plain text file SQLite3XML.php Class Main project class
Accessible without login Plain text file Readme.md Doc. ReadmeFile

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadsqlite3xml-2018-02-28.zip 200KB
Downloadsqlite3xml-2018-02-28.tar.gz 201KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:290
This week:0
All time:7,505
This week:47Up
User Ratings User Comments (2)
 All time
Utility:100%StarStarStarStarStarStar
Consistency:100%StarStarStarStarStarStar
Documentation:100%StarStarStarStarStarStar
Examples:-
Tests:-
Videos:-
Overall:70%StarStarStarStar
Rank:291
 
Thats a very good class ;-)
6 years ago (José Filipe Lopes Santos)		70%StarStarStarStar
Thats a very good class ;-)
6 years ago (José Filipe Lopes Santos)		70%StarStarStarStar
 

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.