首頁猿問請各位大佬指點(diǎn)！php下msql搜...

請各位大佬指點(diǎn)！php下msql搜索查詢問題。求老司機(jī)指點(diǎn)！

JavaScript

SMILET 2019-08-21 11:42:40

目前有個(gè)項(xiàng)目，搜索的功能。在一個(gè)table里。姓名學(xué)號手機(jī)號項(xiàng)目A項(xiàng)目B除了姓名以外，其他都是精確查詢。姓名:模糊查詢學(xué)號手機(jī)號項(xiàng)目A項(xiàng)目A:精確查詢只輸入一個(gè)關(guān)鍵字，其他不輸入也能查詢。請問這個(gè)sql怎么寫??？

查看完整描述

2 回答

偶然的你

TA貢獻(xiàn)1841條經(jīng)驗(yàn) 獲得超3個(gè)贊

查詢條件可以這么寫if(trim($where['name'])){$where['name']=['like',"%".trim($where['name'])."%"];}else{unset($where['name']);}if(trim($where['number'])){$where['number']=['like',"%".trim($where['number'])."%"];}else{unset($where['number']);}if(trim($where['tel'])){$where['status']=trim($where['status']);}else{unset($where['status']);}