sql - Reading a text file with specific code tag information in php

one text

Solution:

First you have to read a file with file methods in php and than you can get a specific column name and it's value by below way

First read a single line from a file and than use a explode method to break that line into different elements with space delimitation.

$columns = explode(' ', $line_variable);

After generating columns I can see that each key values are delimited by ^ (cap) symbol so for that also we can use the explode method.

$newColumn =[];
foreach($columns as $column){
    $splited = explode('^', $column);
    $newColumn[][$splited[0]] = $splited[1];
}

print_r($newColumn);

This is just to give you an idea that how you can achieve your task but rest is completely dependent on you.