phpeveryday.com

Create a file named "server_books.php" within www/test/ajax. Enter following code:

<?
mysql_connect('localhost','root','admin');
mysql_select_db('test');

$sql = "Select * from `books`";
$q   = mysql_query($sql) or die(mysql_error());

while($r = mysql_fetch_array($q)){
  echo $r['id'];
  echo $r['title'];
  echo $r['author'];
  echo "<br />";
}

?>

Test it. Point your browser to http://localhost/test/ajax/server_books.php. You may get like this:

Now, we create xml document. Modify like this:

<?
header('Content-type: text/xml');

mysql_connect('localhost','root','admin');
mysql_select_db('test');

$sql = "Select * from `books`";
$q   = mysql_query($sql) or die(mysql_error());


$dom = new DOMDocument();

$datas = $dom->createElement('datas');
$dom->appendChild($datas);

while($r = mysql_fetch_array($q)){
  $id = $dom->createElement('id');
  $idText = $dom->createTextNode($r['id']);
  $id->appendChild($idText);

  $title = $dom->createElement('title');
  $titleText = $dom->createTextNode($r['title']);
  $title->appendChild($titleText);

  $author = $dom->createElement('author');
  $authorText = $dom->createTextNode($r['author']);
  $author->appendChild($authorText);

  $book = $dom->createElement('book');
  $book->appendChild($id);
  $book->appendChild($title);
  $book->appendChild($author);

  $datas->appendChild($book);

}


$xmlString = $dom->saveXML();
echo $xmlString;

?>

Next, test it. Point your browser to http://localhost/test/ajax/server_books.php. You may get like this: