Expanding Database Results into PHP

[mfurqan]

Hi,

a database have 4 feilds, book_id autofull , book_title varchar(255), book_desc text, and book_author .. i need to do is to show all listings in htis category in xml format, primary key can be book_title

can any one help me

[penagate]

Very easy - depends on your intended XML output structure though.

Something like this should get you started

<?php
  $books = mysql_query('select * from `books`');
  
  while ($book = mysql_fetch_assoc($books)):
?><book id="<?=$book['book_id']?>">
  <title><?=$book['book_title']?></title>
  <author><?=$book['author']?></author>
  <description><?=$book['book_desc']?></description>
</book>
<?php endwhile; ?>

Should be able to adapt that to your XML structure

[mfurqan]

sorry but is it possible like

if some one use http://www.domain.com/abcxml.php?bookauthor=ABC

when some one use XML results retriving cod ewith above url, will it be working ?

[penagate]

just change the query

$books = mysql_query(select * from `books` where `author` = \''.$_GET['bookauthor'].'\''); 

[mfurqan]

1 thing please do i need XML headers i mean starting from <xml> tag.. do i need to put these headers in echo""; ???

[visualAd]

Send an XML mime type:

header('Content-Type: application/xml');

And add the XML declaration:

<?xml version="1.0" encoding="UTF-8"?>

[mfurqan]

and in botton /xml right ?

[penagate]

No. The XML prolog is separate from the root node.

Here is an example of a complete XML document.

<?xml version="1.0" encoding="utf-8"?>

<root-node>
  <child-node />
</root-node>

The child node is unnecessary, I put it in simply for the purpose of an example.