$img_url = is_file($img_url) ? $img_url : $img_def_url;
$post_date = substr($post->post_date, 0, 10);
echo "<h3>[<a href='/fenlei' target='_blank'>分类</a>]<a href='/post/{$post->id}.html' target='_blank'>" . $post->post_title . "</a></h3>";
echo "<figure><img src='" . $img_url . "'></figure>";
echo "<ul><p>" . mb_substr(strip_tags($post->post_content), 0, 300, 'gb2312') . "</p></ul>";
echo '<div class="dateview"><a title="' . $post->post_title . '" href="/post/' . $post->id . '.html" target="_blank" class="readmore">阅读全文>></a><span>' . $post_date . '</span><span>阅读(10)</span><span>评论(2)</span> <a href="javascript:(0)" class="post-like" data-pid="533" data-event="like"><i class="glyphicon glyphicon-thumbs-up"></i>赞(0)</a></span></div>';
}
//print_r($posts->lastPage());
//$cur_page = $_GET['page'];
$total = $posts->total();
//总文章数
$count_page = $posts->count();
//总页数
$url = $_SERVER['HTTP_HOST'];
//getPageHtml($cur_page,$count_page);
echo '<div class="quotes">' . pageft($total, 5) . '</div>';
//echo '<div class="badoo">'.$posts->render().'</div>';
//echo $posts->render();
?>
@stop
@section('rank')
<li><a href="/" title="Column 三栏布局 个人网站模板" target="_blank">Column 三栏布局 个人网站模板</a></li>
<li><a href="/" title="with love for you 个人网站模板" target="_blank">with love for you 个人网站模板</a></li>
<li><a href="/" title="免费收录网站搜索引擎登录口大全" target="_blank">免费收录网站搜索引擎登录口大全</a></li>
<li><a href="/" title="做网站到底需要什么?" target="_blank">做网站到底需要什么?</a></li>
<li><a href="/" title="企业做网站具体流程步骤" target="_blank">企业做网站具体流程步骤</a></li>
<li><a href="/" title="建站流程篇——教你如何快速学会做网站" target="_blank">建站流程篇——教你如何快速学会做网站</a></li>
<li><a href="/" title="box-shadow 阴影右下脚折边效果" target="_blank">box-shadow 阴影右下脚折边效果</a></li>
<li><a href="/" title="打雷时室内、户外应该需要注意什么" target="_blank">打雷时室内、户外应该需要注意什么</a></li>
@stop
<?php
} else {
?>
<ul>
<?php
if ($pro_class) {
$tj = "where pro_class='{$pro_class}' order by id desc";
} else {
$tj = "order by id desc";
}
$sql = "select * from {$pro_table} {$tj} ";
$res = mysqli_query($conn, $sql);
$total = mysqli_num_rows($res);
pageft($total, 16);
$sql = "select * from {$pro_table} {$tj} limit {$firstcount},{$displaypg}";
//echo $sql;
$res = mysqli_query($conn, $sql);
while ($rows = mysqli_fetch_assoc($res)) {
$img_arr = explode('/', $rows['img']);
$img_url = "img/" . $img_arr[0];
?>
<li><a href="show_details.php?id=<?php
echo $rows['id'];
?>
&pro_class=<?php
echo $rows['pro_class'];
?>
" target="_blank"><img src="<?php
if (empty($param)) {
$param = "keyword=" . urlencode($keyword);
}
}
}
if (isset($_GET[classcode]) && !empty($_GET[classcode])) {
$classcode = $_GET[classcode];
$where = $where . "and prod_class={$classcode} ";
}
//echo "<script>alert(keyword==='" . $_POST[keyword] . "');</script>";
$pagesize = 12;
//一页显示多少条
//分页
$queryTotal = $db->query("select id from prod" . $where);
$total = $db->db_num_rows();
pageft($total, $pagesize, '', $param);
if ($firstcount < 0) {
$firstcount = 0;
}
//列表
$prodQuery = $db->query("select * from prod " . $where . " order by create_date desc limit {$firstcount}, {$displaypg} ");
$prodList = array();
while ($row = $db->fetch_array($prodQuery)) {
$prodList[] = $row;
}
$smarty->assign("prodList", $prodList);
//显示分页的内容
$smarty->assign("page", $pagenav);
//当前位置
$address = "您当前位置：首 页 > <font color='#FF3300'>产品展示</font>";
$smarty->assign("address", $address);
*/
include_once './header.php';
include_once './admin/conn/conn.php';
include_once './admin/conn/page.class.php';
// 截取中文字符
function utf8Substr($str, $from, $len)
{
return preg_replace('#^(?:[\\x00-\\x7F]|[\\xC0-\\xFF][\\x80-\\xBF]+){0,' . $from . '}' . '((?:[\\x00-\\x7F]|[\\xC0-\\xFF][\\x80-\\xBF]+){0,' . $len . '}).*#s', '$1', $str);
}
$pageSize = 5;
// 每页显示的记录数
$sql0 = "select * from tb_people order by votes desc,name asc";
$result0 = $mysqli->query($sql0);
$total = $mysqli->affected_rows;
// 查询总记录！
pageft($total, $pageSize, 1, 1, 1, 9, 20, 1);
$sql = "select * from tb_people order by votes desc,name asc limit {$firstcount},{$pageSize}";
$result = $mysqli->query($sql);
$count = $mysqli->affected_rows;
?>
<div class="votes_content" style="background-color:#FFF5D0 ">
<!-- 左 -->
<div class="votes_left">
<?php
while ($row1 = $result->fetch_assoc()) {
?>
<span>
<a href="./every.php?vid=<?php
echo base64_encode($row1['id']);
?>
<?php
require_once "../action/global_action.php";
//产品分类
$queryProdClass = $db->query("select * from prod_class");
$rowPC = array();
while ($rowProdClass = $db->fetch_array($queryProdClass)) {
$rowPC[] = $rowProdClass;
}
$smarty->assign("prodClassList", $rowPC);
$result = @mysql_query("select id from prod where state='1'");
$total = @mysql_num_rows($result);
pageft($total, 10);
if ($firstcount < 0) {
$firstcount = 0;
}
//列表
$query = $db->query("select a.class_name,b.* from prod_class a,prod b where a.id =b.prod_class and b.state='1' order by b.create_date desc limit {$firstcount}, {$displaypg}");
$prodList = array();
while ($row = $db->fetch_array($query)) {
$prodList[] = $row;
}
$smarty->assign("caseList", $prodList);
$smarty->assign("cpage", $page);
$smarty->assign("page", $pagenav);
$smarty->display("case/caselist.html");
<?php
require_once "action/checkAamsLogin.php";
require_once "action/smarty_inc.php";
require_once "action/mysql.class.php";
require_once "action/page.class.aams.php";
$remark = '新增';
if (isset($_GET[remark]) && "OK" == $_GET[remark]) {
$remark = '已处理';
}
$pagesize = 15;
//一页显示多少条
//分页
$queryTotal = $db->query("select id from message where type='ADVISE' and remark='{$remark}'");
$total = $db->db_num_rows($queryTotal);
pageft($total, $pagesize);
if ($firstcount < 0) {
$firstcount = 0;
}
//新闻列表
$newsQuery = $db->query("select * from message where type='ADVISE' and remark='{$remark}' order by create_date desc limit {$firstcount}, {$displaypg}");
$newsRow = array();
while ($rownews = $db->fetch_array($newsQuery)) {
$newsRow[] = $rownews;
}
$smarty->assign("messageRow", $newsRow);
//显示分页的内容
$smarty->assign("page", $pagenav);
$smarty->display("advise.html");
if ($dberp->nf()) {
while ($dberp->next_record()) {
$suppid = $dberp->f(fd_supp_id);
$arr_suppname[$suppid] = $dberp->f(fd_supp_name);
}
}
//ËÑË÷
if (empty($search)) {
$querywhere = "";
} else {
$querywhere = "where fd_supplierlogo_id like '%{$content}%'";
}
$query = "select fd_supplierlogo_id,fd_supplogo_suppid from web_conf_supplierlogo {$querywhere}";
$db->query($query);
$total = $db->nf();
pageft($total, 10, $str_url);
if ($firstcount < 0) {
$firstcount = 0;
}
$query = "{$query} limit {$firstcount},{$displaypg}";
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
$fd_supplierlogo_id = $db->f(fd_supplierlogo_id);
$fd_supplogo_suppid = $db->f(fd_supplogo_suppid);
$fd_supplogo_suppname = $arr_suppname[$fd_supplogo_suppid];
$result = uploadshow($fd_supplogo_suppid, $scatid);
$thum = $result["thumurl"];
$thum = $thum ? "<img src='{$g_showpic}{$thum}' />" : "";
$e = '<a href=javascript:supploge("' . $g_uppic . '","' . $scatid . '","' . $fd_supplogo_suppid . '"); >ÐÞ¸Ä</a>';
$a = '<a href=javascript:deleteimg("' . $g_uppic . '","' . $scatid . '","' . $fd_supplogo_suppid . '");>ɾ³ý</a>';
<div id="pro_list">
<ul style="width:95%;">
<?php
$tj = " ";
$sql = "select * from {$table} {$tj}";
//echo $sql;
$res = mysql_query($sql);
if ($res) {
$total = mysql_num_rows($res);
}
pageft($total, 12);
$sql = "select * from {$table} {$tj} order by id desc limit {$firstcount},{$displaypg} ";
$res = mysql_query($sql, $conn);
if (strlen($res) == 0) {
echo "没有此类数据";
} else {
while ($rows = mysql_fetch_array($res)) {
$img_arr = explode('/', $rows['img']);
$flod = "../img/";
$img_url = $flod . $img_arr[0];
?>
<li><a href="case_add.php?id=<?php
echo $rows['id'];
?>
$img_def_url = '/images/thumbnail.png';
$img_url = $web_url . $img_url;
//echo $img_url;
$img_url = is_file($img_url) ? $img_url : $img_def_url;
$content = mb_substr(strip_tags($post->post_content), 0, 80, 'UTF-8');
$post_date = substr($post->created_at, 0, 10);
echo "<article class='excerpt excerpt-1'>\n\t\t<a target='_blank' class='focus' href='/post/{$post->id}.html'><img src='{$img_url}' class='thumb' style='display: inline;'/></a>\n\t\t<header><a class='cat' href='/fenlei'>分类<i></i></a> <h2><a target='_blank' href='/post/{$post->id}.html' title='{$post->post_title}'>{$post->post_title}</a></h2></header>\n\t\t<p class='meta'><time><i class='fa fa-clock-o'></i>{$post_date}</time><a target='_blank' class='pc' href='/post/{$post->id}.html#comments'><i class='fa fa-comments-o'></i><span class='ds-thread-count' data-thread-key='{$post->id}' data-count-type='comments'></span></a></p>\n\t\t<p class='note'>{$content}</p>\n\t\t<a target='_blank' href ='/post/{$post->id}.html' class='cat' style='float:right'>阅读全文</a>\n\t\t</article>";
}
$total = $posts->total();
//总文章数
$count_page = $posts->count();
//总页数
$total_page = $posts->total();
$url = $_SERVER['HTTP_HOST'];
//getPageHtml($cur_page,$count_page);
echo '<div class="pagination"><ul>' . pageft($total, 5) . '</ul></div>';
?>
<script>
function highlight(idVal, keyword) {
var textbox = document.getElementById(idVal);
if ("" == keyword) return;
var temp = textbox.innerHTML;
console.log(temp);
var htmlReg = new RegExp("\<.*?\>", "i");
var arr = new Array();
for (var i = 0; true; i++) {
var tag = htmlReg.exec(temp);
if (tag) {
arr[i] = tag;
} else {
break;
include_once 'js/headPHP.php';
include_once 'page.php';
include_once "connect.php";
if (!$_SESSION['admin']) {
echo "<script>alert('你不是管理员！');location.href = 'index.php'</script>";
exit;
}
$sql = "select * from userlist";
$result = $dbh->query($sql);
/*$result = mysql_query($sql);*/
/*$cout_rows = mysql_num_rows($result);*/
$cout_rows = $result->rowCount();
//引用分页函数
$pagecount = 3;
//每页条数
pageft($cout_rows, $pagecount, $cout_rows);
$sql .= " limit {$firstcount}, {$displaypg}";
/*$result = mysql_query($sql);*/
$result = $dbh->query($sql);
?>
<body>
<h2 style="text-align: center;padding-bottom: 20px;">会员管理系统</h2>
<div class="container">
<div style="height: 400px">
<table border="1" align="center" cellpadding="8" cellspacing="0" style="background-color: #fff;" class="table table-hover table-condensed table-bordered">
<tr align="center" style=" font-weight: bold" width="100%">
<td width="10%">序号</td>
<td width="20%">用户名</td>
<td width="30%">爱好</td>
<td width="15%">是否管理员</td>
</tr></form>
</table></td></tr>
</table>
<tr><td bgcolor="#FFFFFF"><table width="99%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#000000">
<tr bgcolor="#E4E4E4">
<td width="36%" height="25" align="center" bgcolor="#E4E4E4"><b>产品分类</b></td>
<td width="22%" align="center" bgcolor="#E4E4E4"><b>产品名称</b></td>
<td width="11%" align="center" bgcolor="#E4E4E4"><b>上传日期</b></td>
<td width="9%" align="center" bgcolor="#E4E4E4"><b>操作</b></td>
</tr>
<?php
$sql = "select * from {$table} {$tj}";
//echo $sql;
$res = mysql_query($sql, $conn);
$total = mysql_num_rows($res);
pageft($total, 15);
$sql = "select * from {$table} {$tj} order by id desc limit {$firstcount},{$displaypg} ";
$res = mysql_query($sql, $conn);
if (strlen($res) == 0) {
echo "没有此类数据";
} else {
while ($rows = mysql_fetch_array($res)) {
?>
<tr bgcolor="#EFEFEF">
<td height="25" align="left" style="padding-left:2px;" bgcolor="#FFFFFF">
<?php
echo "<b>" . name($nav_table, $rows['pro_class1']) . "</b>" . " <span style='font-weight:blod;color:red'>></span> ";
?>
<?php
if ($rows['pro_class1'] == $rows['pro_class']) {
} else {
<a href ="<?php
echo $url_this . 'gty=3';
?>
" ><img src="images/female.gif"></a>
</div>
</div>
</td>
</tr>
<?php
include_once "page.class.php";
$pageSize = $wpdb->get_var($wpdb->prepare("SELECT config_value FROM {$wpdb->config} where config_key='pagesize';"));
$total = count(style_display(0, 0, $_GET['style_keyword']));
pageft($total, $pageSize, 1, 0, 0, 9, 10, 0);
/* gty 0 默认排序，1， 中性排序，2， 女性排序， 3，男性排序*/
$gty = (int) $_GET['gty'];
//未传递参数，设置为默认排序
if (!isset($gty)) {
$gty = 0;
}
$M_styles = style_display($firstcount, $pageSize, $_GET['style_keyword'], $gty);
?>
<tr>
<td><div id="nav_pages"><?php
echo $pagenav;
?>
</div></td>
</tr>
break;
}
$t = new Template('.', "keep");
$t->set_file("supplogo", "supplogo.html");
$t->set_block("supplogo", "BXBK", "bxbks");
$scatid = 10;
//搜索
if (empty($search)) {
$querywhere = "";
} else {
$querywhere = "where fd_supplogo_suppname like '%{$content}%'";
}
$query = "select fd_supplierlogo_id,fd_supplogo_suppid,fd_supplogo_suppname,fd_supplogo_tuijian from web_conf_supplierlogo \n {$querywhere} order by fd_supplogo_tuijian desc ";
$db->query($query);
$total = $db->nf();
pageft($total, 7, $str_url);
if ($firstcount < 0) {
$firstcount = 0;
}
$query = "{$query} limit {$firstcount},{$displaypg}";
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
$fd_supplierlogo_id = $db->f(fd_supplierlogo_id);
$fd_supplogo_suppid = $db->f(fd_supplogo_suppid);
$fd_supplogo_suppname = $db->f(fd_supplogo_suppname);
$fd_supplogo_tuijian = $db->f(fd_supplogo_tuijian);
$getFileimg = new AutogetFile();
$csp_get_img = explode("@@", $getFileimg->AutogetFileimg($scatid, $fd_supplierlogo_id));
$thumimg = $csp_get_img[0];
$thumimg = $thumimg ? "<img src='" . $thumimg . "' width=120 height=50/>" : "";
} else {
$openidStr = "null";
//未关注
}
}
$pageSize = "5";
$page = $_GET['page'];
$count = C::t("#smart_vote#smart_vote")->count_all();
if ($page == "" || !isset($page)) {
$query = C::t("#smart_vote#smart_vote")->fetch_all('0', '5');
pageft($count, $pageSize, 1, 0, 0, 3);
} else {
$firstcount = ($page - 1) * $pageSize;
// $lastcount = $page * $pageSize;
$query = C::t("#smart_vote#smart_vote")->fetch_all($firstcount, $pageSize);
pageft($count, $pageSize, 1, 0, 0, 3);
}
// pageft($count,10);
include template("smart_vote:index");
} else {
if ("value" == $_GET['model']) {
$openid = $_COOKIE["openid"];
//openid
$today = time();
$exitdate = strtotime(date('Y-m-d 23:59:59'));
$geetest = new GeetestLib();
$geetest->set_privatekey("465719ad89db5cbe489cc051ff81a38e");
$voteid = $_POST['voteid'];
if (isset($_POST['geetest_challenge']) && isset($_POST['geetest_validate']) && isset($_POST['geetest_seccode'])) {
$result = $geetest->validate($_POST['geetest_challenge'], $_POST['geetest_validate'], $_POST['geetest_seccode']);
if ($result == TRUE) {
$db = new DB_test();
$db1 = new DB_test();
$t = new Template('.', "keep");
$t->set_file("mobilerecharge_list", "mobilerecharge_list.html");
$t->set_block("mobilerecharge_list", "HEADBXBK", "headbxbks");
$arr_state = array("请求交易", "交易成功", "交易取消", "无效状态");
//$arr_state = auto_charset($arr_state, 'utf-8', 'gbk');
if ($msgstart < 0) {
$msgstart = 0;
}
$all_paymoney = 0;
$query = "select *,case\n when fd_mrclist_payrq ='01' then '" . $arr_state[0] . "'\n when fd_mrclist_payrq ='00' then '" . $arr_state[1] . "'" . "when fd_mrclist_payrq ='03' then '" . $arr_state[2] . "'\n else '" . $arr_state[4] . "' END fd_mrclist_payrq,\n fd_mrclist_ofstate,\n case\n when fd_mrclist_ofstate ='1' then '<font color=blue>充值成功</font>'\n when fd_mrclist_ofstate ='-1' then '正在充值'\n else '<font color=red>充值失败</font>' END ofstate\n from tb_mobilerechargelist\n left join tb_author on fd_author_id = fd_mrclist_authorid\n left join tb_sendcenter on fd_sdcr_id = fd_mrclist_sdcrid\n where 1\n\t\t\tand (fd_mrclist_payrq = '00') and fd_mrclist_sdcrid<100 order by fd_mrclist_id desc ";
$db->query($query);
//and fd_agpm_paytype <>'recharge'
$total = $db->num_rows($result);
pageft($total, $displaypg, $url);
if ($firstcount < 0) {
$firstcount = 0;
}
$count = $firstcount;
$query = "{$query} limit {$firstcount},{$displaypg}";
$rows = $db->num_rows();
if ($db->execute($query)) {
$arr_val = $db->get_all($query);
}
if (is_array($arr_val)) {
foreach ($arr_val as $key => $arr_val) {
$tcount++;
if ($arr_val['fd_mrclist_ofstate'] != '1') {
$arr_val['eidt_ofstate'] = '<a href="javascript:void(0);" name="' . $arr_val['fd_mrclist_authorid'] . '" class="eidt_ofstate" rel="' . $arr_val['fd_mrclist_bkntno'] . '">再次充值</a>';
} else {
$filt_sql .= " && rname='" . $_POST[s_name] . "'";
}
if ($_POST[s_com] != "") {
$filt_sql .= " && rcom='" . $_POST[s_com] . "'";
}
if ($_POST[s_start] != "") {
$filt_sql .= " && rstime>='" . $_POST[s_start] . " 00:00:00'";
}
if ($_POST[s_end] != "") {
$filt_sql .= " && rstime<='" . $_POST[s_end] . " 23:59:59'";
}
//echo $filt_sql;
$rlistnum = $db->query($filt_sql);
$total = $db->db_num_rows($rlistnum);
$displaypg = 2;
pageft($total, $displaypg);
if ($firstcount < 0) {
$firstcount = 0;
}
$limit_sql = $filt_sql . " order by `rstime` desc limit {$firstcount},{$displaypg}";
$rlist = $db->query($limit_sql);
while ($rrow = $db->fetch_array($rlist)) {
$r_list[] = array("rid" => $rrow[rid], "rnum" => $rrow[rnum], "rexcom" => $rrow[rexcom], "rcata" => $rrow[rcata], "rcont" => $rrow[rcont], "rstime" => $rrow[rstime], "rname" => $rrow[rname], "rcom" => $rrow[rcom], "sname" => $rrow[sname]);
}
//显示更新客户信息
if (isset($_GET[updaterid])) {
$ifupdater = 1;
//此变量“ifupdater”用于判断模板页面该显示“修改页面”“添加页面”或者默认“列表页面”
$rlist1 = $db->query("select * from `ex_record` where `rid`='" . $_GET[updaterid] . "'");
$rrow1 = $db->fetch_array($rlist1);
$tpl->assign("ifupdater", $ifupdater);
break;
default:
break;
}
if (!empty($sel_condit)) {
$querywhere .= " and " . $sel_condit . " like '%" . $txtCondit . "%'";
}
$t = new Template(".", "keep");
//调用一个模版
$t->set_file("selagentbkno", "selagentbkno.html");
//显示列表
$t->set_block("selagentbkno", "prolist", "prolists");
$query = "select \n case \n when fd_agpm_paytype ='coupon' then '购买抵用券'\n when fd_agpm_paytype ='creditcard' then '信用卡还款'\n when fd_agpm_paytype ='recharge' then '充值'\n when fd_agpm_paytype ='repay' then '还贷款'\n when fd_agpm_paytype ='order' then '订单付款'\n when fd_agpm_paytype ='tfmg' then '转账汇款'\n else '其他业务' END paytype,\n\n case\n when fd_agpm_payfeedirct ='f' then fd_agpm_paymoney\n when fd_agpm_payfeedirct ='s' then (fd_agpm_paymoney-fd_agpm_payfee)\n else fd_agpm_paymoney END money,\n\n fd_agpm_id as agpm_id,\n fd_agpm_bkordernumber as bkordernumber,\n fd_agpm_no as agpm_no,\n fd_agpm_bkntno as bkntno,\n fd_paycard_key as paycardkey,\n fd_author_truename as author,\n fd_agpm_paydate as paydate,\n fd_agpm_shoucardno as shoucardno,\n fd_agpm_shoucardbank as shoucardbank,\n fd_agpm_shoucardman as shoucardman,\n fd_agpm_shoucardmobile as shoucardmobile,\n fd_agpm_current as current,\n fd_agpm_paymoney as paymoney ,\n fd_agpm_payfee as payfee,\n fd_agpm_arrivemode as arrivemode,\n fd_agpm_arrivedate as arrivedate,\n fd_sdcr_name as sdcrname,\n fd_agpm_memo as memo\n from tb_agentpaymoneylist\n left join tb_paycard on fd_agpm_paycardid = fd_paycard_id\n left join tb_author on fd_author_id = fd_agpm_authorid\n left join tb_sendcenter on fd_sdcr_id = fd_agpm_sdcrid\n where fd_agpm_payrq = '00' and fd_agpm_state = 1 and (fd_agpm_paystate = 0 or fd_agpm_paystate is null ) and fd_agpm_paytype='{$paytype}' {$querywhere}\n order by fd_agpm_no";
$db->query($query);
$total = $db->num_rows($result);
pageft($total, 20, $url);
if ($firstcount < 0) {
$firstcount = 0;
}
$query = "{$query} limit {$firstcount},{$displaypg}";
$db->query($query);
$rows = $db->num_rows();
$arr_result = $db->getFiledData('');
$count = 0;
foreach ($arr_result as $value) {
$count++;
$value['count'] = $count;
$value['arrivemode'] = "T+" . $value['arrivemode'];
$all_paymoney += $value['paymoney'];
$all_payfee += $value['payfee'];
$all_money += $value['money'];
$sql = "SELECT c.type_id,c.class_name,c.course_name,ru.course,ru.id,ru.username,ru.gender,ru.college,ru.work_unit,ru.mobile,\r\n\tru.telephone,ru.qq,ru.email,ru.cnt,ru.create_date,ru.money,ru.pay_date,ru.remark,ru.class_no,t.type_name,au.adminname,ru.input_user FROM\r\n\tboya_reg_user AS ru LEFT JOIN boya_course AS c ON c.id = ru.course LEFT JOIN boya_type AS t ON c.type_id = t.id\r\n\tLEFT JOIN boya_admin_user AS au ON ru.input_user = au.id where 1=1 ";
if ("1" == $_GET[isfee]) {
$sql = $sql . " and pay_date is not null ";
} else {
if ("0" == $_GET[isfee]) {
$sql = $sql . " and pay_date is null ";
}
}
if (isset($_GET[opentime]) && !empty($_GET[opentime])) {
//echo "<script>alert()</script>";
$sql = $sql . " and ru.open_time ='{$_GET['opentime']}' ";
}
if ("-1" != $_GET[classname]) {
$sql = $sql . " and ru.course='{$_GET['classname']}' ";
}
$sql = $sql . " order by ru.create_date desc";
//print_r($sql);
$smarty->assign("opentime", $_GET[opentime]);
$smarty->assign("isfee", $_GET[isfee]);
$smarty->assign("classname", $_GET[classname]);
//δÉóºË»áÔ±·ÖÀà
$adminRow = getListBySql($sql, $db);
$smarty->assign("adminRow", $adminRow);
$smarty->assign("excelname", $adminRow[0][type_name] . "-" . $adminRow[0][class_name] . "-" . $adminRow[0][course_name]);
pageft(0, 1);
$smarty->assign("page", $pagenav);
} else {
pageft(0, 1);
$smarty->assign("page", $pagenav);
}
$smarty->display("queryclass.html");
<?php
require_once "../action/global_action.php";
$result = @mysql_query("select id from news");
$total = @mysql_num_rows($result);
pageft($total, 20);
if ($firstcount < 0) {
$firstcount = 0;
}
//ап╠М
$query = $db->query("select * from news order by create_date desc limit {$firstcount}, {$displaypg}");
$newsList = array();
while ($row = $db->fetch_array($query)) {
$newsList[] = $row;
}
$smarty->assign("newsList", $newsList);
$smarty->assign("cpage", $page);
$smarty->assign("page", $pagenav);
$smarty->display("news/newslist.html");
</tr>
<tr>
<td align="left" class="table_2"><input type="button" class="add_button1" name="sc" value="上传文件" onclick="refresh_now('upload.php')" /></td></tr>
</table>
<tr><td bgcolor="#FFFFFF"><table width="99%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#000000">
<tr bgcolor="#E4E4E4">
<td width="30%" height="25" align="center" bgcolor="#E4E4E4"><b>标题名称</b></td>
<td width="10%" align="center"><b>上传日期</b></td>
<td width="41%" align="center"><b>文件名称</b></td>
<td width="19%" align="center" bgcolor="#E4E4E4"><b>操作</b></td>
</tr>
<?php
$sql = "select * from down";
$res = mysql_query($sql, $conn);
$total = mysql_num_rows($res);
pageft($total, 6);
$sql = "select * from down order by id desc limit {$firstcount},{$displaypg} ";
$res = mysql_query($sql, $conn);
if (strlen($res) == 0) {
echo "NO DATE";
} else {
while ($rows = mysql_fetch_array($res)) {
$id = $rows['id'];
?>
<tr>
<td height="25" align="center" bgcolor="#FFFFFF"><?php
echo $rows['title'];
?>
</a></td>
<td align="center" bgcolor="#FFFFFF"><?php
echo $rows['uptime'];