从列表中创建三维阵列


Create a 3D array from a list

我有以下列表:

1945年1月05日BA 87 34 1 59 50
1945/01/05 CA 18 17 45 49 82
1945年1月13日BA 6 66 1 16 48
1945/01/13 CA 40 60 32 50 80

等等…

我想把它们排列成一个数组,如下所示:

$array['BA'][0][0] = 87;
$array['BA'][0][1] = 34;
$array['BA'][0][2] = 1;
$array['BA'][0][3] = 59;
$array['BA'][0][4] = 50;
$array['CA'][0][0] = 18;
$array['CA'][0][1] = 17;
$array['CA'][0][2] = 45;
$array['CA'][0][3] = 49;
$array['CA'][0][4] = 82;
$array['BA'][1][0] = 6;
$array['BA'][1][1] = 66;
$array['BA'][1][2] = 1;
$array['BA'][1][3] = 16;
$array['BA'][1][4] = 48;
$array['CA'][1][0] = 48;
$array['CA'][1][1] = 60;
$array['CA'][1][2] = 32;
$array['CA'][1][3] = 50;
$array['CA'][1][4] = 80;

我知道我可以使用preg_split('/''s+/',$list);创建阵列,但如何从该列表中创建三维阵列?

感谢您的帮助

试试这样的东西:

更新了代码,以便您也可以加载文件,因为您有内存问题。考虑一下:如果加载的数据量已经造成内存问题,那么最终的结果,数组,也可能产生内存问题!因为这是更多的数据!

因此,这将按行读取,因此不会直接将整个文件加载到内存中。但是,由于内存问题,您可能不应该写入数组,而应该写入数据库。否则,内存问题将不断出现。

<?PHP
/*
 * Example when small amount of data is in a string
 */
/*
//your input
$str='1945/01/05 BA 87 34 1 59 50
1945/01/05 CA 18 17 45 49 82
1945/01/13 BA 6 66 1 16 48
1945/01/13 CA 40 60 32 50 80';
//we work per line
$lines=explode("'n", $str);
//loop each line
foreach($lines AS $line) {
*/
/*
 * Example when big amount of data is in a file
 */
//this will contain the end result
$result=array();
$filename='lines.txt'; //contains the data like in your question
$fp = fopen($filename,'r');
while($line=fgets($fp)) {
    //explode each line on space so we get the different fields
    $fields=explode(' ', $line);
    //we remove the date, not needed
    unset($fields[0]);
    //we get the key (BA/CA/etc) and remove it also
    $key=$fields[1];
    unset($fields[1]);
    //we write the result to the array
    //using array_values so the indexes are from 0-4 again
    //because we removed items
    $result[$key][]=array_values($fields);
}

fclose($fp);
//show the result in html
echo '<pre>';
print_r($result);

这个问题改变了

这确实回答了评论中提出的问题,而不是实际问题。

<?PHP
/*
 * Example when big amount of data is in a file
 */
//this will contain the end result
$result=array();
$filename='lines.txt'; //contains the data like in your question
$fp = fopen($filename,'r');
while($line=fgets($fp)) {
    //explode each line on space so we get the different fields
    $fields=explode(' ', $line);
    //we remove the date, not needed
    unset($fields[0]);
    //we get the key (BA/CA/etc) and remove it also
    $key=$fields[1];
    unset($fields[1]);
    //We start counting the numbers
    foreach($fields AS $nr) {
        $nr=trim($nr);
        if(empty($result[$key][$nr])) {
            $result[$key][$nr]=1;
        }else{
            $result[$key][$nr]++;
        }
    }
}

fclose($fp);
//show the result in html
echo '<pre>';
print_r($result);
<?php
$a = '1945/01/05 BA 87 34 1 59 50
1945/01/05 CA 18 17 45 49 82
1945/01/13 BA 6 66 1 16 48
1945/01/13 CA 40 60 32 50 80';
$array = array();
$list = explode("'n", $a);
echo '<pre>';
print_r($list);
echo '</pre>';
$first_index = 0;
$counter = 0;
foreach($list as $key=>$value) {
    if($counter >=2) {
        $first_index++;
        $counter= 0;
    }
    $row = explode(" ",$value);
    $k = $row[1];
    for($i=2; $i< count($row); $i++) {      
        $array[$k][$first_index][] = $row[$i];          
    }
    $counter++;
}
echo '<pre>';
print_r($array);
echo '</pre>';
?>