<?php
class DatabaseFinder extends Database
{
public $table;
final public function __construct($table)
{
$this->table = "db_{$table}";
}
/**
* Enter description here...
*
* @param unknown_type $primary_key
*/
final public function find($primary_key)
{
return $this->findByWhere('id', $primary_key);
}
/**
* Enter description here...
*
* @param unknown_type $column
* @param unknown_type $value
*/
final public function findBy($column, $order = 'ASC')
{
return $this->query("SELECT * FROM `?` ORDER BY ? ? LIMIT 1", $this->table, $column, $order);
}
/**
* Enter description here...
*
*/
final public function findLast()
{
return $this->findBy('id', 'DESC');
}
/**
* Enter description here...
*
*/
final public function findWhere($column, $value)
{
return $this->query("SELECT * FROM `?` WHERE ? = '?' LIMIT 1", $this->table, $column, $value);
}
/**
* Enter description here...
*
*/
final public function findAll($order = 'ASC')
{
return $this->findAllBy('id', $order);
}
/**
* Enter description here...
*
* @param unknown_type $column
* @param unknown_type $order
* @return unknown
*/
final public function findAllBy($column, $order = 'ASC')
{
return $this->query("SELECT * FROM `?` ORDER BY ? ?", $this->table, $column, $order);
}
/**
* Enter description here...
*
*/
final public function findByWhere($column, $value, $order = 'ASC')
{
return $this->query("SELECT * FROM `?` WHERE ? = ? ORDER BY ? ? LIMIT 1", $this->table, $column, $value, $column, strtoupper($order));
}
/**
* Enter description here...
*
*/
final public function findLastWhere($column, $value)
{
return $this->query("SELECT * FROM `?` WHERE ? = '?' ORDER BY id DESC LIMIT 1", $this->table, $column, $value);
}
/**
* Enter description here...
*
*/
final public function findAllWhere()
{
}
/**
* Enter description here...
*
*/
final public function create()
{
}
/**
* Enter description here...
*
*/
final public function drop()
{
}
/**
* Enter description here...
*
*/
final public function optimize()
{
}
}
?>