StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PONew $_SESSION variable not created after query?
text
Body
copied!<p>I'm trying to build a login process where, by using $_SESSION variables, the login credentials of the user are stored and used to show their relevant data from the database on screen (i.e. they will only see the school data that they work for).</p> <pre><code> <?php session_start(); if(!isset($_SESSION['Initials'], $_SESSION['Surname'])) { $host = "xxx"; $username = "xxx"; $password = "xxx"; $database_name = "xxx"; $table_name = "xxx"; mysql_connect($host, $username, $password) OR die("Can't connect"); mysql_select_db($database_name) OR die("Can't connect to Database"); $query = "SELECT Class FROM $table_name WHERE Initials = '". $_SESSION['Initials']."' AND staff LIKE '%".$_SESSION['Surname']."'"; $result = mysql_query($query); $class = mysql_fetch_array($result); $count = mysql_num_rows($result); if($count === NULL) { echo "ERROR"; } else { $_SESSION['Class'] = $result; echo "Class added to sessions"; } } ?> </code></pre> <p>My initial problem where the query couldn't recognize the session variables was easily solved by adding the correct brackets for the if-statement. My next problem that has arisen here is that even though the query should be successfull (I don't receive an error message saying 'ERROR' when the $count is either FALSE or NULL) it's not creating the result array into a new session, because when I print the session array on a new page it's still only carrying over the 'Initials' and 'Surname' sessions.</p> <p>What do I need to change to my query, or post-query process in order for that array (because it's bound to throw up multiple results) to be made into a new session?</p> <p>Many thanks for the answers to my initial problem!</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

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