How to Concatenation two results into a variable

Question

In PHP I'm running a mysql query and from the results I want to string together multiple columns into a single variable. Obviously my example below doesn't work, but hopefully it gives you an idea of what I'm trying to do.

$var1=         $line_results[city,state,country];

I want var1 to become one long variable for all 3 columns that get stitched together. What is the exact syntax to stitch those 3 columns together? This is what I currently have setup and I want to merge them into one:

  $var1=        $line_results[city];
  $var2=        $line_results[state];
  $var3=        $line_results[country];

http://php.net/manual/en/function.implode.php or http://php.net/manual/en/language.operators.string.php — AbraCadaver, Mar 12 '17 at 15:50

score 3 · Accepted Answer · answered Mar 12 '17 at 15:52

3

Use . to concatenate strings e.g.

$var1 = $line_results['city'] . $line_results['state'] . $line_results['country'];

or if they need a space:

$var1 = $line_results['city'] .' '. $line_results['state'] .' '. $line_results['country'];

Hope this helps!

answered Mar 12 '17 at 15:52

Rwd

34,180
6
64
78

Worked like a charm. You Da Man. – Alby Mar 12 '17 at 16:04
@Alby No worries. Glad I could help! – Rwd Mar 12 '17 at 16:06
Ross: Is it possible to add a carriage return vs. a space? – Alby Mar 12 '17 at 16:46
@Alby you could do something like `. '
' `. or `. "\n\r" `. – Rwd Mar 12 '17 at 17:34
Thanks Ross... Just what I needed. :) – Alby Mar 12 '17 at 17:59

score 1 · Answer 2 · answered Mar 12 '17 at 15:52

1

You can concatenate strings with a dot. $var1 = $line_results[city] . $line_results[state] . $line_results[country]

answered Mar 12 '17 at 15:52

Schokokuchen Bäcker

766
4
17

How to Concatenation two results into a variable

2 Answers2