Writing to database after unserialize

[perky416]

Hi everyone,

 

Im trying to serialize the values of checked checkboxes, save them to a database, then on another page retrieve the value from the database, unserialize it, and then write each checkbox value to the database individually.

 

Using the following test code I'm able to serialize the checkbox values, and then unserialize them and echo them out fine, however im unsure how to separate them and save them individually into the database.

 

$string = implode($_POST['checkbox']);
$test = serialize($string);
$test2 = unserialize($test);
echo $test2;

<?php $i = 0; ?>
<?php while ($row = mysql_fetch_assoc($query)) { ?>
<tr>
    	<td><input type="checkbox" name="<?php echo "checkbox[$i]"; ?>" value="<?php echo $row['test']; ?>" /></td>
    </tr>
<?php $i++; } ?>

 

Any ideas?

Thanks

[perky416]

Figured it out using the following:

 

	$string = implode("|",$_POST['checkbox']);
	$test = serialize($string);
	$test2 = unserialize($test);
	$test3 = explode("|",$test2);

	foreach($test3 as $testing)
	{
		mysql_query("INSERT INTO ...");	
	}

 

Thanks