PHP Classes

SQL Server YII DataProvider: Alternative MS SQL Server data provider for YII

Recommend this page to a friend!
     
  Info   Documentation   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 22 All time: 11,306 This week: 455Up
Version License PHP version Categories
ms-active-data-provi 1MIT/X Consortium ...5PHP 5, Databases, Design Patterns
Description 

Author

Thiago Przyczynski

This package is an alternative MS SQL Server data provider for YII.

It extends the YII framework base active data provider class to define how to fetch data for SQL server database queries with given criteria and pagination support.

The package also comes with an example active record class that can be used to show how to perform the necessary queries to retrieve data from the database using implicitly the data provider class from this package.

Picture of Thiago Przyczynski
  Performance   Level  
Name: Thiago Przyczynski <contact>
Classes: 16 packages by
Country: Brazil Brazil
Age: 35
All time rank: 3196238 in Brazil Brazil
Week rank: 195 Up14 in Brazil Brazil Up

Level 3 StarStarStar

 Innovation award
Innovation award
Nominee: 8x

Documentation

Yii SQL Server Active Data Provider

This package contains an Active Data Provider to be used instead of Yii 1 builtin CActiveDataProvider to fix the "weird" pagination when using a MS Sql Server database in the Active Records classes.

Installation and Usage

Basically you just need to download this package and put MSActiveDataProvider in the application.components folder (by default: protected/components). After that you may use it in any CModel based class, for instance replacing any call of CActiveDataProvider for MSActiveDataProvider.

Example

You can check the User model sample.


  Files folder image Files (3)  
File Role Description
Files folder imageexample (1 file)
Plain text file MSActiveDataProvider.php Class Class source
Accessible without login Plain text file README.md Doc. Documentation

  Files folder image Files (3)  /  example  
File Role Description
  Plain text file User.php Class Class source

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadms-active-data-provi-2019-07-26.zip 1KB
Downloadms-active-data-provi-2019-07-26.tar.gz
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 100%
Total:22
This week:0
All time:11,306
This week:455Up

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.