PHP Classes

TextSQL: Execute SQL queries to manipulate file databases

Recommend this page to a friend!
  Info   Screenshots Screenshots   View files View files (5)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 462 All time: 6,055 This week: 263Up
Version License PHP version Categories
textsql 1.0GNU General Publi...4.3.0Databases, Files and Folders


This class can be used to execute SQL queries to manipulate data stored in flat file databases.

It can parse some types of SQL queries and translate the queries into actions to store and retrieve data from text files.

Currently it supports SQL queries of the types: CREATE TABLE, INSERT and SELECT.

Picture of Sergey Ivanov
Name: Sergey Ivanov <contact>
Classes: 3 packages by
Country: Russian Federation Russian Federation
Age: 36
All time rank: 154646 in Russian Federation Russian Federation
Week rank: 373 Up15 in Russian Federation Russian Federation Up

  • test_table_data.png
  • test_table_str.png
  Files folder image Files  
File Role Description
Files folder imagedb (1 directory)
Plain text file db.class.php Class TextSQL class
Plain text file index.php Example Full Example using TextSQL Class
Plain text file simple.php Example Simple Example using TextSQL class
Image file index_php.png Screen index.php's screenshot

  Files folder image Files  /  db  
File Role Description
Files folder imagetest (1 file)

  Files folder image Files  /  db  /  test  
File Role Description
  Plain text file test.txt Data this file is used here to create /db/ and /db/test/ folders

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:6,055
This week:263Up
User Comments (1)
Missing FROM clause limits it's usability.
14 years ago (Eric Guerin)