THINKPHP項目開發中的日志記錄實例分析

2020-03-22 19:19:25

字體：大中小

來源：轉載

供稿：網友

本文實例講述了THINKPHP項目開發中的日志記錄用法。分享給大家供大家參考。具體方法如下：1、建立日志表
復制代碼代碼如下:CREATE TABLE `logs` (
`id` int(11) NOT NULL auto_increment,
`guid` varchar(100) character set utf8 NOT NULL,
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
`account` varchar(100) character set utf8 NOT NULL,
`nickname` varchar(100) character set utf8 NOT NULL,
`app` varchar(100) character set utf8 NOT NULL,
`action` varchar(100) character set utf8 NOT NULL,
`method` varchar(100) character set utf8 NOT NULL,
`query_string` text character set utf8 NOT NULL,
`is_desc` varchar(100) character set utf8 NOT NULL,
`desc` varchar(100) character set utf8 NOT NULL,
`ipaddr` varchar(100) character set utf8 NOT NULL,
`unique_flag` varchar(100) character set utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
2、Common/common.php里面進行方法的定義:
復制代碼代碼如下:function getGlobalSkypeLogDbConfig() {
$global_skype_db_config = array(
'dbms' = C('DB_TYPE'),
'username' = C('DB_USER'),
'password' = C('DB_PWD'),
'hostname' = C('DB_HOST'),
'database' = C('DB_NAME'),
);
return $global_skype_db_config;
}

function addOperationLog($desc=NULL, $unique_flag='system', $app=APP_NAME, $action=MODULE_NAME, $method=ACTION_NAME) {
$global_skype_db_config = getGlobalSkypeLogDbConfig();
html' target='_blank'>static $global_skype_log_db_conn;
if (!$global_skype_log_db_conn) {
$global_skype_log_db_conn = mysql_connect($global_skype_db_config['hostname'], $global_skype_db_config['username'], $global_skype_db_config['password']);
}
if (!$global_skype_log_db_conn) {
die('Mysql_Error:' . __FILE__ . '|' . __LINE__ . '|' . mysql_error());
}
mysql_query('use ' . $global_skype_db_config['database'], $global_skype_log_db_conn);
mysql_query('set names utf8 ', $global_skype_log_db_conn);

$account = getAdminAccount();
$nickname = getAdminNickname();
$user_id = getAdminUserId();
$ipaddr = get_client_ip();
$query_string = print_r(array_merge($_GET, $_POST), true);

$desc = $desc;
$is_desc = 0;
$unique_flag = $unique_flag;
if ($desc) {
$is_desc = 1;
}

$insert_time = date('Y-m-d H:i:s');

$query = "INSERT INTO `" . C('LOG_DB_TABLE') . "` (`guid`,`account`,`nickname`,`addtime`,`app`,`action`,
`method`,`query_string`,`is_desc`,`desc`,`ipaddr`,`unique_flag`) VALUES ('$user_id','$account','$nickname','$insert_time','$app',
'$action','$method','$query_string','$is_desc','$desc','$ipaddr','$unique_flag');";

return mysql_query($query, $global_skype_log_db_conn);
}

function getAdminAccount() {
return $_SESSION['loginAccount'];
}

function getAdminNickname() {
return $_SESSION['loginUserName'];
}

function getAdminUserId() {
return $_SESSION[C('USER_AUTH_KEY')];
}
在其他操作類里調用addOperationLog();即可希望本文所述對大家的ThinkPHP框架程序設計有所幫助。PHP教程

鄭重聲明：本文版權歸原作者所有，轉載文章僅為傳播更多信息之目的，如作者信息標記有誤，請第一時間聯系我們修改或刪除，多謝。

上一篇：php設計模式之委托模式

下一篇：Zend Framework教程之模型Model基本規則和使用方法