Small Swoole Db 2.3 introduce left joins :
$selector = (new TableSelector('user')) ->leftJoin('post', 'messageOwner', 'message') ; $selector->where() ->firstCondition(new Condition( new ConditionElement(ConditionElementType::var, 'name', 'user'), ConditionOperator::equal, new ConditionElement(ConditionElementType::const, 'john') ))->andCondition(new Condition( new ConditionElement(ConditionElementType::var, 'subject', 'message'), ConditionOperator::like, new ConditionElement(ConditionElementType::const, '%hiring%') )) ;
packagist : https://packagist.org/packages/small/swoole-db
git : https://git.small-project.dev/lib/small-swoole-db
The above is the detailed content of Small Swoole Db. For more information, please follow other related articles on the PHP Chinese website!