convert to array from database sql php

Question

<?php   
$content = "my content";
$parts = array("Part 1 :", "Part 2 :", "Part 3 :","Part 4 :", "Part 5 :");
$name_list = array("Part 1 :\n", "Part 2 :\n", "Part 3 :\n","Part 4 :\n", "Part 5 :");

$email_body = "Product:\n" .str_replace($parts, $name_list, $content);
?>

How I can obtain the same result as in the first script, but I want to import the second array $name_list from my database.

I did the script below, but it doesn't work.

<?php 
$query  = "SELECT * FROM my_table WHERE  id LIKE '%$id%'";
$search = mysql_query($query ) or die(mysql_error());

$name_list = array();
while ($row = mysql_fetch_array($search)) {
    $name_list[] = $row['name'] . ":\n,";
}
$name_list = explode(", ", $name_list);
?>

msk · Accepted Answer · 2017-01-16 08:05:06Z

2

remove this line $name_list = explode(",",$name_list);, because $name_list already in array, and you can use explode to convert string to array, e.g..

<?php
    $name_list = "Part 1 :\n, Part 2 :\n, Part 3 :\n, Part 4 :\n, Part 5 :";
    $name_list = explode(",", $name_list);
    print_r($name_list);
?>

output

Array
(
    [0] => Part 1 :

    [1] =>  Part 2 :

    [2] =>  Part 3 :

    [3] =>  Part 4 :

    [4] =>  Part 5 :
)

so try below code

<?php 
$query  = "SELECT * FROM my_table WHERE  id LIKE '%$id%'";
$search = mysql_query($query ) or die(mysql_error());


$name_list = array();
while ($row = mysql_fetch_array($search)) {
    $name_list[] = $row['name'].":\n,";
}

$parts = array("Part 1 :", "Part 2 :", "Part 3 :","Part 4 :", "Part 5 :");

$email_body = "Product:\n" .str_replace($parts, $name_list, $content);

?>

edited Jan 16, 2017 at 8:05

answered Jan 16, 2017 at 7:38

msk

4812 silver badges12 bronze badges

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

1 Comment

msk Over a year ago

remove this line <code> $name_list = explode(",",$name_list);</code> only, because explode require string, but your passing array

Collectives™ on Stack Overflow

convert to array from database sql php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related