dongxuan1314 2015-12-01 13:32
浏览 44

在显示XML数据的.php文件中显示PHP变量

Basically I have a live search suggestions which uses AJAX. I'm not familiar with AJAX or XML however i've managed to get it working without any errors.

If you take a look at the code file you can see how I would like the XML data to be generated which is the title and url tags to be populated by a database of products. Instead of displaying the database string the live search suggestions is displaying everything between the XML tags for example between the title tags: ".$aa." .

Can anyone please help me work around this issue. It's most likely a silly mistake or an easy solution.

<link>
<?php
header("Content-type: text/xml");
echo "<?xml version='1.0' encoding='UTF-8'?>";
$productdetails = mysql_query("SELECT * FROM products");

while($row = mysql_fetch_array($productdetails)){
    $aa = $row['product_name'];
    $bb = $row['link'];
    echo "<title>".$aa."</title>";
    echo "<url>".$bb."</url>";
    
}
?>
</link>

</div>
  • 写回答

1条回答 默认 最新

  • dongrui6787 2015-12-01 13:40
    关注

    There were link tags before and after the code but oin the php you tried sending a header - I think this might be more like what you are trying to do.

    <?php
        header("Content-type: text/xml");
        $productdetails = mysql_query("SELECT * FROM products");
    
        echo "<?xml version='1.0' encoding='UTF-8'?>";
        while( $row = mysql_fetch_array( $productdetails ) ) {
            echo "
            <link>
                <title>".$row['product_name']."</title>
                <url>".$row['link']."</url>
            </link>";
        }
    ?>
    
    评论

报告相同问题?

悬赏问题

  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥30 用arduino开发esp32控制ps2手柄一直报错
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 求chat4.0解答一道线性规划题,用lingo编程运行,第一问要求写出数学模型和lingo语言编程模型,第二问第三问解答就行,我的ddl要到了谁来求了
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题