PHP Class phprs\ezsql\Sql

How-to-use: $db = new DB($dsn, $username, $passwd); 1. select $res = Sql::select('a, b') ->from('table') ->leftJoin('table1')->on('table.id=table1.id') ->where('a=?',1) ->groupBy('b')->having('sum(b)=?', 2) ->orderBy('c', Sql::$ORDER_BY_ASC) ->limit(0,1) ->forUpdate()->of('d') ->get($db); 2. update $rows = Sql::update('table') ->set('a', 1) ->where('b=?', 2) ->orderBy('c', Sql::$ORDER_BY_ASC) ->limit(1) ->exec($db) ->rows 3. insert $newId = Sql::insertInto('table') ->values(['a'=>1]) ->exec($db) ->lastInsertId() 4. delete $rows = Sql::deleteFrom('table') ->where('b=?', 2) ->orderBy('c', Sql::$ORDER_BY_ASC) ->limit(1) ->exec($db) ->rows

Author: caoym ([email protected])

Show file Open project: caoym/phprs-restful Class Usage Examples

Public Properties

Property	Type	Description
$ORDER_BY_ASC
$ORDER_BY_DESC

Public Methods

Method	Description
deleteFrom ( string $table ) : WhereRule	deleteFrom('table') => "DELETE FROM table"
insertInto ( string $table ) : ValuesRule	insertInto('table') => "INSERT INTO table"
native ( string $str ) : Native	Splice sql use native string(without escaping) for example: where('time>?', 'now()') => " WHERE time > 'now()' " where('time>?', Sql::native('now()')) => " WHERE time > now() "
replaceInto ( string $table ) : ValuesRule	replaceInto('table') => "REPLACE INTO table"
select ( $param0 = '*', $_ = null ) : FromRule	select('column0,column1') => "SELECT column0,column1"
update ( string $table ) : UpdateSetRule	update('table') => "UPDATE table"

Method Details

deleteFrom() public static method

deleteFrom('table') => "DELETE FROM table"

public static deleteFrom ( string $table ) : WhereRule
$table	string
return	phprs\ezsql\rules\basic\WhereRule

insertInto() public static method

insertInto('table') => "INSERT INTO table"

public static insertInto ( string $table ) : ValuesRule
$table	string
return	phprs\ezsql\rules\insert\ValuesRule

native() public static method

Splice sql use native string(without escaping) for example: where('time>?', 'now()') => " WHERE time > 'now()' " where('time>?', Sql::native('now()')) => " WHERE time > now() "

public static native ( string $str ) : Native
$str	string
return	Native

replaceInto() public static method

replaceInto('table') => "REPLACE INTO table"

public static replaceInto ( string $table ) : ValuesRule
$table	string
return	phprs\ezsql\rules\replace\ValuesRule

select() public static method

select('column0', 'column1') => "SELECT column0,column1"

public static select ( $param0 = '*', $_ = null ) : FromRule
$param0		columns
return	phprs\ezsql\rules\select\FromRule

update() public static method

update('table') => "UPDATE table"

public static update ( string $table ) : UpdateSetRule
$table	string
return	phprs\ezsql\rules\update\UpdateSetRule

Property Details

$ORDER_BY_ASC public static property

public static $ORDER_BY_ASC

$ORDER_BY_DESC public static property

public static $ORDER_BY_DESC