App_Controller_Test

<?php

class APP_Controller_Test extends APP_Controller_Application {

    function index() {
        $model = new APP_Model_Test();
        $rows = $model->getAllRows();
        $data = array('foo' => 'bar', 'user' => 'ppi_user');
        $newID = $model->addRow($data);
        $this->redirect('user/profile/' . $newID);
    }

}

App_Model_Test

<?php

// Extends nothing
class App_Model_Test {

    protected $_name = 'users'; // Table name
    protected $_primary = 'id'; // Table Key
    protected $_handler = null;

    function __construct() {
        $ds = new PPI_DataSource();
        $this->_handler = $ds->factory('mysql'); // Name defined in the index.php
    }

    function getAllRows() {
        return $this->_handler->query('select count(*) count from product_views')->fetchAll();
    }

    function addRow(array $data) {
        $this->_handler->insert($this->_name, $data);
        return $this->_handler->lastInsertId();
    }

}

index.php

<?php
require '../ppi/init.php';

// Create a DS reference as 'mysql'
PPI_DataSource::add('mysql', array(
	'type'   => 'pdo_mysql',
	'host'   => 'localhost',
	'dbname' => 'mydb',
	'user'   => 'root',
	'pass'   => 'p4ssw0rd'
));

$app = new PPI_App();

$app->siteMode = 'development';
$app->configBlock = 'development';

$app->boot();
$app->dispatch();