PHP Classes

Packages of Mohamed Abdulalim

Recommend this page to a friend!
  All class groups  >  All authors  >  Packages of Mohamed Abdulalim (1)  >  Mission progress status  >  Reputation  
Picture of Mohamed Abdulalim
Name: Mohamed Abdulalim <contact>
Classes: 1
Country: Egypt Egypt
Age: 45
All time rank: Not yet ranked
Week rank: Not yet ranked
Innovation award
Innovation award
Nominee: 1x
 
  A   B   C   D   E   F   G   H   I   J   K   L   M   N   O   P   Q   R   S   T   U   V   W   X   Y   Z  
  Files folder image Persistence  
Retrieve database table records by a given order
This package can retrieve database table records by a given order.

It provides one class that can compose and execute SQL queries using PDO to retrieve records of database tables by an order defined using a configuration class.

The configuration class allows defining the following:

- The name of the table

- The table columns that will be used to define the sorting order and global sorting order

- The table record identifier column

- The name of the column that will be used to determine if the table record was marked as deleted

The class provides a class for:

- Retrieve the database table record in the next position

- Change the order of a given database table record

- Check if a given database record exists

The package also provides a class to retrieve database table records split in multiple pages.


  A   B   C   D   E   F   G   H   I   J   K   L   M   N   O   P   Q   R   S   T   U   V   W   X   Y   Z