PHP mysqld_update函数代码示例

OGeek|极客世界-中国程序员成长平台 › 门户 › 编程› PHP›PHP编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了PHP中mysqld_update函数的典型用法代码示例。如果您正苦于以下问题：PHP mysqld_update函数的具体用法？PHP mysqld_update怎么用？PHP mysqld_update使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。

在下文中一共展示了mysqld_update函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: updateOrderStock

function updateOrderStock($id, $minus = true)
{
    $ordergoods = mysqld_selectall("SELECT * FROM " . table('shop_order_goods') . " WHERE orderid='{$id}'");
    foreach ($ordergoods as $item) {
        $goods = mysqld_select("SELECT * FROM " . table('shop_goods') . "  WHERE id='" . $item['goodsid'] . "'");
        if ($minus) {
            //属性
            if (!empty($item['optionid'])) {
                mysqld_query("update " . table('shop_goods_option') . " set stock=stock-:stock where id=:id", array(":stock" => $item['total'], ":id" => $item['optionid']));
            }
            $data = array();
            if ($goods['totalcnf'] != 1) {
                $data['total'] = $goods['total'] - $item['total'];
            }
            $data['sales'] = $goods['sales'] + $item['total'];
            mysqld_update('shop_goods', $data, array('id' => $item['goodsid']));
        } else {
            //属性
            if (!empty($item['optionid'])) {
                mysqld_query("update " . table('shop_goods_option') . " set stock=stock+:stock where id=:id", array(":stock" => $item['total'], ":id" => $item['optionid']));
            }
            $data = array();
            if ($goods['totalcnf'] != 1) {
                $data['total'] = $goods['total'] + $item['total'];
            }
            $data['sales'] = $goods['sales'] - $item['total'];
            mysqld_update('shop_goods', $data, array('id' => $item['goodsid']));
        }
    }
}

开发者ID:jaydom，项目名称:weishang，代码行数:30，代码来源:lib_core.php

示例2: member_create_qq

 function member_create_qq($qq_openid, $avatar = '', $nickname = '', $gender = 0)
 {
     if (!empty($qq_openid)) {
         $qq_fans = mysqld_select("SELECT * FROM " . table('qq_qqfans') . " WHERE qq_openid=:qq_openid ", array(':qq_openid' => $qq_openid));
         if (empty($qq_fans['qq_openid'])) {
             $row = array('nickname' => $nickname, 'gender' => intval($gender), 'qq_openid' => $qq_openid, 'avatar' => $avatar, 'createtime' => TIMESTAMP);
             mysqld_insert('qq_qqfans', $row);
         } else {
             $row = array('nickname' => $nickname, 'gender' => intval($gender), 'avatar' => $avatar);
             mysqld_update('qq_qqfans', $row, array('qq_openid' => $qq_openid));
         }
     }
 }

开发者ID:jasonhzy，项目名称:bjcms2.3，代码行数:13，代码来源:lib_qq.php

示例3: foreach

<?php

$operation = !empty($_GP['op']) ? $_GP['op'] : 'display';
if ($operation == 'delete') {
    if (checksubmit('submit')) {
        foreach ($_GP['check'] as $k) {
            mysqld_update('bonus_user', array('deleted' => 1), array('bonus_id' => intval($k)));
        }
        message("批量删除成功！", "refresh", "success");
    }
    mysqld_update('bonus_user', array('deleted' => 1), array('bonus_id' => intval($_GP['id'])));
    message("删除成功！", "refresh", "success");
}
$pindex = max(1, intval($_GP['page']));
$psize = 20;
$bonus_user_list = mysqld_selectall("SELECT user.*,member.mobile mobile,member.realname,orders.ordersn FROM " . table('bonus_user') . " user left join " . table('member') . " member on member.openid=user.openid left join " . table('shop_order') . " orders on orders.id=user.order_id where user.deleted=0 and user.bonus_type_id=:bonus_type_id order by user.bonus_id desc LIMIT " . ($pindex - 1) * $psize . ',' . $psize, array(":bonus_type_id" => $_GP['id']));
$total = mysqld_selectcolumn("SELECT count(user.bonus_id) FROM " . table('bonus_user') . " user left join " . table('member') . " member on member.openid=user.openid left join " . table('shop_order') . " orders on orders.id=user.order_id where user.deleted=0 and user.bonus_type_id=:bonus_type_id", array(":bonus_type_id" => $_GP['id']));
$pager = pagination($total, $pindex, $psize);
include page('bonus_view');

开发者ID:skystar，项目名称:cms，代码行数:19，代码来源:bonusview.php

示例4: mysqld_select

<?php

$code = $_GP['code'];
require WEB_ROOT . '/system/modules/plugin/dispatch/' . $code . '/lang.php';
$item = mysqld_select("SELECT * FROM " . table('dispatch') . " WHERE code = :code", array(':code' => $code));
if (empty($item['id'])) {
    $data = array('code' => $code, 'name' => $_LANG['dispatch_' . $code . '_name'], 'desc' => $_LANG['dispatch_' . $code . '_desc'], 'enabled' => '1', 'sendtype' => $_LANG['dispatch_' . $code . '_sendtype']);
    mysqld_insert('dispatch', $data);
} else {
    $data = array('name' => $_LANG['dispatch_' . $code . '_name'], 'desc' => $_LANG['dispatch_' . $code . '_desc'], 'enabled' => '1', 'sendtype' => $_LANG['dispatch_' . $code . '_sendtype']);
    mysqld_update('dispatch', $data, array('code' => $code));
}
message("操作成功", create_url('site', array('name' => 'modules', 'do' => 'dispatch', 'op' => 'display')));

开发者ID:jaydom，项目名称:weishang，代码行数:13，代码来源:dispatch_install.php

示例5: get_member_account

<?php

$member_account = get_member_account();
$openid = $member['openid'];
$order = mysqld_select("SELECT * FROM " . table('shop_order') . " WHERE  id=:id limit 1", array(':id' => $orderid));
$getmember = member_get($openid);
if ($getmember['gold'] >= $order['price']) {
    $usegold = member_gold($openid, $order['price'], 'usegold', "消费金额:" . $order['price'] . ",订单编号：" . $order['ordersn']);
    if ($usegold) {
        mysqld_update('shop_order', array('status' => '1', 'paytype' => '1'), array('id' => $orderid));
        message('订单提交成功，收货后请验货！', WEBSITE_ROOT . mobile_url('myorder'), 'success');
    } else {
        message('付款失败！', WEBSITE_ROOT . mobile_url('myorder'), 'error');
    }
} else {
    message('余额不足，无法完成付款！', WEBSITE_ROOT . mobile_url('myorder'), 'error');
}

开发者ID:jasonhzy，项目名称:bjcms，代码行数:17，代码来源:payaction.php

示例6: array

<?php

$pay_submit_data = array('delivery_pay_desc' => htmlspecialchars_decode($_GP['delivery_pay_desc']));
mysqld_update('payment', array('order' => $_GP['pay_order'], 'configs' => serialize($pay_submit_data)), array('code' => 'delivery'));
mysqld_update('payment', array('enabled' => '1'), array('code' => 'delivery'));

开发者ID:jaydom，项目名称:weishang，代码行数:5，代码来源:submit.php

示例7: mysqld_update

        $this->setOrderCredit($openid, $order['id'], true, '订单:' . $order['ordersn'] . '收货新增积分');
    }
    mysqld_update('shop_order', array('status' => 3, 'updatetime' => time()), array('id' => $orderid, 'openid' => $openid));
    message('确认收货完成！', mobile_url('myorder', array('status' => intval($_GP['fromstatus']))), 'success');
} else {
    if ($op == 'detail') {
        $orderid = intval($_GP['orderid']);
        $item = mysqld_select("SELECT * FROM " . table('shop_order') . " WHERE openid = '" . $openid . "' and id='{$orderid}' limit 1");
        if (empty($item)) {
            message('抱歉，您的订单不存或是已经被取消！', mobile_url('myorder'), 'error');
        }
        if ($item['hasbonus']) {
            $bonuslist = mysqld_selectall("SELECT bonus_user.*,bonus_type.type_name FROM " . table('bonus_user') . " bonus_user left join  " . table('bonus_type') . " bonus_type on bonus_type.type_id=bonus_user.bonus_type_id WHERE bonus_user.order_id=:order_id", array(":order_id" => $orderid));
        }
        if ($item['paytype'] != $this->getPaytypebycode($item['paytypecode'])) {
            mysqld_update('shop_order', array('paytype' => $this->getPaytypebycode($item['paytypecode'])), array('id' => $orderid, 'openid' => $openid));
            $item = mysqld_select("SELECT * FROM " . table('shop_order') . " WHERE openid = '" . $openid . "' and id='{$orderid}' limit 1");
        }
        $goodsid = mysqld_selectall("SELECT goodsid,total FROM " . table('shop_order_goods') . " WHERE orderid = '{$orderid}'", array(), 'goodsid');
        $goods = mysqld_selectall("SELECT g.id, g.title, g.thumb, g.marketprice,o.total,o.optionid FROM " . table('shop_order_goods') . " o left join " . table('shop_goods') . " g on o.goodsid=g.id " . " WHERE o.orderid='{$orderid}'");
        foreach ($goods as &$g) {
            //属性
            $option = mysqld_select("select * from " . table("shop_goods_option") . " where id=:id limit 1", array(":id" => $g['optionid']));
            if ($option) {
                $g['title'] = "[" . $option['title'] . "]" . $g['title'];
                $g['marketprice'] = $option['marketprice'];
            }
        }
        unset($g);
        $dispatch = mysqld_select("select id,dispatchname,sendtype from " . table('shop_dispatch') . " where id=:id limit 1", array(":id" => $item['dispatch']));
        $payments = mysqld_selectall("select * from " . table("payment") . " where enabled=1 order by `order` desc");

开发者ID:jasonhzy，项目名称:bjcms2.3，代码行数:31，代码来源:myorder.php

示例8: intval

<?php

$op = $_GP['op'] ? $_GP['op'] : 'display';
$status = intval($_GP['status']);
if ($op == 'display') {
    $list = mysqld_selectall("SELECT teller.*,member.realname,member.mobile,member.outgoldinfo FROM " . table('gold_teller') . " teller  left join " . table('member') . " member on teller.openid=member.openid where teller.status=:status order by teller.createtime desc", array('status' => $status));
    include page('outchargegold');
    exit;
}
if ($op == 'post') {
    $id = intval($_GP['id']);
    if (intval($_GP['tostatus']) == -1) {
        $gold_teller = mysqld_select("SELECT teller.* FROM " . table('gold_teller') . " teller where teller.status=0 and id=:id", array(':id' => $id));
        if (!empty($gold_teller['openid'])) {
            member_gold($gold_teller['openid'], $gold_teller['fee'], 'addgold', '余额审核拒绝后返回账户' . $gold_teller['fee'] . '元');
        }
    }
    mysqld_update('gold_teller', array('status' => intval($_GP['tostatus'])), array('id' => $id));
    message("审核完成！", 'refresh', 'success');
}

开发者ID:jaydom，项目名称:weishang，代码行数:20，代码来源:outchargegold.php

示例9: mysqld_update

<?php

//	if(empty($_GP['weixin_appId'])||empty($_GP['weixin_appSecret']))
//	{
//	message("微信公众号appid或者appsecret不能空！");
//	}
//   $cfg = array(
//				  	'weixin_appId' => $_GP['weixin_appId'],
//		   		  'weixin_appSecret' => $_GP['weixin_appSecret']
//         );
//       refreshSetting($cfg);
mysqld_update('thirdlogin', array('enabled' => 1), array('code' => 'weixin'));

开发者ID:jaydom，项目名称:weishang，代码行数:12，代码来源:submit.php

示例10: mysqld_update

<?php

mysqld_update('thirdlogin', array('enabled' => 0), array('code' => 'weixin'));
mysqld_update('payment', array('enabled' => 0), array('code' => 'weixin'));
?>

开发者ID:jaydom，项目名称:weishang，代码行数:5，代码来源:uninstall.php

示例11: mysqld_selectall

    $goods = mysqld_selectall("SELECT id, title, thumb, marketprice, total,credit FROM " . table('shop_goods') . " WHERE id IN ('" . implode("','", $goodsids) . "')");
}
$goodtitle = '';
if (!empty($goods)) {
    foreach ($goods as $row) {
        if (empty($goodtitle)) {
            $goodtitle = $row['title'];
        }
        $_optionid = $ordergoods[$row['id']]['optionid'];
        $optionidtitle = '';
        if (!empty($_optionid)) {
            $optionidtitle = mysqld_select("select title from " . table("shop_goods_option") . " where id=:id", array('id' => $_optionid));
            $optionidtitle = $optionidtitle['title'];
        }
        $goodsstr .= "{$row['title']} {$optionidtitle} X{$ordergoods[$row['id']]['total']}\n";
    }
}
$paytypecode = $order['paytypecode'];
if (!empty($_GP['paymentcode'])) {
    $paytypecode = $_GP['paymentcode'];
}
$payment = mysqld_select("select * from " . table("payment") . " where enabled=1 and `code`=:code ", array('code' => $paytypecode));
if (empty($payment['id'])) {
    message("未找到付款方式，付款失败");
}
if ($order['paytypecode'] != $paytypecode) {
    $paytype = $this->getPaytypebycode($paytypecode);
    mysqld_update('shop_order', array('paytypecode' => $payment['code'], 'paytypename' => $payment['name'], 'paytype' => $paytype), array('id' => $orderid));
}
require WEB_ROOT . '/system/modules/plugin/payment/' . $paytypecode . '/payaction.php';
exit;

开发者ID:skystar，项目名称:cms，代码行数:31，代码来源:pay.php

示例12: mysqld_update

<?php

$code = $_GP['code'];
mysqld_update('dispatch', array('enabled' => 0), array('code' => $code));
message('关闭成功！', 'refresh', 'success');

开发者ID:skystar，项目名称:cms，代码行数:5，代码来源:dispatch_uninstall.php

示例13: member_gold

function member_gold($openid, $fee, $type, $remark)
{
    $member = member_get($openid);
    if (!empty($member['openid'])) {
        if (!is_numeric($fee) || $fee < 0) {
            message("输入数字非法，请重新输入");
        }
        if ($type == 'addgold') {
            $data = array('remark' => $remark, 'type' => $type, 'fee' => $fee, 'account_fee' => $member['gold'] + $fee, 'createtime' => TIMESTAMP, 'openid' => $openid);
            mysqld_insert('member_paylog', $data);
            mysqld_update('member', array('gold' => $member['gold'] + $fee), array('openid' => $openid));
            return true;
        }
        if ($type == 'usegold') {
            if ($member['gold'] >= $fee) {
                $data = array('remark' => $remark, 'type' => $type, 'fee' => $fee, 'account_fee' => $member['gold'] - $fee, 'createtime' => TIMESTAMP, 'openid' => $openid);
                mysqld_insert('member_paylog', $data);
                mysqld_update('member', array('gold' => $member['gold'] - $fee), array('openid' => $openid));
                return true;
            }
        }
    }
    return false;
}

开发者ID:jaydom，项目名称:weishang，代码行数:24，代码来源:init.php

示例14: do_process

 public function do_process()
 {
     global $_GP, $_CMS;
     $settings = globaSetting();
     $configdata = $settings['weixintoken'];
     $token = $configdata;
     if (!$this->checkSign($token)) {
         exit('Access Denied');
     }
     if (strtolower($_SERVER['REQUEST_METHOD']) == 'get') {
         ob_clean();
         ob_start();
         exit($_GET['echostr']);
     }
     if (strtolower($_SERVER['REQUEST_METHOD']) == 'post') {
         $postStr = $GLOBALS["HTTP_RAW_POST_DATA"];
         $message = $this->requestParse($postStr);
         if (empty($message)) {
             exit('Request Failed');
         }
         if ($message['type'] == 'text' || $message['type'] == 'CLICK') {
             $key = $message['content'];
             if ($message['type'] == 'CLICK') {
                 $key = $message['eventkey'];
             }
             if (!empty($key)) {
                 $reply = mysqld_select('SELECT * FROM ' . table('weixin_rule') . "   WHERE  keywords = :keywords", array(':keywords' => $key));
             }
             if (empty($reply['id']) && !empty($key) && strpos($key, 'hx') == 0 && strpos($key, 'x') == 1 && !empty(strstr($key, 'hx'))) {
                 if ($_CMS['addons_bj_hx']) {
                     //扩展模块代码
                     $newkey = str_replace('hx', '', $key);
                     $item = mysqld_select("SELECT * FROM " . table('shop_order') . " WHERE ordersn = :ordersn\t", array(':ordersn' => $newkey));
                     if (empty($item)) {
                         return $this->respText('抱歉，核销订单不存在或被取消', $message);
                     }
                     if ($item['status'] == 3) {
                         return $this->respText('抱歉，核销订单已核销完成，不能重复核销！', $message);
                     }
                     $from_user = $message['from'];
                     $weixin_wxfans = mysqld_select('SELECT * FROM ' . table('weixin_wxfans') . " WHERE weixin_openid = :weixin_openid", array(':weixin_openid' => $from_user));
                     $str = $this->verifyorder($weixin_wxfans['openid'], $newkey);
                     return $this->respText($str, $message);
                 }
             } else {
                 if ($_CMS['addons_bj_tbk']) {
                     //扩展模块代码
                     if (empty($reply['id']) && !empty($key)) {
                         $from_user = $message['from'];
                         $spread = mysqld_select("SELECT * FROM " . table('bj_tbk_qrcode') . " where weixinkey=:weixinkey limit 1", array(':weixinkey' => $key));
                         if (!empty($spread['id'])) {
                             $weixin_wxfans = mysqld_select('SELECT * FROM ' . table('weixin_wxfans') . " WHERE weixin_openid = :weixin_openid", array(':weixin_openid' => $from_user));
                             if (!empty($weixin_wxfans['openid'])) {
                                 $bj_tbk_member_relect = mysqld_select('SELECT * FROM ' . table('bj_tbk_member_relect') . " WHERE openid = :openid", array(':openid' => $weixin_wxfans['openid']));
                                 //if(empty($bj_tbk_member_relect['isagent']))
                                 //{
                                 //		return $this->respText('您还不是代理无法生成二维码',$message);
                                 //}
                                 $qrcodecache = mysqld_select("SELECT * FROM " . table('bj_tbk_qrcode_cache') . " where qrcodeid=:qrcodeid and from_user=:from_user limit 1", array(':qrcodeid' => $spread['id'], ':from_user' => $from_user));
                                 if (empty($qrcodecache['id']) || empty($qrcodecache['qr_url']) || empty($qrcodecache['media_id']) || empty($qrcodecache['id']) || !empty($qrcodecache['expiretime']) && $qrcodecache['expiretime'] <= TIMESTAMP) {
                                     $media_id = bj_tbk_qrcode($qrcodecache, $spread, $from_user, $weixin_wxfans['openid'], true, 'media_id');
                                     return $this->respImage($media_id, $message);
                                     // $this->sendcustomIMG($from_user,$media_id);
                                     exit;
                                 } else {
                                     return $this->respImage($qrcodecache['media_id'], $message);
                                 }
                             } else {
                                 return $this->respText('您还不是会员无法生成二维码', $message);
                             }
                         }
                     }
                 }
             }
         }
         if ($message['type'] == 'subscribe') {
             $reply = mysqld_select('SELECT * FROM ' . table('weixin_rule') . "   WHERE  keywords = :keywords", array(':keywords' => subscribe_key));
             if (!empty($message['eventkey']) && strlen($message['eventkey']) > 8) {
                 $eventkey = substr($message['eventkey'], 8);
             } else {
                 $eventkey = $message['eventkey'];
             }
             if (!empty($message['from']) && !empty($eventkey)) {
                 bj_tbk_base_shareinfo('', $eventkey, $message['from'], '', 1);
             }
             mysqld_update('weixin_wxfans', array('follow' => 1), array('weixin_openid' => $message['from']));
         }
         if ($message['type'] == 'unsubscribe') {
             mysqld_update('weixin_wxfans', array('follow' => 0), array('weixin_openid' => $message['from']));
         }
         if (empty($reply['id'])) {
             $reply = mysqld_select('SELECT * FROM ' . table('weixin_rule') . "   WHERE  keywords = :keywords", array(':keywords' => default_key));
         }
         if ($reply['ruletype'] == 1) {
             $reply['content'] = htmlspecialchars_decode($reply['description']);
             $reply['content'] = str_replace(array('<br>', '&nbsp;'), array("\n", ' '), $reply['content']);
             $reply['content'] = strip_tags($reply['content'], '<a>');
             return $this->respText($reply['content'], $message);
         }
         if ($reply['ruletype'] == 2) {
//.........这里部分代码省略.........

开发者ID:jaydom，项目名称:weishang，代码行数:101，代码来源:mobile.php

示例15: message

                if (is_error($upload)) {
                    message($upload['message'], '', 'error');
                }
                $data['thumb'] = $upload['path'];
            }
            mysqld_insert('addon8_article', $data);
            message("添加成功", create_url('site', array('name' => 'addon8', 'do' => 'article', 'op' => 'post', 'id' => mysqld_insertid())), "success");
        } else {
            $data = array('createtime' => time(), 'pcate' => intval($_GP['pcate']), 'ccate' => intval($_GP['ccate']), 'iscommend' => intval($_GP['iscommend']), 'ishot' => intval($_GP['ishot']), 'mobileTheme' => intval($_GP['mobileTheme']), 'title' => $_GP['title'], 'readcount' => intval($_GP['readcount']), 'description' => $_GP['description'], 'content' => htmlspecialchars_decode($_GP['content']), 'displayorder' => intval($_GP['displayorder']));
            if (!empty($_GP['thumb_del'])) {
                $data['thumb'] = '';
            }
            if (!empty($_FILES['thumb']['tmp_name'])) {
                file_delete($_GP['thumb_old']);
                $upload = file_upload($_FILES['thumb']);
                if (is_error($upload)) {
                    message($upload['message'], '', 'error');
                }
                $data['thumb'] = $upload['path'];
            }
            mysqld_update('addon8_article', $data, array('id' => $_GP['id']));
            message("修改成功", "refresh", "success");
        }
    }
    include addons_page('article');
    exit;
}
$article_list = mysqld_selectall("SELECT * FROM " . table('addon8_article') . " order by displayorder desc");
$category_pcate = mysqld_selectall("SELECT * FROM " . table('addon8_article_category') . "  where parentid=0 ", array(), 'id');
$category_ccate = mysqld_selectall("SELECT * FROM " . table('addon8_article_category') . "  where parentid!=0 ", array(), 'id');
include addons_page('article_list');

开发者ID:skystar，项目名称:cms，代码行数:31，代码来源:article.php

示例16: elseif

} elseif ($operation == 'default') {
    $id = intval($_GP['id']);
    mysqld_update('shop_address', array('isdefault' => 0), array('openid' => $openid));
    mysqld_update('shop_address', array('isdefault' => 1), array('id' => $id));
    message(1, '', 'ajax');
} elseif ($operation == 'detail') {
    $id = intval($_GP['id']);
    $row = mysqld_select("SELECT id, realname, mobile, province, city, area, address FROM " . table('shop_address') . " WHERE id = :id", array(':id' => $id));
    message($row, '', 'ajax');
} elseif ($operation == 'remove') {
    $id = intval($_GP['id']);
    if (!empty($id)) {
        $address = mysqld_select("select isdefault from " . table('shop_address') . " where id='{$id}'  and openid='" . $openid . "' limit 1 ");
        if (!empty($address)) {
            //修改成不直接删除，而设置deleted=1
            mysqld_update("shop_address", array("deleted" => 1, "isdefault" => 0), array('id' => $id, 'openid' => $openid));
            if ($address['isdefault'] == 1) {
                //如果删除的是默认地址，则设置是新的为默认地址
                $maxid = mysqld_selectcolumn("select max(id) as maxid from " . table('shop_address') . " where  openid='" . $openid . "' limit 1 ");
                if (!empty($maxid)) {
                    mysqld_update('shop_address', array('isdefault' => 1), array('id' => $maxid, 'openid' => $openid));
                    die(json_encode(array("result" => 1, "maxid" => $maxid)));
                }
            }
        }
    }
    die(json_encode(array("result" => 1, "maxid" => 0)));
} else {
    $address = mysqld_selectall("SELECT * FROM " . table('shop_address') . " WHERE deleted=0 and openid = :openid", array(':openid' => $openid));
    include themePage('address');
}

开发者ID:skystar，项目名称:cms，代码行数:31，代码来源:address.php

示例17: intval

$ccate = intval($goods['ccate']);
if (empty($goods)) {
    message('抱歉，商品不存在或是已经被删除！');
}
if ($goods['totalcnf'] != 2 && empty($goods['total'])) {
    message('抱歉，商品库存不足！');
}
if ($goods['istime'] == 1) {
    if (time() < $goods['timestart']) {
        message('抱歉，还未到购买时间, 暂时无法购物哦~', refresh(), "error");
    }
    if (time() > $goods['timeend']) {
        message('抱歉，商品限购时间已到，不能购买了哦~', refresh(), "error");
    }
}
mysqld_update('shop_goods', array('viewcount' => $goods['viewcount'] + 1), array('id' => $goodsid));
//浏览量
$piclist = array(array("attachment" => $goods['thumb']));
$goods_piclist = mysqld_selectall("SELECT * FROM " . table('shop_goods_piclist') . " WHERE goodid = :goodid", array(':goodid' => $goodsid));
$goods_piclist_count = mysqld_selectcolumn("SELECT count(*) FROM " . table('shop_goods_piclist') . " WHERE goodid = :goodid", array(':goodid' => $goodsid));
if ($goods_piclist_count > 0) {
    $piclist = array();
    foreach ($goods_piclist as &$item) {
        $piclist[] = array("attachment" => $item['picurl']);
    }
}
$marketprice = $goods['marketprice'];
$productprice = $goods['productprice'];
$stock = $goods['total'];
//规格及规格项
$allspecs = mysqld_selectall("select * from " . table('shop_goods_spec') . " where goodsid=:id order by displayorder asc", array(':id' => $goodsid));

开发者ID:jasonhzy，项目名称:bjcms2.3，代码行数:31，代码来源:detail.php

示例18: elseif

} elseif ($operation == 'display') {
    $pindex = max(1, intval($_GP['page']));
    $psize = 10;
    $condition = '';
    if (!empty($_GP['keyword'])) {
        $condition .= " AND title LIKE '%{$_GP['keyword']}%'";
    }
    if (!empty($_GP['cate_2'])) {
        $cid = intval($_GP['cate_2']);
        $condition .= " AND ccate = '{$cid}'";
    } elseif (!empty($_GP['cate_1'])) {
        $cid = intval($_GP['cate_1']);
        $condition .= " AND pcate = '{$cid}'";
    }
    if (isset($_GP['status'])) {
        $condition .= " AND status = '" . intval($_GP['status']) . "'";
    }
    $list = mysqld_selectall("SELECT * FROM " . table('shop_goods') . " WHERE  deleted=0 {$condition} ORDER BY status DESC, displayorder DESC, id DESC LIMIT " . ($pindex - 1) * $psize . ',' . $psize);
    $total = mysqld_selectcolumn('SELECT COUNT(*) FROM ' . table('shop_goods') . " WHERE deleted=0 {$condition}");
    $pager = pagination($total, $pindex, $psize);
    include page('goods_list');
} elseif ($operation == 'delete') {
    $id = intval($_GP['id']);
    $row = mysqld_select("SELECT id, thumb FROM " . table('shop_goods') . " WHERE id = :id", array(':id' => $id));
    if (empty($row)) {
        message('抱歉，商品不存在或是已经被删除！');
    }
    //修改成不直接删除，而设置deleted=1
    mysqld_update("shop_goods", array("deleted" => 1), array('id' => $id));
    message('删除成功！', 'refresh', 'success');
}

开发者ID:jasonhzy，项目名称:bjcms2.3，代码行数:31，代码来源:goods.php

示例19: mysqld_update

        mysqld_update('shop_order', array('status' => -2, 'rsreson' => $_GP['rsreson']), array('id' => $orderid, 'openid' => $openid));
        message('申请退款成功，请等待审核！', mobile_url('myorder', array('status' => intval($_GP['fromstatus']))), 'success');
    }
    include themePage('order_detail_return');
    exit;
} elseif ($op == 'confirm') {
    $orderid = intval($_GP['orderid']);
    $order = mysqld_select("SELECT * FROM " . table('shop_order') . " WHERE id = :id AND openid = :openid", array(':id' => $orderid, ':openid' => $openid));
    if (empty($order)) {
        message('抱歉，您的订单不存在或是已经被取消！', mobile_url('myorder'), 'error');
    }
    if (empty($order['isrest'])) {
        //不是换货
        $this->setOrderCredit($openid, $order['id'], true, '订单:' . $order['ordersn'] . '收货新增积分');
    }
    mysqld_update('shop_order', array('status' => 3, 'updatetime' => time()), array('id' => $orderid, 'openid' => $openid));
    message('确认收货完成！', mobile_url('myorder', array('status' => intval($_GP['fromstatus']))), 'success');
} else {
    if ($op == 'detail') {
        $orderid = intval($_GP['orderid']);
        $item = mysqld_select("SELECT * FROM " . table('shop_order') . " WHERE openid = '" . $openid . "' and id='{$orderid}' limit 1");
        if (empty($item)) {
            message('抱歉，您的订单不存或是已经被取消！', mobile_url('myorder'), 'error');
        }
        $goodsid = mysqld_selectall("SELECT goodsid,total FROM " . table('shop_order_goods') . " WHERE orderid = '{$orderid}'", array(), 'goodsid');
        $goods = mysqld_selectall("SELECT g.id, g.title, g.thumb, g.marketprice,o.total,o.optionid FROM " . table('shop_order_goods') . " o left join " . table('shop_goods') . " g on o.goodsid=g.id " . " WHERE o.orderid='{$orderid}'");
        foreach ($goods as &$g) {
            //属性
            $option = mysqld_select("select * from " . table("shop_goods_option") . " where id=:id limit 1", array(":id" => $g['optionid']));
            if ($option) {
                $g['title'] = "[" . $option['title'] . "]" . $g['title'];

开发者ID:jasonhzy，项目名称:bjcms，代码行数:31，代码来源:myorder.php

示例20: elseif

    } elseif ($insert['m_type'] == 8) {
        $data = $_GP['eighth'];
    } elseif ($insert['m_type'] == 9) {
        $data = $_GP['ninth'];
    } elseif ($insert['m_type'] == 10) {
        $data = $_GP['tenth'];
    }
    if (!empty($data)) {
        $insert['param'] = serialize($data);
    } else {
        $insert['param'] = '';
    }
    if ($item == false) {
        $temp = mysqld_insert('addon10_scene_page', $insert);
    } else {
        $temp = mysqld_update('addon10_scene_page', $insert, array('id' => $item['id']));
    }
    if ($temp == false) {
        $this->ajaxmessage('数据提交失败');
    } else {
        $this->ajaxmessage('数据提交成功', web_url('scene_page', array('listid' => $list_id, 'op' => 'display')), 'success');
    }
}
$uploadfolder = WEB_ROOT . '/attachment/image/addon10/';
mkdirs($uploadfolder);
$tmpfoldername = random(15);
copy(ADDONS_ROOT . 'addon10/style/img/default_bg.jpg', $uploadfolder . $tmpfoldername . 'jpg');
$tmpfoldername2 = random(15);
copy(ADDONS_ROOT . 'addon10/style/img/default_btn.png', $uploadfolder . $tmpfoldername2 . 'png');
if ($item == false) {
    $item = array('listorder' => 0, 'thumb' => 'image/addon10/' . $tmpfoldername . 'jpg');

开发者ID:jasonhzy，项目名称:bjcms2.3，代码行数:31，代码来源:page.php

注：本文中的mysqld_update函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

PHP mysqlexec函数代码示例发布时间：2022-05-15

PHP mysqld_selectcolumn函数代码示例发布时间：2022-05-15

bradtraversy/iweather: Ionic 3 mobile we

1 dustinvtran/ml-videos: A collection of v

dustinvtran/ml-videos: A collection of video resources for machine learning

阅读：1287|2022-08-19

2 delphi线程使用

unit untWorkThread;interfaceuses Windows,Classes,SysUtils;type TWorkItem=

阅读：1127|2022-07-22

3 ravikumar001/maven

ravikumar001/maven

阅读：730|2022-08-17

4 更的笔顺,体会更的笔画,理会更的部首

更的笔顺是什么?更的笔顺笔画顺序怎么写？还有更的拼音及意思是什么，好多初学练字者

阅读：633|2022-11-06

5 ceejbot/LOUDBOT: AUTOMATED SHOUTING FOR

ceejbot/LOUDBOT: AUTOMATED SHOUTING FOR MASTODON

阅读：1524|2022-08-18

6 CVE-2022-29834

Improper Limitation of a Pathname to a Restricted Directory ('Path Traversal

阅读：602|2022-07-29

7 kali-docs-cn/kali-linux-web-pentest-cook

kali-docs-cn/kali-linux-web-pentest-cookbook-zh: Kali Linux Web 渗透测试秘籍中

阅读：721|2022-08-15

8 liangtengyu/to_markdown: 一键解析Markdow

liangtengyu/to_markdown: 一键解析Markdown 目前支持: 微信公众号,知乎,知乎专栏,简

阅读：904|2022-08-18

9 win7系统删除资源管理器里我们不想要的图标

win7系统电脑使用过程中有不少朋友表示遇到过win7系统删除资源管理器里我们不想要的图

阅读：629|2022-11-06

10 Delphi按下F1不能出现帮助文档的解决方法

不光是Delphi，Windows里面所有的之所以无法打开.hlp帮助文档的问题都可以使用以下的

阅读：1114|2022-07-18

客服电话

电子邮件

PHP mysqld_update函数代码示例

示例1: updateOrderStock

示例2: member_create_qq

示例3: foreach

示例4: mysqld_select

示例5: get_member_account

示例6: array

示例7: mysqld_update

示例8: intval

示例9: mysqld_update

示例10: mysqld_update

示例11: mysqld_selectall

示例12: mysqld_update

示例13: member_gold

示例14: do_process

示例15: message

示例16: elseif

示例17: intval

示例18: elseif

示例19: mysqld_update

示例20: elseif

请发表评论

全部评论

上一篇：

下一篇：

dustinvtran/ml-videos: A collection of v

delphi线程使用

ravikumar001/maven

更的笔顺,体会更的笔画,理会更的部首

ceejbot/LOUDBOT: AUTOMATED SHOUTING FOR

bradtraversy/iweather: Ionic 3 mobile we

joaomh/curso-de-matlab

断牙刷新位置时间（断牙属性及刷新位置介绍

rugk/mastodon-simplified-federation: Sim

小程序自适应布局开发，注意点（待搜索资料

MATLAB和C语言混合编程-----Matlab7.0编译

关于我们

产品与服务

解决方案

139-2527-9053