Hi,

I have a small web application that allows a user to login.
The user is a class object and has some methods like ->login($dblnk), -> ....
For these methods, it uses a resource variable that is the link to the database so it can perform some queries on it.
I want to store the instance of the user class in a $_SESSION['user'] variable but since session variables are not allowed to hold resources, it doesn't work and I get an error that indicates the resource is an invalid mysql resource.

I tried to work around this by not holding the resource variable in the class anymore and by passing it each time to the methods respectivly. But alas, I always get this same error.

Is there some way around this or is it just completely impossible to have methods that want to perform queries? I know that it works if I don't hold the class instance in a $_SESSION variable but then I have to recreate the instance every time.

Maybe I can write some function external to the class (so it's no longer in the $_session) that handles all queries and is called from the user class but that means quit a lot of work.

So any advice or suggestions are welcome.

regards,
Lieven

AFAIK (and someone please correct me if I'm wrong), there is not a way to share a resource between separate calls to the web server, simple due to the stateless nature of web page serving. Although DB connections are somewhat expensive (time/processing, etc) to initiate, I believe that per-script initiation is your only course of action.

As long as the script initiates the connection only once at the start of the script and uses this open connection for the duration of the script execution, you should be fine.

Thanks, I know there is something like a persistant db connection but I prefer not to use it.

So I create another class that handles all database manipulations with methods to connect and issue queries. It will then return the retrieved rows (if any) in an array format. Or it returns true or false like the result of the query.
This class will not have to be stored in a $_SESSION variable so it should be no problem.

thanks,
Lieven