swethak Posted July 12, 2008 Share Posted July 12, 2008 hi, i run the below code i got the following error and also display output normal way instead of xml entries.plz help that what's the mistake in my code <? header("Content-type: text/xml"); $host = "localhost"; $user = "root"; $pass = "root"; $database = "DataMiningdb"; $linkID = mysql_connect($host, $user, $pass) or die("Could not connect to host."); mysql_select_db($database, $linkID) or die("Could not find database."); $query = "SELECT * FROM vehicles ORDER BY vehicle_id DESC"; $resultID = mysql_query($query, $linkID) or die("Data not found."); $xml_output = "<?xml version=\"1.0\"?>\n"; $xml_output .= "<entries>\n"; for($x = 0 ; $x < mysql_num_rows($resultID) ; $x++){ $row = mysql_fetch_assoc($resultID); $xml_output .= "\t<entry>\n"; $xml_output .= "\t\t<vehicle_id>" . $row['vehicle_id'] . "</vehicle_id>\n"; // Escaping illegal characters $row['vehicle_make'] = str_replace("&", "&", $row['vehicle_make']); $row['vehicle_make'] = str_replace("<", "<", $row['vehicle_make']); $row['vehicle_make'] = str_replace(">", ">", $row['vehicle_make']); $row['vehicle_make'] = str_replace("\"", """, $row['vehicle_make']); $xml_output .= "\t\t<vehicle_make>" . $row['vehicle_make'] . "</vehicle_make>\n"; $xml_output .= "\t</entry>\n"; } $xml_output .= "</entries>"; echo $xml_output; ?> output: Warning: Cannot modify header information - headers already sent by (output started at F:\Facebook\furniture11\Data Mining1\public_html\xmlparsing.php:1) in F:\Facebook\furniture11\Data Mining1\public_html\xmlparsing.php on line 2 5 Bayliner 5 Bayliner 5 Bayliner 4 Bayliner 4 Bayliner 4 Bayliner 3 Baja Marine 3 Baja Marine 3 Baja Marine 2 Miscellaneous 2 Miscellaneous 2 Miscellaneous 1 Miscellaneous 1 Miscellaneous 1 Miscellaneous Quote Link to comment https://forums.phpfreaks.com/topic/114381-problem-in-conversion-of-xml/ Share on other sites More sharing options...
vikramjeet.singla Posted July 12, 2008 Share Posted July 12, 2008 Remove all space before sending any header. in your code their is a space before opening php tag.... refer to code below... <?php header("Content-type: text/xml"); $host = "localhost"; $user = "root"; $pass = "root"; $database = "DataMiningdb"; $linkID = mysql_connect($host, $user, $pass) or die("Could not connect to host."); mysql_select_db($database, $linkID) or die("Could not find database."); $query = "SELECT * FROM vehicles ORDER BY vehicle_id DESC"; $resultID = mysql_query($query, $linkID) or die("Data not found."); $xml_output = "<?xml version=\"1.0\"?>\n"; $xml_output .= "<entries>\n"; for($x = 0 ; $x < mysql_num_rows($resultID) ; $x++){ $row = mysql_fetch_assoc($resultID); $xml_output .= "\t<entry>\n"; $xml_output .= "\t\t<vehicle_id>" . $row['vehicle_id'] . "</vehicle_id>\n"; // Escaping illegal characters $row['vehicle_make'] = str_replace("&", "&", $row['vehicle_make']); $row['vehicle_make'] = str_replace("<", "<", $row['vehicle_make']); $row['vehicle_make'] = str_replace(">", ">", $row['vehicle_make']); $row['vehicle_make'] = str_replace("\"", """, $row['vehicle_make']); $xml_output .= "\t\t<vehicle_make>" . $row['vehicle_make'] . "</vehicle_make>\n"; $xml_output .= "\t</entry>\n"; } $xml_output .= "</entries>"; echo $xml_output; ?> Quote Link to comment https://forums.phpfreaks.com/topic/114381-problem-in-conversion-of-xml/#findComment-588208 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.