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


PHP dbconnection::fetchrow方法代码示例

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


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

 function dologin($username, $password)
 {
     $enc = new Encryption();
     $password = $enc->oneway_encode($password);
     $db = new dbconnection();
     $db->dbconnect();
     $db->query = "select * from " . TABLE_USERS . " where username='{$username}' and password='{$password}'";
     $db->execute();
     if ($db->rowcount() > 0) {
         $row = $db->fetchrow(0);
         $userid = $row['userid'];
         $ipaddr = $_SERVER['REMOTE_ADDR'];
         $lastlogin = Date("Y-m-d H:i:s");
         $db->query = "update " . TABLE_USERS . " set lastlogin='{$lastlogin}' where userid={$userid}";
         $db->execute();
         $db->query = "insert into " . TABLE_USERLOGS . " (userid,ipaddress,logdate,action)\n        values ({$userid},'{$ipaddr}','{$lastlogin}','LOGIN')\n        ";
         $db->execute();
         return $row;
     } else {
         $db->dbclose();
         return false;
     }
 }
开发者ID:CallBest,项目名称:CallCenter-CIMS,代码行数:23,代码来源:user.php

示例3: dbconnection

.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'])) {
    case 'CLASSIC MASTERCARD':
开发者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


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