本文整理汇总了PHP中db_test::num_rows方法的典型用法代码示例。如果您正苦于以下问题:PHP db_test::num_rows方法的具体用法?PHP db_test::num_rows怎么用?PHP db_test::num_rows使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类db_test
的用法示例。
在下文中一共展示了db_test::num_rows方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: Template
<?php
require "../include/common.inc.php";
include "../include/pageft.php";
$db = new db_test();
$gourl = "authorpaycard_query.php";
$gotourl = $gourl . $tempurl;
require "../include/alledit.1.php";
$t = new Template(".", "keep");
$t->set_file("authorpaycard", "authorpaycard.html");
$t->set_block("authorpaycard_query", "prolist", "prolists");
if (!empty($listid)) {
// 编辑
$query = "select fd_agpm_bkntno as bkntno,\n\t\t\t\t count(fd_agpm_paycardid) as paynum,\t\t\n\t\t\t\t sum(fd_agpm_payfee) as payfee,\n\t\t\t\t sum(fd_agpm_sdcrpayfeemoney) as sdcrpayfeemoney,\n\t\t\t\t sum(fd_agpm_sdcragentfeemoney) as sdcragentfeemoney,\n\t\t\t\t fd_agpm_shoucardno as shoucardno,\n fd_agpm_shoucardbank as shoucardbank,\n\t\t\t\t fd_agpm_shoucardman as shoucardman,\n fd_agpm_shoucardmobile as shoucardmobile,\n\t\t\t\t fd_agpm_paytype as paytype,\n\t\t\t\t fd_agpm_paydate as paydate,\n\t\t\t\t fd_agpm_no as no,\n\t\t\t\t fd_agpm_id as agpmid,\t\n\t\t\t\t fd_author_truename as authorname,\n\t\t\t\t fd_paycard_key as paycardkey,\n\t\t\t\t fd_paycardtype_name as paycardtype,\n\t\t\t\t fd_paycard_scope as paycardscope,\n fd_agpm_paymoney as paymoney,\n\t\t\t\t fd_agpm_state as agpmstate,\n\t\t\t\t fd_paycard_batches as batches,\n\t\t\t\t fd_agpm_money as money,\n\t\t\t\t fd_agpm_paymoney as paymoney from tb_agentpaymoneylist \n\t\t\t\t left join tb_author on fd_author_id = fd_agpm_authorid\n\t\t\t\t left join tb_paycard on fd_paycard_id = fd_agpm_paycardid\n\t\t\t\t left join tb_paycardtype on fd_paycardtype_id=fd_paycard_paycardtypeid\n where fd_agpm_id ='{$listid}' group by fd_agpm_paycardid order by fd_agpm_no\n ";
$db->query($query);
$total = $db->num_rows($result);
pageft($total, 20, $url);
if ($firstcount < 0) {
$firstcount = 0;
}
$query = "{$query} limit {$firstcount},{$displaypg}";
//echo $query;
$db->query($query);
$rows = $db->num_rows();
$arr_result = $db->getFiledData('');
foreach ($arr_result as $value) {
$t->set_var($value);
$cssy = $value[payfee] - $value[sdcrpayfeemoney] - $value[sdcragentfeemoney];
$t->parse("prolists", "prolist", true);
}
}