# 數據庫操作 * * * * * **注意：此處的代碼僅為業務邏輯層進行數據庫操作的部分參考代碼** **保存數據** ~~~ $data['nickname'] = $data['username']; $data['leader_id'] = MEMBER_ID; $data['is_inside'] = DATA_NORMAL; $result = $this->modelMember->setInfo($data); ~~~ **新增數據** ~~~ $data = ['name' => $filename, 'path' => $file_dir_name. SYS_DS_PROS . $filename, 'sha1' => $sha1]; $result = $this->modelFile->addInfo($data); ~~~ **更新數據** ~~~ $where = array('name' => $name); $this->modelConfig->updateInfo($where, ['value' => $value]); ~~~ **批量保存數據** ~~~ $exe_log_array = require $exe_log_path; if (empty($exe_log_array) || DATA_NORMAL == $exe_log_array) : return [RESULT_ERROR, '日志文件為空']; endif; $this->modelExeLog->setList($exe_log_array) && file_put_contents($exe_log_path, ''); ~~~ **設置某個字段值** ~~~ $v['rules'] = arr2str(array_values($rules_arr)); $this->modelAuthGroup->setFieldValue(['id' => $v['id']], 'rules', $v['rules']); ~~~ **刪除數據** ~~~ /** * 友情鏈接刪除 */ public function blogrollDel($where = []) { $result = $this->modelBlogroll->deleteInfo($where); $result && action_log('刪除', '友情鏈接刪除' . '，where：' . http_build_query($where)); return $result ? [RESULT_SUCCESS, '刪除成功'] : [RESULT_ERROR, $this->modelBlogroll->getError()]; } ~~~ **獲取某個字段的值** ~~~ /** * 獲取默認頁面標題 */ public function getDefaultTitle() { return $this->modelMenu->getValue(['module' => MODULE_NAME, 'url' => URL], 'name'); } ~~~ **獲取單條數據** ~~~ /** * 獲取驅動信息 */ public function getDriverInfo($where = [], $field = true) { return $this->modelDriver->getInfo($where, $field); } ~~~ **獲取列表數據** ~~~ /** * 獲取會員列表 */ public function getMemberList($where = [], $field = 'm.*,b.nickname as leader_nickname', $order = '', $paginate = DB_LIST_ROWS) { $this->modelMember->alias('m'); $join = [ [SYS_DB_PREFIX . 'member b', 'm.leader_id = b.id', 'LEFT'], ]; $where['m.' . DATA_STATUS_NAME] = ['neq', DATA_DELETE]; return $this->modelMember->getList($where, $field, $order, $paginate, $join); } ~~~