Hi! for the last week ive been trying to figure out how to store/use a php session via mysql.

Ive been writing a small games account system, which simply checks a username & md5 password against a Joomla Portal System database.

This in its self is working fine, though I would also like to log a according user session.

Ive been searching online and looking through Joomla code to see how its done, and so far drawn a blank, and basically don't understand sessions (though theirs plenty of various examples out their).

These are the following fields in the database I need to enter session information:

jos_session

  • username

  • time

  • session_id

  • guest

  • userid

  • usertype

  • gid

  • jaclplus

Username, userid, usertype, gid & jaclplus is brought from the user stored information, and I already have a query pulling that info accordingly on username/password check.

The problem is now im lost in regards to storing a session - ive tried using a session handler found on the web, though found it almost impossible to adjust.

Other standalone php pages will simply do a session check once the login page is working 🙂.

Anyhelp would be most appreciated!

Regards,

    um.. not exactly sure what you mean, but session_id(); will pull the session_id up for you

      Write a Reply...