Skip to main content

php array to xml example

This is an example of generating an xml output format from the database.
This code is creating a sample rss feed from the joomla articles (which can be added to a rss.xml file).

<?php
    $dbhost = "localhost";
    $dbuser = "root";
    $dbpass = "";
    $dbname = "joomla";

    mysql_connect($dbhost,$dbuser,$dbpass);
    mysql_select_db($dbname);
    mysql_query("SET NAMES 'utf8'"); // to get proper format
   
    $sql = "SELECT id, title, alias, title_alias, metadesc FROM `jos_content`
    where catid=12 limit 3";
    $q   = mysql_query($sql) or die(mysql_error());
    $xml = "";

    while($r = mysql_fetch_array($q)){
      $xml .= "<item>";
      $xml .= "<title>".trim($r['title'])."</title>";
      $xml .= "<link>".trim($r['title_alias'])."</link>";
      $xml .= "<pubDate>Fri, 06 Jan 2012 08:30:00 GMT</pubDate>";
      $xml .= "<description>".trim($r['metadesc'])."</description>";
      $xml .= "</item>";
    }

    header("content-type: application/xml;");
    echo $xml;
    ?>

Note: Run the file. If you dont see the xml output, try to view the source code...
Labels:

Comments

Post a Comment

Popular posts from this blog

php strip all tags

The below function can strip almost all tags from a string. function strip_all_tags($string) {     $string = preg_replace( '@<(script|style)[^>]*?>.*?@si', '', $string );     $string = strip_tags($string);     return trim($string); } $a = '<script type="text/javascript" src="jquery.js"></script> <div id="test" style="padding:5px; color:red;">Hello world</div>'; echo strip_all_tags($a); // outputs: Hello world
Post a Comment
Read more

Joomla validate chrono forms using jquery

It is a common practice to use Chrono forms in our joomla site to setup various forms in the site, be it a contact us form, submit a ticket form, or whatever. I have set the option "validate form" to "No" under chronoform settings in admin panel, and also preferred to not include any js or css files. For validating the chrono forms, i prefer jquery. So first lets add jquery support in our joomla. It is quite simple: 1. Download jquery.js and jquery_min.js (1.4.2 version is enough) and place them in media/system/js folder of your joomla. 2. Edit libraries->joomla->html->html->behavior.php, and add the following function below the mootools() function: function jQuery($debug = null)     {         static $loaded;         global $mainframe;         // Only load once         if ($loaded) {    ...
Post a Comment
Read more

php get content between tags

This involves parsing the dom document. <?php function getTextBetweenTags($tag, $html) {     $dom = new domDocument;     @$dom->loadHTML($html);         $dom->preserveWhiteSpace = false;     $content = $dom->getElementsByTagname($tag);     $out = array();         foreach ($content as $item)     {         $out[] = $item->nodeValue;     }     return $out; } $xhtml = '<tag>abc def</tag><tag>123 456</tag>'; $content2 = getTextBetweenTags('tag', $xhtml); foreach( $content2 as $item ) {     echo $item.'<br />'; } ?> Output: abc def 123 456
2 comments
Read more