使用mysqli_fetch_row将数据库TEXT用于IMAGE

Question

I have this code:

$query = "SELECT vidRoles FROM videoinformation";

if ($result = mysqli_query($con, $query)) {

    while ($row = mysqli_fetch_row($result)) {
        $values = explode(',',$row[0]);
        foreach($values as $v)
           printf ("<img src=\"roles/%s.jpg\">", $v);
    }

    mysqli_free_result($result);
}

BUT instead of display:

<img src="roles/Name1.jpg>
<img src="roles/Name2.jpg>
<img src="roles/Name3.jpg>

I have:

<img src="roles/Name1.jpg>
<img src="roles/Name2.jpg>
<img src="roles/Name3.jpg>
<img src="roles/.jpg>
<img src="roles/.jpg>
<img src="roles/.jpg>
<img src="roles/.jpg>

But inside vidRoles filed I have only "Name1,Name2,Name3."
Why this empty images are show up???

Answer 1

try this -

foreach($values as $v) {
    if (!empty($v)) {
       printf ("<img src=\"roles/%s.jpg\">", $v);
    }
}

there are some null values present, that's why it is printing them.