PHP truncate_table函数代码示例

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

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

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

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

示例1: process_order

 /**
  * 订单
  */
 function process_order()
 {
     global $db, $ecs;
     /* 清空订单、订单商品 */
     truncate_table('order_info');
     truncate_table('order_goods');
     truncate_table('order_action');
     /* 订单 */
     $sql = "SELECT o.* FROM " . $this->sprefix . "orders AS o ";
     $res = $this->sdb->query($sql);
     while ($row = $this->sdb->fetchRow($res)) {
         $order = array();
         $order['order_sn'] = $row['order_id'];
         $order['user_id'] = $row['member_id'];
         $order['add_time'] = $row['createtime'];
         $order['consignee'] = ecs_iconv($this->scharset, $this->tcharset, addslashes($row['consignee']));
         $order['address'] = ecs_iconv($this->scharset, $this->tcharset, addslashes($row['ship_addr']));
         $order['zipcode'] = $row['ship_zip'];
         $order['tel'] = $row['ship_tel'];
         $order['mobile'] = $row['ship_mobile'];
         $order['email'] = $row['ship_email'];
         $order['postscript'] = ecs_iconv($this->scharset, $this->tcharset, addslashes($row['memo']));
         $order['shipping_name'] = ecs_iconv($this->scharset, $this->tcharset, addslashes($row['ship_name']));
         $order['pay_name'] = ecs_iconv($this->scharset, $this->tcharset, addslashes($row['shipping']));
         $order['inv_payee'] = ecs_iconv($this->scharset, $this->tcharset, addslashes($row['tax_company']));
         $order['goods_amount'] = $row['total_amount'];
         $order['shipping_fee'] = $row['cost_freight'];
         $order['order_amount'] = $row['final_amount'];
         $order['pay_time'] = $row['paytime'];
         $order['shipping_time'] = $row['acttime'];
         /* 状态 */
         if ($row['ordstate'] == '0') {
             $order['order_status'] = OS_UNCONFIRMED;
             $order['shipping_status'] = SS_UNSHIPPED;
         } elseif ($row['ordstate'] == '1') {
             $order['order_status'] = OS_CONFIRMED;
             $order['shipping_status'] = SS_UNSHIPPED;
         } elseif ($row['ordstate'] == '9') {
             $order['order_status'] = OS_INVALID;
             $order['shipping_status'] = SS_UNSHIPPED;
         } else {
             $order['order_status'] = OS_CONFIRMED;
             $order['shipping_status'] = SS_SHIPPED;
         }
         if ($row['pay_status'] == '1') {
             $order['pay_status'] = PS_PAYED;
         } else {
             $order['pay_status'] = PS_UNPAYED;
         }
         if ($row['userrecsts'] == '1') {
             if ($row['recsts'] == '1') {
                 if ($order['shipping_status'] == SS_SHIPPED) {
                     $order['shipping_status'] = SS_RECEIVED;
                 }
             } elseif ($row['recsts'] == '2') {
                 $order['order_status'] = OS_CANCELED;
                 $order['pay_status'] = PS_UNPAYED;
                 $order['shipping_status'] = SS_UNSHIPPED;
             }
         }
         if (!$db->autoExecute($ecs->table('order_info'), $order, 'INSERT', '', 'SILENT')) {
             //return $db->error();
         }
         /* 订单商品 */
     }
     /* 返回 */
     return TRUE;
 }

开发者ID:BGCX262，项目名称:zuyii-svn-to-git，代码行数:71，代码来源:shopex48.php

示例2: process_order

    /**
     * 订单
     */
    function process_order()
    {
        global $db, $ecs;

        /* 清空订单、订单商品 */
        truncate_table('order_info');
        truncate_table('order_goods');
        truncate_table('order_action');

        /* 订单 */
        $sql = "SELECT o.*, t.tmethod, p.payment FROM ".$this->sprefix."mall_orders AS o " .
                "LEFT JOIN ".$this->sprefix."mall_offer_t AS t ON o.ttype = t.id " .
                "LEFT JOIN ".$this->sprefix."mall_offer_p AS p ON o.ptype = p.id";
        $res = $this->sdb->query($sql);
        while ($row = $this->sdb->fetchRow($res))
        {
            $order = array();
            $order['order_sn']          = $row['orderid'];
            $order['user_id']           = $row['userid'];
            $order['add_time']          = $row['ordertime'];
            $order['consignee']         = ecs_iconv($this->scharset, $this->tcharset, addslashes($row['name']));
            $order['address']           = ecs_iconv($this->scharset, $this->tcharset, addslashes($row['addr']));
            $order['zipcode']           = $row['zip'];
            $order['tel']               = $row['tel'];
            $order['mobile']            = $row['mobile'];
            $order['email']             = $row['email'];
            $order['postscript']        = ecs_iconv($this->scharset, $this->tcharset, addslashes($row['memo']));
            $order['shipping_name']     = is_null($row['tmethod']) ? ' ' : ecs_iconv($this->scharset, $this->tcharset, addslashes($row['tmethod']));
            $order['pay_name']          = is_null($row['payment']) ? ' ' : ecs_iconv($this->scharset, $this->tcharset, addslashes($row['payment']));
            $order['inv_payee']         = ecs_iconv($this->scharset, $this->tcharset, addslashes($row['invoiceform']));
            $order['goods_amount']      = $row['item_amount'];
            $order['shipping_fee']      = $row['freight'];
            $order['order_amount']      = $row['total_amount'];
            $order['pay_time']          = $row['paytime'];
            $order['shipping_time']     = $row['sendtime'];

            /* 状态 */
            if ($row['ordstate'] == '0')
            {
                $order['order_status']      = OS_UNCONFIRMED;
                $order['shipping_status']   = SS_UNSHIPPED;
            }
            elseif ($row['ordstate'] == '1')
            {
                $order['order_status']      = OS_CONFIRMED;
                $order['shipping_status']   = SS_UNSHIPPED;
            }
            elseif ($row['ordstate'] == '9')
            {
                $order['order_status']      = OS_INVALID;
                $order['shipping_status']   = SS_UNSHIPPED;
            }
            else // 3 发货 4 归档
            {
                $order['order_status']      = OS_CONFIRMED;
                $order['shipping_status']   = SS_SHIPPED;
            }

            if ($row['ifsk'] == '1')
            {
                $order['pay_status']        = PS_PAYED;
            }
            else // 0 未付款 5 退款
            {
                $order['pay_status']        = PS_UNPAYED;
            }

            if ($row['userrecsts'] == '1') // 用户操作了
            {
                if ($row['recsts'] == '1') // 到货
                {
                    if ($order['shipping_status'] == SS_SHIPPED)
                    {
                        $order['shipping_status'] = SS_RECEIVED;
                    }
                }
                elseif ($row['recsts'] == '2') // 取消
                {
                    $order['order_status']      = OS_CANCELED;
                    $order['pay_status']        = PS_UNPAYED;
                    $order['shipping_status']   = SS_UNSHIPPED;
                }
            }

            /* 如果已付款，修改已付款金额为订单总金额，修改订单总金额为0 */
            if ($order['pay_status'] > PS_UNPAYED)
            {
                $order['money_paid']    = $order['order_amount'];
                $order['order_amount']  = 0;
            }

            if (!$db->autoExecute($ecs->table('order_info'), $order, 'INSERT', '', 'SILENT'))
            {
                //return $db->error();
            }

            /* 订单商品 */
//.........这里部分代码省略.........

开发者ID:noikiy，项目名称:mdwp，代码行数:101，代码来源:shopex47.php

注：本文中的truncate_table函数示例整理自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 truncate_text函数代码示例发布时间：2022-05-23

PHP truncate_string函数代码示例发布时间：2022-05-23

umegaya/lua-aws: pure-lua implementation

1 努力思考能减肥吗？

人类的大脑是“最耗电”的器官，它每天都能消耗人体摄入的20%的能量。不过，它的“用

阅读：286|2022-11-06

2 Delphi_09_Delphi_Object_Pascal_面向对象

今天这里讨论一下Delphi中的面向对象编程，这里不做过多过细的讨论，主要做提纲挈领的

阅读：5899|2022-07-22

3 angular/material: Material design for An

angular/material: Material design for AngularJS

阅读：322|2022-08-17

4 CVE-2021-45721

JFrog Artifactory prior to version 7.29.8 and 6.23.38 is vulnerable to Reflected

阅读：1038|2022-07-08

5 jenkins-infra/pipeline-library: Collecti

jenkins-infra/pipeline-library: Collection of custom steps and variables for our

阅读：739|2022-08-15

6 sassoftware/sas-viya-machine-learning: C

sassoftware/sas-viya-machine-learning: Code examples for machine learning techni

阅读：1935|2022-08-19

7 YangMame/Arch-Linux-Installer: Arch-Linu

YangMame/Arch-Linux-Installer: Arch-Linux-Install-Script/Arch Linux 安装脚本

阅读：403|2022-08-15

8 ray-x/navigator.lua: Source code analysi

ray-x/navigator.lua: Source code analysis navigation plugin for Neovim. Navigat

阅读：302|2022-08-16

9 rezaahmadzadeh/Expectation-Maximization:

rezaahmadzadeh/Expectation-Maximization: Expectation-Maximization (EM) algorithm

阅读：598|2022-08-17

10 CVE-2021-29799

IBM Engineering Requirements Quality Assistant On-Premises (All versions) could

阅读：578|2022-07-29

客服电话

电子邮件

PHP truncate_table函数代码示例

示例1: process_order

示例2: process_order

请发表评论

全部评论

上一篇：

下一篇：

黄聪：微信小程序服务器 TLS1.0 1TLS.2 配

bradtraversy/iweather: Ionic 3 mobile we

joaomh/curso-de-matlab

CVE-2022-1483

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

umegaya/lua-aws: pure-lua implementation

什么是现代农业?发展新农业的关键是科技

Rapsssito/react-native-tcp-socket: React

设计一款小程序产品要考虑哪些？用友小盟小

CVE-2022-20221

榨汁机、破壁机和豆浆机的区别(国产豆浆机

关于我们

产品与服务

解决方案

139-2527-9053

客服电话

电子邮件

PHP truncate_table函数代码示例

示例1: process_order

示例2: process_order

请发表评论

全部评论

上一篇：

下一篇：

黄聪：微信小程序 服务器 TLS1.0 1TLS.2 配

bradtraversy/iweather: Ionic 3 mobile we

joaomh/curso-de-matlab

CVE-2022-1483

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

umegaya/lua-aws: pure-lua implementation

什么是现代农业?发展新农业的关键是科技

Rapsssito/react-native-tcp-socket: React

设计一款小程序产品要考虑哪些？用友小盟小

CVE-2022-20221

榨汁机、破壁机和豆浆机的区别(国产豆浆机

关于我们

产品与服务

解决方案

139-2527-9053

黄聪：微信小程序服务器 TLS1.0 1TLS.2 配