Hi Andrew - I didn't mean to ignore your reply...
Here is your earlier post -
" The fact that you can echo the $_SESSION information on the same page and
they contain the correct values suggest to me that the issue of MySQL/MSSQL is
a red herring. I would look into things like the value for register_globals to
make sure you don't have a global variable stepping on some of your session
Register_globals is off in our php.ini file.
Again, I am fairly new to PHP. I guess I don't understand how a global variable
can "step on" a session variable if the only thing I'm assigning anywhere in my
application to said session variable is a value from a database query. When
PHP changes pages, it might be arbitrarily assigning some value to a session
variable, even though I'm not telling it to?
Can you please explain this to me? Thanks -
From: Andrew Ballard [mailto:aball...@gmail.com]
Sent: Thursday, September 16, 2010 2:21 PM
To: Cheryl Sullivan
Cc: Tommy Pham; email@example.com
Subject: Re: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from
MYSQL Query stick
On Thu, Sep 16, 2010 at 10:26 AM, Cheryl Sullivan <csull...@shh.org> wrote:
> When I echo all five $_SESSION vars from here, they are all populated.
> Then I can either redirect or form post to the next page. In either
> case, the $_SESSION vars populated from SQL Server ( the SSN and Cost
> Center vars) are blank when I echo them on the destination page.
On Thu, Sep 16, 2010 at 2:12 PM, Cheryl Sullivan <csull...@shh.org> wrote:
> Tommy - I ran phpinfo() but I don't see anything in it referencing
> MSSQL or SQLSRV. I have included all the references to "sql" I see
> below, but the only references I see to databases are to mySQL and
> SQLLite. Unfortunately I don't have any control over how service-packed
> the database server is. Is there something in SP 4 for SQL Server 2000
> that is supposed to fix the issue I'm having, I may be able to plead my
> case for getting the latest SP. Is this the case, do you know?
Again, I ask - based on what you said earlier - are you sure this is
even a database issue? You said that when you echo the values in your
$_SESSION array AFTER reading them from the database they are there,
and you only lose them on the next request after either a redirect or
a manual form POST. If the values are getting into $_SESSION correctly
within this page, your issue is not related to the database at all.
Am I misunderstanding you?
Notice: This communication, including attachments, may contain information that
is confidential and protected. It constitutes non-public information intended
to be conveyed only to the designated recipient(s). If you believe that you
have received this communication in error, please notify the sender immediately
by return e-mail and promptly delete this e-mail, including attachments without
reading or saving them in any manner. The unauthorized use, dissemination,
distribution, or reproduction of this e-mail, including attachments, is
prohibited and may be unlawful. Thank you.
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php