Online PHP editor | refs for Xhr68

<?php $database = 'id|name_sname|identity|address|region|hours|destination|price; -------------------------------------------------------------------- 1|Test Mod|123456789|husi, stanilesti, vaslui|HUSI - IASI|20:00|HUSI|100; 2|Jhon Doe|123456789|husi, stanilesti, vaslui|HUSI - IASI|20:00|HUSI|100; 3|Himel Rana|123456789|husi, stanilesti, vaslui|HUSI - IASI|20:00|HUSI|100; 4|Ezra Mod|123456789|husi, stanilesti, vaslui|HUSI - IASI|20:00|HUSI|100; 5|Keven Korp|123456789|husi, stanilesti, vaslui|HUSI - IASI|20:00|HUSI|100; 6|Tamim Iqbal|123456789|husi, stanilesti, vaslui|HUSI - IASI|20:00|HUSI|100;'; //$data = file_get_contents("database.txt"); //read the file $rows = explode("\n", $database); //create array separate by new line $rows = array_map("trim", $rows); // for removing any unwanted space $rowCount = count($rows); // Count your database rows function CountCol($data){ $col = explode("|", $data); return count($col); } // Creating array from our text database // in our database first two rows are not needed so I am skipig this // by using i = 2 // and $rowCount -1 because of our array start from 0 but count start from 1 // adding $id[$i-2] and like other because of we have started our first loop from 2 and I want to // create my new array starting from 0 . for ($i=2; $i <$rowCount-1 ; $i++) { for ($j=0; $j < CountCol($rows[$i]) ; $j++) { $column = explode("|", $rows[$i]); $id[$i-2] = $column[0]; $name_sname[$i-2] = $column[1]; $identity[$i-2] = $column[2]; $address[$i-2] = $column[3]; $region[$i-2] = $column[4]; $hours[$i-2] = $column[5]; $destination[$i-2] = $column[6]; $price[$i-2] = $column[7]; } } // let's print our data // I am using 3 here because of we have no need first 2 rows and our array start from 0 for ($i=0; $i < $rowCount-3 ; $i++) { echo "ID: ".$id[$i] ."\r\n"; echo "name_sname: ".$name_sname[$i]."\r\n"; echo "identity: ".$identity[$i] ."\r\n"; echo "address: ".$address[$i] ."\r\n"; echo "region: ".$region[$i] ."\r\n"; echo "hours: ".$hours[$i] ."\r\n"; echo "destination: ".$destination[$i] ."\r\n"; echo "price: ".$price[$i] ."\r\n"; } // // get it like below echo "printing information using id number \r\n"; echo $name_sname[0]; // here 0 is row number or id number echo "\r\n"; echo $name_sname[1];// here 1 is row number or id number echo "\r\n"; echo $id[0]; ?>