I can't save to database but the message show the data has been save

Need Help
1

I have created Cake PHP 3, I want to add data, but when I clik submit button, the data is didn’t save but the message show data has been save. I add into two different tables. When I try to add data in one table is fine.

StoreController.php

public function add()
{
$this->loadComponent('General');
$setStatus = 1;
$store = $this->Stores->newEntity();
if ($this->request->is('post')) {
    // dd( $this->request->getData());exit;
    $connection = ConnectionManager::get('ora');
    $connection->begin();
    $store = $this->Stores->patchEntity($store, $this->request->getData());;

    $merchantTable = TableRegistry::get('MasterFile.Merchants');
    $merchant = $merchantTable->find()->where(['MERCHANT_CODE'=>$store->MERCHANT_CODE])->first();

    $store->MERCHANT_ID = $merchant->MERCHANT_ID;
    $store->CREATED_DATE = date("Y-m-d h:i:s");
    $store->LAST_UPDATED_DATE = date("Y-m-d h:i:s");
    $store->LAST_APPROVED_DATE = date("Y-m-d h:i:s");
    $store->LAST_VERSION_DATE = date("Y-m-d h:i:s");

    // $store->store_address->LINE1 = $store->LINE1;

    // Start - Controller Code to handle file uploading
    if(!empty($this->request->data['STORE_LOGO']['name']))
    {
        $file = $this->request->data['STORE_LOGO']; //put the data into a var for easy use

        $ext = substr(strtolower(strrchr($file['name'], '.')), 1); //get the extension
        $arr_ext = array('jpg', 'jpeg', 'png'); //set allowed extensions

        $fileName = $this->request->data['STORE_LOGO']['name'];
        $uploadPath = WWW_ROOT.'img/store_logo/';
        $uploadFile = $uploadPath.$fileName;

        //only process if the extension is valid
        if(in_array($ext, $arr_ext))
        {
            if(move_uploaded_file($this->request->data['STORE_LOGO']['tmp_name'],$uploadFile))
            {
                $store['STORE_LOGO'] = $uploadFile;
            }
        }

        
    }

    if(!empty($this->request->data['BACKGROUND_PICTURE']['name']))
    {
        $fileName = $this->request->data['BACKGROUND_PICTURE']['name'];
        $uploadPath = WWW_ROOT.'img/background_picture/';
        $uploadFile = $uploadPath.$fileName;

        if(move_uploaded_file($this->request->data['BACKGROUND_PICTURE']['tmp_name'],$uploadFile))
            {
                $store['BACKGROUND_PICTURE'] = $uploadFile;
            }
    }

    // now do the save
    if ($this->Stores->save($store)) {
        $setStatus = 1;
        $message = 'The store has been saved.';

        if($setStatus == 1){
            $this->loadComponent('General');
            $this->loadModel('MasterFile.Addresss');
            $setStatus = 1;
            $address = $this->Addresss->newEntity();
            //dd($this->request->data);

            $this->request->data['Address']['LINE1'] = $this->request->data['LINE1'];
            $this->request->data['Address']['LINE2'] = $this->request->data['LINE2'];
            $this->request->data['Address']['LINE3'] = $this->request->data['LINE3'];

            //dd($this->request->data['Address']);
           
            $connection = ConnectionManager::get('ora');
            $connection->begin();
            $address = $this->Addresss->patchEntity($address, $this->request->data['Address']);

            // dd($address);
            // now do the save
            if ($this->Addresss->save($address)) {
                $setStatus = 1;
                $message = 'The store has been saved.';
            }else{
                $setStatus = 0;
                $message = 'The store could not be saved. Please, try again.';
            }

            $this->Flash->set(__($message));

        }
    }else{
        $setStatus = 0;
        $message = 'The store could not be saved. Please, try again.';
    }

    $this->Flash->set(__($message));

    if($setStatus){
        $connection->commit();
        return $this->redirect(['action' => 'index']);
    }else {
        $connection->rollback();
    }
}

$this->set(compact('store'));
$this->set('_serialize', ['store']);

}

What should i do?
Thank you for your help!

2 Likes
2

I have the same problem. Any clue what the problem was?