最近感觉写jquery水平提高,帮朋友的感觉不错
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<script language="javascript" src="jquery.js"></script>
<style type="text/css">
#ln_find_time{ float:left;}
#ln_find_place{ float:left;}
#ln_find_language{ float:left;}
#ln_find_geshi{ float:left;}
#ln_find_kind{ float:left;}
#ln_find_singer{ float:left;}
</style>
<script language="javascript">
//显示选择内容
function finddata(divname,selval){
selectname = "#sel_"+divname+" option:selected";
outdivname = '#ln_'+divname;
indivname = '#'+divname;
if(selval!=0){
$(".z_h").show();
content = $(selectname).text();
closevar = "'"+divname+"'";
var ddd = '<div id="ln_'+divname+'" style="display:none;"><span id="'+divname+'"></span><span><a href="javascript:void(0);" οnclick="closeDiv('+closevar+')">X</a></span></div>';
$(".z_h").append(ddd);
$(indivname).html(content);
$(outdivname).show();
}else{
closeDiv(divname);
}
}
//关闭选择内容
function closeDiv(divname){
outdivname = '#ln_'+divname;
indivname = '#'+divname;
selectname = "#sel_"+divname;
$(indivname).html("");
$(outdivname).hide();
$(selectname)[0].selectedIndex = 0;
}
//ajax获取查找数据
function sendData(){
var newtime = $("#sel_find_time option:selected").val();
var newkind = $("#sel_find_kind option:selected").val();
var newlanguage = $("#sel_find_language option:selected").val();
var newgeshi = $("#sel_find_geshi option:selected").val();
$.ajax({
type:"POST",
url:"find.php",
data:"newtime="+newtime+"&newkind="+newkind+"&newlanguage="+newlanguage+"&newgeshi="+newgeshi,
success:function(data){
alert(data);
$("#result").html(data);
}
});
}
//全选和取消
$("document").ready(function(){
$("#allcheck").click(function(){
if(this.checked){
$("input[name='trkid']").each(function(){this.checked=true;});
}else{
$("input[name='trkid']").each(function(){this.checked=false;});
}
});
});
//反选
function selfan(){
$("[name='trkid']").each(function(){
if($(this).attr("checked")){
$(this).removeAttr("checked");
}else{
$(this).attr("checked",'true');
}
})
}
function setCheckbox(){
$("input[name='trkid']").attr("checked",'true');
}
</script>
</head>
<body>
<div id="result"></div>
<select name="sel_find_time" id="sel_find_time" οnchange="finddata('find_time',this.value);">
<option value="0" >按时间</option>
<option value="1">近三天</option>
<option value="2">近半月</option>
<option value="3">近一月</option>
<option value="4">近半年</option>
<option value="5">近一年</option>
<option value="-1">不限</option>
</select>
<select name="sel_find_kind" id="sel_find_kind" οnchange="finddata('find_kind',this.value);">
<option value="0" selected="selected">按曲种</option>
<option value="1">流行歌曲</option>
<option value="2">对唱歌曲</option>
<option value="-1">不限</option>
</select>
<select name="sel_find_language" id="sel_find_language" οnchange="finddata('find_language',this.value);">
<option value="0" selected="selected">按语言</option>
<option value="1">国语</option>
<option value="5">韩语</option>
<option value="-1">不限</option>
</select>
<select name="sel_find_geshi" id="sel_find_geshi" οnchange="finddata('find_geshi',this.value);">
<option value="0" selected="selected">按格式</option>
<option value="1">DVD</option>
<option value="2">VCD</option>
<option value="-1">不限</option>
</select>
<input name="搜索" type="button" value="确定" οnclick="sendData()" />
<div class="z_h" style="display:none;">
<div id="show_ln" style="float:left;;">您已选择:</div>
</div>
<!-- 全选反选-->
<div style="clear:both;"></div>
<div style="float:left;"> <input type="checkbox" id="allcheck" name="allcheck" ></div>
<a href="javascript:void(0);" οnclick="setCheckbox();" ><div id="findall" style="float:left;"> 全选</div></a>
<div style="float:left"><a href="javascript:void(0);" οnclick="selfan();"> 反选 </a></div>
<input type="checkbox" name="trkid" value="checkbox1">
checkbox1
<input type="checkbox" name="trkid" value="checkbox2">
checkbox2
<input type="checkbox" name="trkid" value="checkbox3">
checkbox3
<input type="checkbox" name="trkid" value="checkbox4">
</body>
</html>
find.php
<?php
$newtime = $_REQUEST["newtime"];
$newkind = $_REQUEST["newkind"];
$newlanguage = $_REQUEST["newlanguage"];
$newgeshi = $_REQUEST["newgeshi"];
$newsinger = $_REQUEST["newsinger"];
$newplace = $_REQUEST["newplace"];
$sql = "SELECT * FROM 表 WHERE 1=1 ";
if ($newtime && $newtime!=-1) {
$findtime = changetime($newtime);
$sql.= " AND inputtime >=".$findtime;
}
if ($newkind && $newtime!=-1) {
$sql.= " AND typeid =".$newkind;
}
if ($newlanguage && $newtime!=-1) {
$sql.= " AND language ='".$newlanguage."'";
}
if ($newgeshi && $newtime!=-1) {
$sql.= " AND Codec='".$newgeshi."'";
}
//与数据库相连或者所有数据
$resut = $sql;
$output = json_encode($resut);
//输出数据
echo $output;
//时间转换
function changetime($time){
$arrtime = 0;
if ($time == 1) {
$arrtime = mktime (0,0,0,date("m") ,date("d")-3,date("Y"));
}elseif ($time = 2){
$arrtime = mktime (0,0,0,date("m") ,date("d")-15,date("Y"));
}elseif ($time = 3){
$arrtime = mktime (0,0,0,date("m")-1 ,date("d"),date("Y"));
}elseif ($time = 4){
$arrtime = mktime (0,0,0,date("m")-6 ,date("d"),date("Y"));
}else{
$arrtime = mktime (0,0,0,date("m") ,date("d"),date("Y")-1);
}
return $arrtime;
}