本文整理汇总了PHP中db_test::query方法的典型用法代码示例。如果您正苦于以下问题:PHP db_test::query方法的具体用法?PHP db_test::query怎么用?PHP db_test::query使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类db_test
的用法示例。
在下文中一共展示了db_test::query方法的13个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: changecoupon
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;
}
}
示例2: saveFileid
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;
}
示例3:
<?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;
示例4: getnewssaler
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;
}
}
示例5: while
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();
示例6:
$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);
示例7: getallpaymoney
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;
}
示例8: then
<?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':
示例9: checkdeptid
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;
}
示例10: values
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;
}
示例11: getauthormeal
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;
}
示例12: getusemoney
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";
}
}
示例13:
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);