Rasher PHP Data Access Layer Helper - Database Repository: Run queries to access data in any type of database
| Recommend this page to a friend! |
 Author |
 |
|
||||||||||
This package provides several classes that can connect to many kinds of databases and executes SQL queries to perform any type of data access (MySQLi, PDO) to database tables.
Currently, it can:
- Connect to a database server via MySQLi or PDO extensions
- Execute prepared queries and get the results as an array or by result column name
- Access a database like a repository with functions to access repository records by performing operations to create, read, update, and delete repository items
- Manipulate database record column values according to the respective data type
- DT_ITEM, DT_LIST complex attribute types and searching abilities
- Transaction handling
- Caching the database query results
- Comparison operators to define filtering conditions
Currently, it can:
- Connect to a database server via MySQLi or PDO extensions
- Execute prepared queries and get the results as an array or by result column name
- Access a database like a repository with functions to access repository records by performing operations to create, read, update, and delete repository items
- Manipulate database record column values according to the respective data type
- DT_ITEM, DT_LIST complex attribute types and searching abilities
- Transaction handling
- Caching the database query results
- Comparison operators to define filtering conditions
Details
|
| Classes of Hernádi Tamás | > | Rasher PHP Data Access Layer Helper - Database Repository | > |  Download .zip .tar.gz |
> |  Support forum (3) |
> |  Blog |
> |   Latest changes |
|
|||||||||||||||
| Groups |  Screenshots |
Applications |  Files |
| Groups |
 PHP 5 |
Classes using PHP 5 specific features | View top rated classes |
| Databases |
Database management, accessing and searching | View top rated classes |
| Data types |
Modeling and manipulating data types | View top rated classes |
| Design Patterns |
Implementations of well known design patterns | View top rated classes |
| Screenshots |
/opt2/mlemos/httpd/htdocs/application/repository_browse.php 2937  |
|
| Applications that use this package |
No pages of applications that use this class were specified.
If you know an application of this package, send a message to the author to add a link here.
| Files |
/ | src |
| File | Role | Description |
|---|---|---|
| common_static_helper.php |
Class | Class source |
| data_access_layer_helper_base.php |
Class | Class source |
| data_access_layer_helper_mysqli.php |
Class | Class source |
| data_access_layer_helper_pdo.php |
Class | Class source |
| data_type_helper.php |
Class | Class source |
| db_repository_base.php |
Class | Class source |
| db_repository_base_mysqli.php |
Class | Class source |
| db_repository_base_pdo.php |
Class | Class source |
| Files |
/ | test |
| File | Role | Description | ||
|---|---|---|---|---|
| script_mssql (2 files) |
||||
| script_mysql (5 files) |
||||
 login_test.php |
Example | Class source | ||
| stored_procedure_test.php |
Example | Example script | ||
| stored_procedure_test_simple_pdo.php |
Example | Example script | ||
| userrolesetting_data_repository.php |
Class | Class source | ||
| userrole_data_repository.php |
Class | moving files | ||
| user_data_repository.php |
Class | moving files | ||
| Files |
/ | test | / | script_mssql |
| File | Role | Description |
|---|---|---|
| getUser.storedProcedure.sql |
Data | Auxiliary data |
| test.sql |
Data | Auxiliary data |
| Files |
/ | test | / | script_mysql |
| File | Role | Description |
|---|---|---|
| test_user.sql |
Data | Auxiliary data |
| test_userrole.sql |
Data | Auxiliary data |
| test_userrolesetting.sql |
Data | Auxiliary data |
| test_userrole_user...tingscollection.sql |
Data | Auxiliary data |
| test_user_userrolescollection.sql |
Data | Auxiliary data |
 Install with Composer - Download all files: data_access_helper.tar.gz data_access_helper.zipNOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.
|
| Files |
/ | src |
| File | Role | Description |
|---|---|---|
| common_static_helper.php |
Class | Class source |
| data_access_layer_helper_base.php |
Class | Class source |
| data_access_layer_helper_mysqli.php |
Class | Class source |
| data_access_layer_helper_pdo.php |
Class | Class source |
| data_type_helper.php |
Class | Class source |
| db_repository_base.php |
Class | Class source |
| db_repository_base_mysqli.php |
Class | Class source |
| db_repository_base_pdo.php |
Class | Class source |
| Files |
/ | test |
| File | Role | Description | ||
|---|---|---|---|---|
| script_mssql (2 files) |
||||
| script_mysql (5 files) |
||||
| login_test.php |
Example | Class source | ||
| stored_procedure_test.php |
Example | Example script | ||
| stored_procedure_test_simple_pdo.php |
Example | Example script | ||
| userrolesetting_data_repository.php |
Class | Class source | ||
| userrole_data_repository.php |
Class | moving files | ||
| user_data_repository.php |
Class | moving files | ||
| Files |
/ | test | / | script_mssql |
| File | Role | Description |
|---|---|---|
| getUser.storedProcedure.sql |
Data | Auxiliary data |
| test.sql |
Data | Auxiliary data |
| Files |
/ | test | / | script_mysql |
| File | Role | Description |
|---|---|---|
| test_user.sql |
Data | Auxiliary data |
| test_userrole.sql |
Data | Auxiliary data |
| test_userrolesetting.sql |
Data | Auxiliary data |
| test_userrole_user...tingscollection.sql |
Data | Auxiliary data |
| test_user_userrolescollection.sql |
Data | Auxiliary data |
| Install with Composer - Download all files: data_access_helper.tar.gz data_access_helper.zip NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.
|
