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


PHP FC_SQL::next_record方法代码示例

本文整理汇总了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);
}
开发者ID:vcgato29,项目名称:poff,代码行数:8,代码来源:index.php

示例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 />
开发者ID:bitweaver,项目名称:bitcart,代码行数:31,代码来源:subzonemod.php

示例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;
}
开发者ID:bitweaver,项目名称:bitcart,代码行数:18,代码来源:functions.php

示例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")) {
        ?>
开发者ID:bitweaver,项目名称:bitcart,代码行数:31,代码来源:cyberclear.php

示例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 
开发者ID:bitweaver,项目名称:bitcart,代码行数:31,代码来源:oldprodupd.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) {
开发者ID:bitweaver,项目名称:bitcart,代码行数:31,代码来源:contribute_order.php

示例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");
                        ?>
开发者ID:bitweaver,项目名称:bitcart,代码行数:31,代码来源:proddisp.php

示例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 
开发者ID:bitweaver,项目名称:bitcart,代码行数:31,代码来源:subzonendx.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>
开发者ID:bitweaver,项目名称:bitcart,代码行数:31,代码来源:printquery.php

示例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++;
    }
开发者ID:bitweaver,项目名称:bitcart,代码行数:31,代码来源:auxtextupd.php

示例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 
开发者ID:bitweaver,项目名称:bitcart,代码行数:31,代码来源:vendormod.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()) {
    ?>
开发者ID:bitweaver,项目名称:bitcart,代码行数:31,代码来源:couponndx.php

示例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;
    ?>
//.........这里部分代码省略.........
开发者ID:bitweaver,项目名称:bitcart,代码行数:101,代码来源:fc_functions.php

示例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) {
    ?>
开发者ID:bitweaver,项目名称:bitcart,代码行数:30,代码来源:splitcc.php

示例15: substr

<form name=catform method="post" action="categoryseqmod.php">

Enter the category sequence numbers in the
order you want, then click &quot;Update&quot;.
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;
    ?>
开发者ID:bitweaver,项目名称:bitcart,代码行数:31,代码来源:categoryseq.php


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