dennismonsewicz Posted May 5, 2008 Share Posted May 5, 2008 session_start(); if($_POST['username']) { //If the form has been submitted include "sql.php"; $username = stripslashes($_POST['username']); $password = stripslashes($_POST['password']); $sql = "select * from tbl_name where username = " . $username . " and password = " . $password . ""; $result = mysql_query($sql); $count = mysql_num_rows($result); if($count == 1) { session_register("username"); session_register("password"); header("location: URL_GOES_HERE?username=" . $_SESSION['username'] . ""); } $sqlcount = "select COUNT(username) from tbl_name where username = '" . $_SESSION['username'] . "'"; $result = mysql_query($sqlcount)or die(mysql_error()); $downloadcount = "select COUNT(username) from tbl_name where username = '" . $_SESSION['username'] . "'"; $downloadresult = mysql_query($downloadcount)or die(mysql_error()); $downloadrow = mysql_fetch_array($downloadresult); $download_count = $downloadrow['COUNT(username)']; while($row = mysql_fetch_array($result)) { $upload_count = $row['COUNT(username)']; echo '<div class="login"> <p style="text-align: center;">Welcome, ' . ucwords($_SESSION['username']) . '</p> <p><a href="includes/logout.php">Logout?</a></p> <p><a href="index.php?username=' . $_SESSION['username'] . '">Home</a></p> <p><a href="myphotos.php?username=' . $_SESSION['username'] . '">My Photos (' . $upload_count . ')</a></p> <p><a href="mydownloads.php?username=' . $_SESSION['username'] . '">My Downloads (' . $download_count . ')</a></p> <p><a href="upload.php?username=' . $_SESSION['username'] . '">Upload An Image</a></p> <p><a href="change_password.php?username=' . $_SESSION['username'] . '&action=view">Change Password?</a></p> <div class="loginfooter" style="clear: both;"> </div> </div>'; } } else { //User isn't logged in and therefore User must login before proceding echo '<div class="login"> <p>Please Login to Utilize Your Account</p> <form action="index.php" method="post" name="loginform"> <p style="text-align: left; padding-left: 11px;">Username:</p> <input type="text" id="username" name="username" /> <p style="text-align: left; padding-left: 11px;">Password:</p> <input type="password" id="password" name="password" style="clear: right;" /> <input type="image" src="images/loginbutton.jpg" style="width: 66px; height: 33px; float: right; margin-right: 7px;" name="login" /> </form> <div class="loginfooter" style="clear: both;"> </div> </div>'; } Ok so heres my problem, The above code does not pass the username to the header and the session starts but there is no username that gets registered! any ideas? Quote Link to comment Share on other sites More sharing options...
revraz Posted May 5, 2008 Share Posted May 5, 2008 if($count == 1) { $_SESSION["username"] = $username; $_SESSION["password"] = $password; header("location: URL_GOES_HERE?username=" . $_SESSION['username'] . ""); } Quote Link to comment Share on other sites More sharing options...
dennismonsewicz Posted May 5, 2008 Author Share Posted May 5, 2008 that didn't work Quote Link to comment Share on other sites More sharing options...
revraz Posted May 5, 2008 Share Posted May 5, 2008 Post all of the code. Make sure your header is pointing to a URL that is on the same domain. Make sure that a session path is set in your php.ini file. Quote Link to comment Share on other sites More sharing options...
dennismonsewicz Posted May 5, 2008 Author Share Posted May 5, 2008 <?php session_start(); if($_POST['username']) { //If the form has been submitted include "sql.php"; $username = stripslashes($_POST['username']); $password = stripslashes($_POST['password']); $sql = "select * from users where username = " . $username . " and password = " . $password . ""; $result = mysql_query($sql); $count = mysql_num_rows($result); if($count == 1) { $_SESSION["username"] = $username; $_SESSION["password"] = $password; header("location: http://intranet.healthresources.net/hrstock/index.php?username=" . $_SESSION['username'] . ""); } $sqlcount = "select COUNT(username) from uploads where username = '" . $_SESSION['username'] . "'"; $result = mysql_query($sqlcount)or die(mysql_error()); $downloadcount = "select COUNT(username) from downloaded_images where username = '" . $_SESSION['username'] . "'"; $downloadresult = mysql_query($downloadcount)or die(mysql_error()); $downloadrow = mysql_fetch_array($downloadresult); $download_count = $downloadrow['COUNT(username)']; while($row = mysql_fetch_array($result)) { $upload_count = $row['COUNT(username)']; echo '<div class="login"> <p style="text-align: center;">Welcome, ' . ucwords($_SESSION['username']) . '</p> <p><a href="includes/logout.php">Logout?</a></p> <p><a href="index.php?username=' . $_SESSION['username'] . '">Home</a></p> <p><a href="myphotos.php?username=' . $_SESSION['username'] . '">My Photos (' . $upload_count . ')</a></p> <p><a href="mydownloads.php?username=' . $_SESSION['username'] . '">My Downloads (' . $download_count . ')</a></p> <p><a href="upload.php?username=' . $_SESSION['username'] . '">Upload An Image</a></p> <p><a href="change_password.php?username=' . $_SESSION['username'] . '&action=view">Change Password?</a></p> <div class="loginfooter" style="clear: both;"> </div> </div>'; } } else { //User isn't logged in and therefore User must login before proceding echo '<div class="login"> <p>Please Login to Utilize Your Account</p> <form action="index.php" method="post" name="loginform"> <p style="text-align: left; padding-left: 11px;">Username:</p> <input type="text" id="username" name="username" /> <p style="text-align: left; padding-left: 11px;">Password:</p> <input type="password" id="password" name="password" style="clear: right;" /> <input type="image" src="images/loginbutton.jpg" style="width: 66px; height: 33px; float: right; margin-right: 7px;" name="login" /> </form> <div class="loginfooter" style="clear: both;"> </div> </div>'; } ?> in the php.ini file what would i look for, to see about a session path? Quote Link to comment Share on other sites More sharing options...
dennismonsewicz Posted May 5, 2008 Author Share Posted May 5, 2008 ok i fixed my session problem, now i have a new problem session_start(); if($_POST["username"]) { //If the form has been submitted include "includes/sql.php"; $username = stripslashes($_POST['username']); $password = stripslashes($_POST['password']); $sql = "select * from users where username = '$username' and password = '$password'"; $result = mysql_query($sql); $count = mysql_num_rows($result); if($count == 1) { $_SESSION["username"] = $username; $_SESSION["password"] = $password; header("location: URL_GOES_HERE?username=" . $_SESSION['username'] . ""); if($_SESSION['username']) { $sqlcount = "select COUNT(username) from uploads where username = '" . $_SESSION['username'] . "'"; $result = mysql_query($sqlcount)or die(mysql_error()); $downloadcount = "select COUNT(username) from downloaded_images where username = '" . $_SESSION['username'] . "'"; $downloadresult = mysql_query($downloadcount)or die(mysql_error()); $downloadrow = mysql_fetch_array($downloadresult); $download_count = $downloadrow['COUNT(username)']; while($row = mysql_fetch_array($result)) { $upload_count = $row['COUNT(username)']; echo '<div class="login"> <p style="text-align: center;">Welcome, ' . ucwords($_SESSION['username']) . '</p> <p><a href="includes/logout.php">Logout?</a></p> <p><a href="index.php?username=' . $_SESSION['username'] . '">Home</a></p> <p><a href="myphotos.php?username=' . $_SESSION['username'] . '">My Photos (' . $upload_count . ')</a></p> <p><a href="mydownloads.php?username=' . $_SESSION['username'] . '">My Downloads (' . $download_count . ')</a></p> <p><a href="upload.php?username=' . $_SESSION['username'] . '">Upload An Image</a></p> <p><a href="change_password.php?username=' . $_SESSION['username'] . '&action=view">Change Password?</a></p> <div class="loginfooter" style="clear: both;"> </div> </div>'; } } } else { header("loaction: URL_GOES_HERE.php"); } } else { //User isn't logged in and therefore User must login before proceding echo '<div class="login"> <p>Please Login to Utilize Your Account</p> <form action="index.php" method="post" name="loginform"> <p style="text-align: left; padding-left: 11px;">Username:</p> <input type="text" id="username" name="username" /> <p style="text-align: left; padding-left: 11px;">Password:</p> <input type="password" id="password" name="password" style="clear: right;" /> <input type="image" src="images/loginbutton.jpg" style="width: 66px; height: 33px; float: right; margin-right: 7px;" name="login" /> </form> <div class="loginfooter" style="clear: both;"> </div> </div>'; } the login form keeps redisplaying and the control panel does not display. The form is in the last else statement. Any help? Quote Link to comment Share on other sites More sharing options...
revraz Posted May 5, 2008 Share Posted May 5, 2008 Look at your logic here if($count == 1) { $_SESSION["username"] = $username; $_SESSION["password"] = $password; header("location: URL_GOES_HERE?username=" . $_SESSION['username'] . ""); if($_SESSION['username']) { With this logic, your 2nd IF statement will never fire because your header should redirect. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.