Motivation: The query function is the most common also the most common functional module we have seen on the website. The past information queries are connected to the database, and each click must be supported by the background database. In many cases, however, users often operate only for a part of the data, not only aggalators of the server, but also seriously affects the speed of users. In this case, we need to pass a part of the data required in XML to the client in XML, and the user can operate on these data. It is convenient for users and reduces the burden on the server database. why not! And this feature can be generally used to many other modules, so this dynamic query function is added. Material: XML Volume Dynamic Query There are 2 files: Search.xml and Search.xsl effect: Filter data in the case of not refreshing the page, effectively improve the functionality of data queries. Effect: Browse here code: Search.xml
Program code: [Copy code to clipboard]
1 Sailflying A simple query 2002-1-11 17:35:33 xml topic < Team> 2 flyingbird Marry you, is you want you to hurt 2001-09-06 12:45:51 Irrigation essence 3 Changer Regular expression in UBB Forum < Blue_time> 2001-11-23 21:02:16 Web programming essence 4 Tai Lo Year-end Classic True Party Complete Manual V0.1 2000-12-08 10:22:48 Forum Irrigation District 5 mmkk ASP error message 2001 2001-10-13 16:39:05 javascript script search.xsl
Program code: [Copy code to clipboard]
XML Volume Battle (2): Dynamic Query </ Title> <style> body, blueidea, team, blue_id, blue_name, blue_text, Blue_time, blue_class {font: 12px "Song", "Arial", "Times New Roman";} Table {font-size: 12px; border: 0px double; border-color: # 99cc99 # 99cc99 #cccccccccccccccccccccccccccccccccccccccccccc; cellpadding: 3; Cellspacing: 3; BGCOLOR: #eeeee; text-decoration: blink} span {font-size: 12px; color: red;} </ style> <script> function searchText (x) {styleSheet = document.xsldocument; source; source; source; dom = Document.xmldocument; sortfield = document.xsldocument.select nodes ("@ select"); if (x! = ") {sortfield [1] .value =" Team [blue_id = '" x " "]" Layer1.innerhtml = source.documentelement.transformNode (Stylesheet);} else {ALERT ("Please enter filter crit!");}} </ Script> </ head> <body> <p align = "center> < Span> XML Volume Battle (2): Dynamic Query </ span> </ p> <div id = "layer1" name = "layer1"> <xsl: Apply-templates select = "blueidea" /> </ DIV> <hr size = "1" width = "500" /> <table align = "center" cellpadding = "0" cellspacing = "0" border = "0"> <tr> <td> <span> Please enter Screening conditions: </ span> blue_id = <input type = "text" Name = "searchtext" size = "1" maxlength = "1" /> <input type = "button" class = "button" onclick = "searchText (Document.all.SearchText.Value" Value = "search" name = "button" /> </ td> </ tr> <</p>
<p>/ table> </ body> </ html> </ xsl: template> <xsl: template match = "blueidea"> <table width = "500" border = "1" align = "center" cellpadding = "1" cellspacing = "1" bordercolordark = "# fffff" bordercolorlight = "# adaaaad"> <tr bgcolor = "# ffc99" align = "center"> <td> number </ td> <TD> Name </ td> <TD> Topic </ TD> <TD> Posted </ TD> <TD> Classification </ TD> </ TR> <XSL: Apply-Templates Select = "Team" ORDER-by = "Blue_ID" /> </ TABLE > </ xsl: template> <xsl: template match = "team"> <trilign = "center"> <xsl: apply-templates select = "blue_id" /> <xsl: Apply-templates select = "blue_name" / > <XSL: Apply-Templates Select = "Blue_Text" /> <xsl: Apply-Templates SELECT = "Blue_time" /> <xsl: Apply-Templates Select = "Blue_class" /> </ tr> </ xsl: template> <XSL: Template Match = "Blue_ID"> <TD BGCOLOR = "# eeeeee"> <xsl: value-of /> </ td> </ xsl: template> <xsl: template match = "blue_name"> <td> <xsl: value-of /> </ td> </ xsl: template> <xsl: template match = "blue_text"> <td> <xsl: value-of /> </ td> </ xsl: template> < XSL: template match = "blue_time"> <td> <xsl: value-of /> </ td> </ xsl: template> <xsl: template match = "blue_class"> <td> <xsl: value -of /> </ td> </ xsl: template> </ xsl: styleSheet></p></div><div class="text-center mt-3 text-grey">
转载请注明原文地址:https://www.9cbs.com/read-70169.html</div><div class="plugin d-flex justify-content-center mt-3"></div><hr><div class="row"><div class="col-lg-12 text-muted mt-2"><i class="icon-tags mr-2"></i><span class="badge border border-secondary mr-2"><h2 class="h6 mb-0 small"><a class="text-secondary" href="tag-2.html">9cbs</a></h2></span></div></div></div></div><div class="card card-postlist border-white shadow"><div class="card-body"><div class="card-title"><div class="d-flex justify-content-between"><div><b>New Post</b>(<span class="posts">0</span>)
</div><div></div></div></div><ul class="postlist list-unstyled">
</ul></div></div><div class="d-none threadlist"><input type="checkbox" name="modtid" value="70169" checked /></div></div></div></div></div><footer class="text-muted small bg-dark py-4 mt-3" id="footer"><div class="container"><div class="row"><div class="col">CopyRight © 2020 All Rights Reserved
</div><div class="col text-right">Processed:
<b>0.050</b>, SQL:
<b>9</b></div></div></div></footer><script src="./lang/en-us/lang.js?2.2.0"></script><script src="view/js/jquery.min.js?2.2.0"></script><script src="view/js/popper.min.js?2.2.0"></script><script src="view/js/bootstrap.min.js?2.2.0"></script><script src="view/js/xiuno.js?2.2.0"></script><script src="view/js/bootstrap-plugin.js?2.2.0"></script><script src="view/js/async.min.js?2.2.0"></script><script src="view/js/form.js?2.2.0"></script><script>
var debug = DEBUG = 0;
var url_rewrite_on = 1;
var url_path = './';
var forumarr = {"1":"Tech"};
var fid = 1;
var uid = 0;
var gid = 0;
xn.options.water_image_url = 'view/img/water-small.png';
</script><script src="view/js/wellcms.js?2.2.0"></script><a class="scroll-to-top rounded" href="javascript:void(0);"><i class="icon-angle-up"></i></a><a class="scroll-to-bottom rounded" href="javascript:void(0);" style="display: inline;"><i class="icon-angle-down"></i></a></body></html><script>
var forum_url = 'list-1.html';
var safe_token = 'IxW9P3je9hLQ0TgCEl8dMMsQSMWo0D5RNSEz8bk6PD9_2B_2Fv_2BPzcBkmjPclPLnMFibw1xd8Bha6zYNLxbtkcPZ5w_3D_3D';
var body = $('body');
body.on('submit', '#form', function() {
var jthis = $(this);
var jsubmit = jthis.find('#submit');
jthis.reset();
jsubmit.button('loading');
var postdata = jthis.serializeObject();
$.xpost(jthis.attr('action'), postdata, function(code, message) {
if(code == 0) {
location.reload();
} else {
$.alert(message);
jsubmit.button('reset');
}
});
return false;
});
function resize_image() {
var jmessagelist = $('div.message');
var first_width = jmessagelist.width();
jmessagelist.each(function() {
var jdiv = $(this);
var maxwidth = jdiv.attr('isfirst') ? first_width : jdiv.width();
var jmessage_width = Math.min(jdiv.width(), maxwidth);
jdiv.find('img, embed, iframe, video').each(function() {
var jimg = $(this);
var img_width = this.org_width;
var img_height = this.org_height;
if(!img_width) {
var img_width = jimg.attr('width');
var img_height = jimg.attr('height');
this.org_width = img_width;
this.org_height = img_height;
}
if(img_width > jmessage_width) {
if(this.tagName == 'IMG') {
jimg.width(jmessage_width);
jimg.css('height', 'auto');
jimg.css('cursor', 'pointer');
jimg.on('click', function() {
});
} else {
jimg.width(jmessage_width);
var height = (img_height / img_width) * jimg.width();
jimg.height(height);
}
}
});
});
}
function resize_table() {
$('div.message').each(function() {
var jdiv = $(this);
jdiv.find('table').addClass('table').wrap('<div class="table-responsive"></div>');
});
}
$(function() {
resize_image();
resize_table();
$(window).on('resize', resize_image);
});
var jmessage = $('#message');
jmessage.on('focus', function() {if(jmessage.t) { clearTimeout(jmessage.t); jmessage.t = null; } jmessage.css('height', '6rem'); });
jmessage.on('blur', function() {jmessage.t = setTimeout(function() { jmessage.css('height', '2.5rem');}, 1000); });
$('#nav li[data-active="fid-1"]').addClass('active');
</script>
