Explode string from database separated with comma

Question

I have in database row services where have data Live, Text, Video separated with commas

This data is stored from checkboxes with implode function.

Now I need to explode Live Text Video individually and with if conditions to show different HTML code

<div class="icon-sm bg-black-soft bg-blur text-white rounded-circle" title="Live service"><i class="fas fa-video"></i></div>
<div class="icon-sm bg-black-soft bg-blur text-white rounded-circle" title="Text service"><i class="fas fa-align-justify"></i></div>
<div class="icon-sm bg-black-soft bg-blur text-white rounded-circle" title="Video service"><i class="fas fa-camera"></i></div>

I know what to do with if but can't get it individually.

$stmt = $con->prepare('SELECT `id`, `title`, `text`, `main_image`, `tags`, `services` FROM `news` ORDER BY `id` DESC LIMIT 8');

// Retrieve query results
$stmt->execute();
$stmt->bind_result($id, $title, $text, $naslovna, $tags, $services);
while ($stmt->fetch()) {
    // Add result to accounts array
    $news[] = ['id' => $id, 'title' => $title, 'text' => $text, 'naslovna' => $naslovna, 'tags' => $tags, 'services' => $services];
    $services = explode(", ", $services);
}

kmoser · Accepted Answer · 2022-07-17 21:30:44Z

1

You are not storing anything returned by the call to $stmt->fetch(). You need to do something like this:

while ($row = $stmt->fetch()) {
    $servis = $row['services'];
    $services = explode(', ', $servis);
}

Once you have created the array of services, you can output your HTMLseveral ways, including an if() or switch(). But it would probably be more efficient this way, in which the title and class are derived from the service:

<?php
foreach($services as $svc) {
    $title = ['Live' => 'Live', 'Text' => 'Text', 'Video' => 'Photo'][$svc];
    $c = ['Live' => 'fa-video', 'Text' => 'fa-align-justify', 'Video' => 'fa-camera'][$svc];
?>
    <div class="icon-sm bg-black-soft bg-blur text-white rounded-circle" title="<?= $title ?> service">
      <i class="fas <?= $c ?>"></i>
    </div>
<?php
}
?>

Here is the switch() version:

<?php
foreach($services as $svc) {
    switch ($svc) {
        case 'Live':
?>
<div class="icon-sm bg-black-soft bg-blur text-white rounded-circle" title="Live service"><i class="fas fa-video"></i></div>
<?php
        break;
        case 'Text':
?>
<div class="icon-sm bg-black-soft bg-blur text-white rounded-circle" title="Text service"><i class="fas fa-align-justify"></i></div>
<?php
        break;
        case 'Video':
?>
<div class="icon-sm bg-black-soft bg-blur text-white rounded-circle" title="Photo service"><i class="fas fa-camera"></i></div>
<?php
        break;
    }
}
?>

edited Jul 17, 2022 at 21:30

answered Jul 17, 2022 at 21:24

kmoser

9,3693 gold badges28 silver badges45 bronze badges

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

9 Comments

Marko Stevanović Over a year ago

Hi, thank you for your answer. I know how to do it in HTML with an if statement, but I can't explode with PHP code. I think something is wrong with my code.

kmoser Over a year ago

@MarkoStevanović See my updated answer.

Marko Stevanović Over a year ago

When I try print_r($services); show me Array ( [0] => )

kmoser Over a year ago

@MarkoStevanović What does print_r($row)' show?

Marko Stevanović Over a year ago

Show me 1 I print it inside in the while loop

|

Marko Stevanović · Accepted Answer · 2022-07-19 19:25:13Z

0

Selected everything with one query

$stmt = $con->prepare('SELECT `id`, `title`, `text`, `main_image`, `tags`, `services` FROM `news` ORDER BY `id` DESC LIMIT 8');

// Retrieve query results
$stmt->execute();
$stmt->bind_result($id, $title, $text, $naslovna, $tags, $services);
while ($stmt->fetch()) {
    // Add result to accounts array
    $news[] = ['id' => $id, 'title' => $title, 'text' => $text, 'naslovna' => $naslovna, 'tags' => $tags, 'services' => $services];
}

And printed with if statement

<?php
$service = explode(", ", $new['services']);
if (in_array('Live', $service)) { ?>
   <div class="icon-sm bg-black-soft bg-blur text-white rounded-circle" title="Live servis"><i class="fas fa-tower-broadcast"></i></div>
<?php }
if (in_array('Text', $service)) {  ?>
   <div class="icon-sm bg-black-soft bg-blur text-white rounded-circle" title="Tekst servis"><i class="fas fa-align-justify"></i></div>
<?php }
if (in_array('Video', $service)) {  ?>
<div class="icon-sm bg-black-soft bg-blur text-white rounded-circle" title="Video servis"><i class="fas fa-video"></i></div>
<?php }
if (in_array('Photo', $service)) {  ?>
   <div class="icon-sm bg-black-soft bg-blur text-white rounded-circle" title="Foto servis"><i class="fas fa-camera"></i></div>
<?php } ?>

This is working but, it is safe?

answered Jul 19, 2022 at 19:25

Marko Stevanović

511 silver badge8 bronze badges

3 Comments

kmoser Over a year ago

"Safe" in what sense? Safety is a sliding scale, not a yes/no. What are you concerned about?

Marko Stevanović Over a year ago

I mean it is safe for use. I am concerned about the secure code. No attack can be carried out like SQL injection

kmoser Over a year ago

SQL injection is impossible in this case because the SQL statement is hard-coded, and not dependent on external, user-supplied data. As long as there is no other means for the contents of the DB to be altered, this code is safe.

Collectives™ on Stack Overflow

Explode string from database separated with comma

2 Answers 2

9 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related