PHP Classes
Icontem

Class: DATA


  Search   All class groups All class groups   Latest entries Latest entries   Top 10 charts Top 10 charts   Newsletter Newsletter   Blog Blog   Forums Forums   Help FAQ Help FAQ  
  Login   Register  
Recommend this page to a friend! ReTweet ReTweet Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Martin Alterisio  >  DATA  >  Download  >  Support forum Support forum (5)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: DATA Support forum
Base name: data
Description: Access data stored in MySQL tables like arrays
Related top rated classes: , , ,
Version: 0.8.0
Required PHP version: 5.1
License: GNU Lesser General Public License (LGPL)
All time users: 1143 users
All time rank: 2238
Week users: 5 users
Week rank: 1647
 
  Author   Group folder image Groups   Detailed description   Freshmeat project  
  Rate classes User ratings   Applications   Files Files  

Author

Picture of Martin Alterisio
Name: Martin Alterisio <e-mail contact>
Published packages: 5 Browse this author's classes Browse this author's classes
Country: Argentina Argentina - PHP jobs in Argentina
Home page: http://mundogris.wordpress.com/
Age: 26
All time rank: 715
Week rank: 341

Innovation Award

PHP Programming Innovation award nominee
April 2007
Number 8
 One of the new features introduced with PHP 5 is the iterator interfaces provided by the SPL (Standard PHP Library) extension.

SPL allows applications to traverse objects using regular functions used to traverse array members.

This class provide new SPL iterators that allow applications to easily traverse data from MySQL databases using the same array traversal functions.

Manuel Lemos

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

Detailed description

DATA stands for Database Access Through Arrays. This package can be used to access data stored in MySQL tables like accessing arrays. It uses SPL to implement several classes and iterators interfaces to access MySQL databases.

Examples:

$DB['test_table'][] = array(
'name' => 'first',
'value' => 'the first row'
);

foreach ($DB['test_table'] as $i => $row) {
...
}

$DB['test_table']['first']['value'] = '1st';

unset($DB['test_table']['first']);

Freshmeat project

Project record: phpdata
Popularity score: 13.27
Vitality score: 1.48

User ratings

There are not enough user ratings to display for this class.

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.

Files

File Role Description
Accessible without login Plain text file example.php Example An usage example
Accessible without login Plain text file example.sqltypes.php Example An usage example
Accessible without login Plain text file data.lib.php Appl. Main include file of the DATA library.
Accessible without login Plain text file data.mysql5.lib.php Appl. Include to use the DATA library using a MySQL5 database.
Files folder image DATA
  Accessible without login Plain text file AssociativeIndexingStrategy.php Class An interface to algorithmic solutions for mapping an associative array index to rows in a database table.
  Accessible without login Plain text file CannotRemoveField.php Class An exception thrown when an unset has been tried on a row field.
  Accessible without login Plain text file Exception.php Class All exceptions inside the DATA library extend this exception.
  Accessible without login Plain text file FieldDoesntExist.php Class An exception thrown when trying to read a field that doesn't exist on the table.
  Accessible without login Plain text file IndexingStrategyException.php Class All exceptions that occur on indexing strategies extend this exception.
  Accessible without login Plain text file InvalidDate.php Class An exception thrown when a sql date field is filled with an invalid value.
  Accessible without login Plain text file InvalidDatetime.php Class An exception thrown when a sql datetime field is filled with an invalid value.
  Accessible without login Plain text file InvalidDecimal.php Class An exception thrown when a sql decimal field is filled with an invalid value or has overflown its capacity.
  Accessible without login Plain text file InvalidInt.php Class An exception thrown when a sql int field is filled with an invalid value or has overflown its capacity.
  Accessible without login Plain text file InvalidTime.php Class An exception thrown when a sql time field is filled with an invalid value.
  Accessible without login Plain text file NotImplemented.php Class An exception thrown when a feature hasn't been implemented yet.
  Accessible without login Plain text file NotNullable.php Class An exception thrown when trying to null a not nullable sql field.
  Accessible without login Plain text file Number.php Class Interface for numerical objects.
  Accessible without login Plain text file PrimaryKeyNeeded.php Class An exception thrown when a primary key is required for the operation requested.
  Accessible without login Plain text file PrimaryKeyTooLarge.php Class An exception thrown when a primary key is too large for the operation requested.
  Accessible without login Plain text file ReadOnly.php Class An exception thrown when access to the database through an object is read only.
  Accessible without login Plain text file RowDoesntExist.php Class An exception thrown when trying to read a row that doesn't exist on the table.
  Accessible without login Plain text file SQLChar.php Class ANSI SQL Character data type representation.
  Accessible without login Plain text file SQLCharFactory.php Class A concrete factory for inboxing strings into char fields.
  Accessible without login Plain text file SQLDate.php Class ANSI SQL Date data type representation.
  Accessible without login Plain text file SQLDatetime.php Class ANSI SQL Datetime data type representation.
  Accessible without login Plain text file SQLDecimal.php Class ANSI SQL arbitrary size number with decimals data type representation.
  Accessible without login Plain text file SQLDecimalFactory.php Class A concrete factory for inboxing php values into decimal fields.
  Accessible without login Plain text file SQLInt.php Class ANSI SQL Integer data type representation.
  Accessible without login Plain text file SQLIntFactory.php Class A concrete factory for inboxing php values into int fields.
  Accessible without login Plain text file SQLSmallInt.php Class ANSI SQL small integer data type representation.
  Accessible without login Plain text file SQLSmallIntFactory.php Class A concrete factory for inboxing php values into small int fields.
  Accessible without login Plain text file SQLTime.php Class ANSI SQL Time data type representation.
  Accessible without login Plain text file SQLType.php Class SQL type representation.
  Accessible without login Plain text file SQLTypeConstraintFailed.php Class An exception thrown when an sql type constraint fails to apply to a value.
  Accessible without login Plain text file SQLTypeFactory.php Class Abstract factory for SQL types representations.
  Accessible without login Plain text file SQLVarchar.php Class ANSI SQL Character Varying data type representation.
  Accessible without login Plain text file SQLVarcharFactory.php Class A concrete factory for inboxing strings into varchar fields.
  Accessible without login Plain text file StringTooLarge.php Class An exception thrown when a sql character field cannot hold the string provided by the user.
Files folder image DATA/MySQL5
  Accessible without login Plain text file Access.php Class This class provides basic interaction with a MySQL5 database.
  Accessible without login Plain text file Database.php Class This class is the abstraction of a MySQL5 database implementing the array access behavior.
  Accessible without login Plain text file DefaultIndexingStrategy.php Class Default strategy for mapping an associative array index to rows in a database table.
  Accessible without login Plain text file Error.php Class An exception thrown when an error is detected on an operation with a MySQL5 database.
  Accessible without login Plain text file PrimaryKeyIndexingStrategy.php Class Strategy for mapping array offsets to primary key values.
  Accessible without login Plain text file Row.php Class This class is the abstraction of a MySQL5 table row implementing the array access and iteration behavior.
  Accessible without login Plain text file Schema.php Class MySQL5 schema observation functions class
  Accessible without login Plain text file SQLDateFactory.php Class A concrete factory for inboxing string with mysql date format into date objects.
  Accessible without login Plain text file SQLDatetimeFactory.php Class A concrete factory for inboxing string with mysql datetime format into datetime objects.
  Accessible without login Plain text file SQLTimeFactory.php Class A concrete factory for inboxing string with mysql time format into time objects.
  Accessible without login Plain text file Table.php Class This class is the abstraction of a MySQL5 table implementing the array access and iteration behavior.
  Accessible without login Plain text file TableIterator.php Class Table rows iterator.
Download all files: data.tar.gz data.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.

 
  Advertise on this site Advertise on this site   Site map Site map   Statistics Statistics   Site tips Site tips   Privacy policy Privacy policy   Contact Contact  

For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2009 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products