db-models

Wordpress Database Model Plugin

A Yii2-like model handler for database connections in WordPress

Function	Description
$model = new TableName;	Initiates a model instance
$model->find()	Initiator for SELECT queries
$model->find()->where(['field' => 'value', 'field2' => 'value2'])	Adds a where clause to the query
$model->find()->cache('unique_identifier')	Caches the query with WP transient
$model->find()->limit(1)	Adds a limit to the query
$model->find()->one()	Returns one row
$model->find()->all()	Returns several rows

Example:

<?php

/**
 * Models Plugin Example
 * Add this to a view in your template
 */

// Require the model file
require(MODELS_PATH . 'Options.php');

// Find Example with cache (returns array of objects)
$all_opts = Options::find()->cache('cacheIdentifier')->all();

// Find Example with select
$three_opts = Options::find()->limit(3)->select(['option_id', 'option_name'])->orderBy('option_id DESC')->all();

// FindByPk Example (returns Object)
$opt1 = Options::findByPk(1);

// Print out the record with Pk = 1
echo '<h2>Row found by Primary Key</h2>';
echo "Primary Key 1: ".$opt1->option_name." => ".$opt1->option_value."<br>";

// Print out the three first rows in Options
echo '<h2>Three last rows with select</h2>';
foreach($three_opts as $opt)
{
	echo $opt->option_name.'<br>';
}
// Print all rows in Options (cached)
echo '<h2>All rows (Cached)</h2>';
foreach($all_opts as $opt)
{
	echo $opt->option_name.'<br>';
}

?>