Login   Register  
PHP Classes
elePHPant
Icontem

Class: sql4array

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Sylvain Rabot  >  sql4array  >  Download .tar.gz .zip  >  Support forum Support forum  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: sql4array
Support forum Support forum
Base name: sql4array
Description: Query PHP arrays using an SQL dialect
Related classes: ,
Version: 0.0.3
PHP version: 5.0.0
License: GNU Lesser General Public License (LGPL)
All time users: 769 users
All time rank: 3547
Week users: 0 users
Week rank: 2590
Picture of Sylvain Rabot
Author: Sylvain Rabot <e-mail contact>
Packages: 6 Browse this author's classes Browse this author's classes
Country: France France - PHP jobs in France
Age: 24
All time rank: 29618 in France France
Week rank: 336 Down18 in France France Equal
Innovation award
Innovation award
Nominee: 3x


  Detailed description  
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.

 

  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

  Rate classes User ratings   Applications   Related links   Files Files  

  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  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Good (83.3%)
Good (83.3%)
-
Good (83.3%)
-
-
Not sure (58.3%)
931
Month:
Not yet rated by the users

  Applications that use this class  
No application links were specified for this class.
Add link image If you know an application of this package, send a message to the author to add a link here.

  Related links  
Link Description
sql4array homepage

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

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.