当前位置: 首页>>代码示例>>PHP>>正文


PHP db_test::num_rows方法代码示例

本文整理汇总了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);
    }
}
开发者ID:Xiaoyuyexi,项目名称:client-server,代码行数:31,代码来源:authorpaycard.php


注:本文中的db_test::num_rows方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。