mysql建表:
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for fanwe_bank_response
-- ----------------------------
DROP TABLE IF EXISTS `fanwe_bank_response`;
CREATE TABLE `fanwe_bank_response` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`user_name` varchar(100) NOT NULL,
`mobile` varchar(100) NOT NULL,
`response` varchar(1000) NOT NULL,
`create_time` int(11) NOT NULL,
`create_date` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
//测试充值回调信息写入
function bank_response($user_id,$data)
{
$sql="select * from ".DB_PREFIX."user where AES_DECRYPT(mobile_encrypt,'__FANWEP2P__') =".$user_id;
$user=$GLOBALS['db']-> getRow($sql);
$log=array();
$log['user_id']=$user['id'];
$log['user_name']=$user['user_name'];
$log['mobile']=$user_id;
$data=json_encode($data);
$log['response']=$data;
$log['create_time']=TIME_UTC;
$log['create_date']=date("Y-m-d H:i:s",TIME_UTC);
$GLOBALS['db']->autoExecute(DB_PREFIX."bank_response",$log);
}
//调试用写日志文件
function logger($log_content)
{
$max_size = 10000000;
$log_filename = APP_ROOT_PATH."public/".$log_content['mchnt_txn_ssn']."_log.xml";
$GLOBALS['curr_log_file']=$log_filename;
if( file_exists($log_filename) && (abs(filesize($log_filename))>$max_size) )
{
unlink($log_filename);
}
file_put_contents($log_filename, var_export($log_content,TRUE),FILE_APPEND);
}
//调试用写日志文件
function logger2($log_content)
{
$max_size = 10000000;
$log_filename = APP_ROOT_PATH."public/".$log_content['mchnt_txn_ssn']."_log2.xml";
$GLOBALS['curr_log_file']=$log_filename;
if( file_exists($log_filename) && (abs(filesize($log_filename))>$max_size) )
{
unlink($log_filename);
}
file_put_contents($log_filename, var_export($log_content,TRUE),FILE_APPEND);
}