Extract exploded results from a column

Question

I entered several data inside the same column with the implode, now I want to extract the results of the query with the explodes so as to keep the data separate so that later I can work them.

I have the code this way, but it’s not returning anything in the arrays:

$conn = new mysqli($servername, $username, $password, $dbname);
$conn->set_charset('utf8');

$sql = "SELECT arrachar FROM centrodb.marcacaoInfancia";

$result = mysqli_query($conn, $sql);

    $result1 = explode(' ', $result);

    echo $result1[0];
    echo $result1[1];
    echo $result1[2];
    echo $result1[3];
    echo $result1[4];
    echo $result1[5];
    echo $result1[6];
    echo $result1[7];
    echo $result1[8];
    echo $result1[9];
    echo $result1[10];
    echo $result1[11];

Answer 1

You have to "treat" that $result to determine how you want to handle the data.

A widely used method is the fetch_assoc() which returns an associative array of the table.

So let’s make a loop with the fetch_assoc() and read each row of the table:

while ($linha= mysqli_fetch_assoc($result)) {
    $result1 = explode(' ', $linha["arrachar"]);
    var_dump($result1);
}

If you only have a line or query with limit 1 can ignore the while.

$linha= mysqli_fetch_assoc($result);
$result1 = explode(' ', $linha["arrachar");
var_dump($result1);

Another example using the fetch_array (array common, numeric)

$linha= mysqli_fetch_array($result, MYSQLI_NUM);
$result1 = explode(' ', $linha[0]);
var_dump($result1);

Answer 2

Try something like that:

$conn = new mysqli($servername, $username, $password, $dbname);
$conn->set_charset('utf8');

$sql = "SELECT arrachar FROM centrodb.marcacaoInfancia";

$result = mysqli_query($conn, $sql);
$data = '';

while($row = $result->fetch_assoc()) {
    $data .= $row["arrachar"].',';
}
$result1 = explode(',', $data);

echo $result1[0];
echo $result1[1];
echo $result1[2];
echo $result1[3];
echo $result1[4];
echo $result1[5];
echo $result1[6];
echo $result1[7];
echo $result1[8];
echo $result1[9];
echo $result1[10];
echo $result1[11];