本文整理汇总了PHP中FetchRow函数的典型用法代码示例。如果您正苦于以下问题：PHP FetchRow函数的具体用法？PHP FetchRow怎么用？PHP FetchRow使用的例子？那么, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了FetchRow函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: SelectDataWhere
<table border=0 cellspacing=1 cellpadding=1 width=100%><br>
<tr>
<td align="center" valign="top" class='header2' colspan=4 >
Approval Decision</td>
</tr>
</table>
<br>
<table border=0 cellspacing=1 cellpadding=1 width='90%' align=center>
<tr>
</tr>
<tr>
<?php
$getapp = SelectDataWhere($dbtype, $dbLink, "ebpls_buss_approve", "where owner_id = {$owner_id} and \n\t\t\t\t\t business_id={$business_id}");
$getit = FetchRow($dbtype, $getapp);
$getnum = NumRows($dbtype, $getapp);
if ($getit[3] == 0 and $getit[3] != '') {
$decsel = 'selected';
} else {
$appsel = 'selected';
}
?>
<td> Application Status: </td>
<td> <select name=decide>
<option value=1 <?php
echo $appsel;
?>
>Approved</option>示例2: elseif
if ($mtopsearch == 'SEARCH') {
//search existing
require_once "includes/release_search.php";
} elseif ($com == 'PrintReport') {
//verify if already have a permit code
if ($permit_type != 'Business') {
$vericode = SelectMultiTable($dbtype, $dbLink, $permittable, "released,{$incode}", "where owner_id = {$owner_id} and active=1 limit 1");
} else {
$vericode = SelectMultiTable($dbtype, $dbLink, $permittable, "released,{$incode}", "where owner_id = {$owner_id} and \n\t\t\t business_id={$business_id} and active = 1 limit 1");
}
$veri = FetchRow($dbtype, $vericode);
if ($veri[0] == '0' || $veri[0] == '') {
//assign new code
//get format of permit
$getcod = SelectMultiTable($dbtype, $dbLink, "permit_templates", "permit_header, permit_date, permit_sequence", "where permit_type='{$permit_type}'");
$getcode = FetchRow($dbtype, $getcod);
//check if have other permit last year
//get setting
$rr = mysql_query("select * from ebpls_buss_preference");
$rt = mysql_fetch_assoc($rr);
$ry = $rt["iReset"];
if ($ry == '1') {
$getpyr = mysql_query("select * from {$permittable} order by {$incode} desc");
$gt = mysql_fetch_assoc($getpyr);
$anoba = $gt["for_year"];
if ($anoba == date('Y')) {
//get total number of permit released
$curyr = date('Y');
$gettotal = SelectDataWhere($dbtype, $dbLink, $permittable, "where released = 1 and for_year = '{$curyr}'");
$gettot = NumRows($dbtype, $gettotal);
} else {示例3: isset
require_once "includes/variables.php";
require 'setup/setting.php';
//$dbLink =Open($dbtype,$connecttype,$dbhost,$dbuser,$dbpass);
$max_resultsr = $thIntPageLimit;
$pagemulti = $page;
$ascdesc1 = isset($ascdesc1) ? $ascdesc1 : 'asc';
//2008.05.06
$reftype = isset($reftype) ? $reftype : '';
if ($pagemulti == '') {
$pagemulti = 1;
}
$myrow = $pagemulti * $max_resultsr - $max_resultsr;
// Perform MySQL query on only the current page number's result
//$result = mysql_query($searchsql)or die (mysql_error());
$result = Query1($dbtype, $dbLink, $searchsql);
while ($get_info = FetchRow($dbtype, $result)) {
// Build your formatted results here.
if ($itemID_ == 1221) {
include 'includes/bizlinks.php';
} elseif ($itemID_ == 4212) {
include 'includes/asslinks.php';
} elseif ($itemID_ == 2212) {
include 'includes/paylinks.php';
} elseif ($itemID_ == 3212) {
include 'includes/rellinks.php';
} elseif ($itemID_ == 5212) {
include 'includes/applinks.php';
} else {
if ($selMode == ebpls_nbusiness) {
include 'includes/eNature-inc.php';
}示例4: SelectMultiTable
<!--
<html>
<head>
<link rel="stylesheet" href="stylesheets/default.css" type="text/css"/>
</head>
<body>
<br>
<div align='center'>
<?php
if ($owner_id == '') {
$owner_id = 0;
}
$getemp = SelectMultiTable($dbtype, $dbLink, $permittable, "occ_permit_code, occ_permit_application_date,\r\n occ_position_applied, occ_employer,occ_employer_trade_name,\r\n occ_employer_lot_no, occ_employer_street, business_id", "where owner_id={$owner_id} and active=1");
$getit = FetchRow($dbtype, $getemp);
$permit_code = $getit[0];
$pos_app = $getit[2];
$permit_date = $getit[1];
$employer_name = $getit[3];
$trade_name = $getit[4];
$street = $getit[6];
$lot_no = $getit[5];
?>
<form name="_FRM" method="POST" action="index.php?part=1221&owner_id=<?php
echo $owner_id;
?>
&permit_type=Occupational&stat=<?php
echo $status;
?>
&create=No&addfee=Add">-->
<form method=post action ='index.php?part=4&class_type=Permits&itemID_=1221&addfee=Add&owner_id=<?php 示例5: NumRows
$gt = NumRows($dbtype, $getreq);
while ($ic < $gt) {
while ($getr = FetchRow($dbtype, $getreq)) {
$ic++;
if ($col1 == 0) {
include 'tablecolor-inc.php';
print "<tr bgcolor='{$varcolor}'>\n";
}
$check1 = SelectDataWhere($dbtype, $dbLink, "havereq", " where owner_id={$owner_id}\n \tand business_id={$business_id} \n\t\t\t\t\tand reqid={$getr['0']}");
$hreq = NumRows($dbtype, $check1);
if ($hreq == 0) {
$insertreq = InsertQuery($dbtype, $dbLink, "havereq", "", "'', {$getr['0']}, {$owner_id}, {$business_id},0");
$ch = 'UNCHECKED';
$gethr[4] = 0;
} else {
$gethr = FetchRow($dbtype, $check1);
if ($gethr[4] == 1) {
$ch = 'CHECKED';
} else {
$ch = 'UNCHECKED';
}
}
$getr[1] = stripslashes($getr[1]);
print "\t\n\t\t\t\t<td align=right width=5%><input type=hidden name=colre[{$ic}] \n\t\t\t\tvalue={$getr['0']}>  \n\t\t\t\t<input type=checkbox name=x[{$ic}] {$ch}></td><td align=left width=23%>{$getr['1']}\n\t\t\t\t</td>";
$col1 = $col1 + 1;
$arr_id[$i++] = $ic;
if ($col1 > 1) {
print "</tr><tr>";
$col1 = 0;
}
}示例6: SelectMultiTable
echo $get_info[4];
?>
&permit_type=<?php
echo $permit_type;
?>
&stat=<?php
echo $stat;
?>
");'>Re-Print OR</a></div></td>
<?php
}
print "</tr>\n";
}
//end while
$getpay = SelectMultiTable($dbtype, $dbLink, "temppayment", "sum(payamt)", "where owner_id = {$owner_id} and permit_type='{$permit_type}' \n\t\t\t and permit_status='{$stat}' and pay_date like '{$getyearnow}%'");
$totalpaid = FetchRow($dbtype, $getpay);
$totalpaidnf = number_format($totalpaid[0], 2);
?>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
<tr><td>Total : </td>
<td align=right> <?php
echo $totalpaidnf;
?>
</td>
<?php
$hj = $totalpaid[0];
$amtchange = $hj - $totalpay;
if ($amtchange < 0) {
print "<td></td>\n";
} else {
print "<td></td>\n";示例7: round
$htag = 'Assessment';
$com = 'approve';
require "includes/headerassess.php";
require "includes/assessment.php";
}
}
//$grandamt = $total_tax_compute + $total_sf_compute + $fee;
//echo "$total_tax_compute + $total_sf_compute + $fee";
//echo $grandamt;
//$ttax=$grandamt+$totfee;
$totfee = round($totfee, 2);
$ttax = $grandamt - $totfee;
$gid = SelectDataWhere($dbtype, $dbLink, "bus_grandamt", "where business_id={$business_id} and active = 0 and\n owner_id={$owner_id} order by gid desc limit 1");
$haveexist = NumRows($dbtype, $gid);
if ($haveexist != 0) {
$mt = FetchRow($dbtype, $gid);
$grdmt = $mt[3];
} else {
$grdmt = $grandamt + $totfee;
}
$tabs = abs($grdmt - $totalpaidtax);
if ($grdmt == '0.00') {
$grdmt = $grandamt;
}
$gettag = SelectDataWhere($dbtype, $dbLink, "ebpls_buss_preference", "");
$gettag = FetchArray($dbtype, $gettag);
if ($gettag[sassess] == '') {
$grdmt = $ota - $add2fee + $totfee;
$tabs = abs($grdmt - $totalpaidtax);
$grandamt = $grdmt;
}示例8: SelectMultiTable
<?php
//matinding nakakahilong sql
$ff = "(";
$outamt = '';
$compsql = SelectMultiTable($dbtype, $dbLink, "tempassess a, ebpls_buss_taxfeeother b,\r\n ebpls_buss_complex c", "a.multi, a.amt, a.formula, c.coptr, c.addons,a.compval", "where a.natureid = b.natureid and \r\n\t\t\ta.taxfeeid = b.taxfeeid and a.taxfeeid = c.taxfeeid1 and \r\n\t\t\tb.taxfeeid = c.taxfeeid1 and a.tfoid = b.tfoid and \r\n\t\t\ta.tfoid = c.tfoid and b.tfoid = c.tfoid and \r\n\t\t\ta.natureid = b.natureid and b.natureid = c.natureid \r\n\t\t\tand a.natureid = c.natureid and\r\n\t\t\tc.taxfeeid={$taxfeeid} and a.active=1\r\n and a.transaction='{$stat}' and owner_id = {$owner_id} \r\n\t\t\tand business_id = {$business_id}\r\n\t\t\torder by compid asc");
while ($comp = FetchRow($dbtype, $compsql)) {
if (is_numeric($comp[2])) {
$formula = "((" . $comp[0] . "*" . $comp[2] . "))" . $comp[3] . $comp[4];
} else {
$formula = "((" . $comp[0] . $comp[2] . $comp[3] . $comp[4];
}
$outamt = $outamt . $formula;
}
$cfr = $fr . $ff . $outamt;
//."))";
// eval ("\$totind=$fr$ff$outamt));");
// echo $cfr;
//count "(" ")"
$sop = substr_count($cfr, '(');
$scp = substr_count($cfr, ')');
if ($sop > $scp) {
$looper = $scp;
$addcp = '';
while ($looper < $sop) {
$addcp = $addcp . ')';
$looper++;
}
}
eval("\$totind={$cfr}{$addcp};");
// echo $totind;示例9: SelectDataWhere
</textarea>
</td>
</tr>
</table>
<table border=1 align=center width=600<br><br>
<tr>
<td align=center>Keyword</td><td align=center>Message</td><td></td>
</tr>
<?php
if ($submitbt == 'Search') {
$sms = SelectDataWhere($dbtype, $dbLink, "sms_message", "where keyword like '{$keyword}%'");
} else {
$sms = SelectDataWhere($dbtype, $dbLink, "sms_message", "");
}
while ($msg = FetchRow($dbtype, $sms)) {
$msg[1] = stripslashes($msg[1]);
$msg[2] = stripslashes($msg[2]);
?>
<tr>
<td><input type=hidden name=msgid value=<?php
echo $msg[0];
?>
>
<?php
echo $msg[1];
?>
</td>
<td>
<?php
echo $msg[2];示例10: date
//Module that saves information to table bus_grandamt
//if ($itemID_ == "4212") {
$yearfornow = date('Y');
if (strtolower($pmode) == 'quarterly') {
$paympart = $qtrcnt;
}
if (strtolower($pmode) == 'semi-annual') {
$paympart = $semcnt;
}
if (strtolower($pmode) == 'annual') {
$paympart = '1';
}
if ($ramt2 == 0) {
$getgh = SelectDataWhere($dbtype, $dbLink, "bus_grandamt", "where owner_id = '{$owner_id}' and business_id = '{$business_id}' and transaction='{$stat}' and ts = '{$yearfornow}' and paymode = '{$pmode}' and paypart = '{$paympart}'");
$getghg = FetchRow($dbtype, $getgh);
$nghigh = $getghg[3];
} else {
$nghigh = 0;
}
$updatebus = UpdateQuery($dbtype, $dbLink, "bus_grandamt", "active = 0", "owner_id = '{$owner_id}' and business_id='{$business_id}' and ts != '{$yearfornow}'");
if ($nghigh <= 0) {
$ramt2 = round($ramt2, 2);
$buspen = round($buspen, 2);
$busint = round($busint, 2);
$nbacktax = round($nbacktax, 2);
$divtax = round($divtax, 2);
$totalexptax = round($totalexptax, 2);
//if ($) {
// $nbacktax = 0;
//}示例11: alert
'">
<?php
} else {
?>
<body onload='javascript: alert("Cannot Process.
No Payment Is Made");'></body>
<?php
$nopayment = '1';
require_once "includes/payform.php";
}
} else {
$tfee = SelectMultiTable($dbtype, $dbLink, "ebpls_fees_paid", "sum(fee_amount)* multi_by", "where owner_id = {$owner_id} and\n permit_type='{$permit_type}'");
$totalfee = FetchRow($dbtype, $tfee);
$totpay = $totalfee[0];
$totchnge = SelectMultiTable($dbtype, $dbLink, "temppayment", "sum(payamt)", "where owner_id = {$owner_id} \n\t\t\t\t and permit_type='{$permit_type}' and status=1\n and permit_status='{$stat}'");
$amtchange = FetchRow($dbtype, $totchnge);
$ort = SelectDataWhere($dbtype, $dbLink, "temppayment", "where owner_id = {$owner_id} and permit_type='{$permit_type}' \n\t\t\t\t and status=1 and permit_status='{$stat}'");
$ort = FetchArray($dbtype, $ort);
$totpaid = $amtchange[0];
$amtchange = $totpay - $amtchange[0];
$orno = $ort[or_no];
//please populate ACCOUNT CODES
$getmax = SelectDataWhere($dbtype, $dbLink, "ebpls_transaction_payment_or", "");
$or = NumRows($dbtype, $getmax);
$or = $or + 1;
$trans_id = $owner_id;
$payment_code = $orno;
$payment_id = 0;
$tax_fee_code = 'taxcode';
$account_code = 'acntcode';
$account_desc = 'acnt desc';示例12: NumRows
// culture_fee where culture_type like '$culture_type%'
// order by $watfld $orderbyasde") or die ("new".mysql_error());
require 'setup/setting.php';
$max_resultsr = $thIntPageLimit;
$pagemulti = $page;
if ($pagemulti == '') {
$pagemulti = 1;
}
$reccnt = NumRows($dbtype, $resultr);
if ($reccnt == 0) {
?>
<body onload='alert("No Record Found");'></body>
<?php
}
$norow = $pagemulti * $max_resultsr - $max_resultsr;
while ($getit = FetchRow($dbtype, $resultr)) {
$getengine = @mysql_query("select * from ebpls_fish_description where fish_id = '{$getit['0']}'");
$getengine1 = @mysql_fetch_assoc($getengine);
$norow++;
include 'tablecolor-inc.php';
print "<tr bgcolor='{$varcolor}'>\n";
if ($getit[5] == 1) {
$ft = "Constant";
} elseif ($getit[5] == 2) {
$ft = "Formula";
} else {
$ft = "Range";
}
print "<td> {$norow}</td>\n";
print "<td>{$getengine1['fish_desc']}</td><td>{$getit['1']}</td><td>{$getit['2']}</td><td>{$ft}</td>\n\t<td><a href='index.php?part=4&class_type=Preference&selMode=ebpls_nfishcfees&action_=8&permit_type=Fishery&com=Edit&boat_type={$getit['4']}&trans={$getit['2']}&updateit=1' class='subnavwhite'>\n\tEdit</a>";
?>示例13: Open
$permit_type = 'Business';
include "includes/variables.php";
include "lib/multidbconnection.php";
$dbLink = Open($dbtype, $connecttype, $dbhost, $dbuser, $dbpass, $dbname);
$permittable = 'ebpls_business_enterprise_permit';
//--- get connection from DB
//$dbLink = get_db_connection();
global $ThUserData;
$getbus = SelectDataWhere($dbtype, $dbLink, "tempbusnature", "where tempid={$tempid}");
$getbu = FetchRow($dbtype, $getbus);
$owner_id = $getbu[5];
$business_id = $getbu[6];
$bus_code = $getbu[1];
$bus_nature = $getbu[2];
$getp = SelectDataWhere($dbtype, $dbLink, $permittable, "where owner_id ={$owner_id} \n\t\t\tand business_id ={$business_id} and active = 1");
$getp = FetchRow($dbtype, $getp);
$pin = $getp[14];
if ($pin == '') {
$pin = $genpin;
}
?>
<form action="upline.php" method=post>
<script language='Javascript' src='javascripts/default.js'></script>
<script language="Javascript">
function CheckIt(x)
{
var msgTitle = "Payment\n";
if(isNaN(x.value))
{
alert( msgTitle + "Please input a valid amount!");示例14: SelectMultiTable
if ($getd[5] == 3) {
$xv = 0;
} else {
$xv = $getn[3];
}
}
$getrange = SelectMultiTable($dbtype, $dbLink, "ebpls_buss_taxrange", "rangeamount, rangelow", "where taxfeeid={$getd['2']} and rangelow = {$xv}\r\n\t\t\t\tand rangestatus='A'");
$haveex = NumRows($dbtype, $getrange);
if ($haveex != 1) {
$getrange = SelectMultiTable($dbtype, $dbLink, "ebpls_buss_taxrange", "rangeamount", "where taxfeeid={$getd['2']} and rangelow <= {$xv} and\r\n rangehigh >= {$xv} and rangestatus='A'");
$lookrange = NumRows($dbtype, $getrange);
if ($lookrange == 0 || $lookrange == '') {
$getrange = SelectMultiTable($dbtype, $dbLink, "ebpls_buss_taxrange", "rangeamount", "where taxfeeid={$getd['2']} and rangestatus='A' \r\n\t\t\t\t\t\t order by rangeid desc limit 1");
}
}
$range = FetchRow($dbtype, $getrange);
if (is_numeric($range[0])) {
$totind = $range[0];
$rtag = 'range';
$compvalrange = $totind;
} else {
$getd[1] = $range[0];
eval("\$totind={$d}({$xv}{$range['0']};");
$compvalrange = $totind;
}
} else {
$indi = 0;
$xv = 1;
$totind = $getd[1];
$rtag = '';
}示例15: SelectMultiTable
,0,0,'<?php
echo $getcheck[13];
?>
')"><font color=blue>View Payment Details</font></a>
<?php
}
?>
</td>
<tr>
<?php
$totscheck = $totscheck + $getcheck[3];
$s++;
}
}
$getclear = SelectMultiTable($dbtype, $dbLink, "ebpls_transaction_payment_check a, \n\t\t\tebpls_transaction_payment_or b,\n ebpls_transaction_payment_or_details c", "sum(a.check_amount)", "where a.or_no=b.or_no and a.or_no=c.or_no and b.or_no=c.or_no and\n c.or_entry_type='CHECK' and a.check_status='CLEARED' and\n\t\t\tc.transaction='{$istat}' and\n c.trans_id={$owner_id} and c.payment_id={$business_id}");
$totcheck = FetchRow($dbtype, $getclear);
print "<tr><br></tr>";
$totchecknf = number_format($totscheck, 2);
print "<tr><td></td><td></td><td align=right>Total Check Payment:</td><td align=right>{$totchecknf}</td></tr>";
$totpay = $totcash + $totscheck;
?>
</table>
<table border =0 align=left class=sub>
<tr><td></td><td>Total Payments Made:</td><td><font color=red><b>Php <?php
echo number_format($totpay, 2);
?>
<b></font></td><td></td>
</table>
<?php
if ($bpar == 1 || $ulev == 6 || $ulev == 7 and $totpay > 0) {