<?php /** * User: Eden * Date: 2019/3/30 * 共有内容 */ /** CREATE TABLE `tf_configs` ( `id` int(11) NOT NULL COMMENT 'id', `key` varchar(100) NOT NULL COMMENT 'key', `value` text NOT NULL COMMENT 'value', `create_time` int(11) NOT NULL COMMENT '创建时间' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='配置表'; */ namespace Common\Service; class ConfigService extends CommonService { /** * 添加一个key * $key = 'total_donate' * @param $key * @param $val * @return array */ public function addOneKey($key,$val) { // 查询key是否存在 $configs = M('configs'); $r = $configs->where(array('key'=>$key))->find(); if ($r !== false) { // 添加 $data = [ 'key' => $key, 'value' => $val, 'create_time'=> time() ]; return $configs->add($data); } else { return $configs->where(['key'=>$key])->save(['value'=>$val]); } } /** * 更新单个key * $key = 'total_donate' * @param $key * @param $val * @return array */ public function updateOneKey($key,$val) { $configs = M('configs'); return $configs->where(['key'=>$key])->save(['value'=>$val]); } /** * 查询单个key * $key = 'total_donate'; * @param $key * @return array */ public function queryOneKey($key) { $configs = M('configs'); $data = $configs->where(['key'=>$key])->find(); if ($data) { return $data['value']; } else { return false; } } /** * 查询多个key * $keys = 'total_donate,total_help,total_join'; * $keys = ['total_donate','total_help','total_join']; * @param array $keys * @return mixed */ public function queryKeys($keys = []) { $where = []; if ($keys) { $where['key'] = ['in', $keys]; } $configs = M('configs'); $data = $configs->where($where)->getField('`key`, `value`'); return $data; } /** * 查询key * $key = ['key'=>['in', 'total_donate,total_help,total_join']]; * $key = ['key'=>['in', ['total_donate','total_help','total_join']]]; * @param $key * @return array */ public function queryKey($key) { $configs = M('configs'); $website = $configs->where($key)->getField('`key`, `value`'); return $website; } }
更全面了!很实用的配置服务。