8000 Merge pull request #306 from thaberkern/pdo_session_cookbook_fixes · dustin10/symfony-docs@c765b6a · GitHub
[go: up one dir, main page]
Skip to content
8000

Commit c765b6a

Browse files
weaverryanweaverryan
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

File tree

1 file changed

+38
-0
lines changed

1 file changed

+38
-0
lines changed

‎cookbook/configuration/pdo_session_storage.rst

Lines 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