<?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);
}
/**
* 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;
}
