note 124261 added to function.join
| From: | Anonymous@php.net | Date: | Fri, 04 Oct 2019 14:18:32 +0000 |
| Subject: | note 124261 added to function.join | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-212452@lists.php.net to get a copy of this message | ||
https://github.com/erdalceylan/array-join
{
"require": {
"erdalceylan/array-join": "2.0.0"
}
}
<?php
$instance = \ArrayJoin\Builder::newInstance()
->select("a.id", "a.nick", "b.item", "d.food")
->from($users, "a")
->innerJoin($items, "b", new \ArrayJoin\On("a.id = b.user_id"))
->leftJoin($texts, "c", new \ArrayJoin\On("a.id = c.user_id"))
->rightJoin($foods, "d", new \ArrayJoin\On("b.user_id = d.user_id"))
->where(function ($id, $text, $item, $food){
return $id < 50;
}, "a.id", "c.text", "b.item", "d.food")
->groupBy("a.id", "d.food")
->limit(2)
->offset(1)
->setFetchType(\ArrayJoin\Builder::FETCH_TYPE_OBJECT);
$instance->execute();
array (
stdClass::__set_state(array(
'id' => 1,
'nick' => 'erdal',
'item' => 'çorap',
'food' => 'iskender',
)),
stdClass::__set_state(array(
'id' => 1,
'nick' => 'erdal',
'item' => 'çorap',
'food' => 'iskender',
)),
);
----
Server IP: 208.43.231.9
Probable Submitter: 185.85.3.168 (proxied: 78.186.146.239)
----
Manual Page -- http://php.net/manual/en/function.join.php
Edit -- https://master.php.net/note/edit/124261
Del: integrated -- https://master.php.net/note/delete/124261/integrated
Del: useless -- https://master.php.net/note/delete/124261/useless
Del: bad code -- https://master.php.net/note/delete/124261/bad+code
Del: spam -- https://master.php.net/note/delete/124261/spam
Del: non-english -- https://master.php.net/note/delete/124261/non-english
Del: in docs -- https://master.php.net/note/delete/124261/in+docs
Del: other reasons-- https://master.php.net/note/delete/124261
Reject -- https://master.php.net/note/reject/124261
Search -- https://master.php.net/manage/user-notes.php