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


PHP dbconnection::rowcount方法代码示例

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


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

示例1: preload_lists

function preload_lists()
{
    $db = new dbconnection();
    $db->dbconnect();
    $db->query = "select listid,listname from " . TABLE_LISTS . " where active=1";
    $db->execute();
    $rowcount = $db->rowcount();
    if ($rowcount > 0) {
        for ($x = 0; $x < $rowcount; $x++) {
            $row = $db->fetchrow($x);
            $list[$x] = $row;
        }
    }
    return $list;
}
开发者ID:CallBest,项目名称:CallCenter-CIMS,代码行数:15,代码来源:preloadvalues.php

示例2: changepassword

 function changepassword($userid, $oldpass, $newpass, $newpassrepeat)
 {
     if ($newpass == $newpassrepeat) {
         $enc = new Encryption();
         $db = new dbconnection();
         $db->dbconnect();
         //check oldpass, update password if ok, send message if not
         $password = $enc->oneway_encode($oldpass);
         $db->query = "select userid from " . TABLE_USERS . " where userid={$userid} and password='{$password}'";
         $db->execute();
         if ($db->rowcount() > 0) {
             $newpass = $enc->oneway_encode($newpass);
             $db->query = "update " . TABLE_USERS . " set password='{$newpass}' where userid={$userid}";
             $db->execute();
             $msg = 'Password updated.';
         } else {
             $msg = 'Incorrect old password.';
         }
     } else {
         $msg = 'New password does not match.';
     }
     return $msg;
 }
开发者ID:CallBest,项目名称:CallCenter-CIMS,代码行数:23,代码来源:user.php

示例3: dbconnection

.col3_mbclient_yes{margin-left:15px;}
.col3_mbclient_no{margin-left:5px;}
.col3txt_branchremarks {border:0px;border-bottom:1px solid black;margin-left:5px;}
				</style>
		<title>Metrobank Application Form</title>
    </head>
<?php 
if (isset($_REQUEST['leadid'])) {
    $leadid = $_REQUEST['leadid'];
    require_once '../../includes/dbase.php';
    require_once '../../includes/settings.php';
    $db = new dbconnection();
    $db->dbconnect();
    $db->query = "select * from " . TABLE_CLIENTS . " a left join " . TABLE_CLIENTINFO . " b on (a.leadid=b.leadid) where a.leadid={$leadid}";
    $db->execute();
    if ($db->rowcount() > 0) {
        $row = $db->fetchrow(0);
    }
}
?>
<body>
    
    <div id="main">
	
        <div class="column1">
            <h3>ALL FIELDS ARE MANDATORY AND MUST BE FILLED UP.</h3><br>
			
			<b>MY CHOICE OF A METROBANK CREDIT CARD</b><br>
			
			<?php 
switch (strtoupper($row['mccardtype'])) {
开发者ID:CallBest,项目名称:CallCenter-CIMS,代码行数:31,代码来源:MBAppForm.php

示例4: on

    } else {
        $appliedcard = $_REQUEST['appliedcard'];
    }
} else {
    $appliedcard = '';
}
if (isset($_REQUEST['applied'])) {
    $checked = $_REQUEST['applied'];
} else {
    $checked = '';
}
//actual query
if ($appliedcard != '') {
    $db->query = "\n      select * from " . TABLE_CLIENTS . " a\n      inner join " . TABLE_LISTS . " b on (a.listid=b.listid)\n      inner join " . TABLE_USERS . " c on (a.agent=c.userid)\n      inner join " . TABLE_CARDS . " d on (a.leadid=d.leadid)\n      where disposition='{$dispo}' and teamid={$teamid} {$listid} and {$appliedcard}='{$checked}' order by {$sort} limit {$start}, {$end}\n    ";
    $db->execute();
} else {
    $db->query = "\n      select * from " . TABLE_CLIENTS . " a\n      inner join " . TABLE_LISTS . " b on (a.listid=b.listid)\n      inner join " . TABLE_USERS . " c on (a.agent=c.userid)\n      where disposition='{$dispo}' and teamid={$teamid} {$listid} order by {$sort} limit {$start}, {$end}";
    $db->execute();
}
$gridvalues = array();
$tablebody = "";
$rowcount = $db->rowcount();
for ($x = 0; $x < $rowcount; $x++) {
    $row = $db->fetchrow($x);
    $gridvalues[$x] = $row;
}
$body->template_loop('gridvalues', $gridvalues);
$body->add_key('prev', $start - 10);
$body->add_key('next', $start + 10);
$activelist = preload_lists();
$body->template_loop('list', $activelist);
开发者ID:CallBest,项目名称:CallCenter-CIMS,代码行数:31,代码来源:gridview.php

示例5: Date

} else {
    exit;
}
if (isset($_REQUEST['referalname'])) {
    require_once "../../includes/settings.php";
    require_once "../../includes/dbase.php";
    $referalname = $_REQUEST['referalname'];
    $referalcontact = $_REQUEST['referalcontact'];
    $curdatetime = Date("Y-m-d H:i:s");
    $db = new dbconnection();
    $db->dbconnect();
    $db->query = "\n    insert into " . TABLE_CLIENTS . "\n      (completename,phone,disposition,dateuploaded,tagdate,dateexpires,listid,opener,agent,referencecode)\n      values\n      ('{$referalname}','{$referalcontact}','Referal',curdate(),'{$curdatetime}',CURDATE() + INTERVAL 30 DAY,2,{$userid},{$userid},'{$leadid}')\n    ";
    $db->execute();
    $db->query = "\n    select leadid from " . TABLE_CLIENTS . "\n    where agent={$userid} and disposition='Referal' and tagdate='{$curdatetime}'\n    ";
    $db->execute();
    if ($db->rowcount() == 1) {
        $row = $db->fetchrow(0);
        $db->query = "insert into " . TABLE_CLIENTINFO . " (leadid) values (" . $row['leadid'] . ")";
        $db->execute();
        $db->query = "insert into " . TABLE_CARDS . " (leadid) values (" . $row['leadid'] . ")";
        $db->execute();
    } else {
        //temporary error handler
        $db->query = "update " . TABLE_CLIENTS . " set disposition='ERROR' where agent={$userid} and disposition='Referal' and tagdate='{$curdatetime}'";
        $db->execute();
    }
}
$body = new Template();
$body->set_template("../../templates/agent/referal.html");
$body->add_key('cname', $cname);
$body->add_key('userid', $userid);
开发者ID:CallBest,项目名称:CallCenter-CIMS,代码行数:31,代码来源:referal.php

示例6: dbconnection

}
$db = new dbconnection();
$db->dbconnect();
//masterfile
$concatname = str_replace(' ', '', $clfirstname . $clmiddlename . $cllastname);
$db->query = "\n  update " . TABLE_CLIENTS . "\n  set agent={$agent},disposition='{$disposition}',tagdate=now(),remarks='{$remarks}',concatname='{$concatname}'\n  where leadid={$leadid}\n  ";
$db->execute();
//clientinfo
$db->query = "\n  update " . TABLE_CLIENTINFO . "\n  set \n    {$setfields}\n    leadid={$leadid}\n  where leadid={$leadid}\n  ";
$db->execute();
//verifications
if (strtoupper($disposition) == 'VERIFIED') {
    $now = Date("Y-m-d");
    $db->query = "\n    select tagdate from " . TABLE_VER . "\n    where leadid={$leadid} and tagdate='{$now}'\n    ";
    $db->execute();
    if ($db->rowcount() == 0) {
        $db->query = "\n      insert into " . TABLE_VER . "\n        (leadid,agent,disposition,tagdate)\n        values\n        ({$leadid},{$agent},'{$disposition}','{$now}') \n      ";
        $db->execute();
    } else {
        $db->query = "\n      update " . TABLE_VER . "\n        set agent={$agent},disposition='{$disposition}',tagdate='{$now}'\n        where leadid={$leadid} \n      ";
        $db->execute();
    }
    $db->query = "\n  insert into " . TABLE_FILES . "\n    (leadid,filename,dateuploaded,agent)\n    values\n    ({$leadid},'','0000-00-00',0)\n    on duplicate key update\n    leadid={$leadid} \n  ";
    $db->execute();
}
//phonenumbers
$db->query = "select leadid,phonenumber from " . TABLE_PHONES . " where leadid={$leadid}";
$db->execute();
$queries = array();
$rowcount = $db->rowcount();
for ($x = 0; $x < $rowcount; $x++) {
开发者ID:CallBest,项目名称:CallCenter-CIMS,代码行数:31,代码来源:savevalues.php


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