# Custom connection managaer query in cakephp 3

**URL:** <https://discourse.cakephp.org/t/custom-connection-managaer-query-in-cakephp-3/7756>\
**Category:** Uncategorized\
**Created:** [April 30, 2020, 4:12am UTC](https://discourse.cakephp.org/t/custom-connection-managaer-query-in-cakephp-3/7756 "2020-04-30T04:12:31Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![henryuu](https://avatars.discourse-cdn.com/v4/letter/h/2bfe46/32.png) [@henryuu](https://discourse.cakephp.org/u/henryuu)\
**Post date:** [April 30, 2020, 4:12am UTC](https://discourse.cakephp.org/t/custom-connection-managaer-query-in-cakephp-3/7756/1 "2020-04-30T04:12:31Z")

</div>

In older version for cakephp 1.3 ,when using custom query like below I was getting result in array of defined model or table name, like below  
$query = "SELECT `survey_responses` . `created` , `survey_question_options` . `name` FROM `survey_responses` LEFT JOIN `survey_question_options` ON `survey_responses` . `id` = `survey_question_options` . `survey_response_id` ";  
$res = $this-\>ChallengeResponse-\>query($query);  
result is  
Array  
(  
[0] =\> Array  
(  
[‘survey\_responses’] =\> Array  
(  
[created] =\> 2020-04-17 07:10:52  
)  
[‘survey\_question\_options’] =\> Array  
(  
[name] =\> ‘test’  
)  
)  
[1] =\> Array  
(  
[‘survey\_responses’] =\> Array  
(  
[created] =\> 2020-04-18 07:10:52  
)  
[‘survey\_question\_options’] =\> Array  
(  
[name] =\> ‘test2’  
)  
)  
)

but using connection manager in cakephp 3.x I am getting result like below

```
Array
(
[0] => Array
    (
        [created] => 2020-04-17 07:10:52
		[name] => 'test'
	)

[1] => Array
    (
        [created] => 2020-04-18 07:10:52
		[name] => 'test2'
	)
)
```

---

<div class="post-metadata">

**Author:** ![Zuluru](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/zuluru/32/1230_2.png) [@Zuluru](https://discourse.cakephp.org/u/Zuluru)\
**Post date:** [April 30, 2020, 2:45pm UTC](https://discourse.cakephp.org/t/custom-connection-managaer-query-in-cakephp-3/7756/2 "2020-04-30T14:45:52Z")

</div>

Please share the CakePHP 3.x code that you’re using.

---

<div class="post-metadata">

**Author:** ![henryuu](https://avatars.discourse-cdn.com/v4/letter/h/2bfe46/32.png) [@henryuu](https://discourse.cakephp.org/u/henryuu)\
**Post date:** [May 1, 2020, 4:24am UTC](https://discourse.cakephp.org/t/custom-connection-managaer-query-in-cakephp-3/7756/3 "2020-05-01T04:24:45Z")

</div>

In 3.x i am using like below  
$this-\>conn = ConnectionManager::get(‘default’);  
return $this-\>conn-\>query($sql)-\>fetchAll(‘assoc’);

in 1.3 I was using like below  
return $this-\>Model-\>query($sql);

$sql is same in both, but gives result like i mentioned above