bash awk - need associative array output from a php script -


i have php script responsible returning names , associated id's database:

//general array structure is: $array = array(     "name1" => 001,     "name2" => 002,     ... ); return $array; 

i have awk code needs have access array, , turn map. php script can modified accommodate this. awk script:

//awk: system("/usr/bin/php /path/to/script/query_db.php")  //query_db.php: echo implode(' ', $results); 

what don't know how make array in awk, given above. echoes values returned php script's array, , elides keys.

keep simple. php use loop dump array:

<?php foreach ($array $k=>$v) echo "$k=$v\n"; ?> 

output:

name1=1 name2=2 

now in awk use = field separator , populate associative array:

php -s arr.php | awk -f= '{arr[$1]=$2} end{for (i in arr) print i, a[i]}' 

Comments