/**
* 执行一条SQL语句
* @param unknown $sql
* @param string $params
*/
function exec($sql, $params = NULL)
{
if (func_num_args() == 2) {
$params = $this->autoarr($params);
} else {
$params = func_get_args();
array_shift($params);
}
return $this->db->execute($sql, $params);
}
/**
* 显示简单数据库信息
*/
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;
}
