dtjwov4984 2014-01-31 18:03
浏览 20
已采纳

在PHP中创建XML输出

I am trying to create an XML file output in PHP for a remote phone book on an IP Phone, here is the code i have:

<?php
$conn=mysql_connect("localhost","user","********");
mysql_select_db("db_name",$conn);

header("Content-Type: text/xml");
header("Connection: close");
header("Expires: -1");
?>

<YealinkIPPhoneDirectory>
<?php
$output='<YealinkIPPhoneDirectory>
';
$sql="SELECT * from contacts ";
$rs=mysql_query($sql,$conn);
while($result=mysql_fetch_array($rs)) {
    $output .= "<DirectoryEntry>
";
    $output .= "<Name>Mobile:</Name>
";
    $output .= "<Telephone>" . $result["mobile"] . "</Telephone>
";
    $output .= "</DirectoryEntry>
";
}
$output='</YealinkIPPhoneDirectory>
';

echo '$output';
?>

but i get this error message:

This page contains the following errors:

error on line 3 at column 8: Extra content at the end of the document
Below is a rendering of the page up to the first error.

$output
  • 写回答

2条回答 默认 最新

  • dqaq59269 2014-01-31 18:09
    关注
    <?php
    
    $conn=mysql_connect("localhost","user","********");
    mysql_select_db("db_name",$conn);
    
    header("Content-Type: text/xml");
    header("Connection: close");
    header("Expires: -1");
    
    $output = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>
    ";
    $output .= '<YealinkIPPhoneDirectory>
    ';
    $sql="SELECT * from contacts ";
    $rs=mysql_query($sql,$conn);
    while($result=mysql_fetch_array($rs)) {
        $output .= "<DirectoryEntry>
    ";
        $output .= "<Name>Mobile:</Name>
    ";
        $output .= "<Telephone>" . $result["mobile"] . "</Telephone>
    ";
        $output .= "</DirectoryEntry>
    ";
    }
    $output.='</YealinkIPPhoneDirectory>';
    
    echo $output;
    
    ?>
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥60 ESP32怎么烧录自启动程序
  • ¥50 html2canvas超出滚动条不显示
  • ¥15 java业务性能问题求解(sql,业务设计相关)
  • ¥15 52810 尾椎c三个a 写蓝牙地址
  • ¥15 elmos524.33 eeprom的读写问题
  • ¥15 使用Java milo连接Kepserver服务端报错?
  • ¥15 用ADS设计一款的射频功率放大器
  • ¥15 怎么求交点连线的理论解?
  • ¥20 软件开发方法学习来了
  • ¥15 微信小程序商城如何实现多商户收款 平台分润抽成