# How can i store session in database usign cakephp 5.6

**URL:** <https://discourse.cakephp.org/t/how-can-i-store-session-in-database-usign-cakephp-5-6/2534>\
**Category:** Need Help\
**Created:** [May 8, 2017, 11:20am UTC](https://discourse.cakephp.org/t/how-can-i-store-session-in-database-usign-cakephp-5-6/2534 "2017-05-08T11:20:37Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![hdlambavala](https://avatars.discourse-cdn.com/v4/letter/h/e47c2d/32.png) [@hdlambavala](https://discourse.cakephp.org/u/hdlambavala)\
**Post date:** [May 8, 2017, 11:20am UTC](https://discourse.cakephp.org/t/how-can-i-store-session-in-database-usign-cakephp-5-6/2534/1 "2017-05-08T11:20:37Z")

</div>

I have done both configuration and created database name as cake.session. but still now i can not store session value in data base.  
Anyone can help me

---

<div class="post-metadata">

**Author:** ![rrd](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/rrd/32/113_2.png) [@rrd](https://discourse.cakephp.org/u/rrd)\
**Post date:** [May 8, 2017, 1:06pm UTC](https://discourse.cakephp.org/t/how-can-i-store-session-in-database-usign-cakephp-5-6/2534/2 "2017-05-08T13:06:44Z")

</div>

Current CakePHP version is 3.4. There is no version 5.6. Please check your version number. Please share part of your config file and explain your problem in more details.

---

<div class="post-metadata">

**Author:** ![hdlambavala](https://avatars.discourse-cdn.com/v4/letter/h/e47c2d/32.png) [@hdlambavala](https://discourse.cakephp.org/u/hdlambavala)\
**Post date:** [May 8, 2017, 1:48pm UTC](https://discourse.cakephp.org/t/how-can-i-store-session-in-database-usign-cakephp-5-6/2534/3 "2017-05-08T13:48:54Z")

</div>

Thank you for your reply.  
And sorry for wrong information about cakephp version.  
I am working on 2.x cakephp version.  
I have created cake\_sessions table as following

CREATE TABLE cake\_sessions ( id varchar(255) NOT NULL default ‘’, data text, expires int(11) default NULL, PRIMARY KEY (id));

I have configure in core.php [file.as](http://file.as) following.

\<?php Configure::write('Session', array( 'defaults' =\> 'database', 'handler' =\> array( 'model' =\> 'cake\_sessions' ) )); I have created in model like CakeSession.php. But still now its can not store the session in database.

---

<div class="post-metadata">

**Author:** ![rrd](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/rrd/32/113_2.png) [@rrd](https://discourse.cakephp.org/u/rrd)\
**Post date:** [May 8, 2017, 2:10pm UTC](https://discourse.cakephp.org/t/how-can-i-store-session-in-database-usign-cakephp-5-6/2534/4 "2017-05-08T14:10:09Z")

</div>

In `core.php` `Configure::write('Session', array('defaults' => 'database'));` should be enough.

You do not need `app/Model/CakeSesions.php`, nor a dedicated Controller for the sessions as Cake does everything nicely without these files.

Than you should add session to your components and helpers.

`AppController.php`

```
class AppController extends Controller
{
public $components = array('Session');
public $helpers = array('Session');
//rest of your code

```

After this in any controller you can write and read session.

`$this->Session->write('vaiableName', 'value');`  
`echo $this->Session->read('vaiableName'); //shold be "value"`

---

<div class="post-metadata">

**Author:** ![hdlambavala](https://avatars.discourse-cdn.com/v4/letter/h/e47c2d/32.png) [@hdlambavala](https://discourse.cakephp.org/u/hdlambavala)\
**Post date:** [May 8, 2017, 2:51pm UTC](https://discourse.cakephp.org/t/how-can-i-store-session-in-database-usign-cakephp-5-6/2534/5 "2017-05-08T14:51:05Z")

</div>

Thank you sir for reply.  
I will implement and then let you know.

---

<div class="post-metadata">

**Author:** ![hdlambavala](https://avatars.discourse-cdn.com/v4/letter/h/e47c2d/32.png) [@hdlambavala](https://discourse.cakephp.org/u/hdlambavala)\
**Post date:** [May 9, 2017, 4:35am UTC](https://discourse.cakephp.org/t/how-can-i-store-session-in-database-usign-cakephp-5-6/2534/7 "2017-05-09T04:35:02Z")

</div>

Hello sir,  
I have done same configuration but still now it is not storing session data in database.

This code is for my core.php

\<?php Configure::write('debug', 2); Configure::write('Error', array( 'handler' =\> 'ErrorHandler::handleError', 'level' =\> E\_ALL & ~E\_DEPRECATED, 'trace' =\> true )); Configure::write('Exception', array( 'handler' =\> 'ErrorHandler::handleException', 'renderer' =\> 'ExceptionRenderer', 'log' =\> true )); Configure::write('App.encoding', 'UTF-8'); Configure::write('Session', array('defaults' =\> 'database')); Configure::write('Acl.classname', 'DbAcl'); Configure::write('Acl.database', 'default'); App::uses('MemcachedEngine', 'Memcached.Lib/Cache/Engine'); $engine = 'Memcached'; if (extension\_loaded('apc') && function\_exists('apc\_dec') && (php\_sapi\_name() !== 'cli' || ini\_get('apc.enable\_cli'))) { $engine = 'Apc'; } $duration = '+999 days'; Cache::config('\_cake\_core\_', array( 'engine' =\> $engine, 'prefix' =\> $prefix . 'cake\_core\_school\_', 'path' =\> CACHE . 'persistent' . DS, //'serialize' =\> ($engine === 'File'), 'duration' =\> $duration, 'lock' =\> true, # !!! )); Cache::config('\_cake\_model\_', array( 'engine' =\> $engine, 'prefix' =\> $prefix . 'cake\_model\_school\_', 'path' =\> CACHE . 'models' . DS, //'serialize' =\> ($engine === 'File'), 'duration' =\> $duration )); Cache::config('default', array('engine' =\> 'Memcached')); Cache::config('default', array( 'engine' =\> 'Memcached', //[required] 'duration' =\> 3600, //[optional] 'probability' =\> 100, //[optional] 'prefix' =\> 'cake\_school\_', //[optional] prefix every cache file with this string 'servers' =\> array( '127.0.0.1:11211' // localhost, default port 11211 ), //[optional] 'persistent' =\> true, // [optional] set this to false for non-persistent connections 'compress' =\> false, // [optional] compress data in Memcache (slower, but uses less memory) )); And i have done for appcontroller same configuration. but still now not working.

---

<div class="post-metadata">

**Author:** ![PeterVARGA](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/petervarga/32/1928_2.png) [@PeterVARGA](https://discourse.cakephp.org/u/PeterVARGA)\
**Post date:** [November 2, 2020, 3:30pm UTC](https://discourse.cakephp.org/t/how-can-i-store-session-in-database-usign-cakephp-5-6/2534/8 "2020-11-02T15:30:07Z")

</div>

Hi rrd, is this approach also valid for CakePHP 4.1.4 [the current version]?

---

<div class="post-metadata">

**Author:** ![Zuluru](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/zuluru/32/1230_2.png) [@Zuluru](https://discourse.cakephp.org/u/Zuluru)\
**Post date:** [November 2, 2020, 3:35pm UTC](https://discourse.cakephp.org/t/how-can-i-store-session-in-database-usign-cakephp-5-6/2534/9 "2020-11-02T15:35:40Z")

</div>

[https://book.cakephp.org/4/en/development/sessions.html#database-sessions](https://book.cakephp.org/4/en/development/sessions.html#database-sessions) and [https://book.cakephp.org/4/en/development/sessions.html#accessing-the-session-object](https://book.cakephp.org/4/en/development/sessions.html#accessing-the-session-object) cover this. In short, basically yes.

---

<div class="post-metadata">

**Author:** ![rrd](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/rrd/32/113_2.png) [@rrd](https://discourse.cakephp.org/u/rrd)\
**Post date:** [November 3, 2020, 9:09am UTC](https://discourse.cakephp.org/t/how-can-i-store-session-in-database-usign-cakephp-5-6/2534/10 "2020-11-03T09:09:37Z")

</div>

It should.

We have a hungarian facebook group if you are interested 🙂

> **[Facebook Groups](https://www.facebook.com/groups/cakehu)**
>
> CakePHP Magyar has 45 members. Minden ami CakePHP... 
> 
> A bejegyzéseket indítsd egy hashtaggal, hogy lehessen látni mi a #téma

---

<div class="post-metadata">

**Author:** ![PeterVARGA](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/petervarga/32/1928_2.png) [@PeterVARGA](https://discourse.cakephp.org/u/PeterVARGA)\
**Post date:** [November 3, 2020, 9:22am UTC](https://discourse.cakephp.org/t/how-can-i-store-session-in-database-usign-cakephp-5-6/2534/11 "2020-11-03T09:22:37Z")

</div>

Thank you, nNo Facebook, no Twitter, no Instagram, no Youtube and nevertheless I am alive 😉

---

<div class="post-metadata">

**Author:** ![rrd](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/rrd/32/113_2.png) [@rrd](https://discourse.cakephp.org/u/rrd)\
**Post date:** [November 3, 2020, 9:40am UTC](https://discourse.cakephp.org/t/how-can-i-store-session-in-database-usign-cakephp-5-6/2534/12 "2020-11-03T09:40:21Z")

</div>

🙂 Like a psyhopat