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


PHP COMMONFUNC::totalRows方法代码示例

本文整理汇总了PHP中COMMONFUNC::totalRows方法的典型用法代码示例。如果您正苦于以下问题:PHP COMMONFUNC::totalRows方法的具体用法?PHP COMMONFUNC::totalRows怎么用?PHP COMMONFUNC::totalRows使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在COMMONFUNC的用法示例。


在下文中一共展示了COMMONFUNC::totalRows方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1:

$db1->next_record();
if($db1->num_rows()>0){
$fadd     = $db1->f('fld_add');
$fedit    = $db1->f('fld_edit');
$fdelete  = $db1->f('fld_delete');
$fview    = $db1->f('fld_view');
}
*/
##******************************************************************
if ($_REQUEST['mode'] == "del") {
    $fldId = $_REQUEST['fldId'];
    $delete_query_details = "delete from " . TBL_CATAGORY . " where fldId=" . $fldId;
    $delmsg = $db->query($delete_query_details);
    if (isset($delmsg)) {
        $_REQUEST['msg'] = "Catagory Deleted Successfully!";
        $count = $func->totalRows(TBL_CATAGORY);
        $offset = $_REQUEST['page'] * 10;
        if ($count <= $offset) {
            $offset = $offset - $count;
            $_REQUEST['page'] = $offset / 10;
        }
    }
}
if ($_REQUEST['mode'] == "delAll") {
    //print_r($_POST['check_delete']);
    for ($i = 0; $i < count($_POST['check_delete']); $i++) {
        //print_r($fldPageId);
        //print_r($k);
        $delete_query_details = "delete from " . TBL_CATAGORY . " where fldId=" . $_POST['check_delete'][$i];
        $delmsg = $db->query($delete_query_details);
    }
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:ADCatagoryList.php

示例2: addslashes

$srchCond = '';
if (!$searchname) {
    $searchname = $_REQUEST['searchname'];
}
$searchname = addslashes($searchname);
if (strlen($searchname) > 0) {
    $queryString = "searchname={$searchname}";
    $srchCond = "AND fldName like '%" . $searchname . "%'";
}
if ($_REQUEST['mode'] == "del") {
    $fldId = $_REQUEST['fldId'];
    $delete_query_details = "delete from " . TBL_COLLEGE_COACH . " where fldId=" . $fldId;
    $delmsg = $db->query($delete_query_details);
    if (isset($delmsg)) {
        $_REQUEST['msg'] = "Team Deleted Successfully!";
        $count = $func->totalRows(TBL_COLLEGE_COACH);
        $offset = $_REQUEST['page'] * 10;
        if ($count <= $offset) {
            $offset = $offset - $count;
            $_REQUEST['page'] = $offset / 10;
        }
    }
}
if ($_REQUEST['mode'] == "delAll") {
    for ($i = 0; $i < count($_POST['check_delete']); $i++) {
        $delete_query_details = "delete from " . TBL_COLLEGE_COACH . " where fldId=" . $_POST['check_delete'][$i];
        $delmsg = $db->query($delete_query_details);
    }
    if (isset($delmsg)) {
        $_REQUEST['msg'] = "College Deleted Successfully!";
        $count = $func->totalRows(TBL_COLLEGE_COACH);
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:ADTeamList.php

示例3: addslashes

$srchCond = '';
if (!$searchname) {
    $searchname = $_REQUEST['searchname'];
}
$searchname = addslashes($searchname);
if (strlen($searchname) > 0) {
    $queryString = "searchname={$searchname}";
    $srchCond = "AND fldClass like '%" . $searchname . "%'";
}
if ($_REQUEST['mode'] == "del") {
    $fldId = $_REQUEST['fldId'];
    $delete_query_details = "delete from " . TBL_CLASS . " where fldId=" . $fldId;
    $delmsg = $db->query($delete_query_details);
    if (isset($delmsg)) {
        $_REQUEST['msg'] = "Class Deleted Successfully!";
        $count = $func->totalRows(TBL_CLASS);
        $offset = $_REQUEST['page'] * 10;
        if ($count <= $offset) {
            $offset = $offset - $count;
            $_REQUEST['page'] = $offset / 10;
        }
    }
}
if ($_REQUEST['mode'] == "delAll") {
    //print_r($_POST['check_delete']);
    for ($i = 0; $i < count($_POST['check_delete']); $i++) {
        $delete_query_details = "delete from " . TBL_CLASS . " where fldId=" . $_POST['check_delete'][$i];
        $delmsg = $db->query($delete_query_details);
    }
    if (isset($delmsg)) {
        $_REQUEST['msg'] = "Class Deleted Successfully!";
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:ADAthleteClassList.php

示例4:

if (strlen($searchname) > 0) {
    $queryString = "searchname={$searchname}";
    $srchCond = "AND fldTitle like '%" . $searchname . "%'";
}
if ($_REQUEST['mode'] == "del") {
    $fldId = $_REQUEST['fldId'];
    $query_Image = " Select * from " . TBL_BANNER . " where fldId ='" . $fldId . "'";
    $db1->query($query_Image);
    $db1->next_record();
    echo $db1->f('fldImage');
    @unlink('../banner/' . $db1->f('fldImage'));
    $delete_query_details = "delete from " . TBL_BANNER . " where fldId='" . $fldId . "'";
    $delmsg = $db->query($delete_query_details);
    if (isset($delmsg)) {
        $_REQUEST['msg'] = "Banner Deleted Successfully!";
        $count = $func->totalRows(TBL_BANNER);
        $offset = $_REQUEST['page'] * 10;
        if ($count <= $offset) {
            $offset = $offset - $count;
            $_REQUEST['page'] = $offset / 10;
        }
    }
}
if ($_REQUEST['mode'] == "delAll") {
    for ($i = 0; $i < count($_POST['check_delete']); $i++) {
        $query_Image = " Select * from " . TBL_BANNER . " where fldId ='" . $_POST['check_delete'][$i] . "'";
        $db1->query($query_Image);
        $db1->next_record();
        echo $db1->f('fldImage');
        @unlink('../banner/' . $db1->f('fldImage'));
        $delete_query_details = "delete from " . TBL_BANNER . " where fldId='" . $_POST['check_delete'][$i] . "'";
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:ADBannerList.php

示例5:

$db1->next_record();
if($db1->num_rows()>0){
$fadd     = $db1->f('fld_add');
$fedit    = $db1->f('fld_edit');
$fdelete  = $db1->f('fld_delete');
$fview    = $db1->f('fld_view');
}
*/
##******************************************************************
if ($_REQUEST['mode'] == "del") {
    $fldId = $_REQUEST['fldId'];
    $delete_query_details = "delete from " . TBL_OTHER . " where fldId=" . $fldId;
    $delmsg = $db->query($delete_query_details);
    if (isset($delmsg)) {
        $_REQUEST['msg'] = "Other Deleted Successfully!";
        $count = $func->totalRows(TBL_OTHER);
        $offset = $_REQUEST['page'] * 10;
        if ($count <= $offset) {
            $offset = $offset - $count;
            $_REQUEST['page'] = $offset / 10;
        }
    }
}
if ($_REQUEST['mode'] == "delAll") {
    //print_r($_POST['check_delete']);
    for ($i = 0; $i < count($_POST['check_delete']); $i++) {
        //print_r($fldPageId);
        //print_r($k);
        $delete_query_details = "delete from " . TBL_OTHER . " where fldId=" . $_POST['check_delete'][$i];
        $delmsg = $db->query($delete_query_details);
    }
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:ADLisOther.php

示例6: addslashes

$srchCond = '';
if (!$searchname) {
    $searchname = $_REQUEST['searchname'];
}
$searchname = addslashes($searchname);
if (strlen($searchname) > 0) {
    $queryString = "searchname={$searchname}";
    $srchCond = "AND fldSportsname like '%{$searchname}%'";
}
if ($_REQUEST['mode'] == "del") {
    $fldId = $_REQUEST['fldId'];
    $delete_query_details = "delete from " . TBL_SPORTS . " where fldId='" . $fldId . "'";
    $delmsg = $db->query($delete_query_details);
    if (isset($delmsg)) {
        $_REQUEST['msg'] = "Sport Deleted Successfully!";
        $count = $func->totalRows(TBL_SPORTS);
        $offset = $_REQUEST['page'] * 10;
        if ($count <= $offset) {
            $offset = $offset - $count;
            $_REQUEST['page'] = $offset / 10;
        }
    }
}
if ($_REQUEST['mode'] == "delAll") {
    foreach ($_REQUEST['check_delete'] as $key => $fldId) {
        $delete_query_details = "delete from " . TBL_SPORTS . " where fldId='{$fldId}'";
        $delmsg = $db->query($delete_query_details);
    }
    if (isset($delmsg)) {
        $_REQUEST['msg'] = "Sports Deleted Successfully!";
        $count = $func->totalRows(TBL_SPORTS);
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:ADSportList.php

示例7: foreach

        }
    }
}
if ($_POST['search'] == 'Search') {
    $fldStartdate = $_POST['fldStartdate'];
    $fldEndDate = $_POST['fldEndDate'];
    $fldcontent = $_POST['fldcontent'];
}
if ($_REQUEST['mode'] == "delAll") {
    foreach ($_REQUEST['check_delete'] as $k => $mail_id) {
        $delete_query_details = "delete from " . TBL_MAIL . " where mail_id='{$mail_id}'";
        $delmsg = $db->query($delete_query_details);
    }
    if (isset($delmsg)) {
        $_REQUEST['msg'] = "Message Deleted Successfully!";
        $count = $func->totalRows(TBL_MAIL);
        $offset = $_REQUEST['page'] * 10;
        if ($count <= $offset) {
            $offset = $offset - $count;
            $_REQUEST['page'] = $offset / 10;
        }
    }
}
if ($_REQUEST['mode'] == "dective") {
    $mail_id = $_REQUEST['mail_id'];
    $active_query_details = "update " . TBL_MAIL . " set visible = 'DECTIVE' where mail_id='" . $mail_id . "'";
    $activemsg = $db->query($active_query_details);
    if (isset($activemsg)) {
        $_REQUEST['msg'] = "Message De-Active Successfully!";
    }
}
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:ADMessageList.php

示例8:

    $db1->next_record();
    $db1->num_rows();
    if ($db->num_rows() == 0) {
        $delete_query_details = "delete from " . TBL_ATHLETE_STATS_CATAGORY . " where fldId=" . $fldId;
        $delmsg = $db1->query($delete_query_details);
    } else {
        ?>

		<script type="text/javascript">
		alert("You have to delete its Subcategory first");
		</script>
		<?php 
    }
    if (isset($delmsg)) {
        $_REQUEST['msg'] = "Category Deleted Successfully!";
        $count = $func->totalRows(TBL_ATHLETE_STATS_CATAGORY);
        $offset = $_REQUEST['page'] * 10;
        if ($count <= $offset) {
            $offset = $offset - $count;
            $_REQUEST['page'] = $offset / 10;
        }
    }
}
if ($_REQUEST['mode'] == "delAll") {
    for ($i = 0; $i < count($_POST['check_delete']); $i++) {
        $query_child = " Select * from " . TBL_ATHLETE_STATS_CATAGORY . " where fldParentId =" . $_POST['check_delete'][$i];
        $db1->query($query_child);
        $db1->next_record();
        $db1->num_rows();
        if ($db1->num_rows() == 0) {
            $delete_query_details = "delete from " . TBL_ATHLETE_STATS_CATAGORY . " where fldId=" . $_POST['check_delete'][$i];
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:ADAthleteCatagoryList.php

示例9: header

    header("Location:login.php");
}
//for paging
$func = new COMMONFUNC();
$page = new Page();
$db = new DB();
$db2 = new DB();
$flag = 0;
//Local Variables
$IsMyProfile = 0;
if ($_REQUEST['mode'] == "del") {
    $delete_query_details = "delete from " . TBL_COLLEGE_NEEDS . " where fldId='" . $_REQUEST['fldId'] . "'";
    $delmsg = $db->query($delete_query_details);
    if (isset($delmsg)) {
        $_REQUEST['msg'] = "Need Type successfully deleted.";
        $count = $func->totalRows(TBL_NEEDTYPE);
        $offset = $_REQUEST['page'] * 10;
        if ($count <= $offset) {
            $offset = $offset - $count;
            $_REQUEST['page'] = $offset / 10;
        }
    }
}
//Detect if this Athlete is Athlete viewing profile
if ($_REQUEST['collegeid'] != '' and $_SESSION['College_Coach_id'] != '' and $_REQUEST['collegeid'] == $_SESSION['College_Coach_id']) {
    $IsMyProfile = 1;
}
#######################################
## SEND NETWORK REQUEST
//Insert, Display Notification, and Email Recipient
$GLOBALPage = "collegeprofile.php?collegeid=";
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:collegeprofile.php

示例10: OR

        $srchCond = "AND ((fldName like '%{$searchname}%') OR (fldSchool = '{$searchteam}'))";
    }
} else {
    if (!$_REQUEST['searchname'] and $_REQUEST['fldSchool'] != 0) {
        $searchteam = $_REQUEST['fldSchool'];
        $srchCond = "AND fldSchool = '{$searchteam}'";
        $flag++;
    }
}
if ($_REQUEST['mode'] == "del") {
    $fldId = $_REQUEST['fldId'];
    $delete_query_details = "delete from " . TBL_HS_AAU_COACH . " where fldId='" . $fldId . "'";
    $delmsg = $db->query($delete_query_details);
    if (isset($delmsg)) {
        $_REQUEST['msg'] = "High School / AAU Coach Deleted Successfully!";
        $count = $func->totalRows(TBL_HS_AAU_COACH);
        $offset = $_REQUEST['page'] * 10;
        if ($count <= $offset) {
            $offset = $offset - $count;
            $_REQUEST['page'] = $offset / 10;
        }
    }
}
if ($_REQUEST['mode'] == "delAll") {
    foreach ($_REQUEST['check_delete'] as $key => $fldId) {
        $delete_query_details = "delete from " . TBL_HS_AAU_COACH . " where fldId='{$fldId}'";
        $delmsg = $db->query($delete_query_details);
    }
    if (isset($delmsg)) {
        $_REQUEST['msg'] = "High School / AAU Coach Deleted Successfully!";
        $count = $func->totalRows(TBL_HS_AAU_COACH);
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:ADCoachList.php

示例11: addslashes

/*if(!$searchname){
$searchname=$_REQUEST['searchname'];
}
$searchname = addslashes($searchname);
if(strlen($searchname)>0)
{   $queryString="searchname=$searchname";
	$srchCond= "AND fldEventName like '%".$searchname."%'";
}
*/
if ($_REQUEST['mode'] == "del") {
    $id = $_REQUEST['id'];
    $delete_query_details = "delete from " . $tbl_transportation_discount . " where id=" . $id;
    $delmsg = $db->query($delete_query_details);
    if (isset($delmsg)) {
        $_REQUEST['msg'] = "Transportation Discount Deleted Successfully!";
        $count = $func->totalRows($tbl_transportation_discount);
        $offset = $_REQUEST['page'] * 10;
        if ($count <= $offset) {
            $offset = $offset - $count;
            $_REQUEST['page'] = $offset / 10;
        }
    }
}
if ($_REQUEST['mode'] == "delAll") {
    for ($i = 0; $i < count($_POST['check_delete']); $i++) {
        $delete_query_details = "delete from " . $tbl_transportation_discount . " where id=" . $_POST['check_delete'][$i];
        $delmsg = $db->query($delete_query_details);
    }
    if (isset($delmsg)) {
        $_REQUEST['msg'] = "Transportation Discount Deleted Successfully!";
        $count = $func->totalRows($tbl_transportation_discount);
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:ADTransportationManage.php

示例12: addslashes

$srchCond = '';
if (!$searchname) {
    $searchname = $_REQUEST['searchname'];
}
$searchname = addslashes($searchname);
if (strlen($searchname) > 0) {
    $queryString = "searchname={$searchname}";
    $srchCond = "AND fldTitle like '%" . $searchname . "%' OR fldDescription like '%" . $searchname . "%'";
}
if ($_REQUEST['mode'] == "del") {
    $fldId = $_REQUEST['fldId'];
    $delete_query_details = "delete from tbl_notes where fldId=" . $fldId;
    $delmsg = $db->query($delete_query_details);
    if (isset($delmsg)) {
        $_REQUEST['msg'] = "Note Deleted Successfully!";
        $count = $func->totalRows("tbl_notes");
        $offset = $_REQUEST['page'] * 10;
        if ($count <= $offset) {
            $offset = $offset - $count;
            $_REQUEST['page'] = $offset / 10;
        }
    }
}
if ($_REQUEST['mode'] == "delAll") {
    for ($i = 0; $i < count($_POST['check_delete']); $i++) {
        $delete_query_details = "delete from tbl_notes where fldId=" . $_POST['check_delete'][$i];
        $delmsg = $db->query($delete_query_details);
    }
    if (isset($delmsg)) {
        $_REQUEST['msg'] = "Note Deleted Successfully!";
        $count = $func->totalRows("tbl_notes");
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:ADNotesList.php

示例13: addslashes

$srchCond = '';
if (!$searchname) {
    $searchname = $_REQUEST['searchname'];
}
$searchname = addslashes($searchname);
if (strlen($searchname) > 0) {
    $queryString = "searchname={$searchname}";
    $srchCond = "AND fldCollegename like '%{$searchname}%'";
}
if ($_REQUEST['mode'] == "del") {
    $fldId = $_REQUEST['fldId'];
    $delete_query_details = "delete from " . TBL_COLLEGE_REGISTER . " where fldId='" . $fldId . "'";
    $delmsg = $db->query($delete_query_details);
    if (isset($delmsg)) {
        $_REQUEST['msg'] = "College Deleted Successfully!";
        $count = $func->totalRows(TBL_COLLEGE_REGISTER);
        $offset = $_REQUEST['page'] * 10;
        if ($count <= $offset) {
            $offset = $offset - $count;
            $_REQUEST['page'] = $offset / 10;
        }
    }
}
if ($_REQUEST['mode'] == "delAll") {
    foreach ($_REQUEST['check_delete'] as $k => $fldId) {
        $delete_query_details = "delete from " . TBL_COLLEGE_REGISTER . " where fldId='{$fldId}'";
        $delmsg = $db->query($delete_query_details);
    }
    if (isset($delmsg)) {
        $_REQUEST['msg'] = "College Deleted Successfully!";
        $count = $func->totalRows(TBL_COLLEGE_REGISTER);
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:ADCollegeList.php

示例14: addslashes

$srchCond = '';
if (!$searchname) {
    $searchname = $_REQUEST['searchname'];
}
$searchname = addslashes($searchname);
if (strlen($searchname) > 0) {
    $queryString = "searchname={$searchname}";
    $srchCond = "fldStatus=1 AND fldName like '%" . $searchname . "%'";
}
if ($_REQUEST['mode'] == "del") {
    $fldId = $_REQUEST['fldId'];
    $delete_query_details = "delete from " . TBL_COLLEGE . " where fldId=" . $fldId;
    $delmsg = $db->query($delete_query_details);
    if (isset($delmsg)) {
        $_REQUEST['msg'] = "College Deleted Successfully!";
        $count = $func->totalRows(TBL_COLLEGE);
        $offset = $_REQUEST['page'] * 10;
        if ($count <= $offset) {
            $offset = $offset - $count;
            $_REQUEST['page'] = $offset / 10;
        }
    }
}
if ($_REQUEST['mode'] == "delAll") {
    for ($i = 0; $i < count($_POST['check_delete']); $i++) {
        $delete_query_details = "delete from " . TBL_COLLEGE . " where fldId=" . $_POST['check_delete'][$i];
        $delmsg = $db->query($delete_query_details);
    }
    if (isset($delmsg)) {
        $_REQUEST['msg'] = "College Deleted Successfully!";
        $count = $func->totalRows(TBL_COLLEGE);
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:ADListCollege.php

示例15:

$db1->next_record();
if($db1->num_rows()>0){
$fadd     = $db1->f('fld_add');
$fedit    = $db1->f('fld_edit');
$fdelete  = $db1->f('fld_delete');
$fview    = $db1->f('fld_view');
}
*/
##******************************************************************
if ($_REQUEST['mode'] == "del") {
    $fldId = $_REQUEST['fldId'];
    $delete_query_details = "delete from " . TBL_ATHELETE_STAT . " where fldId='" . $fldId . "'";
    $delmsg = $db->query($delete_query_details);
    if (isset($delmsg)) {
        $_REQUEST['msg'] = "Athlete Stat Deleted Successfully!";
        $count = $func->totalRows(TBL_ATHELETE_STAT);
        $offset = $_REQUEST['page'] * 10;
        if ($count <= $offset) {
            $offset = $offset - $count;
            $_REQUEST['page'] = $offset / 10;
        }
    }
}
if ($_REQUEST['mode'] == "delAll") {
    for ($i = 0; $i < count($_POST['check_delete']); $i++) {
        $delete_query_details = "delete from " . TBL_ATHELETE_STAT . " where fldId='" . $_POST['check_delete'][$i] . "'";
        $delmsg = $db->query($delete_query_details);
        if (isset($delmsg)) {
            $_REQUEST['msg'] = "Athlete Stat Deleted Successfully!";
            $count = $func->totalRows(TBL_ATHELETE_STAT);
            $offset = $_REQUEST['page'] * 10;
开发者ID:trungjc,项目名称:collegeprospectnetwork,代码行数:31,代码来源:ADAtheleteStateList.php


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