/** * 显示简单数据库信息 */ public function data() { $pdo = CxPdo::Init(); $result = $pdo->query("SHOW TABLES FROM " . DB_NAME)->fetchAll(); if (!$result) { die('No Data ...'); } foreach ($result as $v) { $tables[] = $v['Tables_in_' . DB_NAME]; } if (!isset($_REQUEST['_1'])) { $_REQUEST['_1'] = $tables[0]; } $tableName = $_REQUEST['_1']; //表名 if (!in_array($tableName, $tables)) { die('No Table ...'); } $dao = new CxDao($tableName); if (!isset($_REQUEST['_2'])) { $_REQUEST['_2'] = 10; } //显示的数量 if (!isset($_REQUEST['_3'])) { $_REQUEST['_3'] = $dao->id(); } //表的ID if (!isset($_REQUEST['_4'])) { $_REQUEST['_4'] = 'desc'; } //显示的顺序 $result = $dao->tbl()->limit($_REQUEST['_2'], 0)->orderby($_REQUEST['_3'] . ' ' . $_REQUEST['_4'])->fetchAll(); $num = $dao->count(); include PATH_CXMVC . 'tbl/data.tbl.php'; }
/** * 根据SQL语句执行一个存储过程 * @param string $sql * @param array $params * @param string $result * @return array */ public static function call_bak($sql, $params = null, $result = null) { $pdo = CxPdo::Init(); $pdo->execute($sql, $params); if ($result != null) { return $pdo->query('select ' . $result)->fetch(); } return true; }