_XMLGetValue ( xml ; xpath )

Used to return the value of the xml node specified by the xpath parameter.

Average rating: 4.0 (50 votes) Log in to vote

Micah Woods - Show more from this author
Scodigo, Inc.
http://www.scodigo.com

Sample input:

_XMLGetValue ( "FredFlintstone" ; "/xml/LastName" )

Sample output:

Flintstone

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
NAME:
_XMLGetValue

HISTORY:
Created: 17-APR-2007 by Micah Woods (based on previous work by James Stewart)

PURPOSE:
Used to return the value of the xml node specified by the xpath parameter.

PARAMETERS:
xml; xpath

NOTES:
This function will ONLY return a value if there are no errors and valid results.
Use the $_lastCFError, $_lastCFWarning and $_lastCFLog variables to check for 
errors, warnings and log info.

POSSIBLE ERRORS:
1 Couldn't load xml (check that you've supplied valid xml)
2 Couldn't create DOMXpath (not likely to occur but just in case)
3 Invalid expression (check your xpath expression)

POSSIBLE WARNINGS:
4 No value was found for this xpath expression (not necessarily an error but you should know that nothing was found based on the supplied expression)
*/

Let (
    [
        $xml = xml ;
        $xpath = xpath ;
        phpCode =
"
// report all errors¶
error_reporting(E_ALL);¶
¶
// initialize CF vars (used to store error, warning and log info from the last executed CF)¶
fm_evaluate('Let ( $_lastCFError = 0 ; $_lastCFError )');¶
fm_evaluate('Let ( $_lastCFWarning = 0 ; $_lastCFWarning )');¶
fm_evaluate('Let ( $_lastCFLog = \"\" ; $_lastCFLog )');¶
¶
// get params from FileMaker¶
$xml = fm_evaluate('$xml');¶
$xpath = fm_evaluate('$xpath');¶
¶
// add xml declaration if not included¶
if (substr($xml, 0, 2) <> '<?') {¶
  $xml = \"<?xml version=\\\"1.0\\\" encoding=\\\"ISO-8859-1\\\"?>\n\" . $xml;¶
}¶
¶
// create a DOMDocument and load the supplied xml (the @ symbol suppresses errors from output)¶
$dom = @DOMDocument::loadXML($xml);¶
¶
// error creating the DOMDocument?¶
if (!$dom instanceof DOMDocument) {¶
  $last_error = error_get_last();¶
  fm_evaluate('Let ( $_lastCFError = 1 ; \"\" )');¶
  fm_evaluate('Let ( $_lastCFLog = \"Couldn\'t load xml (check that you\'ve supplied valid xml). ' . $last_error[\"message\"] . '\" ; \"\" )');¶
  exit;¶
}¶
¶
// create a DOMXPath object¶
try {¶
  $xp = new DOMXPath($dom);¶
} catch (DOMException $e) {¶
  fm_evaluate('Let ( $_lastCFError = 2 ; \"\" )');¶
  fm_evaluate('Let ( $_lastCFLog = \"Couldn\'t create DOMXPath. ' . $e . '\" ; \"\" )');¶
  exit;¶
}¶
¶
// evaluate the xpath expression and return the results¶
$var = @$xp->evaluate($xpath);¶
¶
if (!$var instanceof DOMNodeList) {  ¶
  $last_error = error_get_last();¶
  fm_evaluate('Let ( $_lastCFError = 3 ; \"\" )');¶
  fm_evaluate('Let ( $_lastCFLog = \"' . $last_error[\"message\"] . ' (check your xpath expression).\" ; \"\" )');¶
} else {¶
  $value = @$var->item(0)->nodeValue;¶
  $last_error = error_get_last();¶
  if ($last_error) {¶
    fm_evaluate('Let ( $_lastCFWarning = 4 ; \"\" )');¶
    fm_evaluate('Let ( $_lastCFLog = \"No value was found for this xpath expression.\" ; \"\" )');¶
    exit;¶
  }¶
  echo $value;¶
}"
    ] ;
        PHP_Execute ( phpCode )
)

XPath is a very powerful tool for finding information in an XML document. This function uses PHP code via SmartPill to allow you to use XPath expressions for parsing out values stored in an XML string. If you'd like to know more about XPath, there's a good tutorial here: http://www.w3schools.com/xpath/default.asp.

Comments

		bing, zhengzhou Oct 20, 2014
PHP_Execute ( phpCode )ï¼Ÿï¼Ÿï¼Ÿï¼Ÿï¼Ÿis

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

_XMLGetValue ( xml ; xpath )

Comments

Support this website.

Support this website.