programming PHP - XML

[dcharlier]

Hello,

I am trying to contact a PHP-MYSQL database by an IP Phone.

However, the IP Phone shows me the following :

<CiscoIPPhoneDirectory><Prompt>Select Number</prompt> ...

instead of interpreting the "xml code".

my code is the following :

<?php

$db = mysql_connect("localhost");

mysql_select_db("xml",$db);

$result = mysql_query("SELECT * FROM directory",$db);

printf("<CiscoIPPhoneDirectory><Prompt>Select Number</Prompt><Title>DIDATA MOBILE PHONES</Title>");

while ($myrow = mysql_fetch_row($result))

{
printf(" <DirectoryEntry>");
printf(" <Name>");
printf(" $myrow[1]");
printf(" </Name>");
printf(" <Telephone>");
printf(" $myrow[2]");
printf(" </Telephone>");
printf(" </DirectoryEntry>");
}

printf(" </CiscoIPPhoneDirectory>/r/n");

?>

[superwormy]

I think you need to make it more clean what you're trying to do and what the problem is...

XML 'Code' is not interpreted at all... it might be parsed... or read... but its not interpreted.

What do you mean contact a PHP-MySQL databse by an IP Phone? First of all, theres no such thing as a PHP-MySQL database... theres a MySQL database, and PHP might ocnnect to it... but thats bout it...

And by an IP Phone...?

[dcharlier]

OK, I will try to explain my problem in details:

I am trying to send XML. I try this by using the

printf ("<TAG>"); to send the information on request.

However, my problem is the following :

when I call the "printxml.php", it send the information but the other device thinks it is text and does not parse the code.

I know you have to add contenttype. 'XML/TEXT' to a javascript script for example.

Can someone help me out ?

[superwormy]

What is ' the other device ' you are refering to? The browser or some other program?

Theres really nothing you can do, if it won't obey the Content-type header its the devices fault, not your scripts.

Also... you don't use Content-type headers in Javascript...

You are doing a:

header ("Content-type: text/xml");

right?

[dcharlier]

the other device can be a normal browser or an IP Phone.

Maybe I can find my way out with the following:

what is the difference between

a text file named text.txt on a web server containing XML tags
<->
and a text file named as text.xml on a web server ?

Many Thanks

[superwormy]

There is no difference. Period. End of story.

Theres no diffeence between a .php file and a .html or a .jsp or .txt or... etc. etc. etc.

BUT when the webserver sees a request for those files, it handles them differently. If it sees .php it hands it to the PHP binary first. If it sees .txt it sends header, Content-type: text/plain... etc. etc.

If you do a:

header ("Content-type: text/xml");

If may help.

[dcharlier]

<CiscoIPPhoneDirectory>
<Prompt>Select Number</Prompt>
<Title>DIDATA MOBILE PHONES</Title>
<Prompt>Select Number</Prompt>
<DirectoryEntry>
<Name> Amezouj Karim (-) </Name>
<Telephone> +32 473/ 999 291 </Telephone> </DirectoryEntry>
</CiscoIPPhoneDirectory>

Let me ask it on another way : how can I send the xml contents above with a php script ?

Thanks

[dcharlier]

thanks superwormy : it works !!!!

it was the content type that was missing.

Thanks for your efforts

[superwormy]

What are you sending it to?

Do you mean if someone visits *.php you want to send them that XML?

As a note, you should probably also have a correct XML doctype declaration and stuff ni that XML...

<?php

header ("Content-type: text/xml");

print ("
<CiscoIPPhoneDirectory> 
<Prompt>Select Number</Prompt> 
<Title>DIDATA MOBILE PHONES</Title> 
<Prompt>Select Number</Prompt> 
<DirectoryEntry> 
<Name> Amezouj Karim (-) </Name> 
<Telephone> +32 473/ 999 291 </Telephone> </DirectoryEntry> 
</CiscoIPPhoneDirectory> 
");

?>

[superwormy]

Glad ot hear it.