Display PHP Array On New Line

Question

I am trying to display the output of a sql query on 3 different lines using the echo function. The php code is enclosed inside a div tag. My code is below

<div class="ClientAdress" id="ClientAdress">
<?php
$db = new SQLite3( 'Stock_Control.sqlite');
$sql = 'SELECT City,County,Street_Adress FROM Customer WHERE Customer_ID = 14';
$result = $db->query($sql);//->fetchArray(SQLITE3_ASSOC); 

    $row = array(); 

    $i = 0; 

     while($res = $result->fetchArray(SQLITE3_ASSOC)){ 

         if(!isset($res['City'])) continue; 
          $row[$i]['City'] = $res['City']; 
          $row[$i]['County'] = $res['County']; 
          $row[$i]['Street_Adress'] = $res['Street_Adress']; 

          $i++; 

      } 

        echo $row[0]['City'];
        echo $row[0]['County'];
        echo $row[0]['Street_Adress'];

?>
</p>
</div>

The current output is "BurgasBurgasplaces"

Edit:

This is what I tried:

<div class="ClientAdress" id="ClientAdress">
<?php
$db = new SQLite3( 'Stock_Control.sqlite');
$sql = 'SELECT City,County,Street_Adress FROM Customer WHERE Customer_ID = 14';
$result = $db->query($sql);//->fetchArray(SQLITE3_ASSOC); 
$row = array(); 
$i = 0; 
while($res = $result->fetchArray(SQLITE3_ASSOC))
{ 
if(!isset($res['City'])) continue; 
$row[$i]['City'] = $res['City']; 
$row[$i]['County'] = $res['County']; 
$row[$i]['Street_Adress'] = $res['Street_Adress']; 
$i++; 

} 
echo $row[0]['City'] .  "<br />\n";;
echo $row[0]['County'] .  "<br />\n";;
echo $row[0]['Street_Adress'] .  "<br />\n";;
?>
</div>

sidenote: you dont open that p tag, or your opening it in the wrong place — Lawrence Cherone
– Lawrence Cherone, Commented Mar 10, 2015 at 18:08
You have an answer/solution below. Been there for a while, actually. — Funk Forty Niner
– Funk Forty Niner, Commented Mar 10, 2015 at 18:25

Funk Forty Niner · Accepted Answer · 2015-03-10 18:16:37Z

2

Concatenate a line break to each one -

echo $row[0]['City'] . "<br />" . "\n";
echo $row[0]['County'] . "<br />" . "\n";
echo $row[0]['Street_Adress'] . "<br />" . "\n";

Using \n to produce clean HTML in source.

You can also use the following, having both <br /> and \n inside one set of quotes:

echo $row[0]['City'] . "<br />\n";
echo $row[0]['County'] . "<br />\n";
echo $row[0]['Street_Adress'] . "<br />\n";

Otherwise, and should you later decide to add styling to those or wrapped in table tags, will all be inside one long line, rather than having each line neatly placed one underneath the other.

edited Mar 10, 2015 at 18:16

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

answered Mar 10, 2015 at 18:06

Jay Blanchard

34.5k17 gold badges82 silver badges130 bronze badges

Sign up to request clarification or add additional context in comments.

10 Comments

Funk Forty Niner Over a year ago

It's a simple as that Sam ;-)

Jay Blanchard Over a year ago

You know me, I am such a simple guy @Fred-ii- ;-)

Jay Blanchard Over a year ago

Hmmmm, interesting @Fred-ii-, I would have put both items in a single set of quotes.

Funk Forty Niner Over a year ago

Ah.... yes you're right. Good point. Oh well, the OP's got enough to go on now ;-) Just force of habit.

Jay Blanchard Over a year ago

It's worth thousands Ralph! ;-)

|

dojs · Accepted Answer · 2015-03-10 19:02:34Z

0

That code looks ugly, simplify it even more;

foreach ($row[0] as $key => $value)
{
  printf('%s => %s <br>\n', $key, $value);
  // OR
  echo "$key => $value <br> \n";
}

Automating will help you make your code cleaner, easier to understand and make you program faster.

answered Mar 10, 2015 at 19:02

dojs

5172 silver badges11 bronze badges

Collectives™ on Stack Overflow

Display PHP Array On New Line

2 Answers 2

10 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

10 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related