mod_session_dbd and php $_SESSION have nothing to do with each other and php has its own session management system.
If you can better explain what you are trying to do, someone might be able to give you a recommendation for whether to use mod_session or php session. Also, the Comments section on the Apache manual pages<http://httpd.apache.org/docs/trunk/mod/mod_session_dbd.html#comments_section>is NOT for asking questions like this. Please don't do it again. - Y On Tue, Apr 29, 2014 at 12:14 AM, Билгүүн Ө <bilguu...@statebank.mn> wrote: > *From:* Билгүүн Ө [mailto:bilguu...@statebank.mn] > *Sent:* Tuesday, April 29, 2014 12:03 PM > *To:* 'users-...@httpd.apache.org' > *Subject:* Question > > > > Dear everyone > > I'm trying to use mo_session_db, but i cant. I'm using mysql-14.14, > apache-2.4.9 and php-5.5.11. > > I create database named session_db, and table named SESSION which created > by query CREATE TABLE SESSION ( id VARCHAR(32) NOT NULL COMMENT 'Stores the > Session ID', access INT(10) UNSIGNED NOT NULL, data TEXT, PRIMARY KEY > (`id`) ) ENGINE=INNODB ROW_FORMAT=DEFAULT; > > My mod_session_dbd.conf is: > > Session On > > SessionDBDCookieName session path=/ > > SessionDBDCookieRemove Off > > SessionDBDPerUser On > > SessionDBDDeleteLabel deletesession > > SessionDBDInsertLabel insertsession > > SessionDBDSelectLabel selectsession > > SessionDBDUpdateLabel updatesession > > DBDriver mysql > > DBDParams "host=<ip address x.x.x.x/localhost>, port=3306, user=root, > password=<password>, dbname=session_db" > > DBDExptime 300 > > DBDPrepareSQL "delete from SESSION where id = %s" deletesession > > DBDPrepareSQL "update SESSION set data = %s, access = %lld, id = %s where > id = %s" updatesession > > DBDPrepareSQL "insert into SESSION (id, access, data) values (%s, %lld, > %s)" insertsession > > DBDPrepareSQL "select data from SESSION where id = %s and (access = 0 or > access > %lld)" selectsession > > DBDPrepareSQL "delete from SESSION where access != 0 and access < %lld" > cleansession > > > > I tested by store the session but it could not store in sql. My test > pages are: > > > > #index.html > > <form action="session.php" method="get"> > > Value:<input type="text" name="view"/> > > <input type="submit" value="Submit"/> > > </form> > > > > #session.php > > session_start(); > > if(isset($_GET['view'])) > > { $_SESSION['view'] = $_GET['view']; > > echo "Saved in SESSION<br/>"; > > echo "<a href=link.php>Link</a><br/>"; > > echo "<a href=index.html>Back</a>"; > > } > > else > > { echo "Could not save in SESSION<br/>"; > > echo "<a href=index.html>Back</a>"; > > } > > #link.php > > session_start(); > > if(isset($_SESSION['view'])) > > { echo"Session: ". $_SESSION['view']."<br/>"; > > echo "<a href=clear.php>Clear cookie</a><br/>"; > > } > > else > > { echo "There is no cookie<br/>"; } > > > > #clear.php > > session_start(); > > if(isset($_SESSION['view'])) > > { unset($_SESSION['view']); > > echo "cookie cleared<br/><br/>"; > > } > > else{ echo "there has not been saved cookie<br/>"; } > > > > Is there any problem in my config or testing pages. Sorry for my bad > english > > > > [image: line] > > Хүндэтгэсэн > > Ө.Билгүүн > > Системийн администратор > > МТ Системийн хэлтэс > > > > Мэйл хаяг | bilguu...@sbank.mn; bilguu...@statebank.mn > > Вэб хуудас | www.statebank.mn > > > > [image: state-logo] > > *Танд санхүүгийн үйлчилгээг эрсдэлгүй хүргэнэ.* > > >
