PHP Classes

sql4array: Query PHP arrays using an SQL dialect

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 56%Total: 860 All time: 4,073 This week: 455Up
Version License PHP version Categories
sql4array 0.0.3GNU Lesser Genera...5.0.0PHP 5, Databases, Data types
Description 

Author

Sylvain Rabot

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: United States United States
Innovation award
Innovation award
Nominee: 3x

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

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
Downloadsql4array-2007-05-04.zip 3KB
Downloadsql4array-2007-05-04.tar.gz
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:860
This week:0
All time:4,073
This week:455Up
 User Ratings  
 
 All time
Utility:80%StarStarStarStarStar
Consistency:80%StarStarStarStarStar
Documentation:-
Examples:80%StarStarStarStarStar
Tests:-
Videos:-
Overall:56%StarStarStar
Rank:1898
  

  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.


  Related pages  
homepage