Concat database results with PHP

Question

I'm new at PHP, so if there's some kind of advice, it will be well received.

I want to concat all the results I get from a sql query to my database.

I got the code:

$sql = $_POST['sql']; /*sql query*/
$result = "";

$query = mysqli_query($conn, $sql);
while ($row = mysqli_fetch_array($query, MYSQLI_NUM)) {
  $result = $result . ' ' . $row;
}

echo $result;

What I want is not a sql query that concats, but a way to concat rows with PHP.

We need to know what your data looks like in PHP – GrumpyCrouton Apr 19 '18 at 20:58 — GrumpyCrouton, Apr 19 '18 at 20:58
loop, echo value, echo space, repeat. – Apr 19 '18 at 21:02 — , Apr 19 '18 at 21:02
`group_concat` function with `mysql` – RoMEoMusTDiE Apr 19 '18 at 21:03 — RoMEoMusTDiE, Apr 19 '18 at 21:03

score 0 · Answer 1 · answered Apr 19 '18 at 21:16

0

The correct syntax would be:

select group_concat(index separator ' ')
from playerdeck;

This assumes that you do not care about the ordering of the values. If you do:

select group_concat(index order by index separator ' ')
from playerdeck;

answered Apr 19 '18 at 21:16

Gordon Linoff

1,242,037
58
646
786

This works, but I don't want to but the concat in the sql query – David Leites Apr 19 '18 at 21:32
1

... but you should (unless there is a reason that you haven't told us). – mickmackusa Apr 23 '18 at 11:20

Concat database results with PHP

1 Answers1