SitePoint Sponsor

User Tag List

Results 1 to 8 of 8

Thread: secure session

  1. #1
    SitePoint Addict
    Join Date
    Dec 2011
    Posts
    221
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    secure session

    Greetings!

    I'm thinking of a secure sessions and I'm confused what data to save in my database.

    session_id, ipaddress,login_date,status..Is that all?

    thank you in advance.

  2. #2
    SitePoint Wizard silver trophybronze trophy Cups's Avatar
    Join Date
    Oct 2006
    Location
    France, deep rural.
    Posts
    6,869
    Mentioned
    17 Post(s)
    Tagged
    1 Thread(s)
    Session data which is also stored in a database is not inherently more secure than plain old sessions, but at least the session data lives on past the normal session data cleanup time.

    I'm not exactly sure of what you are asking, but this old project might give you some other ideas Sessionara.

  3. #3
    SitePoint Addict
    Join Date
    Dec 2011
    Posts
    221
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Sorry for not being clear. I'm asking for fields that I can use in my table, I'm using sqlsrv driver. Thank you for the response.

  4. #4
    Programming Since 1978 silver trophybronze trophy felgall's Avatar
    Join Date
    Sep 2005
    Location
    Sydney, NSW, Australia
    Posts
    16,863
    Mentioned
    25 Post(s)
    Tagged
    1 Thread(s)
    The firelds that you would save in the table would be whatever fields that the session uses. This would vary from one project to the next, there would not be any common list of fields.
    Stephen J Chapman

    javascriptexample.net, Book Reviews, follow me on Twitter
    HTML Help, CSS Help, JavaScript Help, PHP/mySQL Help, blog
    <input name="html5" type="text" required pattern="^$">

  5. #5
    SitePoint Addict
    Join Date
    Dec 2011
    Posts
    221
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    How about my proposed field, would that be ok? I'm making a simple inventory system.

    id,session_id, ipaddress,login_date,status

    my status if s/he is active or not.

  6. #6
    . shoooo... silver trophy logic_earth's Avatar
    Join Date
    Oct 2005
    Location
    CA
    Posts
    9,013
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)
    Depends on your project and what you are going to do with them...Its kinda pointless to ask us since we don't know the system you are making. We can pull a random guess from our behind but that wouldn't be very useful. All in all, your question is way to vague for us to answer in any meaningful way.
    Logic without the fatal effects.
    All code snippets are licensed under WTFPL.


  7. #7
    SitePoint Addict
    Join Date
    Dec 2011
    Posts
    221
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Sorry for that. I'm making an inventory system for our computer laboratories. thank you.

  8. #8
    SitePoint Wizard silver trophybronze trophy Cups's Avatar
    Join Date
    Oct 2006
    Location
    France, deep rural.
    Posts
    6,869
    Mentioned
    17 Post(s)
    Tagged
    1 Thread(s)
    If you explained why you want to permanently store some of the session variables in a table, and how imagine your inventory system will benefit from having them, then you might elicit some ideas from us about the best way to go about it.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •