xPDO

xPDO
Object-relational bridge library using database persistence and Active Record pattern.

  • Feb
  • 16
  • 2017

Initialize Schema From Within a Parent Class

by W. Shawn Wilkerson

A simple mechanism which can be used to initialize the database schema from within the main package class file.

Keywords
  • Feb
  • 16
  • 2017

Creating write-protected xPDOObjects

by W. Shawn Wilkerson

Data retrieved from API's or database tables filled with read-only data may need protection from being altered, deleted, or overwritten. The following offers a technique to block all saves to the database.

Keywords
  • Nov
  • 28
  • 2014

Sample Class for use with xPDO

by W. Shawn Wilkerson

This class is a foundational class which can be used to create any number of MODX Revolution applications based on xPDO.

Keywords
class, example
  • Oct
  • 21
  • 2014

xPDO quick displays of table datum

by W. Shawn Wilkerson

Class functions which directly access xPDO's class definition to create table headers and values for table datum.

Keywords
utilities
  • Jul
  • 09
  • 2014

Working with PHP's DateTime for Periods of Time

by W. Shawn Wilkerson

Building a tool-set to tackle the DateTime conundrum of retrieving all the transactions which occur during a specified time period.

Keywords
DateTime, example
  • Apr
  • 26
  • 2013

sanitizeObject

by W. Shawn Wilkerson

This is a quick function which returns a key=>value array of designated object fields while removing those to be kept from the presentation.

Keywords
security
  • Jan
  • 22
  • 2013

xPDO Class Dump

by W. Shawn Wilkerson

Provides a straightforward presentation of an xPDO derived class and its relationships.

Keywords
utilities
  • Nov
  • 22
  • 2012

collectionToJSON

by W. Shawn Wilkerson

Simple function to convert an xPDO collection to JSON arrays

Keywords
utilities
  • Nov
  • 22
  • 2012

collectionToArrays

by W. Shawn Wilkerson

Simple reusable function to convert a collection into an array of arrays

Keywords
utilities
  • Mar
  • 31
  • 2012

Establishing database connections via xPDO

by Default Admin User

Database connections via xPDO are as simple as using mysqli, mysql_connect or other traditional methods: with less code, built in try - catch handling, increased functionality, type casting, and injection protection.

Keywords
example

A PDO implementation for PHP 4 and 5.0.x (where native PDO extensions are not available), a way to abstract business objects from the actual SQL queries and prepared statements used to access a relational database structure representing them, and a way to easily describe and provide optimized implementations of an object model for multiple target database platforms.

© 2012 - 2018 W. Shawn Wilkerson. All Rights Reserved.