Sorry Ronald. That was totaly my fault,
The problem is.. getting this to login with the supplied username and password that are in the table. "I duoble checked that" and the fields names are correct.
So getting this to login, setting the id in the session and passing the id to the index page, is the issue.
Here is the login.php file.
[php]<?
include("navtop.php");
include("nav.php");
?>
<td width=80% valign=top>
<p class="bodyHeading"><b>TAC Instructor Access</b></p></span>
<p>You are required to login in order to access your TAC Instructor area. If you need assistance with
your login or this is your first time login in an require a username and password for your account, please
feel free to contact TAC to receive this required information.</p>
<P>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#ffffff">
<tr>
<form name="form1" method="post" action="checklogin.php">
<td>
<table width="50%" border="0" cellpadding="3" cellspacing="1" >
<tr>
<td width="78">Email</td>
<td width="6"></td>
<td width="294"><input name="myusername" size=40 type="text" id="myusername" class='input'></td>
</tr>
<tr>
<td>Password</td>
<td></td>
<td><input name="mypassword" type="password" id="mypassword" class='input'></td>
</tr><tr>
<td> </td>
<td> </td>
<td><input type="submit" name="Submit" value="Login" class='input'></td>
</tr>
</table>
</td>
</form>
</tr>
</table></p>
</span></td></table></span></td></table>
<? include("navbot.php") ?>
[/php]
And here is the checklogin.php file
[php]
<?php
include("db.php");
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];
$que = mysql_query("SELECT * FROM `instructors` WHERE `username`='$myusername' AND `password`='$mypassword'");
if (mysql_num_rows($que)==0)
{
$xusrid = $user_id;
$myID = $user_id;
$_SESSION['xusrid'] = $user_id;
session_register($xusrid);
header("location: index.php");
}
else
{
include("navtop.php");
include("nav.php");
echo "
<td width=80% valign=top>
<p class='bodyHeading'>Login Error</p></span>
<p>
<table border=0 width=600 class='pbox11'>
<td>
<b>Wrong Username or Password - Please wait</b><br>
<META HTTP-EQUIV='Refresh' CONTENT='3;URL=index.php'>
</td></table>
<br><Br><br><Br>
</span></td></table></span></td></table>";
include("navbot.php");
}
?>
[/php]
Here is the index.php page
[php]
<?
include('db.php');
if ($myID == 0) header("location:login.php");
include("navtop.php");
include("nav.php");
$qa = mysql_query("SELECT * FROM `instructors` WHERE id='$myID'");
$row=mysql_fetch_assoc($qa);
$name = $row['first_name'] . " " . $row['last_name'];
$first = $row['first_name'];
echo "
<td width=80% valign=top>
<p class=\"bodyHeading\">Welcome $name</p></span>
<p>
<table border=0 width=600 class=\"pbox11\">
<td>
Welcome $first to your secure TAC Instructor account area. If you have any questions about using this site please
contact our support services at any time.<br>
</td></table>
</td></table>
</span></td></table></span></td></table>";
include("navbot.php");
?>
[/php]
and the db.php file
[php]
<?
define('HOST','localhost');
define('USER','');
define('PASS','');
define('DB','');
mysql_connect(HOST,USER,PASS) or die("Could not connect: " . mysql_error());;
mysql_select_db(DB) or die("Could not select: " . mysql_error());;
$myID = 0;
if (isset($_SESSION['xusrid'])) $myID = intval($_SESSION['xusrid']);
session_start();
?>
[/php]
