我想问下这类php情况该如何优化代码?

Question

我把新增编辑内容页面做在同一个页面上,然后html赋值已填写的东西,但新增页面是没有任何默认值的,我就像如下做法,觉得自己很傻一定有什么办法解决的

public function aeCard(Request $Request , GiftList $GiftList){
        $Card = Model('Card');
        $id = $Request->route('id','0');
        $post = $Request->post();
        if(!$id){
            if(!$post){
                $info['name'] = '';
                $info['banner'] = '';
                $info['utype'] = 0;
                $info['frequency'] = 0;
                $info['eventshare'] = 0;
                $info['clickshare'] = 0;
                $info['type'] = 0;
                $info['atype'] = 0;
                $info['state'] = 1;
                $info['starttime'] = date('Y-m-d') . ' 00:00:00';
                $info['endtime'] = date('Y-m-d') . ' 23:59:59';
                $info['mid'] = 'null';
                $info['id'] = 0;
                $info['cid'] = 'null';
                $info['qrcode'] = 0;
                $info['description'] = '';
                $info['notluck'] = 0;
                $info['giftdata'] = '';
                $info['qrcodedata'] = '0';
                $info['background'] = '0';
                $info['backgroundcolor'] = '';
                $this->assign('info',$info);
                $this->assign('id',0);
                return $this->fetch('ae_card');
            }
        }else{
            $info = $Card->CardInfo($id);
            $info['starttime'] = date('Y-m-d H:i:s',$info['starttime']);
            $info['endtime'] = date('Y-m-d H:i:s',$info['endtime']);
            $giftData = $GiftList->gainActivityGift($id);
            $giftData = array_column($giftData,'id');
            $info['giftdata'] = implode(',',$giftData);
            $info['qrcodedata'] = json_encode(Model('Qrcodeshare')->queryActivity($id));
            $this->assign('info',$info);
            $this->assign('id',$id);
            return $this->fetch('ae_card');
        }
    }

Answer 1

去mysql设置对应字段的默认值