<?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; }