sql ``` ALTER TABLE `ims_ewei_shop_goods` ADD COLUMN `isbonus` tinyint(2) NULL DEFAULT 0 ; ``` php ``` $data["isbonus"] = intval($_GPC["isbonus"]); ``` 頁面 ``` <div class="form-group"> <label class="col-sm-2 control-label">商品類型</label> <div class="col-sm-9 col-xs-12"> <label class="radio-inline"> <input type="radio" value="0" name="isbonus" {if $item['isbonus']==0}checked{/if} /> 普通商品 </label> <label class="radio-inline"> <input type="radio" value="1" name="isbonus" {if $item['isbonus']==1}checked{/if} /> 報單商品 </label> <span class="help-block">報單商品不參與團隊分紅，普通商品參與分紅</span> </div> </div> ``` 應用 ``` $hasokgoods = false; $ordergoods = pdo_fetchall("select og.id,g.isbonus from " . tablename('ewei_shop_order_goods') . ' og left join ' . tablename('ewei_shop_goods') . ' g on g.id = og.goodsid where og.orderid=:orderid and og.uniacid=:uniacid', array(':orderid' => $orderid, ':uniacid' => $_W['uniacid'])); foreach($ordergoods as $v){ if($v['isbonus']==1){ $hasokgoods = true; } } ```