Displaying Explode data using loop

Question

I am new in PHP. I have a code in which i use foreach loop to display data in table of explode function.

Here i have a question

The data in my db is

Here you see After Aatir there is a blank space. When i use loop to print data

<?php
ini_set('error_reporting', E_ALL);
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "pacra1";

$conn = new mysqli($servername, $username, $password, $dbname);
$sql = "SELECT * FROM `pacra_clients` WHERE `id` = 50";

$conn->multi_query($sql);
$result = $conn->use_result();

echo $conn->error; 
$row = $result->fetch_assoc();

$liaison_one = $row['liaison_one'];

$liaison_one_chunks = explode(",", $liaison_one);

    echo '<table border="01">';
    foreach($liaison_one_chunks as $row){
        echo '<tr>';
        $row = explode(',',$row);
    foreach($row as $cell){
            echo '<td>';
            echo $cell;
            echo '</td>';
        }
        echo '</tr>';
    }
    echo '</table>';
?>

The result of my code is

In result you can see that there is a blank cell due to blank space in data.

Is it possible that i can skip blank space which is in my data???

Add an if() condition that when the string is empty(), don't create a row — Logan Wayne
– Logan Wayne, Commented Aug 25, 2015 at 5:12
^ or foreach($row as $cell) { if(!empty($cell)) { echo "<td>{$cell}</td>"; }} — Darren
– Darren, Commented Aug 25, 2015 at 5:12
Why don't you put al these values in different fields in your MySQL table? — Fin
– Fin, Commented Aug 25, 2015 at 5:15
@Fin lets suppose in future i want to some more data like address of that person. For that i create new column every time when i update data. and its difficult to handle. That why i use Implode and Explode — sunny
– sunny, Commented Aug 25, 2015 at 5:18

DannyPhantom · Accepted Answer · 2015-08-25 05:12:36Z

2

Yes it is possible. Use continue.

 foreach($row as $cell){
            if ($cell == "")
                   continue;
            echo '<td>';
            echo $cell;
            echo '</td>';
        }

answered Aug 25, 2015 at 5:12

DannyPhantom

1,06310 silver badges21 bronze badges

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

Comments

Tal · Accepted Answer · 2015-08-25 06:19:52Z

1

Try this

 foreach($row as $cell){
        if ($cell != "" && $cell != null)
        {
        echo '<td>';
        echo $cell;
        echo '</td>';
        }
    }

answered Aug 25, 2015 at 6:19

Tal

1,24114 silver badges25 bronze badges

Collectives™ on Stack Overflow

Displaying Explode data using loop

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related