PHP Class phprs\ezsql\rules\select\JoinRule

Inheritance: extends WhereRule
Show file Open project: caoym/phprs-restful

Public Methods

Method Description
innerJoin ( string $table ) : JoinOnRule innerJoin('table1')->on('table0.id=table1.id') => "INNER JOIN table1 ON table0.id=table1.id"
join ( string $table ) : JoinOnRule join('table1')->on('table0.id=table1.id') => "JOIN table1 ON table0.id=table1.id"
leftJoin ( string $table ) : JoinOnRule leftJoin('table1')->on('table0.id=table1.id') => "LEFT JOIN table1 ON table0.id=table1.id"
rightJoin ( string $table ) : JoinOnRule rightJoin('table1')->on('table0.id=table1.id') => "RIGHT JOIN table1 ON table0.id=table1.id"

Method Details

innerJoin() public method

innerJoin('table1')->on('table0.id=table1.id') => "INNER JOIN table1 ON table0.id=table1.id"
public innerJoin ( string $table ) : JoinOnRule
$table string
return JoinOnRule

join() public method

join('table1')->on('table0.id=table1.id') => "JOIN table1 ON table0.id=table1.id"
public join ( string $table ) : JoinOnRule
$table string
return JoinOnRule

leftJoin() public method

leftJoin('table1')->on('table0.id=table1.id') => "LEFT JOIN table1 ON table0.id=table1.id"
public leftJoin ( string $table ) : JoinOnRule
$table string
return JoinOnRule

rightJoin() public method

rightJoin('table1')->on('table0.id=table1.id') => "RIGHT JOIN table1 ON table0.id=table1.id"
public rightJoin ( string $table ) : JoinOnRule
$table string
return JoinOnRule