Login   Register  
PHP Classes
elePHPant
Icontem

sql4array: Query PHP arrays using an SQL dialect

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2007-05-04 (7 years ago) RSS 2.0 feedStarStarStar 58%Total: 827 All time: 3,856 This week: 1,550Up
Version License PHP version Categories  
sql4array 0.0.3GNU Lesser General Publ...5.0.0PHP 5, Databases, Data types
Description Author  

This class can be used to query PHP arrays using an SQL dialect.

It can execute SQL SELECT queries on bi-dimensional array on which the first dimension is the row number and the second dimension the field names.

The class supports the WHERE clause to specify conditions using operators like =, >, <, LIKE, IN, etc..

The results are returned as arrays and can be sorted with the ORDER clause and restricted with the clause LIMIT.

Innovation Award  
PHP Programming Innovation award nominee
May 2007
Number 3
Arrays are often used in PHP applications to store complex information structures.

Retrieving information from complex arrays may require a lot of hand-written code.

This class provides a surprisingly simple solution that consists of using a SQL-like language to query and retrieve information from arrays as if those are relational databases.

Manuel Lemos
Picture of Sylvain Rabot
Name: Sylvain Rabot <contact>
Classes: 6 packages by
Country: France France
Age: 27
All time rank: 28018 in France France
Week rank: 163 Up11 in France France Up
Innovation award
Innovation award
Nominee: 3x

  Files folder image Files  
File Role Description
Plain text file sql4array.class.php Class Main class
Accessible without login Plain text file sql4array.example.php Example Example

 Version Control Unique User Downloads Download Rankings  
 0%Total:827All time:3,856
 This week:0This week:1,550Up
 User Ratings  
 
 All time
Utility:83%StarStarStarStarStar
Consistency:83%StarStarStarStarStar
Documentation:-
Examples:83%StarStarStarStarStar
Tests:-
Videos:-
Overall:58%StarStarStar
Rank:1014