Subversion-Projekte lars-tiefland.php_share

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
--TEST--
2 
XML_Query2XML::getXML(): [sql][limit] set to 0
3 
--SKIPIF--
4 
<?php $db_layers = array('MDB2', 'DB'); require_once dirname(dirname(__FILE__)) . '/skipif.php'; ?>
5 
--FILE--
6 
<?php
7 
require_once 'XML/Query2XML.php';
8 
require_once dirname(dirname(__FILE__)) . '/db_init.php';
9 
$query2xml = XML_Query2XML::factory($db);
10 
$dom = $query2xml->getXML(
11 
    array(
12 
        'query' => 'SELECT * FROM employee',
13 
        'limit' => 3,
14 
        'offset' => 2
15 
    ),
16 
    array(
17 
        'rootTag' => 'employees',
18 
        'rowTag' => 'employee',
19 
        'idColumn' => 'employeeid',
20 
        'elements' => array(
21 
            'employeename'
22 
        )
23 
    )
24 
);
25 
 
26 
$dom->formatOutput = true;
27 
print $dom->saveXML();
28 
?>
29 
--EXPECT--
30 
<?xml version="1.0" encoding="UTF-8"?>
31 
<employees>
32 
  <employee>
33 
    <employeename>Steve Hack</employeename>
34 
  </employee>
35 
  <employee>
36 
    <employeename>Joan Kerr</employeename>
37 
  </employee>
38 
  <employee>
39 
    <employeename>Marcus Roth</employeename>
40 
  </employee>
41 
</employees>