php.ComLanka.com PHP Tutorial ,PHP source code, PHP online example

Algorithms Arrays Passwords Uncategorized
Commerce Uncategorized
Databases Abstraction Layers Informix LDAP MS SQL MySQL ODBC PostgreSQL Uncategorized
Date & Time Calculators Conversion Translation Uncategorized
Discussion Chat Forums Guestbooks Polls Uncategorized
Email Validation Uncategorized
External Uncategorized
Files and Directories Uncategorized
Games Uncategorized
Graphics 3-D Graphs Resizing Thumbnails Uncategorized
HTML Forms Menus & Navigation Source Viewers Tables Templates Uncategorized
HTTP Authentication Cookies File Uploading Uncategorized
I18N Uncategorized
Math Uncategorized
Miscellaneous Uncategorized
Searching and Trees Uncategorized
Security Uncategorized
Text Uncategorized
Utilities Calendars Counters Link Checkers Weather Uncategorized
XML Uncategorized

php sample source codes
Parses Amazon's XML response (Web Service) <?php /* - AmazonLiteXMLParser ver 0.9.0 Author: Daniel Kushner Email: daniel@amazonlite.com Release: 20 July, 2002 http://www.amazonlite.com/ */ define('AMAZON_FIELD_TYPE_SINGLE', 1); define('AMAZON_FIELD_TYPE_ARRAY', 2); define('AMAZON_FIELD_TYPE_CONTAINER', 3); class AmazonLiteXMLParser { var $parser; var $record; var $currentField = ''; var $fieldType; var $endsRecord; var $errorRecord; var $errorMsg; var $records; var $wroteElementData = false; function AmazonLiteXMLParser($xml) { $xml = preg_replace(array('/&amp;/', '/<p>/i', '/<b>/i', '/\'/', '/\<br\>/i', '/&/'), array('and', '', '', '', ''), trim($xml)); $this->records = array(); $this->parser = xml_parser_create(); xml_set_object($this->parser, $this); xml_set_element_handler($this->parser, 'startElement', 'EndElement'); xml_set_character_data_handler($this->parser, 'cdata'); $this->fieldType = array('errormsg' => AMAZON_FIELD_TYPE_SINGLE, 'title' => AMAZON_FIELD_TYPE_SINGLE, 'authors' => AMAZON_FIELD_TYPE_CONTAINER, 'author' => AMAZON_FIELD_TYPE_ARRAY, 'asin' => AMAZON_FIELD_TYPE_SINGLE, 'isbn' => AMAZON_FIELD_TYPE_SINGLE, 'media' => AMAZON_FIELD_TYPE_SINGLE, 'productname' => AMAZON_FIELD_TYPE_SINGLE, 'catalog' => AMAZON_FIELD_TYPE_SINGLE, 'releasedate' => AMAZON_FIELD_TYPE_SINGLE, 'manufacturer' => AMAZON_FIELD_TYPE_SINGLE, 'imageurlsmall' => AMAZON_FIELD_TYPE_SINGLE, 'imageurlmedium' => AMAZON_FIELD_TYPE_SINGLE, 'imageurllarge' => AMAZON_FIELD_TYPE_SINGLE, 'listprice' => AMAZON_FIELD_TYPE_SINGLE, 'ourprice' => AMAZON_FIELD_TYPE_SINGLE, 'usedprice' => AMAZON_FIELD_TYPE_SINGLE, 'salesrank' => AMAZON_FIELD_TYPE_SINGLE, 'media' => AMAZON_FIELD_TYPE_SINGLE, 'nummedia' => AMAZON_FIELD_TYPE_SINGLE, 'availability' => AMAZON_FIELD_TYPE_SINGLE, 'avgcustomerrating' => AMAZON_FIELD_TYPE_SINGLE, 'rating' => AMAZON_FIELD_TYPE_ARRAY, 'summary' => AMAZON_FIELD_TYPE_ARRAY, 'comment' => AMAZON_FIELD_TYPE_ARRAY, 'product' => AMAZON_FIELD_TYPE_ARRAY, ); $this->endsRecord = array('details' => true); $this->errorRecord = array('errormsg' => true); xml_parse($this->parser, $xml); xml_parser_free($this->parser); } function startElement($p, $element, &$attributes) { $element =strtolower($element); if(isset($attributes['URL'])) { $this->record['url'] = $attributes['URL']; } if(isset($this->fieldType[$element])) { $this->currentField = $element; } else { $this->currentField = ''; } $this->wroteElementData = false; } function endElement($p, $element) { $element =strtolower($element); if(isset($this->endsRecord[$element])) { $this->records[] = $this->record; $this->record = array(); } $this->currentField = ''; } function cdata($p, $text) { $text = preg_replace('/lt;([a-z]+\>)/i', '<\\1', $text); if(isset($this->errorRecord[$this->currentField])) { $this->errorMsg = $text; } if(@$this->fieldType[$this->currentField] === AMAZON_FIELD_TYPE_CONTAINER) { } elseif(@$this->fieldType[$this->currentField] === AMAZON_FIELD_TYPE_ARRAY) { $lastIndex = @count($this->record[$this->currentField]) - 1; $this->wroteElementData ? @$this->record[$this->currentField][$lastIndex] .= $text : @$this->record[$this->currentField][$lastIndex+1] = $text ; } elseif(@$this->fieldType[$this->currentField] === AMAZON_FIELD_TYPE_SINGLE) { @$this->record[$this->currentField] .= $text; } $this->wroteElementData = true; } } ?>
This code is application server that allows to display and edit database table contents with native Borland Delphi components using SOAP. <?php /* This code is application server that allows to display and edit database table contents with native Borland Delphi components using SOAP. 1. Your must have XML-RPC and DOMXML extesions installed on your Web server 2. Grab latest ADODB library from http://php.weblogs.com and install it. 3. Edit database connection properties with your values 4. Open Borland Delphi 7 IDE and create new application 5. Place TSOAPConnection, TClientDataset, TDatasource, TDBGrid components on to the main form 6. Set TSOAPConnection "URL" property to URL to this file on your server, set TSOAPConnection "UseSOAPAdapter" property to false and "Connected" property to true 7. Set TClientDataset "RemoteProvider" property to name of TSOAPConnection component instanse name, "ProviderName" to any value, "Active" property to true 8. Set TDataSource "Dataset" property to name of TClientDataset instanse, "Active" propery to true 9. Set TDBGrid "DataSource" property to name of TDataSource instance name. Your should see now contents of the database table in grid. 10. Compile and run application. To apply updates to server your must call ApplyUpdates method of the TClientDataset This code is ALPHA release. Any suggestions is wellcome. This code is under GPL Author: Denis O.Philippov <denis at atlant dot ru> */ include "adodb.inc.php"; $ado2midas = array( C => "string", X => "bin.hex", N => "r8", I => "i", R => "+", B => "bin.hex" ); $ADODB_FETCH_MODE = 2; $conn = &AdonewConnection("mysql"); $conn -> pconnect("host", "user", "pass", "databasename"); $tablename = "tablename"; $HTTP_RAW_POST_DATA = str_replace("base64Binary", "string", $HTTP_RAW_POST_DATA); $s = xmlrpc_server_create(); xmlrpc_server_register_method($s,'AS_GetRecords', 'AS_GetRecords'); xmlrpc_server_register_method($s,'AS_ApplyUpdates', 'AS_ApplyUpdates'); $out=xmlrpc_server_call_method($s, $HTTP_RAW_POST_DATA, $response, $output_options = array( "output_type" => "xml", "verbosity" => "no_white_space", "escaping" => array("markup", "non-ascii", "non-print"), "version" => "soap 1.1", "encoding" => "utf-8" ) ); echo str_replace(array("<item>","</item>"), "", $out); function getdatapacket($sql){ global $conn, $ado2midas; if($rs = ($conn ->execute($sql))){ $doc = domxml_open_mem('<?xml version="1.0" encoding="UTF-8" standalone="yes"?><DATAPACKET Version="2.0"></DATAPACKET>'); $datapacket = $doc->document_element(); $metadata = $doc -> create_element("METADATA"); $metadata = $datapacket -> append_child($metadata); $fields = $doc -> create_element("FIELDS"); $fields = $metadata -> append_child($fields); $fieldcount = $rs -> FieldCount( ); for($i=0; $i < $fieldcount; $i++) { $_fld = $rs -> Fetchfield($i); $type = $rs -> metatype($_fld ->type); $types[$i] = $_fld; $metatype[$i] = $type; $field = $doc -> create_element("FIELD"); $field = $fields -> append_child($field); $field -> set_attribute("attrname", $_fld -> name); $field -> set_attribute("fieldtype", $ado2midas[$type]); if($type == "C" || $type == "X" || $type == "B"){ $field -> set_attribute("WIDTH", $_fld -> max_length); } if($type == "X"){ $field -> set_attribute("SUBTYPE", "Text"); }elseif($type == "B"){ $field -> set_attribute("SUBTYPE", "Graphics"); } } $params = $doc -> create_element("PARAMS"); $params = $metadata -> append_child($params); $rowdata = $doc -> create_element("ROWDATA"); $rowdata = $datapacket -> append_child($rowdata); while($rw = $rs -> fetchrow()){ $row = $doc -> create_element("ROW"); $row = $rowdata -> append_child($row); for($i=0; $i< $fieldcount; $i++){ if($metatype[$i] == "X "|| $metatype[$i] == "B"){ $row -> set_attribute($types[$i] -> name, base64_encode($rw[$types[$i] -> name])); }else{ $row -> set_attribute($types[$i] -> name, iconv("windows-1251", "UTF-8", $rw[$types[$i] -> name])); } } } $ret->RecsOut = $rs -> RecordCount( ); $ret->return = $doc->dump_mem(false, "UTF-8"); return $ret; }else{ return false; } } function AS_GetRecords($method, $params){ global $conn, $tablename; $providername = $params[ProviderName]; $count = $params["Count"]; $options = $params[Option]; $commandtext = $params[CommandText]; $params = $params[Params]; $ownerdata = $params[OwnerData]; $_ret = getdatapacket("select * from $tablename"); xmlrpc_set_type(&$_ret->return, "base64"); return array( "Params" => $params, "OwnerData" => $ownerdata, "RecsOut" => $_ret -> RecsOut, "return" => $_ret->return); } function AS_ApplyUpdates($method, $params){ global $conn, $ado2midas, $tablename; $ProviderName = &$params[ProviderName]; $Delta = &$params[Delta]; $MaxErrors = &$params[MaxErrors]; $OwnerData = &$params[OwnerData]; $errorcount = 0; $Delta = base64_decode($Delta); $Delta = str_replace('<?xml version="1.0" standalone="yes"?>', '<?xml version="1.0" encoding="ISO-8859-1" standalone="yes"?>', $Delta); $doc = domxml_open_mem($Delta); $meta = $doc -> get_elements_by_tagname("FIELD"); for($i=0; $i< sizeof($meta); $i++){ $defs = (array)$meta[$i] -> attributes(); reset($defs); while(list($k, $v) = each($defs)){ $_defs[$v -> name]=$v -> value; } $fields[$_defs["attrname"]]["type"]=$_defs["fieldtype"]; } $rows = $doc -> get_elements_by_tagname("ROW"); for($i=0; $i< sizeof($rows); $i++){ $__attr = $rows[$i] -> attributes(); unset($attr); while(list($k, $v) = each($__attr)){ $attr[$v -> name]=$v -> value; } unset($__attr); if($attr["RowState"] == 2){ //deleted reset($attr); unset($where); while(list($k, $a) = each($attr)){ if($k != "RowState" && strlen($a)>0){ if($fields[$k]["type"] == "bin.hex"){ $where[]="$k = '".base64_decode($a)."'"; }else{ $where[]="$k = '$a'"; } } } if(sizeof($where) > 0){ $sql = "delete from $tablename where ".join(" and ", $where); if(!$conn -> execute($sql)){ $errorcount ++; } } }elseif($attr["RowState"] == 4){ //inserted record reset($attr); unset($line); while(list($k, $a) = each($attr)){ if(strlen($a) >0){ if($k != "RowState"){ if($fields[$k]["type"] == "bin.hex"){ $line[]="'".base64_decode($a)."'"; }else{ $line[]="'$a'"; } $_fields[]=$k; } } } if(sizeof($line) > 0){ $sql = "insert into $tablename(".join(", ", $_fields).") values (".join(", ", $line).")"; if(!$conn -> execute($sql)){ $errorcount ++; } } }elseif($attr["RowState"] == 1){ //updated record $_attr1 = (array)$rows[$i+1] -> attributes(); unset($_attr); while(list($k, $v) = each($_attr1)){ $_attr[$v -> name]=$v ->value; } unset($_attr1); reset($attr); unset($where); while(list($k, $a) = each($attr)){ if(strlen($a) >0){ if(!($k == "RowState" || $fields[$k]["type"] == "bin.hex" || $fields[$k]["type"] == "r8")){ $where[]="$k = '".utf8_decode($a)."'"; } } } reset($_attr); unset($new); while(list($k, $a) = each($_attr)){ if($k != "RowState"){ if($fields[$k]["type"] == "bin.hex"){ $new[]="$k = '".base64_decode($a)."'"; }else{ $new[]="$k = '".utf8_decode($a)."'"; } } } if(sizeof($where) > 0 && sizeof($new) > 0){ $sql = "update $tablename set ".join(", ", $new)." where ".join(" and ", $where); if(!$conn -> execute($sql)){ $errorcount ++; } } } } $ret=""; xmlrpc_set_type($ret, "base64"); return array(ErrorCount => $errorcount, ownerdata => $ownerdata, "return" => $ret); } ?>
I wrote a basic script for creating an XML document in the first step and parsing for its nodes in the second step. I am sure this will help you to start with PHP DOM-XML. <?php /** * Topic: Create and parse XML files using PHP DOM-XML * Source: http://www.php.net/domxml * Reference: http://www.zugeschaut-und-mitgebaut.de/php/extension.domxml.html * Author: urs@circle.ch, 16-1-2001 * */ // create the xml processing instruction $doc = new_xmldoc("1.0" ); // setting the DOCTYPE is not yet implemented, but // it will hopefully follow soon ;) //$doc->setdtd("<!DOCTYPE faq SYSTEM \"test_dom.dtd\">"); // create a root node and set an attribute $root = $doc->add_root("faq" ); $root->setattr("page", "32" ); // create a child node $one = $root->new_child("question", ""); // set an attribute to the child node $one->setattr("number", "1"); // create a child node and add content $one->new_child("text", "1. Where to get libxml-2.0.0?"); $one->new_child("answer", "You can download the latest release of libxml either as a source archive or RPM package from http://www.xmlsoft.org. The current version is libxml2-2.2.1." ); $two = $root->new_child("question", "" ); $two->setattr("number", "2"); $two->new_child("text", "2. How to configure PHP4?" ); // create a child node without directly adding content $twoone = $two->new_child("answer", ""); // add the content for this node here $twoone->set_content("DIR is the libxml install directory (if you just use --with-dom it defaults to /usr), I needed to use --with-dom=/usr/local" ); $three = $root->new_child("question", "" ); $three->setattr("number", "7" ); $three->new_child("text", "7. How to use DOM XML function ?" ); $three->new_child("answer", "Read this document source for a simple example." ); // print to browser print("<pre>".htmlspecialchars($doc->dumpmem() )."</pre>" ); // write to file $fp = fopen("test_dom.xml", "w+" ); fwrite($fp, $doc->dumpmem(), strlen($doc->dumpmem() )); fclose($fp); // ------------------------------------------------------ // now get the contents back from the xml documents nodes // by using xpath, which should work with PHP 4.0.4 $doc = xmldoc(join("", file("test_dom.xml")) ); $ctx = xpath_new_context($doc ); // show all objects $foo = xpath_eval($ctx, "//child::*"); print_r($foo); print("<br/><br/>"); // show object of text node $foo = xpath_eval($ctx, "//text"); print_r($foo); print("<br/><br/>"); // show object of first text node $foo = xpath_eval($ctx, "//text[1]"); print_r($foo); print("<br/><br/>"); // show object of second text node $foo = xpath_eval($ctx, "//text[2]"); print_r($foo); print("<br/><br/>"); // show object of third answer node $foo = xpath_eval($ctx, "//answer[3]"); print_r($foo); print("<br/><br/>"); // ------------------------------------------------------ // get type, name and content of third text node $foo = xpath_eval($ctx, "//text[3]"); $tmp = $foo->nodeset; print_r($tmp); print("<br/>"); print($tmp[0]->type) . "; "; print($tmp[0]->name) . "; "; print($tmp[0]->content); ?>
This program will display the XML output of your existing database in MySql. You can enhance it by using fopen and fput function to write the output in the file called xml one <?php //Developed by -==[Mihir Shah]==- during my Project work //for the output header("Content-type: text/xml"); //to create connection to database $connection = mysql_connect("127.0.0.1","username", "password") or die ("could not connect to database"); //to select the database here test is the sample database come with mysql $db = mysql_select_db("test",$connection) or die ("Couldn't select database."); $rs = mysql_query("select * from tablename",$connection) or die ("invalid query"); //count the no. of columns in the table $fcount = mysql_num_fields($rs); //you can choose any name for the starting tag echo ("<result>"); while($row = mysql_fetch_array( $rs ) ) { echo ("<tablerow>"); for($i=0; $i< $fcount; $i++) { $tag = mysql_field_name( $rs, $i ); echo ("<$tag>". $row[$i]. "</$tag>"); } echo ("</tablerow>"); } echo ("</result>"); ?>
Transforms a (local|remote) XML file and its accompanying (local|remote) XSL file into html on the server using either a client output buffering in MSIE only or via a URL HTTP GET include via the W3's XSLT public web service. <?PHP /* What: Transforms a (local|remote) XML file and its accompanying (local|remote) XSL file into html on the server using either a client output buffering in MSIE only or via a URL HTTP GET include via the W3's XSLT public web service. Credits: This comes builtin to PHPortal (c) 2002 - Application Builder LGPL (free non-commercial) (http://dev.4arrow.com) of http://4Arrow.com by Michael Glazer http://coding.4arrow.com PHPortal has dynamic Content-Type Transformations for over 15 formats available format types (PHPortal source,xml,rss,vxml,text,excel,word,jpeg,zip,html,xhtml,javascript,swf/flash,css,wml,pdf) Requires: Info: http://www.php.net/manual/en/ref.xslt.php http://www.w3.org/2001/05/xslt http://www.gingerall.com/ http://www.zvon.org/HTMLonly/XSLTutorial/Books/Book1/ http://www.w3.org/Style/XSL/ Example: $args=array( xsl => "http://4arrow.com/format/tpl/rss/weblogRSS91.xsl", xml => "http://coding.4arrow.com/log/headlines.xpc.rss" ); function XSLT($args=''){ if(strstr($_SERVER["HTTP_USER_AGENT"],"MSIE")){ $str=xslt_trans_js($args['xsl'],$args['xml']); } else{ $str=xslt_trans_w3($args['xsl'],$args['xml']); } return $str; }//end if } */ function xslt_trans_js($xsl='',$xml=''){ $str=' <script> function transform(str1,str2){ var xml = new ActiveXObject("Microsoft.XMLDOM"); var xsl = new ActiveXObject("Microsoft.XMLDOM"); xml.async = false; xsl.async = false; xsl.load(str1); xml.load(str2); var theString = xml.transformNode(xsl); document.write (theString); } transform(''.$xsl.'',''.$xml.''); </script> '; ob_start(); echo $str; $contents = ob_get_contents(); ob_end_clean(); return $contents; } function xslt_trans_w3($xslfile='',$xmlfile=''){ $rfile="http://www.w3.org/2000/06/webdata/xslt?xslfile=$xslfile&xmlfile=$xmlfile"; $str=include_once($rfile); return $str; } ?>
Here is a function permetting to export datas provided by a database (mysql for this example) the goal beeing to include them into a XML file (this one will be automatically created). Exporting table to a XML file by Christophe Faizant Here is a function permetting to export datas provided by a database (mysql for this example) the goal beeing to include them into a XML file (this one will be automatically created). The mysql_fetch_array function returning two items per value (like [0]=>value_x and [field_name]=>value_x ) we check the array with a conditional if($j%2) to keep only the wished line. Of course, if the connection settings have already been included into the page, you just have to add a "&" before their names, when the function call them at its first line. (file db2xml.php) <? function db2xml($host,$user,$password,$database,$table,$xml_file) { $create_xml = fopen($xml_file,"w"); fwrite($create_xml,"<xml>\r\n<table>\r\n"); mysql_connect($host, $user, $password); $req = mysql_db_query($database, "select * from $table"); while($row = mysql_fetch_array($req)) { fwrite($create_xml,"<item>\r\n"); for($j=0;$line=each($row);$j++) { if($j%2) { fwrite($create_xml,"<$line[0]>$line[1]</$line[0]>\r\n"); } } fwrite($create_xml,"</item>\r\n"); } fwrite($create_xml,"</table>\r\n</xml>"); fclose($create_xml); mysql_free_result($req); } ?> You get a xml file having the value of $xml_file as name, with a content like the following lines : (note that the names of the original fields have been automatically included into the destination file as <tag></tag>. (file table_products.xml) <xml> <table> <item> <ref>001</ref> <name>product 1</name> <price>195.00</price> </item> <item> <ref>002</ref> <name>product 2</name> <price>205.00</price> </item> <item> <ref>003</ref> <name>product 3</name> <price>45.00</price> </item> </table> </xml>
Using these coding lines xml can gather the existent information in any feed file. Only it is necessary to change her URL of the file to syndicate <?php $xmlfile = fopen("www.minid.net/index.xml", "r"); if(!$xmlfile)die("no se puede abrir el archivo xml"); $readfile = fread($xmlfile ,40000); $searchfile = eregi("<item>(.*)</item>", $readfile ,$arrayreg); $filechunks = explode("<item>", $arrayreg[0]); $count = count($filechunks); for($i=1 ; $i<=$count-1 ;$i++) { ereg("<title>(.*)</title>",$filechunks[$i], $title); ereg("<link>(.*)</link>",$filechunks[$i], $links); echo "<li>"; echo "<a href ='$links[1]'\>$title[1]</a>"; echo "</li>"; } ?>
This function give the Transformation to Page ... According to files that are feed to it .. Feed one Standard XML and its XSL files it will generates according transformation .... in Process of this it generates the Dyanamic XML files according data one want ... <?php /* --=[ By Zubair Saiyed ]=-- --=[ zubair_911@hotmail.com ]=-- --=[ Dt : 4th June 2002 ]=-- --=[ Dt : 7th June 2002 ]=-- --=[ -Prototype One- ]=-- */ // Working Function of XML Parsing \\ /***** Include Section *****/ include ("imap.class"); /***** Global Variable Section *****/ //$File = "Mail_Header.xml"; // this can be any xml file $FileOut = "MailLog.xml" ; $Buffer = array ( ) ; $Mirror = array ( ) ; $Position = array ( ) ; $PosCount = 0 ; $Count = 0 ; $String ; $MainString ; $Header ; //$XSLFile ; $Result ; if ( ! ($Flag = $imap->open("username","password","host","143" ))) die ( "Can not Connect to Imap Server !!!! " ) ; /***** Parsing Function *****/ function MailXMLParser( $File , $XSLFile ) { global $FileOut ; global $Buffer, $Mirror, $Position, $PosCount ; global $Count, $String, $MainString , $Header ; /***** Opening the Needed XML File *****/ if ( ! ( $Fi = fopen ( $File , "r" ) ) ) die ( " Could not able to Open File" . $File ) ; /* XSL Content Reader */ if ( ! ( $Fx = fopen ( $XSLFile , "r" ) ) ) die ( " Could not able to Open File" . $File ) ; else $XSLFile = fread ( $Fx,filesize($XSLFile)); fclose ( $Fx ) ; /* End-XSL-Reader*/ /* Important : Header Extraction Function Excluded Here */ /***** Reading File and Storing into the Buffer *****/ while ( ! feof ( $Fi ) ) { $Buffer [ $Count ] = fgetc ( $Fi ) ; $Count++ ; } $Total = $Count ; for ( $Count = 0 ; $Count < $Total ; $Count++ ) { if ( $Buffer [ $Count ] == "<" && $Buffer [ $Count+1 ] == "?" ) { //Marking the Position // $Position [ $PosCount ] = $Count ; $PosCount++ ; } if ( $Buffer [ $Count ] == "?" && $Buffer [ $Count+1 ] == ">" ) { //Marking the Position // $Position [ $PosCount ] = $Count ; $PosCount++ ; } } for ( $i = 0 ; $i < $PosCount ; $i++ ) { if ( ( $i + 1 ) % 2 != 0 ) // Starting Pos to Copy into String { $Start = $Position [ $i ] ; $End = $Position [ $i +1 ] ; for ( ; $Start < $End + 2 ; $Start++ ) { $String .= $Buffer [ $Start ] ; } $Header .= $String ; $Header .= "\n" ; $String = ""; // Set String to NULL // } } fclose ( $Fi ) ; /**** Closing the file as it has been Parsed to Check The Headers of the XML *****/ /***** Create the Parser *****/ $Parser = xml_parser_create ( ) ; /***** Registering the Handlers *****/ // -=[ Dt: 7th June 2002 ]=- For Case Folding Option // xml_parser_set_option ($Parser,XML_OPTION_CASE_FOLDING,FALSE); xml_set_element_handler ( $Parser , "startElementHandler" , "endElementHandler" ) ; xml_set_character_data_handler ( $Parser , "cdataHandler" ) ; /***** Opening File Again to Use XML_Parse *****/ /// An Inclusion of File That will be created in between the Process /// if ( ! ( $Fp = fopen ( $File , "r" ) ) ) die ( " Could not able to Open File" . $File ) ; while ( $Data = fread ( $Fp , 4096 ) ) { if ( !xml_parse ( $Parser , $Data , feof ( $Fp ) ) ) { die ( "Error in Xml Document" ) ; } } if ( !xml_parser_free( $Parser ) ) die("Fatal Error :: Can not Free Parser"); /***** Finally Writing to Output File *****/ /***** Closing the Files *****/ fclose ( $Fp ) ; /***** Printing Directed to Browser ****/ // May 25th Edition $MainString = $Header . $MainString ; CreateXSLT($MainString,$XSLFile ) ; // we have to pass this string as XML in xslt_process // /***** Fuctions that is Required to Generate the Dynamic XML File *****/ } function startElementHandler ( $Parser , $Name , $Attrib ) { $String = "<". $Name . ">" ; // --=[ if Some of the Tag can be Looped ]=-- // $String = CheckTags ( $String ) ; WriteFile ( $String ) ; } function endElementHandler ( $Parser , $Name ) { $String = "</". $Name . ">\n" ; WriteFile ( $String ) ; //echo ( "&lt;/$Name&gt; <br>" ) ; } function cdataHandler ( $Parser , $Data ) { $String = $Data ; if ( $String != "\n" ) WriteFile ( $Data ) ; else WriteFile ( $String ) ; //echo ("$Data<br>" ) ; } /***** Function That Writes In the MainString such that contain all Remaing XML Tags *****/ function WriteFile ( $String ) { global $MainString ; $MainString .= $String . " \n" ; } /***** Function that can Loop Specific Tags *****/ function CheckTags ( $String ) { global $Result ; global $imap ; switch ( $String ) { // No of Cases Made Here !! // case "<Mail_Header>": $String = MailHeaders(); return $String ; case "<Mail_Footer>": return $String ; case "<Mail_Box>": return $String ; } // Switch Ends } // Fuction ends /***** Function that returns the Header of Mails *****/ function MailHeaders ( ) { global $imap ; $Result = $imap->mail_headers_list(); $Counter = count($Result)-1; while ( list($Key,$Value) = each($Result) ) { if ( $Key < $Counter) { $String .= "<Mail_Header>"."\n"; $String .= $Value ."\n"."</Mail_Header>"."\n" ; } if ( $Key == $Counter) { $String .= "<Mail_Header>"."\n"; $String .= $Value ; } } // while ends return $String ; } /***** Function that Generates the HTML For Particular XML/XSL *****/ function CreateXSLT ( $MainString , $XSLFile ) { global $FileOut ; if ( ! ( $Fp = fopen ( $FileOut , "w" ) ) ) die ( " Could not able to Open File" . $File ) ; $arguments = array('/_xml' => $MainString ,'/_xsl' => $XSLFile ); $xsltproc = xslt_create(); $html = xslt_process( $xsltproc,'arg:/_xml','arg:/_xsl',NULL,$arguments); if (!$html) die('XSLT processing error: '.xslt_error($xsltproc)); xslt_free($xsltproc); echo $html ; fputs($Fp,$MainString); fclose($Fp); } MailXMLParser( "Mail_Header.xml", "Mail_Header.xsl" ) ; // here Pass any Standard XML/XSL file // // Regards -- Zubair Saiyed // ?>
This basic example will allow you to generate and XML file using PHP and data from your mySQL database. It also has the ability to save the XML Doc if you read through the code and uncomment the three lines of code that do it. //-------------------------------------------------------------------------- // This is where you specify your Database connection stuff // // mysql_connect -- Open a connection to a MySQL Server / die -- Alias of exit() // //-------------------------------------------------------------------------- $db_name = "mycompany"; //This is your database Name $link = mysql_connect("localhost", "UserName", "PassWord") or die("Could not connect to server!"); //This is your table name. This is a one table config to do more table you will need to rework the code. $table_name = 'userinfo'; $select_db = mysql_select_db($db_name, $link); // mysql_select_db -- Select a MySQL database $query = "SELECT * FROM " . $table_name; $result = mysql_query($query, $link) or die("Could not complete database query"); //mysql_query -- Send a MySQL query $num = mysql_num_rows($result); //mysql_num_rows -- Get number of rows in result if ($num != 0) { //-------------------------------------------------------------------------- // If you would like to save a copy of the XML Doc being created uncomment this // line and the two lines at the bottom containing fwrite and fclose. // // //-------------------------------------------------------------------------- //$file= fopen("results.xml" , "w"); //fopen -- Opens file or URL //-------------------------------------------------------------------------- // XML Header Tag Goes Here // // // //-------------------------------------------------------------------------- $_xml ="<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\r\n"; $_xml .="<results>\r\n"; //-------------------------------------------------------------------------- // This while loop loops throught the data found from the above query and // generates the XML Doc. // // //-------------------------------------------------------------------------- while ($row = mysql_fetch_array($result)) { //mysql_fetch_array -- Fetch a result row as an associative array, a numeric array, or both. $_xml .=" <item>\r\n"; $_xml .=" <recordnumber>" . $row[RecordID] . "</recordnumber>\r\n"; $_xml .=" <username>" . $row[username] . "</username>\r\n"; $_xml .=" <address>" . $row[address] . "</address>\r\n"; $_xml .=" <city>" . $row[city] . "</city>\r\n"; $_xml .=" <state>" . $row[state] . "</state>\r\n"; $_xml .=" <zip>" . $row[zip] . "</zip>\r\n"; $_xml .=" <phonenumber>" . $row[phonenumber] . "</phonenumber>\r\n"; $_xml .=" <email>" . $row[email] . "</email>\r\n"; //You can use if statements to check if the returned value is null. //If it is just place a default value in the tags like below. if ($row[website]) { $_xml .=" <website>http://" . $row[website] . "</website>\r\n"; } else { $_xml .=" <website>http://www.ipdg3.com</website>\r\n"; } $_xml .=" <deleted>" . $row[deleted] . "</deleted>\r\n"; $_xml .=" </item>\r\n"; } $_xml .="</results>"; //-------------------------------------------------------------------------- // If you would like to save a copy of the XML Doc being created uncomment this // line and the two lines at the bottom containing fwrite and fclose. // // //-------------------------------------------------------------------------- //fwrite($file, $_xml); //fwrite -- Binary-safe file write //fclose($file); //fclose -- Closes an open file pointer //-------------------------------------------------------------------------- // This will echo the XML file out to the screen so you can view it. // // // //-------------------------------------------------------------------------- echo $_xml; } else { echo "No Records found"; } ?>
Quick and dirty generic function to parse multiple SQL queries into a DOM XML structure. Based on use with a PostgreSQL db. This SQL2XML function is somewhat stronger then the class-based one that can be found in the code gallery. Perhaps I'll extend / rewrite this function once the DOM XML functionality in PHP is stable. <?php /* function sql_file(string $filename); We are using external SQL-files that deliver the content for each page. This has proven to be _very_ efficient. The use of the global var. $globals is by far the best option, but it does the trick. example SQL-file: ----------------- SELECT employer.id, employer.firstname, employer.lastname FROM employer WHERE employer.id = $globals[id] ----------------- */ function sql_file($filename) { // path where the sql-files can be found $path = "/home/www/sql/"; // globals which are used in the eval global $globals; // check if the file exists if (file_exists($path.$filename)) { // need to eval the contents to parse the globals $contents = implode('', file($path.$filename)); eval ("\$contents = \"$contents\";"); // support the "'" character from a HTTP GET variabele $contents = str_replace ("\'", "'", $contents); } return $contents; } /* function query2xml ( string $parentnode, [ string $childname, (string $sql_file | array $array) ]+ ); (note: [ ... ]+ means one or more times these parameters) Quick and dirty generic function to parse multiple SQL queries into a XML structure. The $parentnode is a DOM XML node, where all new nodes will be created under. The $childname is the new name for each new node. The information for each of those nodes is retrieved from parsing the SQL-file $sql_file or directly from the array $array. Due to it's recursive functionality, it's easy to build complex XML structures. Example 1: ---------- This code snippet: $doc = new_xmldoc('1.0'); $root = $doc->add_root('PARENT'); query2xml ( $root, 'TEST', 'select_test.sql', 'TESTCHILD', 'select_child.sql'); with select_test.sql: SELECT id, name FROM test and select_child.sql: SELECT var1 FROM child where id=$globals[id]; could create the following XML structure: <PARENT> <TEST ID="1" NAME="blah"> <= 'id' and 'name' are added to globals <CHILD VAR1="etc"/> <= query is parsed with the globals <CHILD VAR1="moreblah"/> <CHILD VAR1="etc2"/> </TEST> <TEST ID="2" NAME="another"/> <= no childs, empty query <TEST ID="3" NAME="just another"/> <TEST ID="4" NAME="and another"> <CHILD VAR1="etc3"/> <CHILD VAR1="fine"/> </TEST> </PARENT> (note: you can test this with a simple "echo $doc->dumpmem();" ) Example 2: ---------- Instead of using an SQL-file as input, you can also use an twodimensional associative array which 'fakes' the output of the parsed query. The following code snippet: $doc = new_xmldoc('1.0'); $root = $doc->add_root('PARENT'); $construct = array ( array ( 'id' => 1, 'name' => 'blah'), array ( 'id' => 2, 'name' => 'leeg') ); query2xml ( $root, 'TEST', $construct, 'TESTCHILD', 'select_child.sql'); returns this: <PARENT> <TEST ID="1" NAME="blah"> <CHILD VAR1="etc"/> <CHILD VAR1="moreblah"/> <CHILD VAR1="etc2"/> </TEST> <TEST ID="2" NAME="another"/> </PARENT> Extra functionality: -------------------- To 'override' the default name for a node (the $childname), you can let a SQL-query return a column named 'childname' which contains new names for the nodes. */ function query2xml() { // connection parameters for the postgreSQL database $connection_params = "dbname=test user=test"; // globals are used for the parsing of the SQL-files global $globals; // how many arguments have been given with this function? $numargs = func_num_args(); // only continue where there are at least 3 + 2n arguments if($numargs != 1 && $numargs % 2 == 1) { // retrieve the arguments in an array $arg_list = func_get_args(); // get the reference to the parent node and strip the // first element off the array $parentnode =& $arg_list[0]; array_shift($arg_list); // get the $childname and $sql_file/$array, strip these also off the array // and place a new (null) element in the array (to be overwritten // with a reference to the new parent node) $childname = array_shift($arg_list); $sql = array_shift($arg_list); array_unshift($arg_list, null); // is $sql an SQL-file? if(is_string($sql)) { // parse the SQL-file into a query string $query = sql_file($sql); $connection = pg_connect($connection_params); $server_query = @pg_exec($query); $numrows = pg_numrows($server_query); $fetch_array = "\$query_output = @pg_fetch_array(\$server_query, \$i, PGSQL_ASSOC);"; } // is $sql an array? if(is_array($sql)) { $numrows = count($sql); $fetch_array = "list(,\$query_output) = each(\$sql);"; } // start adding nodes for each new row for($i=0; $i<$numrows; $i++) { // fetch a row (eval'd into $query_output) eval($fetch_array); // check for a childname 'override' in the query output while(list($key, $val) = each($query_output)) if($key=='childname') $childname = strtoupper($val); reset($query_output); // create a new childnode named $childname under $parentnode $child = $parentnode->new_child($childname, ''); // add the row values as attributes to the current node while(list($key, $val) = each($query_output)) { // good idea to utf8 encode strings from the database if(is_string($val)) $val = utf8_encode($val); // add the row values as new globals (for recursion) $globals[$key] = $val; // only use uppercase attribute names $key = strtoupper($key); $child->set_attribute($key, $val); } // overwrite the first value in the array with the new parentnode $arg_list[0] =& $child; // call the function, with two arguments less and the new parentnode call_user_func_array('query2xml', $arg_list); } } } ?>
This is a minimal, and hopefully simple class to get data out of a xml file via path query. Like; /rootNode/subnode/node .. if you don't understand read the code source, you'll dig it :) It was inspired from lots of great codes from the open source (mainly from zend.com and pear.php.net), wich are not necessarly related to xml, list them back would be too long and I would surely forget some, so i felt like I had to give it back to the open source. now make something better out of it :) to do: - add support for duplicate nodes. - add support fo namespaces. note to coders: - the $i & $o stands for input & output, i think it's a clean and efficient way to handle mainstream data trough functions. - this code may not be appropriate for proffessional use since it does not meet the industry standards and is still in beta developement - I think it can handle malformed or broken xml files without ending with infinites loops or crashing, but you shall respect some rules to in your xml file composition .. and avoid node repetition :/ i'll work on that soon. ** BOF file.xml ** data data ** EOF file.xml ** finally, feel free to report me bugs, suggestions or comments. - h3 at mindkind dot org <?php // +-----------------------------------------------------------------------+ // | Copyright 2003-2004 h3 Http://h3.valleyfield.net | // | All rights reserved. E x p a n d the web | // | | // | o Client : open source release [ @ zend dot com] | // | o File : mxml.class.php | // | o Version : 1.0 beta | // | | // | THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS | // | "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT | // | LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR | // | A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT | // | OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, | // | SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT | // | LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, | // | DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY | // | THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT | // | (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE | // | OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. | // | | // +-----------------------------------------------------------------------+ // | Author: h3 <h3@valleyfield.net , h3@mindkind.org> | // +-----------------------------------------------------------------------+ class mxml { function mxml($i) { $this->xfile = file($i); } # Get tag data (<node>data</node>) as String function get_data($i) { $xpath = explode('/',$i); $z = 0; for($x=0;$x<=count($this->xfile);$x++) { if (trim($xpath[$z])=="") $z++; if(ereg($xpath[$z],$this->xfile[$x])) { if($z==count($xpath)-1) { return $this->xtractelm($xpath[$z],$x); break; } else { $z++; } } } } # Get tag attributes ( <node attr1="A" attr2="B" /> ) as Array function get_attr($i) { $xpath = explode('/',$i); $z = 0; for($x=0;$x<=count($this->xfile);$x++) { if (trim($xpath[$z])=="") $z++; if(ereg($xpath[$z],$this->xfile[$x])) { if($z==count($xpath)-1) { return $this->xtractattr($this->xfile[$x]); break; } else { $z++; } } } } # Attributes extraction function xtractattr($i) { $i = explode(" ",$i); for($x=0;$x<count($i);$x++) { if(!ereg("<|>",$i[$x]) && trim($i[$x])!="") { $tmp = explode("=",$i[$x]); $k = trim($tmp[0]); $chr['>'] = ""; $chr['"'] = ""; $o[$k] = strtr($tmp[1],$chr); } } return $o; } # Fill variable untill we meet the closing tag from get_data function xtractelm($i,$pointer) { if(isset($this->xfile) && is_array($this->xfile)) { for($x=$pointer;$x<count($this->xfile);$x++) { $o .= $this->xfile[$x]; if(ereg('</'.$i.'>',$this->xfile[$x])) { return trim(strip_tags($o)); break; } } } } } ?>
This class for manage site news. <?php // +----------------------------------------------------------------------+ // | PHP Version 5 | </div> <!-- ##### Footer ##### --> <div id="footer"> <div> <P><CENTER><IFRAME SRC="http://webmaster.hoofoo.net/banners/banners.php?u=4&t=0" HSPACE=0 VSPACE=0 FRAMEBORDER=0 SCROLLING=no WIDTH=468 HEIGHT=75 name="bannerexchange"></IFRAME></CENTER></p> </div> <div> <!-- Begin: AdBrite --> <script type="text/javascript"><!-- google_ad_client = "pub-2664172908219191"; /* 728x90, created 7/22/08,freewebdirectory */ google_ad_slot = "4296344504"; google_ad_width = 728; google_ad_height = 90; //--> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> <!-- End: AdBrite --> </div> <div> Copyright © 2004-2007, ComLanka Web Solutions | Modified on Jan 28, 2007 </div> </div> </body> </html>