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.
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.
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.
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.
How about my proposed field, would that be ok? I'm making a simple inventory system.
my status if s/he is active or not.
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.
Sorry for that. I'm making an inventory system for our computer laboratories. thank you.
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.