SlightPHP framework Documentation
\
SlightPHP

\SlightPHPDb_PDO

Summary

Methods
Properties
Constants
init()
setCount()
setPage()
setLimit()
setGroupby()
setOrderby()
select()
selectOne()
update()
delete()
insert()
execute()
__construct()
query()
lastInsertId()
rowCount()
__connect()
__quote()
$host
$port
$user
$password
$database
$charset
$orderby
$groupby
$sql
$count
$limit
$page
$error
$globals
No constants found
No protected methods found
No protected properties found
N/A
No private methods found
$prefix
$countsql
$affectedRows
N/A

Properties

$host

$host :

Type

$port

$port :

Type

$user

$user :

Type

$password

$password :

Type

$database

$database :

Type

$charset

$charset :

Type

$orderby

$orderby :

Type

$groupby

$groupby :

Type

$sql

$sql :

Type

$count

$count :

Type

$limit

$limit :

Type

$page

$page :

Type

$error

$error :

Type

$globals

$globals : array

Type

array

$prefix

$prefix :

Type

$countsql

$countsql :

Type

$affectedRows

$affectedRows :

Type

Methods

init()

init(  $params = array())

construct

Parameters

$params

setCount()

setCount(  $count)

is count

Parameters

$count

setPage()

setPage(  $page)

page number

Parameters

$page

setLimit()

setLimit(  $limit)

page size

Parameters

$limit

setGroupby()

setGroupby(  $groupby)

group by sql

Parameters

$groupby

setOrderby()

setOrderby(  $orderby)

order by sql

Parameters

$orderby

select()

select(mixed  $table, array  $condition = "", array  $item = "*", string  $groupby = "", string  $orderby = "", string  $leftjoin = "") : \SlightPHP\DbData

select data from db

Parameters

mixed $table
array $condition
array $item
string $groupby
string $orderby
string $leftjoin

Returns

\SlightPHP\DbData —

object || Boolean false

selectOne()

selectOne(mixed  $table, array  $condition = "", array  $item = "*", string  $groupby = "", string  $orderby = "", string  $leftjoin = "") : array

Parameters

mixed $table
array $condition
array $item
string $groupby
string $orderby
string $leftjoin

Returns

array —

item

update()

update(mixed  $table, \SlightPHP\string,array  $condition = "", array  $item = "") : integer

update data

Parameters

mixed $table
\SlightPHP\string,array $condition
array $item

Returns

integer —

update("table",array('name'=>'myName','password'=>'myPass'),array('id'=>1)); update("table",array('name'=>'myName','password'=>'myPass'),array("password=$myPass"));

delete()

delete(  $table, \SlightPHP\string,array  $condition = "") : integer

delete

Parameters

$table
\SlightPHP\string,array $condition

Returns

integer —

delete("table",array('name'=>'myName','password'=>'myPass'),array('id'=>1)); delete("table",array('name'=>'myName','password'=>'myPass'),array("password=$myPass"));

insert()

insert(  $table, array  $item = "",   $isreplace = false,   $isdelayed = false, array  $update = array()) : integer

insert

Parameters

$table
array $item
$isreplace
$isdelayed
array $update

,egarray("key"=>value,"key2"=>value2") insert into zone_user_online values(2,'','','','',now(),now()) on duplicate key update onlineactivetime=CURRENT_TIMESTAMP;

Returns

integer —

InsertID

execute()

execute(string  $sql) : array

Parameters

string $sql

Returns

array —

$data || Boolean false

__construct()

__construct(  $prefix = "mysql")

Parameters

$prefix

query()

query(string  $sql,   $bind1 = array(),   $bind2 = array()) : Array

query

Parameters

string $sql
$bind1
$bind2

Returns

Array —

$result || Boolean false

lastInsertId()

lastInsertId()

rowCount()

rowCount()

__connect()

__connect(  $forceReconnect = false)

Parameters

$forceReconnect

__quote()

__quote(  $condition,   $split = "AND",   $bind)

Parameters

$condition
$split
$bind