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

  Author Author  
Picture of Sylvain Rabot
Name: Sylvain Rabot <contact>
Classes: 6 packages by
Country: France France
Age: 27
All time rank: 28318 in France France
Week rank: 159 Up9 in France France Up
Innovation award
Innovation award
Nominee: 3x


  Detailed description   Download Download .zip .tar.gz  
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.

  Classes of Sylvain Rabot  >  sql4array  >  Download Download .zip .tar.gz  >  Support forum Support forum  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: sql4array
Base name: sql4array
Description: Query PHP arrays using an SQL dialect
Version: 0.0.3
PHP version: 5.0.0
License: GNU Lesser General Public License (LGPL)
All time users: 821 users
All time rank: 3847
Week users: 0 users
Week rank: 1531 Equal
 
  Groups   Rate classes User ratings   Applications   Related pages   Files Files  

  Groups  
Group folder image PHP 5 Classes using PHP 5 specific features View top rated classes
Group folder image Databases Database management, accessing and searching View top rated classes
Group folder image Data types Modeling and manipulating data types View top rated classes


  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

  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Good (83%) Good (83%) - Good (83%) - - Not sure (58%) 1010
Month: Not yet rated by the users

  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  
sql4array
homepage

  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

Download Download all files: sql4array.tar.gz sql4array.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.