php code
$ms =& ms();
$this->assign('set_avatar', $ms->user->set_avatar($id));
$this->assign('user', $user);
$this->assign('phone_tel', explode('-', $user['phone_tel']));
/* 导入jQuery的表单验证插件 */
$this->import_resource(array(
'script' => 'jquery.plugins/jquery.validate.js'
));
$page = $this->_get_page();
//tixian code
$con = mysql_connect("localhost","a0527232048","abc");
mysql_select_db("a0527232048",$con);
$sql="select * from ecm_configs where id=1";
$rows=array();
$rows=mysql_query($sql,$con);
while($row=mysql_fetch_array($rows))
{
$ct1=$row[10];//兑换条件最低积分
$ct2=$row[11]; //兑换时间
$ct3=$row[12]/100; //兑换比率
}
if ($jf1==0 and $jf2==0 and $jf3==0)
{
$sql2="SELECT m.user_name, IFNULL(sum(c.cons), 0) AS cons
FROM ecm_member AS m LEFT JOIN caifujifen AS c ON c.to2=m.user_id
WHERE 1 GROUP BY m.user_name
ORDER BY cons desc";
}
if ($jf1==0 and $jf2==0 and $jf3==1)
{
$sql2="select * from (SELECT m.user_name, IFNULL(sum(c.cons), 0) AS cons
FROM ecm_member AS m LEFT JOIN caifujifen AS c ON c.to2=m.user_id
WHERE 1 GROUP BY m.user_name
ORDER BY cons desc) as t where cons>=".$ct1."";
}
if ($jf1!==0 and $jf2!==0 and $jf3==2)
{
$sql2="select * from (SELECT m.user_name, IFNULL(sum(c.cons), 0) AS cons
FROM ecm_member AS m LEFT JOIN caifujifen AS c ON c.to2=m.user_id
WHERE 1 GROUP BY m.user_name
ORDER BY cons desc) as t where cons>=".$jf1." and cons<=".$jf2."";
}
$rows2=mysql_query($sql2,$con);
$lists=array();
$page['item_count'] = mysql_num_rows($rows2);
while($row2=mysql_fetch_row($rows2))
{
$username=$row2[0];
$jifen=$row2[1];
$mon=$jifen*$ct3;
$lists[]="<tr><td width=50></td>".$username."</td><td width=100>".$jifen."</td><td width=100>".$mon."</td><td width=250><td><td width=100><a href=#>a</a></td>";
}
//tixian code end
$this->_format_page($page);
$this->assign('page_info', $page);
//$this->assign('cftj',zdcfjf($id));
$this->assign('txlist',$sql2);
$this->display('user.tixian.html');
user.tixian.html 代码
<table class="tab1">
<tr><td width="50" align="center"><strong>ID</strong></td><td width="100" align="center"><strong>用户</strong></td><td width="100" align="center"><strong>财富积分</strong></td><td width="350" align="center"><strong>可提现金额</strong></td><td width="100" align="center"><strong>操作</strong></td></tr>
{foreach from=$txlist item=txlist }
{$txlist}
{/foreach}
</table>程序做好后,第一次浏览页面,是正常的,能调出符合条件的N条记录;
可刷新一次,就异常了,只能调了一条记录,异常的时候打印$sql2也是正常的,把异常时候的$sql2语句放到phpmyadmin执行的结果是正常的;这个时候 ,再上传一次 user.tixian.html 刷新一次的时候是正常的,再刷新一次,又出现上面的异常;再上传 user.tixian.html 又正常,再刷新,又异常 这中间我也注意观察了服务器上的user.tixian.html 没有自己更改过,也不可能自己更改吧这模板文件?
折磨了一晚上了,请帮忙看看,谢谢。
$ms =& ms();
$this->assign('set_avatar', $ms->user->set_avatar($id));
$this->assign('user', $user);
$this->assign('phone_tel', explode('-', $user['phone_tel']));
/* 导入jQuery的表单验证插件 */
$this->import_resource(array(
'script' => 'jquery.plugins/jquery.validate.js'
));
$page = $this->_get_page();
//tixian code
$con = mysql_connect("localhost","a0527232048","abc");
mysql_select_db("a0527232048",$con);
$sql="select * from ecm_configs where id=1";
$rows=array();
$rows=mysql_query($sql,$con);
while($row=mysql_fetch_array($rows))
{
$ct1=$row[10];//兑换条件最低积分
$ct2=$row[11]; //兑换时间
$ct3=$row[12]/100; //兑换比率
}
if ($jf1==0 and $jf2==0 and $jf3==0)
{
$sql2="SELECT m.user_name, IFNULL(sum(c.cons), 0) AS cons
FROM ecm_member AS m LEFT JOIN caifujifen AS c ON c.to2=m.user_id
WHERE 1 GROUP BY m.user_name
ORDER BY cons desc";
}
if ($jf1==0 and $jf2==0 and $jf3==1)
{
$sql2="select * from (SELECT m.user_name, IFNULL(sum(c.cons), 0) AS cons
FROM ecm_member AS m LEFT JOIN caifujifen AS c ON c.to2=m.user_id
WHERE 1 GROUP BY m.user_name
ORDER BY cons desc) as t where cons>=".$ct1."";
}
if ($jf1!==0 and $jf2!==0 and $jf3==2)
{
$sql2="select * from (SELECT m.user_name, IFNULL(sum(c.cons), 0) AS cons
FROM ecm_member AS m LEFT JOIN caifujifen AS c ON c.to2=m.user_id
WHERE 1 GROUP BY m.user_name
ORDER BY cons desc) as t where cons>=".$jf1." and cons<=".$jf2."";
}
$rows2=mysql_query($sql2,$con);
$lists=array();
$page['item_count'] = mysql_num_rows($rows2);
while($row2=mysql_fetch_row($rows2))
{
$username=$row2[0];
$jifen=$row2[1];
$mon=$jifen*$ct3;
$lists[]="<tr><td width=50></td>".$username."</td><td width=100>".$jifen."</td><td width=100>".$mon."</td><td width=250><td><td width=100><a href=#>a</a></td>";
}
//tixian code end
$this->_format_page($page);
$this->assign('page_info', $page);
//$this->assign('cftj',zdcfjf($id));
$this->assign('txlist',$sql2);
$this->display('user.tixian.html');
user.tixian.html 代码
<table class="tab1">
<tr><td width="50" align="center"><strong>ID</strong></td><td width="100" align="center"><strong>用户</strong></td><td width="100" align="center"><strong>财富积分</strong></td><td width="350" align="center"><strong>可提现金额</strong></td><td width="100" align="center"><strong>操作</strong></td></tr>
{foreach from=$txlist item=txlist }
{$txlist}
{/foreach}
</table>程序做好后,第一次浏览页面,是正常的,能调出符合条件的N条记录;
可刷新一次,就异常了,只能调了一条记录,异常的时候打印$sql2也是正常的,把异常时候的$sql2语句放到phpmyadmin执行的结果是正常的;这个时候 ,再上传一次 user.tixian.html 刷新一次的时候是正常的,再刷新一次,又出现上面的异常;再上传 user.tixian.html 又正常,再刷新,又异常 这中间我也注意观察了服务器上的user.tixian.html 没有自己更改过,也不可能自己更改吧这模板文件?
折磨了一晚上了,请帮忙看看,谢谢。
代码没给全吧?最后的打印列表,是保存在数组$lists??
谢谢您的回复,
代码只是给了相关的部份,这是在修改ECMALL,其他未给出的是ECMALL自带的代码,
打印的列表是保存在$lists里面,模板用的是smarty,我奇怪的是为什么总是第一次浏览的时候正常,再刷新就异常了上传一下模板,未做任何改动的模板,再浏览就正常了,再刷新就异常。。如此反复。。谢谢 2楼的办法 我这就试试
function tixian()
{
$ms =& ms();
$this->assign('set_avatar', $ms->user->set_avatar($id));
$this->assign('user', $user);
$this->assign('phone_tel', explode('-', $user['phone_tel']));
/* 导入jQuery的表单验证插件 */
$this->import_resource(array(
'script' => 'jquery.plugins/jquery.validate.js'
));
$page = $this->_get_page();
//tixian code
$con = mysql_connect("localhost","a0527232048","21740200");
mysql_select_db("a0527232048",$con);
$sql="select * from ecm_configs where id=1";
$rows=array();
$rows=mysql_query($sql,$con);
while($row=mysql_fetch_array($rows))
{
$ct1=$row[10];//兑换条件最低积分
$ct2=$row[11]; //兑换时间
$ct3=$row[12]/100; //兑换比率
}
if ($jf1==0 and $jf2==0 and $jf3==0)
{
$sql2="SELECT m.user_name, IFNULL(sum(c.cons), 0) AS cons
FROM ecm_member AS m LEFT JOIN caifujifen AS c ON c.to2=m.user_id
WHERE 1 GROUP BY m.user_name
ORDER BY cons desc";
}
if ($jf1==0 and $jf2==0 and $jf3==1)
{
$sql2="select * from (SELECT m.user_name, IFNULL(sum(c.cons), 0) AS cons
FROM ecm_member AS m LEFT JOIN caifujifen AS c ON c.to2=m.user_id
WHERE 1 GROUP BY m.user_name
ORDER BY cons desc) as t where cons>=".$ct1."";
}
if ($jf1!==0 and $jf2!==0 and $jf3==2)
{
$sql2="select * from (SELECT m.user_name, IFNULL(sum(c.cons), 0) AS cons
FROM ecm_member AS m LEFT JOIN caifujifen AS c ON c.to2=m.user_id
WHERE 1 GROUP BY m.user_name
ORDER BY cons desc) as t where cons>=".$jf1." and cons<=".$jf2."";
}
$rows2=mysql_query($sql2,$con);
$lists=array();
$page['item_count'] = mysql_num_rows($rows2);
while($row2=mysql_fetch_row($rows2))
{
$username=$row2[0];
$jifen=$row2[1];
$mon=$jifen*$ct3;
$lists[]="<tr><td width=50></td>".$username."</td><td width=100>".$jifen."</td><td width=100>".$mon."</td><td width=250><td><td width=100><a href=#>a</a></td>";
}
//tixian code end
$this->_format_page($page);
$this->assign('page_info', $page);
//$this->assign('cftj',zdcfjf($id));
$this->assign('txlist',$lists);
$this->display('user.tixian.html');
}
//积分提现结束
{$txl}
{/foreach}