예제 #1
0
<?php

require "dbConnect.php";
require "personalFunctions.php";
if (isset($_POST['table']) && isset($_POST['format'])) {
    $sql = 'SELECT * FROM ' . $_POST['table'];
    $result = $dbo->query($sql);
    $rows = $result->fetchAll(PDO::FETCH_ASSOC);
    unset($dbo);
    switch ($_POST['format']) {
        case 'csv':
            writeCsv($rows);
            break;
        case 'json':
            writeJson($rows);
            break;
        case 'xml':
            writeXml($rows);
            break;
    }
} else {
    $result = $dbo->query('SHOW TABLES');
    unset($dbo);
}
예제 #2
0
파일: base.php 프로젝트: drehere/shenmegui
/**
 * transform Object to XML string
 *
 * @param $obj
 * @param string $rootName : root node name of xml
 * @param bool $content : only content or all  
 * @return XMLstring
 */
function toXmlString($obj, $nodeName, $content)
{
    $dom = new DOMDocument('1.0', 'utf-8');
    writeXml($obj, $dom, $dom, $dom, $nodeName);
    $return = $dom->saveXML();
    /**
     * 返回xml内容,不包括头信息
     * 
     * <?xml version="1.0" encoding="utf-8"?>
     * 长度为38个字节
     */
    if ($content === true) {
        $return = substr($return, 38);
    }
    return $return;
}