Online PHP editor | output for Itvnr

@ 2020-01-28T11:51:45Z

<?php

$labels = [
["EY>Yes","Media Type>Category B","Coverage Type>Quote","Industry Programs>Communications","Score>1"],
["EY>No","Media Type>Category B2","Coverage Type>Quote2","Industry Programs>Communications2","Score>2"],
]; 
$i = 0;

foreach($labels[0] as $ind=>$label){
    
        $letter = range('A', 'Z')[$ind];
        $tmp = explode('>',$label); 
        $col_names[] = $tmp[0];
        echo $letter.'1'."\r\n";
        //$objPHPExcel->getActiveSheet()->setCellValue($letter.'1',$tmp[0]); 
        echo "Column -> $tmp[0] \r\n"; 
}
    echo "\r\n\r\n";

// print_r($col_names);  // column names
/*
(
    [0] => EY
    [1] => Media Type
    [2] => Coverage Type
    [3] => Industry Programs
    [4] => Score
)
*/


foreach ($labels as $ind=>$item){
    
        $index = $ind + 2;
        
    foreach($item as $ind2=>$data){
         
        $letter = range('A', 'Z')[$ind2];
        
        echo "$letter$index \r\n";
        
        $val = explode('>',$data);
         
        //$objPHPExcel->getActiveSheet()->setCellValue("$letter$index",$val[1]);
        echo "Value at $index -> $val[1] \r\n\r\n";
    }
    echo "\r\n\r\n";
}

Output for 7.2.0 - 7.2.34, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.19, 8.3.0 - 8.3.4, 8.3.6 - 8.3.7: A1 Column -> EY B1 Column -> Media Type C1 Column -> Coverage Type D1 Column -> Industry Programs E1 Column -> Score A2 Value at 2 -> Yes B2 Value at 2 -> Category B C2 Value at 2 -> Quote D2 Value at 2 -> Communications E2 Value at 2 -> 1 A3 Value at 3 -> No B3 Value at 3 -> Category B2 C3 Value at 3 -> Quote2 D3 Value at 3 -> Communications2 E3 Value at 3 -> 2
Output for 8.3.5: Warning: PHP Startup: Unable to load dynamic library 'sodium.so' (tried: /usr/lib/php/8.3.5/modules/sodium.so (libsodium.so.23: cannot open shared object file: No such file or directory), /usr/lib/php/8.3.5/modules/sodium.so.so (/usr/lib/php/8.3.5/modules/sodium.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0 A1 Column -> EY B1 Column -> Media Type C1 Column -> Coverage Type D1 Column -> Industry Programs E1 Column -> Score A2 Value at 2 -> Yes B2 Value at 2 -> Category B C2 Value at 2 -> Quote D2 Value at 2 -> Communications E2 Value at 2 -> 1 A3 Value at 3 -> No B3 Value at 3 -> Category B2 C3 Value at 3 -> Quote2 D3 Value at 3 -> Communications2 E3 Value at 3 -> 2

preferences:dark modelive preview