Saturday, November 19, 2011

web services using php as xml format


Create a php file with following code:
$hostname="localhost";
$username="bhoopendra";
$password="";
$database="my_db";
$table='comment';
$con=mysql_connect($hostname, $username, $password) or die(mysql_error());
mysql_select_db($database, $con) or die(mysql_error());
$result=mysql_query("SELECT * FROM ".$table) or die(mysql_error());
$doc = new DomDocument('1.0');
$root = $doc->createElement('root');
$root = $doc->appendChild($root);

while($row = mysql_fetch_assoc($result)) {
$occ = $doc->createElement($table);
  $occ = $root->appendChild($occ);
  foreach ($row as $fieldname => $fieldvalue) {
$child = $doc->createElement($fieldname);
$child = $occ->appendChild($child);
$value = $doc->createTextNode($fieldvalue);
$value = $child->appendChild($value);
 }
}
$xml_string = $doc->saveXML();
//echo $xml_string;
$file=fopen("web.xml", "w");
if(fwrite($file,$xml_string)){
header('location: web.xml');
}

No comments:

Post a Comment