PHP Classes

PHP Query Builder Library for Related Tables: Build queries to get data from related tables

Recommend this page to a friend!
  Info   View files View files (20)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog (1)    
Last Updated Ratings Unique User Downloads Download Rankings
2023-11-30 (5 months ago) RSS 2.0 feedNot yet rated by the usersTotal: 84 All time: 10,033 This week: 455Up
Version License PHP version Categories
query-relation-manag 1.0MIT/X Consortium ...5Databases, Design Patterns, PHP 7
Description 

Author

This package can build queries to get data from related tables.

It provides classes with a fluent interface that has functions for adding related tables that will be joined and filter conditions to define the table records that will be returned when the resulting database query is executed.

The package also provides a function to execute the composed database query and return the query results.

Picture of Smoren  Freelight
  Performance   Level  
Name: Smoren Freelight <contact>
Classes: 38 packages by
Country: Russian Federation Russian Federation
Age: 34
All time rank: 284078 in Russian Federation Russian Federation
Week rank: 44 Up4 in Russian Federation Russian Federation Up
Innovation award
Innovation award
Nominee: 16x

Details

query-relation-manager

Packagist PHP Version Support Scrutinizer Code Quality Coverage Status Build and test License: MIT

Implements the functionality of getting tree data from a database with one-to-one and one-to-many relationships using only one select-query to the database with flexible conditions configuration.

QueryRelationManager can be integrated with any ORM system based on PHP and potentially compatible with any relational DBMS.

Current package includes an example of integration with raw PDO without ORM.

Also there is an implementation for ActiveRecord as extension for Yii2.

How to install to your project

composer require smoren/query-relation-manager

  Files folder image Files  
File Role Description
Files folder image.github (1 directory)
Files folder imagesrc (2 directories)
Files folder imagetests (3 files, 3 directories)
Accessible without login Plain text file codeception.yml Data Auxiliary data
Accessible without login Plain text file composer.json Data Auxiliary data
Accessible without login Plain text file LICENSE Lic. License text
Accessible without login Plain text file README.md Doc. Documentation

  Files folder image Files  /  .github  
File Role Description
Files folder imageworkflows (1 file)

  Files folder image Files  /  .github  /  workflows  
File Role Description
  Accessible without login Plain text file test_master.yml Data Auxiliary data

  Files folder image Files  /  src  
File Role Description
Files folder imageBase (3 files, 1 directory)
Files folder imagePdo (2 files)

  Files folder image Files  /  src  /  Base  
File Role Description
Files folder imageStructs (4 files)
  Plain text file QueryRelationManagerBase.php Class Class source
  Plain text file QueryRelationManagerException.php Class Class source
  Plain text file QueryWrapperInterface.php Class Class source

  Files folder image Files  /  src  /  Base  /  Structs  
File Role Description
  Plain text file JoinCondition.php Class Class source
  Plain text file JoinConditionCollection.php Class Class source
  Plain text file Table.php Class Class source
  Plain text file TableCollection.php Class Class source

  Files folder image Files  /  src  /  Pdo  
File Role Description
  Plain text file QueryRelationManager.php Class Class source
  Plain text file QueryWrapper.php Class Class source

  Files folder image Files  /  tests  
File Role Description
Files folder imagescripts (1 file)
Files folder imageunit (1 file)
Files folder image_support (1 file)
  Accessible without login Plain text file coding_standard.xml Data Auxiliary data
  Accessible without login Plain text file unit.suite.yml Data Auxiliary data
  Accessible without login Plain text file _bootstrap.php Aux. Auxiliary script

  Files folder image Files  /  tests  /  scripts  
File Role Description
  Accessible without login Plain text file migrate.php Aux. Database install script

  Files folder image Files  /  tests  /  unit  
File Role Description
  Plain text file PDOTest.php Class Class source

  Files folder image Files  /  tests  /  _support  
File Role Description
  Plain text file UnitTester.php Class Class source

 Version Control Unique User Downloads Download Rankings  
 100%
Total:84
This week:0
All time:10,033
This week:455Up