preg_match "field=value" pairs

[ahayes1ic]

I am designing a script to interpret the results returned from a payment gateway.

The returned information is in the form of a text string with the information I require forming part of the string in a field=value pairs.

I cannot seem to come up with an expression to effectively extract these pairs to an array. Ideally I would like to put these values into an associative array (array[field]=value). If possible extracting the information above the pairs as form of receipt.

Here is an example of the string I am dealing with -

declined 00015X366539 Transaction No: 00xxxxxx ------------------------ COUNTRY CODE AU 14/11/07 23:51 RRN 00015X366539 VISA XXXXXXXXXXX CREDIT A/C 11/07 AUTHORISATION NO: DECLINED 31 PURCHASE $155.00 TOTAL AUD $155.00 (SUBJECT TO CARDHOLDER'S ACCEPTANCE) ------------------------ . settlement_date=15/11/07 card_desc=VISA status=declined txn_ref=XXXXXXXXXXXXXXX refund_mode=0 transaction_no=XXXXXXX rrn=00015X366539 response_text=INVALID CARD pld=0 total_amount=15500 card_no=XXXXXXXXXXX version=V1.0 merchant_index=1096 card_expiry=xx/xx training_mode=0 operator_no=xxxxxxx response_code=31 card_type=6 approved=0 cashout_amount=0 receipt_array=ARRAY(0x834f8ac) account_type=CREDIT A/C result=0

Can anyone help with this?

Cheers

[jkurrle]

You might want to consider using explode() multiple times instead of preg_match. By creatively using recurring text fields as separating delimiters, you might be able to parse data out into an array.

[Weedpacket]

preg_split('/ (?=\w+=)/', $string) was the first thing that sprang to mind for me.

[jkurrle]

$parse=explode("- . ",$body);
$pairs=explode(" ",$parse[1]);
$keyed_array=array();
foreach($pairs as $pair)
  {
  $split=explode("=",$pair);
  array_push($keyed_array,$split[0] => $split[1]);
  }

or something like that...

[Weedpacket]

jkurrle wrote:

$pairs=explode(" ",$parse[1]);

The values can contain spaces....

[jkurrle]

No biggie. It can be slightly altered as follows:

$parse=explode("- . ",$body); 
$pairs=explode(" ",$parse[1]); 
$keyed_array=array(); 
foreach($pairs as $pair) 
  { 
  $split=explode("=",$pair); 
  if($split[1]=="")
    {
    $count=count($key_array)-1;
    $keyed_array[$count]=$keyed_array[$count] . " " . $pair;
    }
  else array_push($keyed_array,$split[0] => $split[1]); 
  } 

It will then append any orphaned data back to the previous array item.

[ahayes1ic]

I have been offered this solution -

 <?php
function extract_transaction_details($response){
//      First we assume that all valid keys are:  [a-z_]+=
//      Becuase I suck at regular expressions, we will just `split`
//      the string on that pattern, causing each key-value-pair to
//      be on it's own line (which make it's really easy to work with)

   $split_response = preg_replace("#([a-z_]+=)#", "\n\\1", $response) . "\n";

//      Now its just a matter of a simple regex:  {$key}={$value}\n
if(preg_match_all("#([a-z_]+)=([^\n]+)\n#i", $split_response, $matches, PREG_SET_ORDER) == 0){
         return false;

    }
//      Now turn the $matches array into a dictionary.  $match[0] contains
//      the entire expressions, $match[1] the key, and $match[2] the value

    $dict = array();


foreach($matches as $match){
      $dict[$match[1]] = $match[2];
        }
       return $dict;
}

$t = "declined 00015X366539 Transaction No: 00xxxxxx ------------------------ COUNTRY CODE AU 14/11/07 23:51 RRN 00015X366539 VISA XXXXXXXXXXX CREDIT A/C 11/07 AUTHORISATION NO: DECLINED 31 PURCHASE $155.00 TOTAL AUD $155.00 (SUBJECT TO CARDHOLDER'S ACCEPTANCE) ------------------------ . settlement_date=15/11/07 card_desc=VISA status=declined txn_ref=XXXXXXXXXXXXXXX refund_mode=0 transaction_no=XXXXXXX rrn=00015X366539 response_text=INVALID CARD pld=0 total_amount=15500 card_no=XXXXXXXXXXX version=V1.0 merchant_index=1096 card_expiry=xx/xx training_mode=0 operator_no=xxxxxxx response_code=31 card_type=6 approved=0 cashout_amount=0 receipt_array=ARRAY(0x834f8ac) account_type=CREDIT A/C result=0";

 print_r(extract_transaction_details($t));
?>

Output:

Array
(
    [settlement_date] => 15/11/07
    [card_desc] => VISA
    [status] => declined
    [txn_ref] => XXXXXXXXXXXXXXX
    [refund_mode] => 0
    [transaction_no] => XXXXXXX
    [rrn] => 00015X366539
    [response_text] => INVALID CARD
    [pld] => 0
    [total_amount] => 15500
    [card_no] => XXXXXXXXXXX
    [version] => V1.0
    [merchant_index] => 1096
    [card_expiry] => xx/xx
    [training_mode] => 0
    [operator_no] => xxxxxxx
    [response_code] => 31
    [card_type] => 6
    [approved] => 0
    [cashout_amount] => 0
    [receipt_array] => ARRAY(0x834f8ac)
    [account_type] => CREDIT A/C
    [result] => 0
)

I suspect it can be done in many ways.

[Weedpacket]

ahayes1ic wrote:

I suspect it can be done in many ways.

Using my suggestion gives

function extract_transaction_details($t)
{

$lines = preg_split('/ (?=\w+=)/', $t);

$header = array_shift($lines); // In case you want that.

$dump = array();
foreach($lines as $line)
{
	list($key,$val) = explode('=', $line);
	$dump[$key] = $val;
}
return $dump;
}

But really that is a nasty format; it's like a flashback to the early 1980s. Couldn't the fields at least be on separate lines?!

[jkurrle]

Ooooh! I like how you use list() I'll have to remember that one!

[ahayes1ic]

Weedpacket wrote:

But really that is a nasty format; it's like a flashback to the early 1980s. Couldn't the fields at least be on separate lines?!

Unfortunately the reply string is generated from a perl script on the payment gateway that I cannot edit to return a more user friendly response.

[Weedpacket]

jkurrle wrote:

Ooooh! I like how you use list() I'll have to remember that one!

You might be amused by what I actually wrote first time around, before deciding I was being a bit too clever:

$keys = $vals = array();
foreach($lines as $line)
{
    list($keys[],$vals[]) = explode('=', $line);
}
$dump = array_combine($keys,$vals);