Advanced Search

Return to Snippet

Revision: 1492
at October 11, 2006 11:35 by NexusRex
Initial Code 
if ($num != 0) {

 $file= fopen("results.xml", "w");

 $_xml ="<?xml version=\"1.0\" encoding=\"UTF-8\" ?>
";

 $_xml .="<site>
";

 while ($row = mysql_fetch_array($result)) {

 if ($row["pageTitle"]) {

 $_xml .="\t<page title=\"" . $row["pageTitle"] . "\">
";

 $_xml .="\t\t<file>" . $row["pageLink"] . "</file>
";
$_xml .="\t</page>
";
 } else {

 $_xml .="\t<page title=\"Nothing Returned\">
";
$_xml .="\t\t<file>none</file>
";

 $_xml .="\t</page>
";
 } }

 $_xml .="</site>";

 fwrite($file, $_xml);

 fclose($file);

 echo "XML has been written.  <a href=\"results.xml\">View the XML.</a>";

 } else {

 echo "No Records found";

 } ?>
Initial URL 
http://builder.com.com/5110-6388-5055276.html
Initial Description 

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Create XML file and populate with data from mySQL

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql, xml

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
PHP