PHP FC_SQL::f方法代码示例

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);
}

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;
    ?>
//.........这里部分代码省略.........

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;
}

$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")) {
        ?>
 background="<?php 

}
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 
echo $act;

    $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) {
        $c = (double) 0;

<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");
                        ?>
"><?php 

$cartid = getparam('cartid');
$zid = (int) getparam('zid');
$lid = (int) getparam('lid');
$subz = (int) getparam('subz');
$ccexp_years = (int) getparam('ccexp_years');
$mode = getparam('mode');
// ==========  end of variable loading  ==========
require_once BITCART_PKG_PATH . 'public.php';
require_once BITCART_PKG_PATH . 'cartid.php';
require_once BITCART_PKG_PATH . 'languages.php';
require_once BITCART_PKG_PATH . 'flags.php';
$fcl = new FC_SQL();
$fcz = new FC_SQL();
$fcz->query("select zonecurrsym,zflag1 from zone where zoneid={$zid}");
if ($fcz->next_record()) {
    $csym = stripslashes($fcz->f("zonecurrsym"));
    $csym = trim($csym);
    $zflag1 = (int) $fcz->f('zflag1');
} else {
    $csym = '';
    $zflag1 = 0;
}
// get the language templates
$fcl->query("select langterms,langcopy,langordr from lang where langid={$lid}");
$fcl->next_record('langterms');
if (!empty($showscat)) {
    $tmpl = stripslashes($fcl->f('langstmpl'));
} else {
    $tmpl = stripslashes($fcl->f('langtmpl'));
}
$lterms = $fcl->f('langterms');

$fcp = new FC_SQL();
// check if product exists
$fcu = new FC_SQL();
// update product
$fcw = new FC_SQL();
// web
//$fcc = new FC_SQL; // :VESTIGIAL?: mag 030704 I don't see this used anywhere.
$fcz = new FC_SQL();
// zone
$now = time();
$droot = 'BITCART_PKG_PATH';
// figure out from the addzone* fields which zones must be processed
// accumulate a numeric indexed array $zins
$fcz->query("select zoneid from zone order by zoneid");
while ($fcz->next_record()) {
    $zid = (int) $fcz->f('zoneid');
    $tzid = (int) getparam('addzone' . $zid);
    //$tzid : this zone id, get the value of this zone flag
    if ($tzid) {
        // if this box was checked
        $zins[] = $zid;
        // process this zone (add this zone to array of zones to process)
    }
}
$z = 0;
while ($zins[$z]) {
    // process all selected zones
    $zid = $zins[$z];
    $proderr = 0;
    // the fields are all in the form of name + zoneid
    // we recover the language independent fields below

if ($ossem && $ossed && $ossey) {
    $ossedate = mktime(23, 59, 59, $ossem, $ossed, $ossey);
} else {
    $ossedate = 0;
}
require './admin.php';
require './header.php';
require_once BITCART_PKG_PATH . 'flags.php';
$fcp = new FC_SQL();
$fpo = new FC_SQL();
$fcg = new FC_SQL();
if ($act == 'add' || $act == 'update' && !empty($pgrpname)) {
    // update group name only if not null
    $fcg->query("select count(*) as cnt from prodoptgrp " . "where pgrpzid={$zoneid} and pgrplid={$langid} and pgrpgrp={$poptgrp}");
    $fcg->next_record();
    $cnt = $fcg->f('cnt');
    $fcg->free_result();
    // name/rename the option group with the value given
    if ($cnt) {
        $fcg->query("update prodoptgrp set pgrpname='{$pgrpname}' " . "where pgrpzid={$zoneid} and pgrplid={$langid} and pgrpgrp={$poptgrp}");
    } else {
        $fcg->query("insert into prodoptgrp (pgrpzid,pgrplid,pgrpgrp,pgrpname) " . "values ({$zoneid},{$langid},{$poptgrp},'{$pgrpname}')");
    }
}
if ($act == 'add') {
    if ($poptgrp) {
        // get flag values from group if it exists
        $fpo->query("select poptflag1,poptflag2 from prodopt " . "where poptsku='{$poptsku}' and poptgrp={$poptgrp}");
        if ($fpo->next_record()) {
            $poptflag1 = $fpo->f("poptflag1");
            $poptflag2 = $fpo->f("poptflag2");

if ($esdid == 0) {
    echo fc_text('esdnotrans');
    echo fc_text('esdcustsvc');
    exit;
}
require './pwesd.php';
$now = time();
// increment the download count
$fcesd = new FC_SQL();
$fcesd->query("select esddlcnt,esddlmax,esddlexp,esddlfile from esd " . "where esdid={$esdid} and esdoid='{$pwuid}'");
if (!$fcesd->next_record()) {
    echo fc_text('esdnodl');
    echo fc_text('esdcustsvc');
    exit;
}
$esddlcnt = (int) $fcesd->f('esddlcnt') + 1;
$esddlmax = (int) $fcesd->f('esddlmax');
$esddlexp = (int) $fcesd->f('esddlexp');
$esddlfile = $fcesd->f('esddlfile');
$fcesd->free_result();
if ($esddlcnt > $esddlmax || $now > $esddlexp) {
    echo fc_text('esddlmax');
    echo fc_text('esdcustsvc');
    exit;
}
$fcesd->query("update esd set esddlcnt={$esddlcnt} where esdid={$esdid}");
$fcesd->commit();
$file = substr(strrchr($esddlfile, '/'), 1);
set_magic_quotes_runtime(0);
$fd = fopen($esddlfile, 'rb');
if ($fd) {

$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>
  <td>

        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++;
    }
}

echo $vendid;
?>
">
<input type=hidden name=zoneid value="<?php 
echo $zoneid;
?>
">
<input type=hidden name=langid value="<?php 
echo $langid;
?>
">

Vendor Name: <i>max 80 characters</i><br>
<input name="vendname" size=50 onFocus="currfield='vendor'"
 value="<?php 
echo $fcv->f("vendname");
?>
"><br>

Vendor Address 1: <i>max 80 characters</i><br>
<input name="vendaddr1" size=50 onFocus="currfield='vendor'"
 value="<?php 
echo $fcv->f("vendaddr1");
?>
"><br>

Vendor Address 2: <i>max 80 characters</i><br>
<input name="vendaddr2" size=50 onFocus="currfield='vendor'"
 value="<?php 
echo $fcv->f("vendaddr2");
?>

</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()) {
    ?>
<option value="<?php