Login   Register  
PHP Classes
elePHPant
Icontem

sql4array

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

  Author  
Picture of Sylvain Rabot
Name: Sylvain Rabot <e-mail contact>
Packages: 6 Browse all classes by Sylvain Rabot Browse all classes by
Country: France France - PHP jobs in France
Age: 26
All time rank: 29319 in France France
Week rank: 399 Down20 in France France Down
Innovation award
Innovation award
Nominee: 3x


  Detailed description   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 .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: 801 users
All time rank: 3747
Week users: 1 user
Week rank: 2150 Up
 
  Groups   Rate classes User ratings   Applications   Related links   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  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Good (83.3%)
Good (83.3%)
-
Good (83.3%)
-
-
Not sure (58.3%)
965
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
Accessible without login 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.