控制器
//展示1
function show()
{
$biao=M('biao3');
$bol=$biao->select();
$hang=count($bol);
//echo $hang;die;
$num=3;
$ye=ceil($hang/$num); //页数
//设置当前页
$page=isset($_GET['page'])?$_GET['page']:1;
//echo $page;die;
//每页显示的第一条数据(偏移量)
$par=($page-1)*$num;
//设置上下页
$list=$page<=1?1:$page-1;
$next=$page>=$ye?$ye:$page+1;
//再次查询
$bool=$biao->limit($par,$num)->select();
//echo $biao->_sql();die;
//赋值
$this->assign('data',$bool);
$this->assign('list',$list);
$this->assign('next',$next);
$this->assign('ye',$ye);
$this->display('show');
}
//修改
function update()
{
//接受id
$id=I('get.id');
//echo $id;
$a=I('get.aa');
//echo $a;
$data['g_desc']=$a;
$biao=M('biao3');
$bol=$biao->where("g_id='$id'")->save($data);
if($bol)
{
echo 1;
}
else
{
echo 0;
}
}
视图层
<style>
a{
text-decoration: none;
}
a:hover{
color: aqua;
}
.pp{
font-family: "Courier New", Courier, monospace;
font-style: italic;
color: greenyellow;
}
</style>
<div id="div1">
<table border="1">
<tr>
<th>品牌名字</th>
<th>品牌logo</th>
<th>商品图片</th>
<th>商品描述</th>
</tr>
<foreach name="data" item="v">
<tr>
<td>{$v.g_name}</td>
<td><a href="__ROOT__/{$v.g_logo}" target="_blank"><img src="__ROOT__/{$v.g_logo}" width="100" height="40"></a></td>
<td>
<?php
$tu=explode('-./',$v['g_img']);
array_shift($tu); //删除前面的-
//print_r($tu);die;
foreach($tu as $v2)
{?>
<img src="__ROOT__/<?php echo $v2;?>" width="60" height="40">
<?php }
?>
</td>
<td οnclick="chang('{$v.g_id}')">
<input type="text" value="{$v.g_desc}" id="i{$v.g_id}" style="display: none" οnblur="update('{$v.g_id}')"><span id="s{$v.g_id}">{$v.g_desc}</span>
</td>
</tr>
</foreach>
</table>
<td>
<a href="javascript:" οnclick="fun(1)">首页</a>
<a href="javascript:" οnclick="fun('{$list}')">上一页</a>
<a href="javascript:" οnclick="fun('{$next}')">下一页</a>
<a href="javascript:" οnclick="fun('{$ye}')">尾页</a>
</td>
<br/> <br/> <br/>
<a href="__URL__/show2" class="pp">不美观,换一种展示</a>
</div>
<script>
function fun(page)
{
//alert(page);die;
var ajax=new XMLHttpRequest();
ajax.onreadystatechange=function()
{
if(ajax.readyState==4&&ajax.status==200)
{
document.getElementById('div1').innerHTML=ajax.responseText;
}
}
ajax.open('get','__URL__/show?page='+page);
ajax.send(null);
}
//即点即改 显示文本框
function chang(id)
{
document.getElementById('i'+id).style.display = 'block';
document.getElementById('s'+id).innerHTML = ''; //清空
}
//即点即改 修改数据
function update(id)
{
var a=document.getElementById('i'+id).value;
//alert(a);die;
var ajax=new XMLHttpRequest();
ajax.onreadystatechange=function()
{
if(ajax.readyState==4&&ajax.status==200)
{
//alert(ajax.responseText);
if(ajax.responseText==1)
{
alert('修改成功');
}
else
{
alert('修改失败');
}
}
}
ajax.open('get','__URL__/update?id='+id+'&aa='+a); //不要一样
ajax.send(null);
}
</script>