Sessions?? Vincent you there?

[Anon]

OK I decided on breaking the ice and trying sessions. Now cool I got it to pass a var across the pages but what if I want to alter this var and then pass it...don't I have to keep $session_var = "my_var" right below session_start(); ? For example:

<PRE>

<?php

      //globals.php 

session_start();
$sess_var = "tableChoice"; <---i want this to pass $tableName to next page?
session_register("sess_var");

$hostName = "xxxxx"; // Where MySQL is running.
$userName = "xxxx"; // user name needed to connect.
$password = "xxxx"; // password for MySQL authentication.
$databaseName = "xxxxx"; // database name.

switch ($tableChoice) { 

                               case "c": 
                                           $tableName="MyTable"; 
                                        break; 
                               case "r": 
                                           $tableName="YourTable"; 
                                        break; 
                               case "s": 
                                           $tableName="OurTable"; 
                                        break; 
                                default: 
                                           $tableName="none"; 
                                        break; 
                               } 

?>

</PRE>

Now in my next page I use:
<PRE>
<?php

       session_start(); 

   $selectStmt = "SELECT * FROM $sess_var WHERE ROWID=$rowid " ; 
                         . 
                         . 
                         . 
                         . 

?>
</PRE>

Obviously this isn't working and I know it's because I'm not directly passing the
variable tableName...through tableChoice....what I think I need to do is...

<PRE>
session_start();

$sess_var = switch ("tableChoice") {

                                            case "c": 
                                                       $tableName="MyTable"; 
                                                   break; 
                                             case "r": 
                                                       $tableName="YourTable"; 
                                                   break; 
                                             case "s": 
                                                      $tableName="OurTable"; 
                                                   break; 
                                               default: 
                                                      $tableName="none"; 
                                                   break; 
                                             } 

session_register("sess_var");

                         $hostName = "xxxxx"; // Where MySQL is running. 
                         $userName = "xxxx"; // user name needed to connect. 
                         $password = "xxxx"; // password for MySQL authentication. 
                         $databaseName = "xxxxx"; // database name. 

?>

</PRE>

...but this don't work....so I'm missing some understanding here, what do I do? Thanks again in advance,

                              Marcel.

[Anon]

Update to above...$sess_var has to be initialized in an earlier page where the user actually selects the table in a drop down box.
<PRE>

<?php

session_start();
$sess_var = &$tableChoice; <---passing by reference to allow change.
session_register("sess_var");
.
.
.
.
.
($formValues) ? $formValues["state"] : "");
printf(" Zip/Postal Code: <INPUT TYPE=text SIZE=9 NAME=zip VALUE=\"%s\">",
($formValues) ? $formValues["zip"] : "");
printf(" Country: <INPUT TYPE=text SIZE=35 NAME=country VALUE=\"%s\">
<BR>\n", ($formValues) ? $formValues["country"] : "");
printf(" TABLE?: <SELECT NAME=tableChoice>");
printf("<OPTION VALUE=\"n\">none</OPTION>");
printf("<OPTION VALUE=\"c\">CrowSoup</OPTION>");
printf("<OPTION VALUE=\"r\">RantingRaven</OPTION>");
printf("<OPTION VALUE=\"s\">SaleBarn</OPTION>");
printf("</SELECT>");
.
.
.
.
.
?>
now $sess_var should be sent to globals.php where the $tableChoice is switched with the tableName value, finally all this is passed to another page call it modify_table.php where the tableName=($sess_var) is passed to the mysql query as the table to SELECT. Now, the question how? I keep getting an error that says Warning: Cannot send session cache limiter - headers already sent by (output started at common.php:111) in globals.php on line 3, which tells me I got the cart before the horse! Any help much appreciated.

Marcel.

[Anon]

Ok I'm guessing this is what you want.

session_start();
$sess_var = "tableChoice";
session_register($sess_var);

This would register the variable $tableChoice in the session, whereas what you had was resistering the variable that held the string "tableChoice". Now does it work?

[Anon]

eh, this is not going to do what you want.

you assign the string "tableChoice" to the
variable $sess_var which is registered as
a session variable (session_register("sess_var")😉

so that is EXACTLY what you are going to see
on the next page: $sess_var holding the
string "tableChoice".

I think what you want is the following:

--> page1.php <--
session_start();
session_register("sess_var");

<.... choose the tablename here ....>

$sess_var = $tableName;

--> page2.php <--
session_start();

$selectStmt = "SELECT * FROM $sess_var WHERE ROWID=$rowid " ;

this will give the desired result.

(at least I -think- this is what you want)

^_

• Vincent

[Anon]

You're right it didn't do what I wanted it to do. But I tried yours, again, and still no go.

Help me understand something...after the $sess_var is registered it is written to a file and can then be re-called as long as I use the session_start(); function correct?

OK...what causes the error: Warning: Cannot send session cache limiter - headers already sent by (output started at common.php:111) in globals.php on line 2...is it not because the header already has the sess_var information in it? And if so...then I must be passing it already? Right?

Ok answer that for now while I dig some more. Thanks Vincent, I appreciate your straight forward answers. 🙂 And I do read the manuals...and the columns, and more! hehehehe...

    Marcel.

[Anon]

Nope Shaun didn't work?? Because I use a hidden/post to first pass this page to the add page and then modify or select the tableName from a case statement in theis next page, I think I'm creating two instances of the sess_var and therefore getting the error I describe to Vincent...what do you think?

Marcel.

[Anon]

Well that little error would mean that the file globals.php already sent some text to the user's browser, maybe it might just be a space outside of the <?php ?> blocks, that can be enough to screw up sessions.

The session, as with any header stuff, has to be sent before any other text, if any text even a space is sent it will produce an error.

[Anon]

Could this error be caused from a post before the session register?

Before the globals is called, a file called common is "required" by add.php, common posts the selection from the forms drop down box to add.php. Now this is where it all comes together add.php "requires" globals.php, where the $tableName is registered into the $sess_var...then $sess_var "hopefully" holds the $tableName to pass to the other scripts...ie:modify, delete. But all I get is first that error and second $tableName=none??

And there is no blank spaces?
<?php
session_start();
$sess_var = "tableChoice";
session_register("sess_var");
.....more code after this.......
.
.
.
?>

[Anon]

Sort of related...

My session vars work in IE but not in netscape. I see the session ID passed around but the registered vars don't seem to be set. Are there obvious things that need to be considered for netscape. My vars echo to the screen in IE but are blank in netscape.

Thanks
Randy
[e-mail]

[Anon]

Hey maybe that's what my problem is!? I'm using Netscape and can't get it to work either. Didn't even check with IE...hmmmmm..so what you think Vincent, any ideas??

Marcel.