# Niushop開源商城數據操作 --- niushop使用了thinkphp的數據庫操作原理，用戶可以使用thinkphp的數據庫操作，但是niushop針對數據庫操作整體進行了封裝，數據查詢更加方便，所以建議用戶使用niushop專門封裝的數據庫操作便于整體管理。 ### 1. **數據查詢** 查詢單條數據 getInfo\($condition, $field\):$condition:表示傳入條件，$field:表示查詢字段 ```php model('help')->getInfo([ ['id', '=', $help_id], ['site_id', '=', $site_id] ], 'id, title, content, class_id, class_name, sort, link_address, create_time, modify_time'); ``` 查詢列表getList\($condition = \[\], $field = true, $order = '', $alias = 'a', $join = \[\], $group = '', $limit = null\) ```php model('help')->getList($condition, $field, $order, '', '', '', $limit); ``` 查詢分頁列表pageList\($condition = \[\], $field = true, $order = '', $page = 1, $list\_rows = PAGE\_LIST\_ROWS, $alias = 'a', $join = \[\], $group = null, $limit = null\) ```php model('help')->pageList($condition, $field, $order, $page, $page_size); ``` 查詢視圖，按照thinkphp視圖查詢方法： ```php public function getApplyDetail($condition) { $field = 'nsa.apply_id, nsa.site_id,nsa.website_id, nsa.member_id, nsa.username, nsa.cert_id, nsa.shop_name, nsa.apply_state, nsa.apply_message, nsa.apply_year, nsa.category_name, nsa.category_id, nsa.group_name, nsa.group_id, nsa.paying_money_certificate, nsa.paying_money_certificate_explain, nsa.paying_deposit, nsa.paying_apply, nsa.paying_amount, nsa.create_time, nsa.audit_time, nsa.finish_time, nsc.cert_id, nsc.cert_type, nsc.company_name, nsc.company_province_id, nsc.company_city_id, nsc.company_district_id, nsc.company_address, nsc.contacts_name, nsc.contacts_mobile, nsc.contacts_card_no, nsc.contacts_card_electronic_1, nsc.contacts_card_electronic_2, nsc.contacts_card_electronic_3, nsc.business_licence_number, nsc.business_licence_number_electronic, nsc.business_sphere, nsc.taxpayer_id, nsc.general_taxpayer, nsc.tax_registration_certificate, nsc.tax_registration_certificate_electronic, nsc.bank_account_name, nsc.bank_account_number, nsc.bank_name, nsc.bank_address, nsc.bank_code, nsc.bank_type, nsc.settlement_bank_account_name, nsc.settlement_bank_account_number, nsc.settlement_bank_name, nsc.settlement_bank_address,nsc.company_full_address, w.site_area_name'; $alias = 'nsa'; $join = [ [ 'shop_cert nsc', 'nsa.cert_id = nsc.cert_id', 'left' ], [ 'website w', 'w.site_id = nsa.website_id', 'left' ], ]; $info = model('shop_apply')->getInfo($condition, $field, $alias, $join); return $this->success($info); } ``` 查詢第一條數據getFirstData\($condition, $order\) 獲取查詢數據的數量getCount\($condition\) 獲取查詢字段和getSum\($condition, $field\) 獲取查詢字段最大值getMax\($condition, $field\) 獲取查詢字段最小值getMin\($condition, $field\) ### **2. 數據添加** niushop數據添加使用add方法，例如： ```php /** * 添加幫助文章 * @param array $data */ public function addHelp($data) { $help_id = model('help')->add($data); Cache::tag("help")->clear(); return $this->success($help_id); } ``` ### **3. 數據修改，使用update方法，傳入修改條件** ```php /** * 修改幫助文章 * @param array $data */ public function editHelp($data, $condition) { $res = model('help')->update($data, $condition); Cache::tag("help")->clear(); return $this->success($res); } ``` ### **4. 數據刪除，使用delete方法** ```php /** * 刪除文章 * @param unknown $coupon_type_id */ public function deleteHelp($condition) { $res = model('help')->delete($condition); Cache::tag("help")->clear(); return $this->success($res); } ```