Introduction

Extended Database Library for LH project

How to use

Model is already imported on Controller, so you can call without include.

Controller

$model = new Model(false, array(
  'table'   => 'cms_news',
  'id'      => 'news_id',
  'visible' => 'visible',
));

$records = $model->find();

Methods

📄️ Model::__construct

Model class constructor

📄️ Model::setTableName

Set Table Name

📄️ Model::getTableName

Get Table name

📄️ Model::setPrimary

Set Primary ID name

📄️ Model::getPrimary

Get Primary ID name

📄️ Model::setVisible

Set Visible flag name

📄️ Model::getVisible

Get Visible flag name

📄️ Model::setBindParam

Set Bind Parameter types

📄️ Model::addBindParam

Add Bind Parameter types

📄️ Model::getBindParam

Get Bind Parameter types

📄️ Model::select

Set Select Parameter

📄️ Model::listMax

Set ListMax Parameter

📄️ Model::current

Set Current Page Parameter

📄️ Model::where

Set Where Parameter

📄️ Model::whereOpen

Add open bracket on Where query

📄️ Model::whereClose

Add close bracket on Where query

📄️ Model::having

Set Having Parameter

📄️ Model::havingOpen

Add open bracket on Having query

📄️ Model::havingClose

Add close bracket on Having query

📄️ Model::order

Set Order Parameter

📄️ Model::join

Set Join Parameter

📄️ Model::group

Set Group Parameter

📄️ Model::find

Get rows designated count

📄️ Model::getPager

Get variables for making pager

📄️ Model::one

Get one row from the records

📄️ Model::count

Get the number of record's count

📄️ Model::id

Get one record by specified primary ID

📄️ Model::setOptions

Setting option parameter

📄️ Model::resetOptions

Reset Options Data

📄️ Model::insert

Execute Insert data

📄️ Model::updateWhere

Execute Update the records by specified condition

📄️ Model::update

Execute Update the record by specified primary ID

📄️ Model::deleteWhere

Execute Logical Delete the records by specified condition

📄️ Model::delete

Execute Logical Delete the record by specified primary ID

📄️ Model::eraseWhere

Execute Physical Delete the records by specified condition

📄️ Model::erase

Execute Physical Delete the record by specified primary ID

📄️ Model::create

Execute Create Table

📄️ Model::dropTable

Execute Drop table

📄️ Model::dropIndex

Execute Drop index

📄️ Model::alterAddColumn

Execute Alter Add Column

📄️ Model::alterRenameTo

Execute Alter Rename

📄️ Model::pragma

Execute Pragma

📄️ Model::reset

Reset Model

📄️ Model::debug

Get last executed query

📄️ Model::unsetRegularUseQuery

Disable automatic append query for a current query flag

📄️ Model::unsetRegularUseQueryForTable

Disable automatic append query of the table for a current query flag

📄️ Model::disabledRegularUseQuery

Disable automatic append query flag