Online PHP editor | refs for NIPRE

<?php $db = 'id|name_sname|identity|address|region|hours|destination|price; -------------------------------------------------------------------- 1|Ezra Mod|123456789|husi, stanilesti, vaslui|HUSI - IASI|20:00|HUSI|100; 2|Ezra Mod|123456789|husi, stanilesti, vaslui|HUSI - IASI|20:00|HUSI|100; 3|Ezra Mod|123456789|husi, stanilesti, vaslui|HUSI - IASI|20:00|HUSI|100; 4|Ezra Mod|123456789|husi, stanilesti, vaslui|HUSI - IASI|20:00|HUSI|100; 5|Ezra Mod|123456789|husi, stanilesti, vaslui|HUSI - IASI|20:00|HUSI|100; 6|Ezra Mod|123456789|husi, stanilesti, vaslui|HUSI - IASI|20:00|HUSI|100;'; $lines = explode(PHP_EOL, $db); foreach($lines as $key => $line){ $convert = explode("|", $line); //create array separate by new line if($key == 0) { foreach($convert as $column_name) { $columns[] = $column_name; } } if(is_numeric($convert[0])) { $data[$columns[0]][] = $convert[0]; } } print_r($data);