SlightPHP framework Documentation
\
SlightPHP

\SlightPHPDb_Mysql

Summary

Methods
Properties
Constants
init()
setCount()
setPage()
setLimit()
setGroupby()
setOrderby()
select()
selectOne()
update()
delete()
insert()
execute()
__construct()
query()
lastInsertId()
rowCount()
__connect()
$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
__quote()
__addsqlslashes()
$mysql
$countsql
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

$mysql

$mysql :

Type

$countsql

$countsql :

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

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") this param may be BUG insert into zone_user_online values(2,'','','','',now(),now()) on duplicate key update onlineactivetime=CURRENT_TIMESTAMP;

Returns

integer —

InsertID

execute()

execute(  $sql)

Parameters

$sql

__construct()

__construct()

query()

query(string  $sql,   $countsql = "") : \SlightPHP\DbData

query

Parameters

string $sql
$countsql

Returns

\SlightPHP\DbData —

object

lastInsertId()

lastInsertId()

rowCount()

rowCount()

__connect()

__connect(  $forceReconnect = false)

Parameters

$forceReconnect

__quote()

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

Parameters

$condition
$split

__addsqlslashes()

__addsqlslashes(  $k)

Parameters

$k