StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSimple PHP Session variables
primarykey
Id
8198597
data
AcceptedAnswerId
8198658
AnswerCount
3
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2011-11-20T00:52:11.620
FavoriteCount
0
LastActivityDate
2014-03-18T14:13:24.980
LastEditDate
2011-11-20T01:34:02.677
LastEditorUserId
81216
OwnerUserId
81216
ParentId
0
PostTypeId
1
Score
0
ViewCount
465
LastEditorDisplayName
text
Body
<p>I can't figure out why the following PHP won't work properly:</p> <pre><code> <?php //Authenticate user credentials function authenticate($name, $password) { $sql = "SELECT * FROM users WHERE username = '$name' AND password = '" . md5($password) . "'"; $result = mysql_query($sql); if ($row = mysql_fetch_array($result)) { //Successful login echo "Welcome back, " . $row['username'] . "!"; return true; } else { //Failed login echo "Invalid username or password"; return false; } } function addUser($name, $password) { $sql = "INSERT INTO users (username, role, password) VALUES ('$name', 'CHAIR', '". md5($password) . "');"; mysql_query($sql); } function createTables() { $sql = "CREATE TABLE Users ( Create table Users( username varchar(50) NOT NULL, role ENUM('CHAIR', 'FACULTY', 'STAFF') NOT NULL, password varchar(255) NOT NULL, email varchar(50) NOT NULL PRIMARY KEY, applicant_client_id varchar(50) NOT NULL, countries varchar(50), research_area varchar(255), numAssignedReviews TINYINT UNSIGNED, available varchar(50), workload FLOAT UNSIGNED );" ; mysql_query($sql); } session_start(); if (isset($_SESSION['loggedIn'])) { echo '<script> alert("LoggedIn is set") </script>'; $con = mysql_connect("localhost", "ttony21_Tony", "cse308"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("ttony21_GARS", $con); $name = $_POST["name"]; $password = $_POST["password"]; if (authenticate($name, $password)) { $_SESSION['loggedIn'] = true; } mysql_close($con); } else { $_SESSION['loggedIn'] = false; echo '<script> alert("LoggedIn is not set") </script>'; } ?> <!DOCTYPE html> <html lang="en-US"> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> <title>GARS</title> <style type="text/css"> body { text-align: center; min-width: 600px; } #wrapper { margin: 0 auto; width: 600px; text-align: left; } </style> <script type="text/javascript" src="jquery.js"></script> </head> <body> <div class = "wrapper"> <?php if ($_SESSION['loggedIn']) { echo ' <div class = "upload"> <form action="upload_file.php" method="post" enctype="multipart/form-data"> <label for="file">Filename:</label> <input type="file" name="file" id="file" /> <br /> <input type="submit" name="submit" value="Submit" /> </form> </div> '; } else { echo ' <div class = "login"> <form action = "/" id = "loginForm" method = "post"> <p> Username: <input type = "text" name = "name" /> <br /> Password: <input type = "password" name = "password" /> <br /> <input type = "submit" id= "submit"/> </p> </form> </div> '; } ?> </div> </body> </html> </code></pre> <p>There's a form: <code><form action = "/" id = "loginForm" method = "post"></code></p> <p>When I either submit the form, or refresh the page, it should alert me with the message "LoggedIn is set" correct? But I only get the message "LoggedIn is not set." </p> <p>I know that the session starts and the loggedIn is set properly, but I seem to lose the variable when I refresh the page or use the form, which shouldn't happen because it's a session variable right? </p> <p>I'm new to using them so any help would be appreciated.</p>
Tags
<php><session><variables>
Title
Simple PHP Session variables
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USTonyArra
UserOwnerUserId
1. USTonyArra
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
3. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COYou should really change your MySQL password! And md5() is no more secure, use sha1() with a random salt!
  singulars
  PostPostId
  POSimple PHP Session variables
  UserUserId
  USCodeZombie

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.