1.前台代码
jq写法的ajax根据自己的需求去写
<span style="font-size:18px;"> <span style="white-space:pre"> </span>$.ajax({
type:"POST",
url:"{:U('Home/output/OutputTableData')}",
dataType:"json",
data:{"output":output},
async:true,
success:function(msg){
//msg = msg.substring(1);
//alert(msg);
// msgarr = msg.split(',');
//var lohref = "{:U('Home/output/sefile')}"+"?aaa="+msg;
// alert(lohref);
// location.href = lohref;
var onetable,twotable,threetable,fourtable,fivetable,sixtable,seventable,eighttable;
var json = eval('(' +msg+ ')');
//alert(msg);
// var lohref = "{:U('Home/output/sefile')}"+"?aaa="+;
// alert(lohref);
// location.href = lohref;
},
error:function(){
alert("请联系小灰灰");
}
});
}else{
alert("请选择学科!!!");
}</span>
2.控制层
使用ajaxReturn方法将从数据库获取的数据传到前台
<span style="font-size:18px;">use Common\Out_put\Output_AllSql as out;
</span>
<span style="font-size:18px;">public function OutputTableData(){
$TableName= $_POST['output'];
$NameSql = $TableName[0];
$AjaxOutput = new out;
$TableData=$AjaxOutput->Outputajax($NameSql);
$data=json_encode($TableData,JSON_UNESCAPED_UNICODE);
$this->ajaxReturn($data, 'json');
}</span>
3.模板层
控制数据查询,并返回到模板层
<span style="font-size:18px;">class Output_AllSql{
//前台ajax刷新表
public function Outputajax($TableName){
$mode_filter=M('','','CONFIG_JC_BASICINFO');</span>
<span style="font-size:18px;"><span style="font-family: Arial, Helvetica, sans-serif;"> $sql = </span>""<span style="font-family: Arial, Helvetica, sans-serif;">;</span></span>
<span style="font-size:18px;"> $result<span style="font-family: Arial, Helvetica, sans-serif;"> = $mode_filter -> query($sql);</span></span>
<span style="font-size:18px;"> return $result;
}</span>
<span style="font-size:18px;">}</span>