Gazan Posted January 27, 2009 Share Posted January 27, 2009 I want to make it possible for me to view my guests/users activity on my site using session. The problem is, i have to time it out so they arent staying on the same page according to the session, forever. I need to timeout the session, and after that, i need to update the activity database IF the session with the IP is timed out. How do i do that? Another question, i want to create a mysql search function. on tutorials i've read that you've got to use the LIKE statement in the sql query, but that only results in a complete match of the input, and the result.. Like, i wan't to make it possible for people to type the first three letters of a username, and then the db retrieves the results that matches the request.. Such as, searching for "ph" will give the results "php". Do i have to explode the results and then.. whoa? Thanks Quote Link to comment Share on other sites More sharing options...
cooldude832 Posted January 27, 2009 Share Posted January 27, 2009 If you want to track user's activities on your site you a MySQL table and don't read the session info. Just record the UserID, IP, Date and Page/Action. What you are trying to do makes no sense for your goals Quote Link to comment Share on other sites More sharing options...
Gazan Posted January 27, 2009 Author Share Posted January 27, 2009 You pretty much answered the question.. Sorry, bad at explaining. Thanks alot. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.