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

htaccess disable directory browsing, disable file listing, disable file access

There may be some personal or secure data in a file, that you want to hide from the end user, when it is viewed through a web browser. Ex: http://www.example.com/user_files/24/chat.txt In the above scenario, if the file "chat.txt" contains a secure data, and you dont want to allow end users to directly access the file, or to disable the file listing in the folder "user_files" or "24", use the below code in your .htaccess file inside "user_files" folder: Options -Indexes order allow,deny deny from all
Post a Comment
Read more

dropdown menu over flash banner

It is often annoying in some browsers when the dropdown menu at the top of the flash banner is displayed at the back of the flash. It can be corrected with some minor changes in the flash embed code: 1. for embed tag, add wmode="transparent" 2. add param to the object tag: <param name="wmode" value="transparent" />
Post a Comment
Read more