Implode Prob

[rukia]

hi,

i'm using implode to insert checkbox data as an array into database.. the input in the database is like this:

*Blue*Green*bla....

my checkbox code:

while ( $rows = mysql_fetch_assoc($result) ) {
print('<input type="checkbox" name="clr[]" value="'.$rows['id'].'">'.$rows['colour'].'');
    }

Then I used implode to insert the data into database:

$insertC = '*'.implode('*',$_POST['colour']).'*';
$query = "INSERT INTO colors VALUES('$insertC')";

my problem is how do I retrieve the data for user to choose their most fav color in radio button form..the one that i did, it's display the data in 1 row..the code:

while ($row = mysql_fetch_array($result))
{
$c = $row['color'];

$array = array($c);
$d= implode(",", $array);

print('<input type="radio" name="color" value="'.$rows['colour'].'">&nbsp;'.$d.'<br>'); 
}

result:

*Blue*Green*REd*

what i want is like this:

Blue
Green
Red

can anyone help me..i've been doing this for 2 days..

[shonuff]

http://www.php.net/explode

http://www.phpbuilder.com/board/showthread.php?t=10325770

[Kudose]

rukia wrote:

while ($row = mysql_fetch_array($result))
{
$c = $row['color'];

$array = array($c);
$d= implode(",", $array);

print('<input type="radio" name="color" value="'.$rows['colour'].'">&nbsp;'.$d.'<br>'); 
}

result:

*Blue*Green*REd*

what i want is like this:

Blue
Green
Red

Your result of BlueGreenREd Should not be. It should be blue,green,red since you are imploding the array with a comma, not an asterisk.

In any case, here is an example of what you want to do:

nevermid -> shonuff posted good explanations via links

[rukia]

i try to do like this (below) and it is success..

$names = array('Red', 'Green', 'Blue', 'Yellow');
$d = implode('<input type="radio" name="colour" value="'.$rows['names'].'">', $names);
print('<input type="radio" name="colour" value="'.$rows['names'].'">&nbsp;'.$d.'<br>'); 

output:
Red
Green
Blue
Yellow

but, when i apply it like this(below), it cannot...

while ($row = mysql_fetch_array($result))
{
$c = $row['color'];

$array = array($c);
$d = implode('<input type="radio" name="colour" value="'.$rows['color'].'">', $array);
print('<input type="radio" name="colour" value="'.$rows['color'].'">&nbsp;'.$d.'<br>'); 
}

output:
Red Blue Green Yellow
HOW??

[rukia]

i try to use explode with default value (as shown below), it can...but...

$string = "Red Blue Green";
$arr = explode(" ", $string);
print_r($arr);
echo "<br>";
foreach($arr as $key => $value)
print('<input type="radio" name="colour" value="'.$rows[''].'">&nbsp;'.$value.'<br>'); 

...but...when i do like this (below), it cannot...why...what mistakes did i do...

while ($row = mysql_fetch_array($result))
{
$c = $row['color'];
$arr = $c;
$d = explode(" ", $arr);
echo "<br>";
foreach($d as $key => $value)
print('<input type="radio" name="colour" value="'.$rows[''].'">&nbsp;'.$value.'<br>'); 
}

the output(based on entry in the database):
red, green
blue
green,blue