[RESOLVED] match string pattern..

ajd335

hey all,

my $shipping->_xml_response contains , the below string

<?xml version="1.0"?><RatingServiceSelectionResponse><Response><TransactionReference><CustomerContext> Shipping</CustomerContext><XpciVersion>1.0001</XpciVersion></TransactionReference><ResponseStatusCode>1</ResponseStatusCode><ResponseStatusDescription>Success</ResponseStatusDescription></Response><RatedShipment><Service><Code>03</Code></Service><RatedShipmentWarning>Your invoice may vary from the displayed reference rates</RatedShipmentWarning><BillingWeight><UnitOfMeasurement><Code>LBS</Code></UnitOfMeasurement><Weight>36.0</Weight></BillingWeight><TransportationCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>31.14</MonetaryValue></TransportationCharges><ServiceOptionsCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>0.00</MonetaryValue></ServiceOptionsCharges><TotalCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>31.14</MonetaryValue></TotalCharges><GuaranteedDaysToDelivery></GuaranteedDaysToDelivery><ScheduledDeliveryTime></ScheduledDeliveryTime><RatedPackage><TransportationCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>31.14</MonetaryValue></TransportationCharges><ServiceOptionsCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>0.00</MonetaryValue></ServiceOptionsCharges><TotalCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>31.14</MonetaryValue></TotalCharges><Weight>36.0</Weight><BillingWeight><UnitOfMeasurement><Code>LBS</Code></UnitOfMeasurement><Weight>36.0</Weight></BillingWeight></RatedPackage></RatedShipment></RatingServiceSelectionResponse>

I want to store the value of
<TotalCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>31.14</MonetaryValue></TotalCharges>
value of MonetaryValue field which is 31.14 in one variable..
How can i use preg_match or ereg here ???
i tried out ,,

$str = $shipping->_xml_response ;
echo $str;
$var = preg_match("/<TotalCharges><CurrencyCode>USD<"/"CurrencyCode><MonetaryValue>(.*)<"/"MonetaryValue><
"/"TotalCharges>/",$str,$matches);
echo htmlentities($matches['0']);

but above dint work...

Weedpacket

Instead of using regular expression functions to work with XML, why not use XML functions to work with XML. Say...

$xml = new DomDocument;
$xml->loadXML('<?xml version="1.0"?>..........');


$xpath = new DomXPath($xml);
$monetary_values = array();
foreach($xpath->query('//TotalCharges/MonetaryValue/text()') as $node)
	$monetary_values[] = $node->wholeText;

var_dump($monetary_values);

There are two TotalCharges/MonetaryValue nodes in the XML you supplied. I couldn't tell which one you wanted, so I built an array containing all of them.

But you have to admit "//TotalCharges/MonetaryValue/text()" is much easier to read than the regular expression (even if it did parse, which it wouldn't, because you haven't escaped the forward slashes correctly - and even then it would need more work).

ajd335

Weedpacket wrote:
Instead of using regular expression functions to work with XML, why not use XML functions to work with XML. Say...
$xml = new DomDocument;
$xml->loadXML('<?xml version="1.0"?>..........');


$xpath = new DomXPath($xml);
$monetary_values = array();
foreach($xpath->query('//TotalCharges/MonetaryValue/text()') as $node)
	$monetary_values[] = $node->wholeText;

var_dump($monetary_values);
There are two TotalCharges/MonetaryValue nodes in the XML you supplied. I couldn't tell which one you wanted, so I built an array containing all of them.

But you have to admit "//TotalCharges/MonetaryValue/text()" is much easier to read than the regular expression (even if it did parse, which it wouldn't, because you haven't escaped the forward slashes correctly - and even then it would need more work).

Hi ,
Thanks for the replay...I tried out the below code , as u have suggested , but dint give me any answer ,
Actually i have a php page in which i have written the XML code , which is my request to one of the UPS API , and then i got response from them , which is stored in Shipping->_xml_response (//shipping is one object of the class which i have made)

And I want the value of the MonetaryValue , which comes under TotalCharges array..
I have used the following

$xml =new DomDocument;
$xml->LoadXML($shipping->_xml_response);
$xpath = new DomXPath($xml);
$monetary_values =array();
foreach($xpath->query('//TotalCharges/MonetaryValue/text()') as $node
$monetary_values[] = $node->wholeText;
var_dump($monetary_values);

can u please , tell me where I am going wrong ..?

ajd335

Hey all....

I have a string response from the API , is XML response..
the response is as below

<?xml version="1.0"?><RatingServiceSelectionResponse><Response><TransactionReference><CustomerContext> Shipping</CustomerContext><XpciVersion>1.0001</XpciVersion></TransactionReference><ResponseStatusCode>1</ResponseStatusCode><ResponseStatusDescription>Success</ResponseStatusDescription></Response><RatedShipment><Service><Code>03</Code></Service><RatedShipmentWarning>Your invoice may vary from the displayed reference rates</RatedShipmentWarning><BillingWeight><UnitOfMeasurement><Code>LBS</Code></UnitOfMeasurement><Weight>36.0</Weight></BillingWeight><TransportationCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>31.14</MonetaryValue></TransportationCharges><ServiceOptionsCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>0.00</MonetaryValue></ServiceOptionsCharges><TotalCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>31.14</MonetaryValue></TotalCharges><GuaranteedDaysToDelivery></GuaranteedDaysToDelivery><ScheduledDeliveryTime></ScheduledDeliveryTime><RatedPackage><TransportationCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>31.14</MonetaryValue></TransportationCharges><ServiceOptionsCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>0.00</MonetaryValue></ServiceOptionsCharges><TotalCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>31.14</MonetaryValue></TotalCharges><Weight>36.0</Weight><BillingWeight><UnitOfMeasurement><Code>LBS</Code></UnitOfMeasurement><Weight>36.0</Weight></BillingWeight></RatedPackage></RatedShipment></RatingServiceSelectionResponse>

I wanted to save the value of
<TotalCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>31.14</MonetaryValue></TotalCharges>
the value of monetaryvalue ( that of TotalCharges array) field which is 31.14 .

I tried out the below regular-exp..

      $str = $shipping->_xml_response;
      $var = preg_match("/<TotalCharges><CurrencyCode>USD<\/CurrencyCode><MonetaryValue>(.*)<\/MonetaryValue>/",$str,$matches);
      if($var == true){
      echo $matches[0];}else echo "no match";

and the o/p from that is USD31.14USD31.14USD0.00USD31.14
But i want just 31.14(that may be different e'time) which is declared last(not the first 31.14,not the second 0.00 , but the last 31.14)....how can i do so??