Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Commit c765b6a

Browse filesBrowse files
committed
Merge pull request symfony#306 from thaberkern/pdo_session_cookbook_fixes
[cookbook] Added XML Configuration description to PDO Session Storage Article
2 parents b28453c + 48cc68d commit c765b6a
Copy full SHA for c765b6a

File tree

Expand file treeCollapse file tree

1 file changed

+38
-0
lines changed
Filter options
Expand file treeCollapse file tree

1 file changed

+38
-0
lines changed

‎cookbook/configuration/pdo_session_storage.rst

Copy file name to clipboardExpand all lines: cookbook/configuration/pdo_session_storage.rst
+38Lines changed: 38 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -43,6 +43,36 @@ configuration format of your choice):
4343
user: myuser
4444
password: mypassword
4545
46+
.. code-block:: xml
47+
48+
<!-- app/config/config.xml -->
49+
<framework:config>
50+
<framework:session storage-id="session.storage.pdo" default-locale="en" lifetime="3600" auto-start="true"/>
51+
</framework:config>
52+
53+
<parameters>
54+
<parameter key="pdo.db_options" type="collection">
55+
<parameter key="db_table">session</parameter>
56+
<parameter key="db_id_col">session_id</parameter>
57+
<parameter key="db_data_col">session_value</parameter>
58+
<parameter key="db_time_col">session_time</parameter>
59+
</parameter>
60+
<parameter key="pdo.options" />
61+
</parameters>
62+
63+
<services>
64+
<service id="pdo" class="PDO">
65+
<argument id="dsn">mysql:dbname=sf2demo</argument>
66+
<argument id="user">root</argument>
67+
<argument id="password">password</argument>
68+
</service>
69+
70+
<service id="session.storage.pdo" class="Symfony\Component\HttpFoundation\SessionStorage\PdoSessionStorage">
71+
<argument type="service" id="pdo" />
72+
<argument>%pdo.db_options%</argument>
73+
<argument>%pdo.options%</argument>
74+
</service>
75+
</services>
4676
4777
* ``db_table``: The name of the session table in your database
4878
* ``db_id_col``: The name of the id column in your session table (VARCHAR(255) or larger)
@@ -71,6 +101,14 @@ parameter.ini by referencing the database-related parameters defined there:
71101
user: %database_user%
72102
password: %database_password%
73103
104+
.. code-block:: xml
105+
106+
<service id="pdo" class="PDO">
107+
<argument id="dsn">mysql:dbname=%database_name%</argument>
108+
<argument id="user">%database_user%</argument>
109+
<argument id="password">%database_password%</argument>
110+
</service>
111+
74112
Example MySQL Statement
75113
-----------------------
76114

0 commit comments

Comments
0 (0)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.