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

**URL:** <https://discourse.cakephp.org/t/i-cant-save-to-database-but-the-message-show-the-data-has-been-save/4658>\
**Category:** Need Help\
**Created:** [August 2, 2018, 1:53am UTC](https://discourse.cakephp.org/t/i-cant-save-to-database-but-the-message-show-the-data-has-been-save/4658 "2018-08-02T01:53:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ratriprat](https://avatars.discourse-cdn.com/v4/letter/r/ba8739/32.png) [@ratriprat](https://discourse.cakephp.org/u/ratriprat)\
**Post date:** [August 2, 2018, 1:53am UTC](https://discourse.cakephp.org/t/i-cant-save-to-database-but-the-message-show-the-data-has-been-save/4658/1 "2018-08-02T01:53:19Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![ChrisTerraSoftware](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/christerrasoftware/32/2269_2.png) [@ChrisTerraSoftware](https://discourse.cakephp.org/u/ChrisTerraSoftware)\
**Post date:** [June 27, 2022, 5:29pm UTC](https://discourse.cakephp.org/t/i-cant-save-to-database-but-the-message-show-the-data-has-been-save/4658/2 "2022-06-27T17:29:20Z")

</div>

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