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

Labels:

Comments

Post a Comment

Popular posts from this blog

Retaining checkbox status of a form after submitting it

we will learn here how to post back or retain the value ( status ) of the checkbox. We will use php header redirection to post back the values to our main page where checkbox is present. We will call form page as first page and action or submitted page as second page. The form data will be received by second page and it is supposed to post back the form data back to form page by using query string through address bar. To keep the second page simple we will keep only the redirection part. Here we have excluded the part which takes care if the form passes its validation and execute the actual script (redirection part). Here is the code of our form with two checkboxes, pb-check.php <?php $t1=$_GET['t1']; $t2=$_GET['t2']; if($t1=="yes"){$t1v="checked";} else{$t1v=="";} if($t2=="yes"){$t2v="checked";} else{$t2v=="";} ?> HTML Form code: <form method="post" action="pb-chk.php"> <inp...
1 comment
Read more

Identify the user's browser

Sometimes there arises a need to identify the user's browser. It is pretty easy to find browser with jquery. So if you have included jquery in your page, it takes a simple line to identify the browser:  if ($. browser . msie ) {} // IE if (($.browser.msie) && ($.browser.version == '6.0')) {} // IE6 if ($. browser . opera ) {} // opera if ($. browser . mozilla) {} // Firefox With the help of php, you can get the browser  details with the help of:  $_SERVER['HTTP_USER_AGENT']; Or you can even use the combined version of php and javascript. php + javascript code: <script type="text/javascript"> var string1 = "<?php echo $_SERVER['HTTP_USER_AGENT']; ?>"; // Browser string var myRegExp1 = /Firefox/; var matchPos1 = string1.search(myRegExp1); var myRegExp2 = /Chrome/; var matchPos2 = string1.search(myRegExp2); var myRegExp3 = /MSIE/; var matchPos3 = string1.search(myRegExp3); if(matchPos1 != -1) ...
1 comment
Read more

Prevent caching in IE ajax response

You must have noticed that IE will show the cached response for the ajax calls. To prevent this, just add these lines before outputting any content as response: <?php header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); header("Cache-Control: no-store, no-cache, must-revalidate"); header("Cache-Control: post-check=0, pre-check=0", false); header("Pragma: no-cache"); ?>
Post a Comment
Read more