读取包含数组的文本文件 - 显示在表格中

Question

I am hoping someone can point in the right direction here, been surfing the internet for hours and haven't found a solution.

First, I am an "OKAY" php coder .. so this might be obvi but I am lost.

I have a txt file with array() in from a pull in an api transaction list.

    Array
    (
        [orderid] => 00000000
        [type] => rebill
        [paystatus] => cancelled
    )

    Array
    (
        [orderid] => 000000
        [type] => rebill
        [paystatus] => cancelled
    )
Array
(
    [orderid] => 000000
    [type] => refund
    [paystatus] => cancelled
    [productid] => 939399393
    [firstName] => XXXXXX
    [lastName] => XXXX
    [customeremail] => XXXX
    [amount] => XX.XX
    [refunddate] => 2015-01-01
    [refundstatus] => ok
)

There is thousands of these array()'s ... I am use to dealing with json etc to pull for each, but right now I am lost completely.

I am able to replicate the file with

$f = fopen("merged.txt", "r");

// Read line by line until end of file
while(!feof($f)) { 
    echo fgets($f) . "<br />";
}

fclose($f);

... that's it

I have played around with all kinds of foreach while etc and can't get it to work. If someone could point in the right direction, I would appreciate it so much.

Thanks!

Answer 1

how about try this?

$content= file_get_contents("merged.txt");

$arrays = explode('Array',ltrim(trim($content),'Array'));

echo "<table>";
foreach($arrays as $key => $value){
    $value = text_to_array("Array".$value);
    echo "<tr>";
        echo "<td>";
            echo $value['orderid'];
        echo "</td>";
    echo "</tr>";
}
echo "</table>";




function text_to_array($str) {

    //Initialize arrays
    $keys = array();
    $values = array();
    $output = array();

    //Is it an array?
    if( substr($str, 0, 5) == 'Array' ) {

        //Let's parse it (hopefully it won't clash)
        $array_contents = substr($str, 7, -2);
        $array_contents = str_replace(array(' ', '[', ']', '=>'), array('', '#!#', '#?#', ''), $array_contents);
        $array_fields = explode("#!#", $array_contents);

        //For each array-field, we need to explode on the delimiters I've set and make it look funny.
        for($i = 0; $i < count($array_fields); $i++ ) {

            //First run is glitched, so let's pass on that one.
            if( $i != 0 ) {

                $bits = explode('#?#', $array_fields[$i]);
                if( $bits[0] != '' ) $output[$bits[0]] = $bits[1];

            }
        }

        //Return the output.
        return $output;

    } else {

        //Duh, not an array.
        echo 'The given parameter is not an array.';
        return null;
    }

}