Databases
StackOverflow2013
Postsdbo
PORetrieving $_SESSION values After PHP Redirect
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PORetrieving $_SESSION values After PHP Redirect
    primarykey
    data
    text
    <p>This should be an easy PHP mySQL question (I'm assuming it's sort of PHP and mySQL 101 but I'm having trouble finding an answer)...</p> <p>I have a registration form I've created and when the form is filled out and submitted it posts to a register_user.php page. The code on that page is this:</p> <pre><code>&lt;?php $con = mysql_connect("my_host","my_username","my_password"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("my_db", $con); // username and password sent from form //NEVER Remove the mysql_real_escape_string. Else there could be an Sql-Injection! $firstname=mysql_real_escape_string($_POST['firstname']); $lastname=mysql_real_escape_string($_POST['lastname']); $email=mysql_real_escape_string($_POST['email']); $password=mysql_real_escape_string($_POST['password']); $sql="INSERT INTO my_table (firstName, lastName, email, password) VALUES ('$_POST[firstname]','$_POST[lastname]','$_POST[email]', '$_POST[password]')"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } session_start(); // Register $myusername, $mypassword and redirect to file "profile.php" $_SESSION['firstname']='$_POST[firstname]'; $_SESSION['lastname']='$_POST[lastname]'; $_SESSION['email']='$_POST[email]'; $_SESSION['password']='$_POST[password]'; header("location:profile.php"); ?&gt; </code></pre> <p>As you can see, it redirects to a page called profile.php . On profile.php I'm trying to echo out the session variables by saying:</p> <pre><code>&lt;?php echo "Hello". $_SESSION['firstname']; ?&gt; </code></pre> <p>I'm assuming the variable loses it's value upon the redirect from register_user.php to profile.php (at least this is what I gather from my research thus far). I'm thinking I have to use <code>session_start();</code> on the profile.php to declare the variables again but I don't know how to set the variables to the appropriate values. In register_user.php I was able to use the post values from the form on the previous page but by the time it redirects to profile.php I can no longer do that.</p> <p>Can someone please explain how I can retrieve those values on profile.php? (again I have a feeling this is a very basic question but I'm still learning so be gentle haha :) )</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USkylex
    1. USMillerMedia
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload