Group a query whit joins using PDO

Asked Jun 21 '19 at 06:25

Active Jun 21 '19 at 06:30

Viewed 31 times

I have this query

SELECT qu.nom_questao, qu.tipo_reposta ,rq.des_resposta 
    FROM questao qu 
    inner join questionario_questao qq on qu.id_questao=qq.id_questao 
    inner join questionario q on qq.id_questionario = q.id_questionario 
    left join resposta_questao rq on qu.id_questao=rq.id_questao 
    WHERE q.id_questionario=1

and result of this select i want that group by column nom_questao having a result like

[
    0:[TesteFechada
    [0:opcao1
    1:opcao2
    2:opcao3
    3:opcao4
    ] 
    ],
    1:[TesteAberta
    [
    0:opcao1
    1:opcao2
    2:opcao3
    3:opcao4
    ]
],
    3:[Range[
    0:21
    1:35
    ]
]

is there any way the PDO can do this?

edited Jun 21 '19 at 06:30

Nigel Ren

56,122
11
43
55

asked Jun 21 '19 at 06:25

Gabriel Ribeiro

1

No, PDO will not do this for you. Just use a loop in PHP to create the groups. Something like what's described in https://stackoverflow.com/questions/12706359/php-array-group – apokryfos Jun 21 '19 at 06:28
An ORDER BY clause would be a good start. – Nigel Ren Jun 21 '19 at 06:33
@NigelRen at the end he has to use php `while()`or `foreach()` loop to get his desired result, because with query he can't get his desired output – Alive to die - Anant Jun 21 '19 at 06:34
fetch the record, apply the loop and get your desired result – Alive to die - Anant Jun 21 '19 at 06:37
@AlivetoDie The idea of reading the data and then processing the array is a waste of time, read each row and place it int the structure your after in one go. – Nigel Ren Jun 21 '19 at 06:38
@NigelRen didn't get you. please explain? – Alive to die - Anant Jun 21 '19 at 06:39
@NigelRen you mean i build my object using foreach?? – Gabriel Ribeiro Jun 21 '19 at 15:09

Group a query whit joins using PDO

0 Answers0