note 124261 added to function.join

From: 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

« previous php.notes (#212452) next »