[Resolved] String rearrange to table

colinoo8

Hi there
Can anyone help, i'v been trying to format the contence of the $cart variable from this unreadable mess... to display it in a invoice type table format.

Scissors #208788 : 1 : 8.00 : 1~screw head #01016 : 1 : 1.89 : 1~Snap : 1 : 1.09 : 1~Snap Assorted Colour- Silver : 1 : 1.09 : 1~Hook unit : 2 : 1.39 : 1

What i need is some sort of formated table listing of the $cart contence, i'v been trying for days now to rearrange it, i think i came close a few times but never got it correct, so i'm looking for a little help, please...
Thanks in hope

ihcra

try:

<?php
// Here ive used a variable to represent the input - obviously  this would be whatever you are using as an output
$string = "Scissors #208788 : 1 : 8.00 : 1~screw head #01016 : 1 : 1.89 : 1~Snap : 1 : 1.09 : 1~Snap Assorted Colour- Silver : 1 : 1.09 : 1~Hook unit : 2 : 1.39 : 1";

// First explode the rows - these seem to be represented by the tilde '~' this puts each item description in a separate array row
$items = explode("~", $string);

print "<table><tr><td>Item</td><td>Quantity</td><td>Price</td></tr>";

foreach ($items as $key=>$value) {
    //then split each row into its constituent parts by using " : " as the separator
    $itemrow = explode(" : ", $value);
    print "<tr><td>" . $itemrow[0] . "</td><td>" . $itemrow[1] . "</td><td>" . $itemrow[2];
}
print "</table>";
?>

this outputs:

Item                           Quantity   Price
Scissors #208788               1          8.00
screw head #01016              1          1.89
Snap                           1          1.09
Snap Assorted Colour- Silver   1          1.09
Hook unit                      2          1.39

instead of using arrays you could use an ereg pattern match but arrays are useful i think if you have a variable number of items
if you combined the explode to array for the number of rows but pattern matching split for outputting the columns that would be a suitable alternative

colinoo8

Brill, just what i wanted, Thanks for your help...