[dannyallen]

I am trying to serialize a table from my database, which is named "fcc_templates". Now, I want the output from the database to be like this:


Array
(
[1] => Array
(
[template_1] => Array
(
[tid] => 1
[skinid] => 1
[name] => Installed Correctly
[template] => testing $var
[callname] => install_correct
)
[template_2] => Array
(
[tid] => 1
[skinid] => 1
[name] => Installed Correctly
[template] => testing $var
[callname] => install_correct
)
[template_3] => Array
(
[tid] => 1
[skinid] => 1
[name] => Installed Correctly
[template] => testing $var
[callname] => install_correct
)

)

[2] => Array
(
[template_1] => Array
(
[tid] => 1
[skinid] => 1
[name] => Installed Correctly
[template] => testing $var
[callname] => install_correct
)
[template_2] => Array
(
[tid] => 1
[skinid] => 1
[name] => Installed Correctly
[template] => testing $var
[callname] => install_correct
)
[template_3] => Array
(
[tid] => 1
[skinid] => 1
[name] => Installed Correctly
[template] => testing $var
[callname] => install_correct
)

)

)

Each number [1] etc is a skin set id, and the templates are by their name. Now, I can get my script to output this:

Array
(
[1] => Array
(
[install_correct] => Array
(
[tid] => 1
[skinid] => 1
[name] => Installed Correctly
[template] => testing $var
[callname] => install_correct
)

)

)

But, as you can see, only one template is shown. I want to be able to show all the templates in the [1] array or [2] array or whatever number the skin id is. Here is the code I have so far:

$value = $db->query("SELECT * FROM fcc_templates");
while ($cache1 = $db->fetch_array_assoc($value)){

$newval = array ($cache1[skinid] => array($cache1[callname] => $cache1));

$val .= serialize($newval);

}

echo $val;

echo "<br><br><pre>";
$new1 = unserialize($val);
print_r($new1);
echo "</pre>";

and the serialization seperates each template into its own array. I want each template to be part of the entire skinid array, not it's own big array. Here is what it looks like:


Array
(
[1] => Array
(
[install_correct] => Array
(
[tid] => 1
[skinid] => 1
[name] => Installed Correctly
[template] => testing $var
[callname] => install_correct
)

)

)


Array
(
[1] => Array
(
[next_template] => Array
(
[tid] => 1
[skinid] => 1
[name] => Installed Correctly
[template] => testing $var
[callname] => install_correct
)

)

)

see, each template is in its own array. How can I fix this?

[Eclipse]

So basically you just need serialized nested arrays?

[moronovich]

hello danny,
from your example i think it will be harder to serialize and unserialize the array. it's because your records in the database is not properly nested.
from your query:

PHP Code:

while ($cache1 = $db->fetch_array_assoc($value)){



$newval = array ($cache1[skinid] => array($cache1[callname] => $cache1)); 

for each iteration, it would yield following result:

Code:

$newval = array([skin_id] => array([callname] => array([skin_id] =>skinValue, [tid] =>tvalue, [name] => nameValue, template => templateValue, [callname] => callValue)))

here $newval is an array but its not properly indexed as you want to.

desired array structure:

Code:

$newval[0] = array([skin_id][0] => array([callname][0] => array([skin_id] =>skinValue, [tid] =>tvalue, [name] => nameValue, template => templateValue, [callname] => callValue), [callname][1] => array([skin_id] =>skinValue, [tid] =>tvalue, [name] => nameValue, template => templateValue, [callname] => callValue),[callname][2] => array([skin_id] =>skinValue, [tid] =>tvalue, [name] => nameValue, template => templateValue, [callname] => callValue)))

from your table structure:
[skin_id] is not primary index
which means that you can't automatically assign proper depth of your array since there would be the same level of your array.

solution:
serialization should be done after the loop. PHP function "array_key_exists" would be a nice friend in expanding your array to your desired structure.

example comes later. i'm sure you can solve this problem..