首页 \ 问答 \ PHP使用分组解析XML文件[关闭](PHP parse XML file with grouping [closed])

PHP使用分组解析XML文件[关闭](PHP parse XML file with grouping [closed])

 我有来自库源的以下xml代码：  
<?xml version="1.0" encoding="UTF-8"?>
<Data>
  <MyData>
    <Column Collections="Books.ID">
      <Row>1534</Row>
      <Row>2753</Row>
      <Row>3734</Row>
      <Row>4029</Row>
      <Row>5242</Row>
      <Row>6833</Row>
      <Row>7275</Row>
      <Row>8456</Row>
    </Column>
    <Column Collections="Books.InStock">
      <Row>0</Row>
      <Row>0</Row>
      <Row>0</Row>
      <Row>0</Row>
      <Row>0</Row>
      <Row>0</Row>
      <Row>0</Row>
      <Row>0</Row>
    </Column>
    <Column Collections="Books.HowMany">
      <Row>12</Row>
      <Row>4</Row>
      <Row>19</Row>
      <Row>2</Row>
      <Row>0</Row>
      <Row>18</Row>
      <Row>52</Row>
      <Row>26</Row>
      <Row>32</Row>
      <Row>4</Row>
    </Column>
  </MyData>
 </Data>
 
 如何将该数据放入使用SimpleXML的html表中？ 

I have the following xml code from a library source: 
<?xml version="1.0" encoding="UTF-8"?>
<Data>
  <MyData>
    <Column Collections="Books.ID">
      <Row>1534</Row>
      <Row>2753</Row>
      <Row>3734</Row>
      <Row>4029</Row>
      <Row>5242</Row>
      <Row>6833</Row>
      <Row>7275</Row>
      <Row>8456</Row>
    </Column>
    <Column Collections="Books.InStock">
      <Row>0</Row>
      <Row>0</Row>
      <Row>0</Row>
      <Row>0</Row>
      <Row>0</Row>
      <Row>0</Row>
      <Row>0</Row>
      <Row>0</Row>
    </Column>
    <Column Collections="Books.HowMany">
      <Row>12</Row>
      <Row>4</Row>
      <Row>19</Row>
      <Row>2</Row>
      <Row>0</Row>
      <Row>18</Row>
      <Row>52</Row>
      <Row>26</Row>
      <Row>32</Row>
      <Row>4</Row>
    </Column>
  </MyData>
 </Data>
 
How can I put that data into a html table with SimpleXML?

原文：https://stackoverflow.com/questions/39300847

更新时间：2023-04-21 14:04

最满意答案

 看起来这是不可能的。  
 一种解决方法是使用触发器：  
CREATE OR REPLACE TRIGGER test_trigger
  BEFORE INSERT OR UPDATE
ON test_table
  FOR EACH ROW
WHEN ( new.test_attr IS NULL )
BEGIN
  :new.test_attr := NEW test_t();
END test_trigger;
/
 
 
 它不会完全忽略非默认构造函数，覆盖默认构造函数  
CONSTRUCTOR FUNCTION test_t(in_val NUMBER)
RETURN SELF AS RESULT
 
 尝试使用DEFAULT NEW test_t(1)定义表时导致异常：  
 
  ORA-06553：PLS-307：太多的'TEST_T'声明与此调用相匹配  

Looks like this is not possible. 
One workaround would be to use a trigger: 
CREATE OR REPLACE TRIGGER test_trigger
  BEFORE INSERT OR UPDATE
ON test_table
  FOR EACH ROW
WHEN ( new.test_attr IS NULL )
BEGIN
  :new.test_attr := NEW test_t();
END test_trigger;
/
 
 
It does not completely ignore non-default constructors by the way, overriding the default constructor 
CONSTRUCTOR FUNCTION test_t(in_val NUMBER)
RETURN SELF AS RESULT
 
leads to an exception when trying to define the table with DEFAULT NEW test_t(1): 
 
 ORA-06553: PLS-307: too many declarations of 'TEST_T' match this call

PHP使用分组解析XML文件[关闭](PHP parse XML file with grouping [closed])

最满意答案

相关问答

对象的默认值(Default value for object)[2022-09-20]

什么是sqlite默认列类型？(What is the sqlite default column type?)[2021-12-22]

Oracle中的数字的默认精度和比例是多少？(What is the default Precision and Scale for a Number in Oracle?)[2023-05-05]

在oracle数据库中，如何为用户定义类型的参数指定默认值？(In oracle database, how can I specify default value for a parameter that is a user defined type?)[2024-01-20]

如何使用datetime列类型将datetimepicker默认值插入MYSQL？(How to insert datetimepicker default value to MYSQL with datetime column type?)[2023-11-27]

Oracle：为对象类型列指定默认值(Oracle: specifying default value for object type column)[2021-10-03]

如何将列默认值从DB2复制到Oracle(How to replicate column default value from DB2 to Oracle)[2022-03-29]

如何根据使用它的内容类型在SharePoint中设置用户定义列的默认值(How to set the default value of a user defined column in SharePoint depending on the content type that uses it)[2022-01-12]

oracle列的默认值(oracle default value for a column)[2022-09-07]

MYSQL列的默认值无效(Invalid Default Value for MYSQL Column)[2024-01-18]

相关文章

最新问答