php實(shí)現(xiàn)的mysqldb讀寫(xiě)分離操作類(lèi)示例
636
2024-01-10
通過(guò)如下代碼就可以簡(jiǎn)單實(shí)現(xiàn)select帶模糊查詢(xún)的條件查詢(xún),具體如下jquery.select.js如下:
(function($) { $.selectSuggest = function(target, data, itemSelectFunction) { var defaulOption = { suggestMaxHeight: '200px',//彈出框最大高度 itemColor : '#000000',//默認(rèn)字體顏色 itemBackgroundColor:'RGB(199,237,204)',//默認(rèn)背景顏色 itemOverColor : '#ffffff',//選中字體顏色 itemOverBackgroundColor : '#C9302C',//選中背景顏色 itemPadding : 3 ,//item間距 fontSize : 12 ,//默認(rèn)字體大小 alwaysShowALL : true //點(diǎn)擊input是否展示所有可選項(xiàng) }; var maxFontNumber = 0;//最大字?jǐn)?shù) var currentItem; var suggestContainerId = target + "-suggest"; var suggestContainerWidth = $('#' + target).innerWidth(); var suggestContainerLeft = $('#' + target).offset().left; var suggestContainerTop = $('#' + target).offset().top + $('#' + target).outerHeight(); var showClickTextFunction = function() { $('#' + target).val(this.innerText); currentItem = null; $('#' + suggestContainerId).hide(); } var suggestContainer; if ($('#' + suggestContainerId)[0]) { suggestContainer = $('#' + suggestContainerId); suggestContainer.empty(); } else { suggestContainer = $('<div></div>'); //創(chuàng)建一個(gè)子<div> } suggestContainer.attr('id', suggestContainerId); suggestContainer.attr('tabindex', '0'); suggestContainer.hide(); var _initItems = function(items) { suggestContainer.empty(); var itemHight=0; for (var i = 0; i < items.length; i++) { if(items[i].text.length > maxFontNumber){ maxFontNumber = items[i].text.length; } var suggestItem = $('<div></div>'); //創(chuàng)建一個(gè)子<div> suggestItem.attr('id', items[i].id); suggestItem.append(items[i].text); suggestItem.css({ 'padding':defaulOption.itemPadding + 'px', 'white-space':'nowrap', 'cursor': 'pointer', 'background-color': defaulOption.itemBackgroundColor, 'color': defaulOption.itemColor }); suggestItem.bind("mouseover", function() { $(this).css({ 'background-color': defaulOption.itemOverBackgroundColor, 'color': defaulOption.itemOverColor }); currentItem = $(this); }); suggestItem.bind("mouseout", function() { $(this).css({ 'background-color': defaulOption.itemBackgroundColor, 'color': defaulOption.itemColor }); currentItem = null; }); suggestItem.bind("click", showClickTextFunction); suggestItem.bind("click", itemSelectFunction); suggestItem.appendTo(suggestContainer); suggestContainer.appendTo(document.body); } } var inputChange = function() { var inputValue = $('#' + target).val(); inputValue = inputValue.replace(/[-[]{}()*+?.,\^$|#s]/g, "\$&"); var matcher = new RegExp(inputValue, "i"); return $.grep(data, function(value) { return matcher.test(value.text); }); } $('#' + target).bind("keyup", function() { _initItems(inputChange()); }); $('#' + target).bind("blur", function() { if(!$('#' + suggestContainerId).is(":focus")){ $('#' + suggestContainerId).hide(); if (currentItem) { currentItem.trigger("click"); } currentItem = null; return; } }); $('#' + target).bind("click", function() { if (defaulOption.alwaysShowALL) { _initItems(data); } else { _initItems(inputChange()); } $('#' + suggestContainerId).removeAttr("style"); var tempWidth = defaulOption.fontSize*maxFontNumber + 2 * defaulOption.itemPadding + 30; var containerWidth = Math.max(tempWidth, suggestContainerWidth); var h = this.scrollHeight; $('#' + suggestContainerId).css({ 'border': '1px solid #ccc', 'max-height': '100px', 'top': suggestContainerTop, 'left': suggestContainerLeft, 'width': containerWidth, 'position': 'absolute', 'font-size': defaulOption.fontSize+'px', 'font-family':'Arial', 'z-index': 99999, 'background-color': '#FFFFFF', 'overflow-y': 'auto', 'overflow-x': 'hidden', 'white-space':'nowrap' }); $('#' + suggestContainerId).show(); }); _initItems(data); $('#' + suggestContainerId).bind("blur", function() { $('#' + suggestContainerId).hide(); }); } })(jQuery);
html如下:
<!DOCTYPE html> <html lang="zh_cn"> <head> <title>select.suggest</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> < Bootstrap --> <script src="http://www.gimoo.net/t/1807/js/jquery-1.10.2.js"></script> <script src="http://www.gimoo.net/t/1807/js/jquery.select.js"></script> </head> <body> <h1>Hello, world!</h1> <div> <div> <div>.col-md-1 </div> <div style=""> <input id="testInput" type="text" /> </div> </div> </div> < jQuery (necessary for Bootstrap's JavaScript plugins) --> < Include all compiled plugins (below), or include individual files as needed --> </body> <script type="text/javascript"> var datas =[{"id":"2","text":"中國(guó)石油"}, {"id":"4","text":"中國(guó)建筑"}, {"id":"3","text":"中國(guó)移動(dòng)"}, {"id":"5","text":"中國(guó)工商銀行"}, {"id":"7","text":"中國(guó)鐵建"}, {"id":"8","text":"上海汽車(chē)集團(tuán)"}, {"id":"9","text":"中國(guó)建設(shè)銀行"}, {"id":"10","text":"聯(lián)想集團(tuán)"}]; var itemSelectFuntion = function(){ alert(this.id + "," + this.innerHTML); }; $.selectSuggest('testInput',datas,itemSelectFuntion); </script> </html>
以上就是本文的全部?jī)?nèi)容,希望對(duì)大家的學(xué)習(xí)有所幫助,也希望大家多多支持綠夏網(wǎng)。
#免責(zé)聲明#
本站[綠夏技術(shù)導(dǎo)航]提供的一切軟件、教程和內(nèi)容信息僅限用于學(xué)習(xí)和研究目的;不得將上述內(nèi)容用于商業(yè)或者非法用途,否則,一切后果請(qǐng)用戶(hù)自負(fù)。本站信息來(lái)自網(wǎng)絡(luò)收集整理,版權(quán)爭(zhēng)議與本站無(wú)關(guān)。您必須在下載后的24個(gè)小時(shí)之內(nèi),從您的電腦或手機(jī)中徹底刪除上述內(nèi)容。如果您喜歡該程序或內(nèi)容,請(qǐng)支持正版,購(gòu)買(mǎi)注冊(cè),得到更好的正版服務(wù)。我們非常重視版權(quán)問(wèn)題,如有侵權(quán)請(qǐng)郵件[admin@lxwl520.com]與我們聯(lián)系進(jìn)行刪除處理。敬請(qǐng)諒解!