Ok - I think this is a little rediculous (for all you php folks)

Dev Shed Forums Sponsor:

June 19th, 2003, 04:25 PM

jpenn

Contributing User

Join Date: Jun 2002

Location: Washington, DC

Posts: 2,693

Time spent in forums: 5 h 41 m 10 sec
Reputation Power: 16

Ok - I think this is a little rediculous (for all you php folks)

I reported a bug to the php bug database. This was the exact post:

Subject:

Code:

Problem with session_set_save_handler() when connecting to db outside of obj

Message:

Code:

When connecting to the database inside the class object, everything
works fine with session_set_save_handler(). But, when connecting outside
of the class that holds the methods, php does'nt recognize there is an
active connection to the DB. Is this a known problem that I have
overlooked in the bug db?

I have tried everything, including passing the res id of the connection
into the session handler class but to no avail.

~ Thanks

How many people here can see from this message what is going on - or be able to tell from this what I am getting at - this is the simplest of all things to understand, is it not?

-----------------------------------------------------------

Post your replies and I will post what they came back with.

__________________
~ Joe Penn

June 19th, 2003, 04:57 PM

bcyde

Me likey breadsticks...

Join Date: Jan 2003

Location: Los Angeles

Posts: 1,189

Time spent in forums: 3 Days 1 h 12 m 58 sec
Reputation Power: 12

Sounds like:
1)you're using a class that stores your session vars in a DB
2)when your db connection code is in that class sessions work fine
3)when you open a db connection outside your class and try and pass the connection ID into the class so that it can be used for storing your info it doesn't work.

Is that right?

June 19th, 2003, 06:05 PM

Hero Zzyzzx

Join Date: Jul 2001

Location: Lynn, MA

Posts: 4,635

Time spent in forums: 4 Days 23 h 44 m 19 sec
Reputation Power: 77

They are connecting out of scope and expecting it to work. Correct?

June 19th, 2003, 06:35 PM

Viper_SB

Psycho Canadian

Join Date: Jan 2001

Location: Canada

Posts: 4,793

Time spent in forums: 4 Weeks 22 h 50 m 49 sec
Reputation Power: 437

Ya it's clear

June 19th, 2003, 08:19 PM

rod k

Apprentice Deity

Join Date: Jul 1999

Location: Niagara Falls (On the wrong side of the gorge)

Posts: 3,237

Time spent in forums: 4 m 8 sec
Reputation Power: 13

Quote:

They are connecting out of scope and expecting it to work

It SHOULD work. Scope has no meaning to DB connections. (Except in this case, evidently).

jpenn,
it really shouldn't matter... PHP should internally return the same connection on a subsequent connection to the same host,username & password (& database depending on the RDBMS used).

Check what resource ID is being returned in each and compare.

__________________
FSBO (For Sale By Owner) Realty

June 19th, 2003, 09:37 PM

jpenn

Contributing User

Join Date: Jun 2002

Location: Washington, DC

Posts: 2,693

Time spent in forums: 5 h 41 m 10 sec
Reputation Power: 16

Quote:

hehe - thats the bug Rod - it should'nt matter, but, it is not working when connecting outside of the class. So, this is how the sess_open() method looks (being the first arg to session_set_save_handler()) -

PHP Code:


		
			
function sess_open( $a, $b )

    {

        $this->resource = @$this->db['connection']( $this->db['host'], $this->db['user'], $this->db['pass'] ) or 

        $this->error( mysql_error() );

        @mysql_select_db( $this->db['dbas'], $this->resource ) or $this->error( 'Could Not Select DB' );

        return( $this->resource );

    }

Ok - that is the open method that is passed to the function for setting the custom session handler - every thing works fine on this, as the connection is explicitly made within the method itself.

Now, if removing the db connection outside this method (even if it is still in the same class) it will not register the session handler.

So - the bug is this. How, can one use a db abstraction/connection library while using the custom session handling capabilities.

This is the thing - the custom session handler needs to work with sub classes depending on what database is being used ->

PHP Code:


		
			
class session

{



}

class mysql_session extends session

{



}

class fb_session extends session

{



}

class pgre_session extends session

{



}

I am sure it is nothing to do with the connection resource - for some reason if the connection is not made within the sess_open() method - the whole session handler fails.

To get an idea of what I mean - you can get the class -> http://www.cheetah-soft.com/csh/ - remove the connection functions to outside the class and watch it not work.

-----------------------------------

Hehe - I had asked if it was a clear question becuase the yahoo in the bug department seems to think it was not clear - I thought it was

June 19th, 2003, 09:41 PM

jpenn

Contributing User

Join Date: Jun 2002

Location: Washington, DC

Posts: 2,693

Time spent in forums: 5 h 41 m 10 sec
Reputation Power: 16

PS: bcyde - that is exactly what it is. Apparently the guy that reviewed the bug does'nt understand english maybe...

June 19th, 2003, 10:49 PM

a.koepke

Second highest poster :p

Dev Shed God 5th Plane (7000 - 7499 posts)

Join Date: Jul 2001

Posts: 7,323

Time spent in forums: 8 h 11 m 27 sec
Reputation Power: 27

Hehe, just looked up the bug - what a tool

July 7th, 2003, 08:16 PM

jpenn

Contributing User

Join Date: Jun 2002

Location: Washington, DC

Posts: 2,693

Time spent in forums: 5 h 41 m 10 sec
Reputation Power: 16

%&#$*# - WTH - man, I can not understand these people. How can you have people working on bugs that can't even understand a simple dam post.

Man - I am fustrated about this. This thing is still going on and I am still trying to explain to this guy what the problem is. I feel like I am trying to explain the difference between single quotes and double quotes to a newbie.

Look at the bug in full and give me your take on it: http://bugs.php.net/bug.php?id=24252

#10

July 8th, 2003, 12:29 AM

SammyK

Happy Monkey

Dev Shed Intermediate (1500 - 1999 posts)

Join Date: Nov 2001

Location: UK (University of Kentucky)

Posts: 1,810

Time spent in forums: 3 Days 22 h 49 m 14 sec
Reputation Power: 41

I don't know what session_set_save_handler() means, but let me see if I understand:

If you connect to the DB out side of the class that session_set_save_handler() is in, then session_set_save_handler() no workie. HOWEVER, if you connect to the DB inside of the class that session_set_save_handler() is in, it workie.

Is that right?

__________________

#11

July 8th, 2003, 07:20 AM

jpenn

Contributing User

Join Date: Jun 2002

Location: Washington, DC

Posts: 2,693

Time spent in forums: 5 h 41 m 10 sec
Reputation Power: 16

You got farther than he did by reading the bug for the first time. Yes, that is pretty much correct. session_set_save_handler() takes 6 arguments - they are all function names or method names. open,close,read,write,destroy,gc - if you do not connect to the db within the open method, it will fail.

I still can not understand what is so hard to understand about the bug post.

#12

July 8th, 2003, 08:00 AM

Onslaught

/(bb|[^b]{2})/

Join Date: Nov 2001

Location: Somewhere in the great unknown

Posts: 4,840

Time spent in forums: 2 Days 36 m 16 sec
Reputation Power: 88

Just face it, those two are complete morons.
The post is simple and to the point. You couldn't do much more explaining than what you already have with it.

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: