blocks|key|2269437|text|函数getColumnMeta返回一个数组。一根绳子也没有。除此之外，它被标记为实验性的。我不会在生产代码上使用它，直到它变得更稳定。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2269438|但我觉得这应该管用|2269439|function+sqlToXml($queryResult,+$rootElementName,+$childElementName)
{+
++++$xmlData+=+"<?xml+version=\"1.0\"+encoding=\"ISO-8859-1\"+?>\n";+
++++$xmlData+.=+"<"+.+$rootElementName+.+">";


++++while($record+=+$queryResult->fetch(PDO::FETCH_OBJ))
++++{+
++++++++/*+Create+the+first+child+element++*/
++++++++$xmlData+.=+"<"+.+$childElementName+.+">";

++++++++for+($i+=+0;+$i+<+$queryResult->columnCount();+$i%2B%2B)
++++++++{+
++++++++++++$colum+=+$queryResult->getColumnMeta($i);
++++++++++++$fieldName+=+$column['name'];

++++++++++++/*+The+child+will+take+the+name+of+the+table+column++*/
++++++++++++$xmlData+.=+"<"+.+$fieldName+.+">";

++++++++++++/*+We+set+empty+columns+with+NULL,+or+you+could+set+
++++++++++++++++it+to+'0'+or+a+blank.+*/
++++++++++++if(!empty($record->$fieldName))
++++++++++++++++$xmlData+.=+$record->$fieldName;+
++++++++++++else
++++++++++++++++$xmlData+.=+"null";+

++++++++++++$xmlData+.=+"</"+.+$fieldName+.+">";+
++++++++}+
++++++++$xmlData+.=+"</"+.+$childElementName+.+">";+
++++}+
++++$xmlData+.=+"</"+.+$rootElementName+.+">";+

++++return+$xmlData;+
}|code-block|syntax|javascript|2269440|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

the function getColumnMeta returns an array. not a string.
besides that, its marked as experimental. i wouldnt use it on a production code until it becames more stable.

but i think this should work

<pre><code>function sqlToXml($queryResult, $rootElementName, $childElementName)
{ 
 $xmlData = "&lt;?xml version=\"1.0\" encoding=\"ISO-8859-1\" ?&gt;\n"; 
 $xmlData .= "&lt;" . $rootElementName . "&gt;";


 while($record = $queryResult-&gt;fetch(PDO::FETCH_OBJ))
 { 
 /* Create the first child element */
 $xmlData .= "&lt;" . $childElementName . "&gt;";

 for ($i = 0; $i &lt; $queryResult-&gt;columnCount(); $i++)
 { 
 $colum = $queryResult-&gt;getColumnMeta($i);
 $fieldName = $column['name'];

 /* The child will take the name of the table column */
 $xmlData .= "&lt;" . $fieldName . "&gt;";

 /* We set empty columns with NULL, or you could set 
 it to '0' or a blank. */
 if(!empty($record-&gt;$fieldName))
 $xmlData .= $record-&gt;$fieldName; 
 else
 $xmlData .= "null"; 

 $xmlData .= "&lt;/" . $fieldName . "&gt;"; 
 } 
 $xmlData .= "&lt;/" . $childElementName . "&gt;"; 
 } 
 $xmlData .= "&lt;/" . $rootElementName . "&gt;"; 

 return $xmlData; 
}
</code></pre>

blocks|key|1790647|text|您需要字段名，所以您必须从getColumnMeta()返回的关联数组中检索它，在该数组中，您错误地认为它返回了一个字符串，所以只需替换以下行：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1790648|$fieldName+=+$queryResult->getColumnMeta($i);|code-block|syntax|javascript|1790649|这一次：|1790650|$fieldName+=+$queryResult->getColumnMeta($i);
$fieldName+=+$fieldName['name'];|1790651|这将使$fieldName包含字段名，因此您的其余代码将工作。|style|CODE|1790652|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/pdostatement.getcolumnmeta.php^0|D|F|0|0|0|0|0|3|A|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@$A|Z|B|10|1|11]]|C|$]]|$1|D|3|E|5|F|7|12|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|13|8|@]|9|@]|C|$]]|$1|K|3|L|5|F|7|14|8|@]|9|@]|C|$G|H]]|$1|M|3|N|5|6|7|15|8|@$A|16|B|17|O|P]]|9|@]|C|$]]|$1|Q|3|-4|5|6|7|18|8|@]|9|@]|C|$]]]|R|$S|$5|T|U|V|C|$W|X]]]]

You want the fieldname, so you have to retrieve it from the associative array returned by <a href="http://php.net/manual/en/pdostatement.getcolumnmeta.php" rel="nofollow">getColumnMeta()</a> where you wrongly thought it returned a string, so just replace your following line:

<pre><code>$fieldName = $queryResult-&gt;getColumnMeta($i);
</code></pre>

for this one:

<pre><code>$fieldName = $queryResult-&gt;getColumnMeta($i);
$fieldName = $fieldName['name'];
</code></pre>

that should make <code>$fieldName</code> to contain the field name and so the rest of your code will work.

i want to convert my mysql queries to XML and for that i've used the code of this tutorial : <a href="http://www.codediesel.com/php/converting-mysql-queries-to-xml/" rel="nofollow">http://www.codediesel.com/php/converting-mysql-queries-to-xml/</a> i had to customize it to use PDO instead of mysql functions.
here's the code : 

<pre><code>function sqlToXml($queryResult, $rootElementName, $childElementName)
{ 
 $xmlData = "&lt;?xml version=\"1.0\" encoding=\"ISO-8859-1\" ?&gt;\n"; 
 $xmlData .= "&lt;" . $rootElementName . "&gt;";

 while($record = $queryResult-&gt;fetch(PDO::FETCH_OBJ))
 { 
 /* Create the first child element */
 $xmlData .= "&lt;" . $childElementName . "&gt;";

 for ($i = 0; $i &lt; $queryResult-&gt;columnCount(); $i++)
 { 
 $fieldName = $queryResult-&gt;getColumnMeta($i);

 /* The child will take the name of the table column */
 $xmlData .= "&lt;" . $fieldName . "&gt;";

 /* We set empty columns with NULL, or you could set 
 it to '0' or a blank. */
 if(!empty($record-&gt;$fieldName))
 $xmlData .= $record-&gt;$fieldName; 
 else
 $xmlData .= "null"; 

 $xmlData .= "&lt;/" . $fieldName . "&gt;"; 
 } 
 $xmlData .= "&lt;/" . $childElementName . "&gt;"; 
 } 
 $xmlData .= "&lt;/" . $rootElementName . "&gt;"; 

 return $xmlData; 
}
</code></pre>

But when i try to execute the code i get this error : 
Notice: Array to string conversion in /opt/lampp/htdocs/promos/t.php on line 42

Notice: Array to string conversion in /opt/lampp/htdocs/promos/t.php on line 42

Notice: Array to string conversion in /opt/lampp/htdocs/promos/t.php on line 42

Notice: Array to string conversion in /opt/lampp/htdocs/promos/t.php on line 42
nullnullnullnull

the line 42 is :

<pre><code>if(!empty($record-&gt;$fieldName))
</code></pre>

Do you have any idea about this ? Thank you :)

Queries to XML, Notice: Array to string conversion in

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我想将mysql查询转换为XML，为此我使用了本教程的代码：我不得不自定义它以使用PDO而不是mysql函数。下面是代码：function sqlToXml($queryResult, $rootElementName, $childElementName){ $xmlData = "<?xml version...

问查询到XML，注意:数组到字符串的转换
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问查询到XML，注意:数组到字符串的转换EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问查询到XML，注意:数组到字符串的转换
EN