I have this script, its a login script. Currently after logging in and checking the login it goes to accounts.php

Goes on top of the webpage:

PHP Code:

<?php
session_start();
if(!session_is_registered(myusername)){
header("location:accounts-login.php");
}
?>

Form:

PHP Code:

<form autocomplete="off" id="form" method="post" action="checklogin.php">
<h1>Login Form</h1>
<p>Please log in to the admin area to view logged accounts.</p>

<label>Username
<span class="small">Min. size 6 chars</span>
</label>
<input name="myusername" type="text" id="myusername" size="20" />


<label>Password
<span class="small">Min. size 6 chars</span>
</label>
<input name="mypassword" type="password" id="mypassword" size="20" />

<button name="submitBtn" type="submit"></button>
<div class="spacer"></div>

</form> 


checklogin.php

PHP Code:

<?php
require "inc/config.php";
// username and password sent from form
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];
// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
$sql="SELECT * FROM `admin` WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);
// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1)
{
// Register $myusername, $mypassword and redirect to file "accounts.php"
session_register("myusername");
session_register("mypassword");
header("location:accounts.php");
}
else 
{
header('Location:accounts-login.php');
}
?>

Lets say I was at contact.php, and I had no session, it would redirect me to accounts-login.php

after I login it takes me to accounts.php.

Accounts.php is like the index of the folder.

What I need is for it to take me back to the page I was viewing before.

Kind of like in vbulletin, if your viewing a thread and ur not logged in, when u login it takes u back to the thread.

Is that possible?

When you reach the login page, where the user is redirected if not logged in, save the path to the previous page (SERVER['HTTP_REFERER']) in a session. Be aware of, though, that the SERVER['HTTP_REFERER'] isn't always available, so you should check if it is set first. Then when the user has logged in redirect him the the stored page.

Store the current page in a session variable before you redirect:

PHP Code:

$_SESSION['prev_page'] = $_SERVER['REQUEST_URI']; 


Then redirect back to that page after the login in processed

PHP Code:

header('Location: ' . $_SESSION['prev_page']); 


Ugh... what??

Like:

PHP Code:

<?php
session_start();
$_SESSION['prev_page'] = $_SERVER['REQUEST_URI'];  
if(!session_is_registered(myusername)){
header("location:accounts-login.php");
}
?>

and

PHP Code:

 <?php
require "inc/config.php";
// username and password sent from form
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];
// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
$sql="SELECT * FROM `admin` WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);
// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1)
{
// Register $myusername, $mypassword and redirect to file "accounts.php"
session_register("myusername");
session_register("mypassword");
header('Location: ' . $_SESSION['prev_page']);  
}
else 
{
header('Location:accounts-login.php');
}
?>

Is that correct?

Assuming that config.php starts the session then yes. Also, you should hash your passwords rather than store them raw.