php 解析 xml - 错误:StartTag:元素名称无效 [英] php parse xml - error: StartTag: invalid element name
本文介绍了php 解析 xml - 错误:StartTag:元素名称无效的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在从 php 中的 sql 查询获取数据到 xml 时遇到了严重的问题.我总是收到错误:StartTag: invalid element name.起始元素是一个数字
,我不知道这是否重要?!?
I have a serious problem with getting data from a sql query in php into an xml. I always get the error: StartTag: invalid element name. The Start-Element is a Number
, I dont know if that matters?!?
也许你们可以帮助我!!
Maybe you guys can help me!!
PHP:
$query = "SELECT r.object_id,
t.term_taxonomy_id,
t.term_id,
t.taxonomy,
t.description,
p.post_date_gmt,
p.post_content,
p.post_title,
p.post_excerpt
FROM wp_posts p,
wp_term_taxonomy t,
wp_term_relationships r
WHERE r.object_id= p.id
AND t.term_taxonomy_id = r.term_taxonomy_id
AND p.post_status = 'publish'
AND p.post_type = 'post'
AND to_days(p.post_date_gmt) >= to_days(now()) - 120
ORDER BY p.post_date DESC";
// DB Connect
$connection = mysql_connect($server, $user, $password);
mysql_select_db($dbName, $connection);
$res = mysql_query($query);
// XML Output
$xml = '<?xml version="1.0" encoding="UTF-8"?>
<standing version="1.0">';
while ($row = mysql_fetch_assoc($res)){
$xml .= '
<'.$row['object_id'].'>
<term_taxonomy>'.$row['taxonomy'].'</term_taxonomy>
<description>'.$row['description'].'</description>
<post_date>'.$row['post_date_gmt'].'</post_date>
<post_content>'.$row['post_content'].'</post_content>
<post_title>'.$row['post_title'].'</pst_title>
<post_exerpt>'.$row['post_exerpt'].'</post_exerpt>
</'.$row['object_id'].'>
';
}
$xml.= '</standing>';
// Write to file
$file = 'News.xml';
if(is_file($file)) unlink($file);
$fp = fopen($file, "w+");
fwrite($fp, $xml);
fclose($fp);
mysql_close ($connection);
?>
推荐答案
XML 标签名不能是数字,改为尝试
XML tag names cannot be numbers, instead try
'<object id="' . $row['object_id'] . '">
这篇关于php 解析 xml - 错误:StartTag:元素名称无效的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文