PHP db_test::query方法代码示例

function changecoupon($listid, $no, $type, $money, $couponno, $authorid, $paycardid = null, $memo)
{
    $db = new db_test();
    switch ($type) {
        case "sale":
            $query = "insert into tb_couponglide  (\n\t\t          fd_couponglide_no , fd_couponglide_type , fd_couponglide_addmoney ,\n\t\t          fd_couponglide_lessmoney  , fd_couponglide_datetime , fd_couponglide_memo ,\n\t\t          fd_couponglide_man , fd_couponglide_couponno , fd_couponglide_authorid ,\n\t\t          fd_couponglide_paycardid ,fd_couponglide_listid\n\t\t          )values(\n\t\t          '{$no}' , '{$type}' , '0' , \n\t\t          '{$money}' , now() , '{$memo}' , \n\t\t          '{$loginstaname}' , '{$couponno}' , '{$authorid}' ,\n\t\t          '{$paycardid}' , '{$listid}'\n\t\t          )\n\t\t    ";
            $db->query($query);
            break;
        case "rebuy":
            $query = "insert into tb_couponglide  (\n\t\t          fd_couponglide_no , fd_couponglide_type , fd_couponglide_addmoney ,\n\t\t          fd_couponglide_lessmoney  , fd_couponglide_datetime , fd_couponglide_memo ,\n\t\t          fd_couponglide_man , fd_couponglide_couponno , fd_couponglide_authorid ,\n\t\t          fd_couponglide_paycardid ,fd_couponglide_listid\n\t\t          )values(\n\t\t          '{$no}' , '{$type}' , '{$money}' , \n\t\t          '0' , now() , '{$memo}' , \n\t\t          '{$loginstaname}' , '{$couponno}' , '{$authorid}' ,\n\t\t          '{$paycardid}' , '{$listid}'\n\t\t          )\n\t\t    ";
            $db->query($query);
            break;
        case "use":
            $query = "insert into tb_couponglide  (\n\t\t          fd_couponglide_no , fd_couponglide_type , fd_couponglide_addmoney ,\n\t\t          fd_couponglide_lessmoney  , fd_couponglide_datetime , fd_couponglide_memo ,\n\t\t          fd_couponglide_man , fd_couponglide_couponno , fd_couponglide_authorid ,\n\t\t          fd_couponglide_paycardid ,fd_couponglide_listid\n\t\t          )values(\n\t\t          '{$no}' , '{$type}' , '0' , \n\t\t          '0' , now() , '{$memo}' , \n\t\t          '{$loginstaname}' , '{$couponno}' , '{$authorid}' ,\n\t\t          '{$paycardid}' , '{$listid}'\n\t\t          )\n\t\t    ";
            $db->query($query);
            break;
    }
}

 function saveFileid($dateid, $catid)
 {
     $dbfile = new db_test();
     if ($catid) {
         $query = "update tb_upload_category_list set fd_cat_dateid='{$dateid}'\n\t\t\twhere fd_cat_dateid='0' and fd_cat_id in({$catid})";
         $dbfile->query($query);
         //echo $query;
     }
     //return $query;
 }

<?php

header('Content-Type: application/x-www-form-urlencoded');
header('Content-Type: text/html;charset=gb2312');
require "../include/common.inc.php";
require_once '../include/json.php';
require "../function/changekg.php";
$db = new db_test();
$query = "select * from web_orderdetail \n        left join  web_order on fd_order_id                = fd_orderdetail_orderid\n        where fd_orderdetail_id='{$id}'";
$db->query($query);
if ($db->nf()) {
    $db->next_record();
    $state = $db->f(fd_order_state);
}
if ($state > 1) {
    echo "0@@" . $query;
    exit;
}
$query = "update web_orderdetail set fd_orderdetail_quantity = '{$value}'  where fd_orderdetail_id = '{$id}'";
$db->query($query);
echo "1@@" . $value . $query;

function getnewssaler($value)
{
    $db = new db_test();
    $query = "select fd_saler_truename from web_saler where fd_saler_id='{$value}'";
    $db->query($query);
    if ($db->nf()) {
        $db->next_record();
        $salername = $db->f(fd_saler_truename);
        return $salername;
    }
}

require "../include/common.inc.php";
$db = new db_test();
$db1 = new db_test();
header('Content-Type:text/html;charset=GB2312');
$flagcomm = 0;
$query = "select * from tb_salelistdetail where fd_stdetail_seltid = '{$listid}'";
$db->query($query);
if ($db->nf()) {
    while ($db->next_record()) {
        $paycardid = $db->f(fd_stdetail_paycardid);
        $productid = $db->f(fd_stdetail_productid);
        $saleprice = $db->f(fd_stdetail_price);
        $salequantity = $db->f(fd_stdetail_quantity);
        $query = "select * from tb_paycardstockquantity \n\t\t          where fd_skqy_commid = '{$productid}'";
        $db1->query($query);
        //查询仓库数量
        if ($db1->nf()) {
            $db1->next_record();
            $storagequantity = $db1->f(fd_skqy_quantity) + 0;
            if ($storagequantity < $salequantity) {
                //$tmpquantity = $salequantity - $storagequantity;
                $returnquantitypaycardid = $returnquantitypaycardid . "“" . $productid . "”当库存数量为：" . $storagequantity . "\n";
                $flagcomm = 1;
            }
        }
        $query = "select * from tb_storagecost \n\t\t          where fd_sect_commid = '{$productid}'";
        $db1->query($query);
        //查询平均价格
        if ($db1->nf()) {
            $db1->next_record();

$thismenucode = "6n006";
require "../include/common.inc.php";
$db = new db_test();
$db2 = new db_test();
$db3 = new db_test();
if (!empty($password)) {
    $password = md5($password);
}
switch ($action) {
    case "save":
        if (!empty($id)) {
            $query = "select * from tb_saler where fd_saler_id  = '{$id}'";
            $db->query($query);
            if ($db->nf()) {
                $query = "select * from tb_saler where fd_saler_username  = '{$username}' and fd_saler_id <> '{$id}'";
                $db2->query($query);
                if ($db2->nf() > 0) {
                    $error = "你输入用户名已被注册，请查证！";
                } else {
                    $query = "select * from tb_saler where fd_saler_phone   = '{$phone}' and fd_saler_id <> '{$id}'";
                    $db2->query($query);
                    if ($db2->nf() > 0) {
                        $error = "你输入手机已被注册，请查证！";
                    } else {
                        $query = "select * from tb_saler where fd_saler_idcard   = '{$idcard}' and fd_saler_id <> '{$id}'";
                        $db2->query($query);
                        if ($db2->nf() > 0) {
                            $error = "你输入身份证已被注册，请查证！";
                        } else {
                            $query = "update tb_saler set fd_saler_idcard ='{$idcard}',\n\t          fd_saler_truename ='{$truename}'                , fd_saler_phone ='{$phone}'                 , \n\t\t\tfd_saler_sharesalerid = '{$sharesalerid}'  ,\n\t\t\tfd_saler_username     = '{$username}'      ,\n\t\t\t  fd_saler_salertype     ='{$type}'               , fd_saler_state       = '1'          ,       \n\t\t\t  where fd_saler_id = '{$id}'";
                            $db->query($query);

function getallpaymoney()
{
    $db = new db_test();
    $query = "select sum(fd_agpm_paymoney) as paymoney\n\t\tfrom tb_agentpaymoneylist \n\t\twhere fd_agpm_payrq='00'";
    $db->query($query);
    if ($db->nf()) {
        while ($db->next_record()) {
            $allpaymoney = $db->f(paymoney);
        }
    }
    return $allpaymoney;
}

<?php

require "../include/common.inc.php";
$db = new db_test();
$boolean = 0;
$query = "select\n                 case\n                 when fd_agpm_payfeedirct ='s' then ' 收款方'\n                 when fd_agpm_payfeedirct ='f' then '付款方'\n                 END  payfeedirct,\n\n                 case\n                 when fd_agpm_paytype ='coupon' then '购买抵用券'\n                 when fd_agpm_paytype ='creditcard' then '信用卡还款'" . "when fd_agpm_paytype ='recharge' then        '充值'" . "when fd_agpm_paytype ='pay' then       '还贷款'" . "when fd_agpm_paytype ='order' then '订单付款'" . "when fd_agpm_paytype ='tfmg' then '转账汇款'\n                 else '其他业务' END  paytype,\n\n                 case\n                 when fd_agpm_payfeedirct ='f' then fd_agpm_paymoney\n                 when fd_agpm_payfeedirct ='s' then (fd_agpm_paymoney-fd_agpm_payfee)\n                 else fd_agpm_paymoney END money,\n\n                 fd_agpm_bkordernumber            as bkordernumber,\n                 fd_pymyltdetail_id               as vid,\n                 fd_agpm_bkntno                   as bkntno,\n                 fd_paycard_key                   as paycardkey,\n                 fd_author_truename               as author,\n                 fd_agpm_paytype                  as paytypee,\n                 fd_agpm_paydate                  as paydate,\n                 fd_agpm_shoucardno               as shoucardno,\n                 fd_agpm_shoucardbank             as shoucardbank,\n                 fd_agpm_shoucardman              as shoucardman,\n                 fd_agpm_shoucardmobile           as shoucardmobile,\n                 fd_agpm_current                  as current,\n                 fd_agpm_paymoney                 as paymoney ,\n                 fd_agpm_payfee                   as payfee,\n                 fd_agpm_arrivemode               as arrivemode,\n                 fd_agpm_arrivedate               as arrivedate,\n                 fd_paycardaccount_accountname    as accountname,\n                 fd_sdcr_agentfee                 as sdcragentfee,\n                 fd_agpm_isagentpay               as isagentpay,\n                 fd_paycardaccount_accountnum     as accountnum\n                 from tb_paymoneylistdetail  \n                 left join tb_agentpaymoneylist on fd_pymyltdetail_agpmid = fd_agpm_id\n                 left join tb_paycard on fd_agpm_paycardid = fd_paycard_id\n                 left join tb_author on fd_author_id = fd_agpm_authorid\n                 left join tb_paycardaccount on fd_paycard_paycardaccount = fd_paycardaccount_id\n                 left join tb_sendcenter on fd_sdcr_id = fd_agpm_sdcrid\n                 where fd_pymyltdetail_paymoneylistid = '{$listid}'\n                 order by fd_agpm_bkntno";
$db->query($query);
$arr_result = $db->getFiledData('');
foreach ($arr_result as $key => $value) {
    switch ($value['paytype']) {
        case 'coupon':
            $table = 'couponsale';
            $where = 'couponsale';
            break;
        case 'creditcard':
            $table = 'creditcardglist';
            $where = 'ccglist';
            break;
        case 'recharge':
            $table = 'rechargeglist';
            $where = 'rechargelist';
            break;
        case 'repay':
            $table = 'repaymoneyglist';
            $where = 'repmglist';
            break;
        case 'tfmg':
            $table = 'transfermoneyglist';
            $where = 'tfmglist';
            break;
        case 'suptfmg':

function checkdeptid($fid)
{
    $db1 = new db_test();
    $query = "select * from tb_dept where fd_dept_id != '{$fid}'";
    $db1->query($query);
    if ($db1->nf()) {
        $db1->next_record();
        $check_id = $db1->f(fd_dept_fid);
        checkdeptid($check_id);
    }
    return $check_id;
}

    case "save":
        for ($i = 0; $i < count($arr_wlroadid); $i++) {
            $wlroadid = $arr_wlroadid[$i];
            $arr_wldpid1 = $arr_wldpid[$wlroadid];
            //echo var_dump($arr_wldpid1);
            for ($j = 0; $j < count($arr_wldpid1); $j++) {
                $wlmoney = $arr_wlmoney[$wlroadid][$j];
                //echo $wlmoney."<>";
                $wldunpriceid = $arr_wldpid1[$j];
                $query = "select * from web_authorpayset where fd_authorpayset_wldpid = '{$wldunpriceid}' and fd_authorpayset_wlroadid = '{$wlroadid}'\n\t\t\t          and fd_authorpayset_organmemid = '{$organmemid}'";
                $db->query($query);
                if ($db->nf()) {
                    $db->next_record();
                    $vlid = $db->f(fd_authorpayset_id);
                    $query1 = "update web_authorpayset set fd_authorpayset_money = '{$wlmoney}' where\n\t\t\t\t fd_authorpayset_id ='{$vlid}'";
                    $db2->query($query1);
                } else {
                    $query = "insert into web_authorpayset(fd_authorpayset_wldpid,\n\t\t\t        fd_authorpayset_wlroadid,fd_authorpayset_money,fd_authorpayset_organmemid) values('{$wldunpriceid}','{$wlroadid}','{$wlmoney}','{$organmemid}')";
                    $db->query($query);
                }
            }
        }
        $action = "";
        echo "<script>alert('修改成功');location.href='authorpayset.php'</script>";
        //require("../include/alledit.2.php");
        //Header("Location: $gotourl");
        break;
    default:
        $action = "";
        break;
}

function getauthormeal($type)
{
    $db = new db_test();
    $query = 'select fd_author_' . $type . ',count(fd_author_' . $type . ') as authornum from tb_author group by  fd_author_' . $type . '';
    $db->query($query);
    if ($db->nf()) {
        while ($db->next_record()) {
            $id = $db->f('fd_author_' . $type . '');
            $returnvalue[$id] = $db->f(authornum);
        }
    }
    return $returnvalue;
}

function getusemoney($authorid)
{
    $db = new db_test();
    $data = date("Y-m-d", time());
    $query = "select * from tb_slotcardmoneyreq\n\t\t\tleft join tb_slotcardmoneyset on fd_scdmset_id = fd_pmreq_paymsetid \n\t\t\twhere fd_pmreq_authorid='{$authorid}' and fd_pmreq_state='9' and fd_pmreq_reqdatetime like '{$data}%'";
    $db->query($query);
    if ($db->nf()) {
        //�жϲ�ѯ���ļ�¼�Ƿ�Ϊ��
        while ($db->next_record()) {
            //��ȡ��¼���
            $allreqmoney += $db->f(fd_pmreq_reqmoney);
        }
        return $allreqmoney;
    } else {
        return "0.00";
    }
}

header('Content-Type: application/x-www-form-urlencoded');
header('Content-Type: text/html;charset=gbk');
require "../include/common.inc.php";
require "../include/json.php";
$dbshop = new db_shop();
$db = new db_test();
$shopnavname = u2g(unescape($shopnavname));
switch ($act) {
    case "trad":
        $query = "select * from tb_shop where fd_shop_navname='{$shopnavname}' and  fd_shop_id<> '{$shopid}'";
        $dbshop->query($query);
        if ($dbshop->nf()) {
            echo "仓库名已存在！" . "@@" . "n";
        } else {
            $query1 = "select * from tb_sendcenter where fd_sdcr_name='{$shopnavname}'";
            $db->query($query1);
            if ($db->nf()) {
                echo "仓库名已存在！" . "@@" . "n";
            } else {
                echo "正常" . "@@" . "y";
            }
        }
        break;
    case "sp":
        $query = "select * from tb_shop where fd_shop_navname='{$shopnavname}' and  fd_shop_id<> '{$shopid}'";
        $dbshop->query($query);
        if ($dbshop->nf()) {
            echo "仓库名已存在！" . "@@" . "n";
        } else {
            $query1 = "select * from tb_sendcenter where fd_sdcr_name='{$shopnavname}'";
            $db->query($query1);