本文整理汇总了PHP中FC_SQL::next_record方法的典型用法代码示例。如果您正苦于以下问题:PHP FC_SQL::next_record方法的具体用法?PHP FC_SQL::next_record怎么用?PHP FC_SQL::next_record使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类FC_SQL
的用法示例。
在下文中一共展示了FC_SQL::next_record方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: get_dyn_content
function get_dyn_content($id)
{
$SQL = new FC_SQL();
$qs = "SELECT content FROM anima09_page p\n\t\t\t\tLEFT JOIN anima09_page_content c \n\t\t\t\t\tON p.anima09_page_id = c.anima09_page_id\n\t \t\t\tWHERE p.anima09_page_id = {$id}";
$SQL->query($qs);
$SQL->next_record();
return $SQL->f(0);
}
示例2:
echo $fcs->f('subzdescr');
?>
" /><br />
</td></tr>
<tr><td align="left" colspan="2" bgcolor="#FFFFFF" bgcolor="#FFFFFF">
Select parent subzone:
<select name="subzparent">
<option value="">[Top Level Subzone]</option>
<?php
$currsubzparent = (int) $fcs->f('subzparent');
// get the list of subzones
$get_subz = new FC_SQL();
$get_subz->query("select subzsid,subzdescr from subzone " . "where subzid={$zoneid} order by subzdescr");
while ($get_subz->next_record()) {
$pszid = (int) $get_subz->f('subzsid');
if ($pszid == $currsubzparent) {
$chk = ' selected';
} else {
$chk = '';
}
if ($pszid != $subzsid) {
// don't show our own to prevent self-reference
$pszidd = $get_subz->f('subzdescr');
print "<option value=\"{$pszid}\"{$chk}>{$pszidd}</option>\n";
}
}
$get_subz->free_result();
?>
</select><br />
示例3: show_countries
function show_countries($zid, $lid, $matchiso, $lang_iso)
{
$ret = NULL;
$fct = new FC_SQL();
$fct->query("select ctrylangciso,ctrylangname from country,countrylang " . "where ctryzid={$zid} and ctrylid={$lid} and ctryactive=1 and " . "ctryiso=ctrylangciso and ctrylangliso='{$lang_iso}' order by ctryseq,ctrylangname");
while ($fct->next_record()) {
$iso = $fct->f('ctrylangciso');
$name = $fct->f('ctrylangname');
if ($matchiso == $iso) {
$chk = ' selected';
} else {
$chk = '';
}
$ret .= "<option value=\"{$iso}\"{$chk}>{$name}</option>\n";
}
$fct->free_result();
return $ret;
}
示例4:
$cybercash->address2 = "{$billing_address2}";
$cybercash->cccity = "{$billing_city}";
$cybercash->ccstate = "{$billing_state}";
$cybercash->cczip = "{$billing_zip}";
$cybercash->cccountry = "USA";
// submit the charge to CyberCash and parse out the return data
if (!$cybercash->send()) {
$cybercash->errorHandler("Error: no data received back from CyberCash");
}
$POP = $cybercash->POP;
parse_str(ereg_replace("pop.", "", $POP));
if ($status != 'success') {
// get the Web table
$fcw = new FC_SQL();
$fcw->query("select webback,webtext,weblink,webvlink,webalink,webbg,webfree,websort " . "from fishcart where webzid={$zid} and weblid={$lid}");
$fcw->next_record();
$srt = $fcw->f("websort");
$fcw->free_result();
// END OF ESSENTIAL CART DISPLAY CODE FROM LINE 1 TO HERE
?>
<html>
<head>
<link rel="stylesheet" ID href="style.css" type="text/css" />
<title>
</title>
</head>
<body<?php
if ($fcw->f("webback")) {
?>
示例5: mktime
exit;
}
if ($act == "insert" || $act == "update") {
if ($nsm != "" && $nsd != "" && $nsy != "" && $nem != "" && $ned != "" && $ney != "") {
$sdate = mktime(0, 0, 0, $nsm, $nsd, $nsy);
$ndate = mktime(0, 0, 0, $nem, $ned, $ney);
} else {
$sdate = 0;
$ndate = 0;
}
}
$fco = new FC_SQL();
$fcu = new FC_SQL();
if ($act == "insert") {
$fcu->query("select count(*) as cnt from oprod where oprodsku='{$sku}'");
$fcu->next_record();
if ($fcu->f('cnt') == 0) {
$fco->query("insert into oprod (oprodsku,ostart,oend,ozid) " . "values ('{$sku}',{$sdate},{$ndate},{$zoneid})");
}
$fcu->free_result();
} elseif ($act == "update") {
$fco->query("update oprod " . "set oprodsku='{$sku}',ostart={$sdate},oend={$ndate} where oprodsku='{$sku}'");
} elseif ($act == "delete") {
$fco->query("delete from oprod where oprodsku='{$sku}'");
}
$fco->commit();
?>
<p>
The <?php
示例6: time
$csym = '';
$zflag1 = 0;
}
$now = time();
// see if this order exists
$fco = new FC_SQL();
$fco->query("select subz,contrib from ohead where orderid='{$cartid}'");
if (!$fco->next_record()) {
header("Location: {$nsecurl}/?cartid={$cartid}&zid={$zid}&lid={$lid}");
}
// if subz=0, no products in the cart
$subz = (int) $fco->f("subz");
// get the language templates
$fcl = new FC_SQL();
$fcl->query("select langgeo,langshow,langordr,langcopy,langterms from lang where langid={$lid}");
$fcl->next_record('langterms');
$geo = $fcl->f("langgeo");
$show = $fcl->f("langshow");
$ordr = $fcl->f("langordr");
$copy = $fcl->f("langcopy");
$lterms = $fcl->f("langterms");
$fcl->free_result();
if (!empty($doit)) {
if ($zflag1 & $flag_zonetcpage) {
// set for inline terms and conditions
$ordr = 'terms.php';
}
$contrib = str_replace("\$", "", $contrib);
$contrib = str_replace(",", "", $contrib);
$c = (double) $contrib;
if ($c < 0) {
示例7: while
<td class="showcartcell" colspan="2" align="left" valign="top" bgcolor="#FFFFFF">
<b><?php
echo fc_text('shipfee');
?>
</b><br />
<?php
if ($allowupdate) {
if ($scnt > 1) {
?>
<select name="shipid" size="1" onChange="submit(); return false;">
<?php
$fcmt = new FC_SQL();
$fcmt->query("select ship.shipid,shipdef,shipdescr " . "from ship,subzship " . "where shipzid={$zid} " . "and shipszid={$subz} " . "and ship.shiplid={$lid} " . "and subzship.shiplid={$lid} " . "and subzship.shipid=ship.shipid " . "and subzship.shiplid=ship.shiplid " . "order by ship.shipid");
while ($fcmt->next_record()) {
if ($curshipid == (int) $fcmt->f("shipid")) {
?>
<option value="<?php
echo $fcmt->f("shipid");
?>
" selected><?php
echo stripslashes($fcmt->f("shipdescr"));
?>
</option>
<?php
} else {
?>
<option value="<?php
echo $fcmt->f("shipid");
?>
示例8: substr
$fcs->next_record();
$st = (int) $fcs->f('cnt') + 1;
$fcs->free_result();
?>
<select name="subzone" size="<?php
echo $st;
?>
" onfocus="currfield='subzsid';"
onChange="submit();">
<option value="" selected="selected">[no change]</option>
<?php
$fcs->query("select subzsid,subzdescr,subzvendid from subzone " . "where subzid={$zoneid} order by subzsid");
while ($fcs->next_record()) {
$vendor = $fcs->f('subzvendid');
$fcz->query("select vendid,vendname from vend where vendid={$vendor}");
$fcz->next_record();
echo '<option value="' . $fcz->f('vendid') . ":" . $fcs->f('subzsid') . '">';
echo $fcz->f('vendname') . " : " . substr($fcs->f('subzdescr'), 0, 30) . '</option>';
$fcz->free_result();
}
$fcs->free_result();
?>
</select>
<p></p>
<input type="hidden" name="zoneid" value="<?php
echo $zoneid;
?>
" />
<input type="hidden" name="langid" value="<?php
示例9: getparam
$zoneid = (int) getparam('zoneid');
$langid = (int) getparam('langid');
// ========== end of variable loading ==========
require './admin.php';
require './header.php';
if (!$zoneid || !$langid) {
?>
A zone or language ID was not selected.
<p>Please click the <a href='self.history.back()'>Back</a> button on your browser
and select a zone. Thank you.
<?php
exit;
}
$fcp = new FC_SQL();
$fcp->query("select zonedescr from zone where zoneid='{$zoneid}' and zonedeflid='{$langid}'");
if ($fcp->next_record()) {
$zone_name = $fcp->f("zonedescr") . "<br>";
$fcp->free_result();
}
?>
<table align=center cellspacing=0 cellpadding=4 bgcolor=#666666 width=650 class="text">
<tr valign="middle" align="center">
<td bgcolor=#ffffff>
<h2>FishCart Reporting Module</h2>
</td>
</tr>
</table>
<hr>
<table align=center class="text">
<tr>
示例10: elseif
<?php
exit;
}
$max_seq = new FC_SQL();
if ($databaseeng == 'odbc' && $dialect == 'solid') {
$max_seq->query("select seq from auxtext where rownum < 2 order by seq desc");
} elseif ($databaseeng == 'postgres') {
$max_seq->query("select seq from auxtext order by seq desc limit 1,0");
} elseif ($databaseeng == 'mssql') {
$max_seq->query("select top 1 seq from auxtext order by seq desc");
} elseif ($databaseeng == 'oracle') {
$max_seq->query("select seq from auxtext where rownum < 2 order by seq desc");
} elseif ($databaseeng == 'mysql') {
$max_seq->query("select seq from auxtext order by seq desc limit 0,1");
}
$max_seq->next_record();
$seq = $max_seq->f("seq") + 1;
$max_seq->free_result();
$res = $fcc->query("insert into auxtext (" . "seq,loc,title,text) values ({$seq},{$loc},'{$title}','{$text}')");
} elseif ($act == "mod") {
$res = $fcc->query("update auxtext " . "set loc={$loc},title='{$title}', text='{$text}' where rid='{$rid}'");
} elseif ($act == "del") {
$res = $fcc->query("delete from auxtext " . "where rid={$rid}");
} elseif ($act == "seq") {
$i = 0;
while ($i < $scount) {
$seq = (int) getparam('lseq' . $i);
$rid = (int) getparam('link' . $i);
$res = $fcc->query("update auxtext set seq={$seq} where rid='{$rid}'");
$i++;
}
示例11:
onClick="closehelp();">
Return To Central Maintenance Page</a><br>
</td></tr>
<tr><td align=center colspan=2 bgcolor="#FFFFFF">
<b>
Modify A Vendor Profile<br>
</b>
</td></tr>
<tr><td colspan=2 bgcolor="#FFFFFF">
<?php
$fcv->query("select * from vend where vendzid={$vendid}");
$fcv->next_record();
?>
<form method="post" action="vendorupd.php">
<input type=hidden name=act value=update>
<input type=hidden name=vendid value="<?php
echo $vendid;
?>
">
<input type=hidden name=zoneid value="<?php
echo $zoneid;
?>
">
<input type=hidden name=langid value="<?php
示例12: count
<b>Delete An Existing Coupon Profile</b>
</td></tr>
<tr><td align="center" bgcolor="#FFFFFF">
<form name="couponmod" method="post" action="couponmod.php">
To modify an existing coupon profile,<br />
select its name from the list and<br />
click <i>Modify Selected Profile</i>.
<br />
<?php
$coupon = new FC_SQL();
$coupon->query("select count(*) as cnt from coupon");
$coupon->next_record();
$len = (int) $coupon->f("cnt");
$coupon->free_result();
?>
<select name="cpnid" size="<?php
echo $len + 1;
?>
"
onChange="document.couponmod.action='couponmod.php';submit();">
<option name=cpnid value="" selected>[no change]</option>
<?php
// query the coupon
$coupon->query("select cpnid,cpnredeem from coupon order by cpnid");
while ($coupon->next_record()) {
?>
示例13: fc_display_product
function fc_display_product($fc_sku = '', $zid = 1, $lid = 1, $cat = 0)
{
// display one product with options
// doesn't return anything
global $fc_cartid, $flag_persvc, $flag_webshowqty;
global $fc_csym, $fc_webfree, $fc_webflags1;
global $flag_poptskusub, $flag_poptskumod, $flag_poptskusuf, $flag_poptskupre;
global $flag_poptgrpexc, $flag_poptprcrel, $flag_poptgrpqty, $flag_poptgrpreq;
$now = time();
$fco = new FC_SQL();
$fcp = new FC_SQL();
$fcrp = new FC_SQL();
$fcrpl = new FC_SQL();
$fcp->query('select prodsdescr,proddescr,prodaudio,prodvideo,prodsetup,prodprice,' . 'prodsalebeg,prodsaleend,prodpic,prodpicw,prodpich,prodpersvc,prodflag1 ' . 'from prod,prodlang ' . "where prodsku='{$fc_sku}' and prodlsku='{$fc_sku}' and prodsku=prodlsku");
$fcp->next_record();
$flag1 = (int) $fcp->f('prodflag1');
?>
<tr><td align=left valign=top colspan=1>
<table width="100%" cellpadding=0 cellspacing=0 border=0>
<tr><td align=left valign=top colspan=3>
<br>
<?php
if ($fcp->f("prodpic")) {
// show the product picture (if defined)
?>
<img src="<?php
echo $fcp->f("prodpic");
?>
"
width="<?php
echo $fcp->f("prodpicw");
?>
"
height="<?php
echo $fcp->f("prodpich");
?>
"
alt="" align=left>
<?php
}
// end of the product picture
?>
<b><?php
echo stripslashes($fcp->f("prodsdescr"));
?>
:</b>
<?php
echo stripslashes($fcp->f("proddescr"));
?>
<br>
</td></tr>
<tr><td align=left valign=bottom colspan="1">
<?php
if ($fcp->f("prodaudio")) {
?>
<a href="<?php
echo $fcp->f("prodaudio");
?>
"><i><?php
echo fc_text("audiosample");
?>
</i></a><br>
<?php
}
?>
</td><td align=center valign=bottom colspan="1">
<?php
if ($fcp->f("prodvideo")) {
?>
<a href="<?php
echo $fcp->f("prodvideo");
?>
"><i><?php
echo fc_text("videosample");
?>
</i></a><br>
<?php
}
?>
</td><td colspan=1 align=right valign=middle>
</td></tr>
<tr><td align=left valign=middle colspan=3>
<form method=post action="//fishcart/showcart.php?cartid=<?php
echo $fc_cartid;
?>
&zid=<?php
echo $zid;
?>
//.........这里部分代码省略.........
示例14: count
<?php
if ($showall) {
if ($databaseeng == 'odbc' && $dialect == 'solid') {
$fccc->query("select count(*) as cnt from _ccnum");
} else {
$fccc->query("select count(*) as cnt from {$instid}_ccnums");
}
} else {
if ($databaseeng == 'odbc' && $dialect == 'solid') {
$fccc->query("select count(*) as cnt from _ccnum where fetched='0'");
} else {
$fccc->query("select count(*) as cnt from {$instid}_ccnums " . "where fetched='0'");
}
}
$fccc->next_record();
$cnt = $fccc->f("cnt");
$fccc->free_result();
if ($databaseeng == 'odbc' && $dialect == 'solid') {
$fccc->query("select count(*) as cnt from _ccnum");
} else {
$fccc->query("select count(*) as cnt from {$instid}_ccnums");
}
$fccc->next_record();
$tot = $fccc->f("cnt");
$fccc->free_result();
?>
<?php
if ($cnt) {
?>
示例15: substr
<form name=catform method="post" action="categoryseqmod.php">
Enter the category sequence numbers in the
order you want, then click "Update".
The numbers themselves are not important, only
their relative order. Categories are sorted by
their current order in the structured subcategory
hierarchy; within each level, sequence numbers are
relative among themselves. The displayed numbers
before the description are the parent category ID
and the category ID.
</td></tr>
<?php
$fcc->query("select catval,catdescr,catunder from cat " . "where catzid={$zoneid} and catlid={$langid} order by catunder,catseq");
while ($fcc->next_record()) {
$cid = $fcc->f('catval');
$seq = $fcc->f('catseq');
$cdescr = $fcc->f('catdescr');
$cunder = $fcc->f('catunder');
?>
<tr><td bgcolor="#FFFFFF"><?php
echo $cunder . ':' . $cid . ' ' . substr($cdescr, 0, 40);
?>
<br></td><td bgcolor="#FFFFFF">
<input name="catseq<?php
echo $i;
?>
" size="5" value="<?php
echo $j;
?>