how to read data that is stored with array in php and mysql

Question

i stored data by using multiple checkbox in mysql. i want to show this stored data without include comma by using array. but, it is shown as the array was count comma

index.php


    include('config.php');
    $results = array();
    $sql = "select * from assign1 where id='1'";

    $run = mysqli_query($mysqli,$sql);


      while($row = mysqli_fetch_assoc($run)) {
        $results[] = $row['assign'];   ?> 

<p><?php print_r($results) ?></p>

<?php echo $results[0][0] ."".$results[0][2]."". $results[0][4] ?>

    <?php   } ?>

In mysql,

In output, i stored no 11, but array is only show 1.

output : 691

Use explode() to "explode" the string by ,

user8034901
– user8034901

2019-12-04 10:32:37 +00:00
Commented Dec 4, 2019 at 10:32 — user8034901
– user8034901, Commented Dec 4, 2019 at 10:32

Amit Senjaliya · Accepted Answer · 2019-12-04 10:37:31Z

1

Can you try to explode() function:

$results[] = explode(',', $row['assign']);

foreach($results as $result) {
    echo $result.'/n';
}

answered Dec 4, 2019 at 10:37

Amit Senjaliya

2,9651 gold badge12 silver badges24 bronze badges

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

Comments

Swetha Sekar · Accepted Answer · 2019-12-04 10:40:18Z

1

Use explode() to convert from string to array

$a = "1,2,3";
$d = explode(',',$a);
print_r($d);

answered Dec 4, 2019 at 10:40

Swetha Sekar

2371 silver badge9 bronze badges

Collectives™ on Stack Overflow

how to read data that is stored with array in php and mysql

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