我创建了一个脚本,该脚本从URL中获取XML并更新mysql数据库并将数据解析为csv文件。
我得到XML格式的HTML字符串,它们不应该在那里。解析时如何删除它们?
我像这样加载XML文件:
$xml = simplexml_load_file(utf8_encode($xml_url), 'SimpleXMLElement', LIBXML_NOCDATA);
运行脚本时遇到的错误:
Warning: simplexml_load_file() [function.simplexml-load-file]: http://domain.com/api/get_catalog.php?id=351&user=878&key=b8:1: parser error : Space required after the Public Identifier in /dokumenti/skripte/xmlupdate/lost/test/lost_xml.php on line 59
Warning: simplexml_load_file() [function.simplexml-load-file]: <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"> in /dokumenti/skripte/xmlupdate/lost/test/lost_xml.php on line 59
Warning: simplexml_load_file() [function.simplexml-load-file]: ^ in /dokumenti/skripte/xmlupdate/lost/test/lost_xml.php on line 59
Warning: simplexml_load_file() [function.simplexml-load-file]: http://domain.com/api/get_catalog.php?id=351&user=878&key=b8:1: parser error : SystemLiteral " or ' expected in /dokumenti/skripte/xmlupdate/lost/test/lost_xml.php on line 59
Warning: simplexml_load_file() [function.simplexml-load-file]: <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"> in /dokumenti/skripte/xmlupdate/lost/test/lost_xml.php on line 59
Warning: simplexml_load_file() [function.simplexml-load-file]: ^ in /dokumenti/skripte/xmlupdate/lost/test/lost_xml.php on line 59
Warning: simplexml_load_file() [function.simplexml-load-file]: http://domain.com/api/get_catalog.php?id=351&user=878&key=b8:1: parser error : SYSTEM or PUBLIC, the URI is missing in /dokumenti/skripte/xmlupdate/lost/test/lost_xml.php on line 59
Warning: simplexml_load_file() [function.simplexml-load-file]: <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"> in /dokumenti/skripte/xmlupdate/lost/test/lost_xml.php on line 59
Warning: simplexml_load_file() [function.simplexml-load-file]: ^ in /dokumenti/skripte/xmlupdate/lost/test/lost_xml.php on line 59
xml $ not loaded.
当我使用 Firefox 并将 XML 从 url 保存到磁盘时,当我尝试从 url 获取它时,解析它没有问题。
XML 看起来不错:XML 的一部分:
<?xml version="1.0" encoding="UTF-8"?>
<RecroKatalog>
<viewCustomerDiscount>
<BrojArtikla>10214</BrojArtikla>
<Naziv>Eksterno kucište 2.5" S-ATA+IDE HDD, Aluminium, USB 2.0</Naziv>
<NetoPrice>81.8224</NetoPrice>
<Status>Dostupno</Status>
<Opis></Opis>
<dugi_opis>Isporucuje se u SIVOJ boji</dugi_opis>
<Image>http://shop.lost.hr/data/images/big/10.jpg</Image>
<WEB_Grupa>Ladice i eksterna kucišta - OSTALO</WEB_Grupa>
<Akcija>0</Akcija>
<Proizvodjac></Proizvodjac>
<Klasifikacija>PH-25SD-B/VK220</Klasifikacija>
</viewCustomerDiscount>
错误消息中有一些巨大的线索。 它抱怨看到:
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
这是该网站提供的HTML文档的开始...而不是您要查找的 XML。
当您必须针对远程服务进行身份验证(因此在您登录时在浏览器中工作)时,通常会发生这种情况,但您并没有告诉 SimpleXML 为您执行此操作。