如何使用pdo mysql将包含多个由逗号分隔的值的多个行值提取到php中的单个数组中

Question

I have a database table name books.Now i need to fetch value from multiple row values (column name position) which contains multiple value separated by comma.Now i need to fetch values from multiple rows into an array using pdo php. Thanks in advanced

<?php
require_once "includes\config.php";

$sql = 'SELECT * FROM books WHERE shelf_no=2';
$stmt = $db->prepare($sql);
$stmt->execute();
$row = $stmt->fetchALl(PDO::FETCH_ASSOC);
$d = array();
foreach ($row as $value) {
$d[] = explode(",",$value['position']);
}

print_r($d);
?>

and the result is

Array (
  [0] => Array (
    [0] => b1 
    [1] => b2 
  ) 
  [1] => Array ( 
    [0] => a2 
    [1] => a3
  )
)

but i need all values in a single array

Answer 1

You are exploding it (creating a new array) and then adding that array to another array.

You could run through each value in the exploded string and add them:

<?php
require_once "includes\config.php";

$sql = 'SELECT * FROM books WHERE shelf_no=2';
$stmt = $db->prepare($sql);
$stmt->execute();
$row = $stmt->fetchALl(PDO::FETCH_ASSOC);
$d = array();
foreach ($row as $value) {
    $temp = explode(",",$value['position']);
    foreach($temp as $pos){
        array_push($d, trim($pos));
    }   
}

print_r($d);
?>

If there are duplicates they will show though.