Ok I am really stuck. I have posted this question b4 but I am still puzzled how to get this going. Basically I have a MYSql Database, I want the users details crossed checked against the database and then if correct have them logged in through sessions. However, I can do one or another but I cannot get the users details to cross check against the Database AND then log them in through sessions. I think its the layout of my code but I cant work out what goes where, I have been told its Header etc.. then content. I have tried this but I must be doing something wrong. Here is the code (sorry its a little long):
<?php require_once('../Connections/MARTIN.php'); ?>
<?php
mysql_select_db($database_MARTIN, $MARTIN);
$query_Connect = "SELECT * FROM clientinfo";
$Connect = mysql_query($query_Connect, $MARTIN) or die(mysql_error());
$row_Connect = mysql_fetch_assoc($Connect);
$totalRows_Connect = mysql_num_rows($Connect);
?>
<?php session_start(); ?>
<?php
$sql = "SELECT ClientID, cpassword, CDept FROM clientinfo
WHERE ClientID='$ClientID'
AND cpassword='$Password'
AND Cdept = '$CDept'";
$result = mysql_query($sql)
or die("Error: MySQL said ".mysql_error());
$num = mysql_num_rows($result);
$row = mysql_fetch_assoc($result);
if ($num == 1)
header("location: Logged In/WelcomeUserPage.php"
;
?>
<html>
<head>
<title>HomePage</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<p align="center"><img src="Sites%20Title%20Border.png" width="799" height="89"></p>
<form action = "">
<div align="left">
<p align="center"><font color="Black" size="5">Welcome to IT Help-OnLine</font></p>
<p align="center"> </p>
</div>
<blockquote>
<blockquote>
<p align="center"> Please enter your <i>Client ID</i> and <i>Password</i>
below. <br>
Client ID:<font color="#FFFFFF">::</font>
<input text type="text" size="20"
maxlength="20" name="ClientID">
<br>
Password:
<input text type="Password" size"15"
maxlength="20" name="Password">
</p>
<p align="center"> Department
<select name="CDept" size="1" id="CDept">
<option value="Unknown">Select</option>
<option value="Unknown">-----</option>
<option value="XRay">XRay</option>
<option value="Computing">Computing</option>
<option value="Renal">Renal</option>
<option value="Cardio">Cardio</option>
<option value="Heart Center">Heart Center</option>
<option value="Medical Health">Medical Health</option>
<option value="Diabetes">Diabetes</option>
<option value="Histology">Histology</option>
<option value="Ward 1-12">Ward 1-12</option>
<option value="Ward 13-20">Ward 13-20</option>
</select>
<br>
<br>
<input type = "submit" value="Click To Submit">
<input type = "reset" value="Reset">
<?php
//$Home_Page='Welcome back';
session_register('Home_Page');
?>
</p>
</blockquote>
</blockquote>
</form>
<div align="center">
<p><br>
</p>
<p>If you are a new user please click <a href="New User Details/NewUserDetails.php" target="_top">here</a>.
</p>
<p>Administrators log on <a href="Staff&Admin%20Login%20Page/Staff&Admin%20Login%20Page.php">here</a>
</p>
</div>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p><a href="mailto:mkennelly@hotmail.com">Email</a> us here</p>
</body>
</html>
<?php
mysql_free_result($Connect);
?>
Cheers for this as this is a very important section of my site. Thanks!
<?php require_once('../Connections/MARTIN.php'); ?>
<?php
mysql_select_db($database_MARTIN, $MARTIN);
$query_Connect = "SELECT * FROM clientinfo";
$Connect = mysql_query($query_Connect, $MARTIN) or die(mysql_error());
$row_Connect = mysql_fetch_assoc($Connect);
$totalRows_Connect = mysql_num_rows($Connect);
?>
<?php session_start(); ?>
<?php
$sql = "SELECT ClientID, cpassword, CDept FROM clientinfo
WHERE ClientID='$ClientID'
AND cpassword='$Password'
AND Cdept = '$CDept'";
$result = mysql_query($sql)
or die("Error: MySQL said ".mysql_error());
$num = mysql_num_rows($result);
$row = mysql_fetch_assoc($result);
if ($num == 1)
header("location: Logged In/WelcomeUserPage.php"
;?>
<html>
<head>
<title>HomePage</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<p align="center"><img src="Sites%20Title%20Border.png" width="799" height="89"></p>
<form action = "">
<div align="left">
<p align="center"><font color="Black" size="5">Welcome to IT Help-OnLine</font></p>
<p align="center"> </p>
</div>
<blockquote>
<blockquote>
<p align="center"> Please enter your <i>Client ID</i> and <i>Password</i>
below. <br>
Client ID:<font color="#FFFFFF">::</font>
<input text type="text" size="20"
maxlength="20" name="ClientID">
<br>
Password:
<input text type="Password" size"15"
maxlength="20" name="Password">
</p>
<p align="center"> Department
<select name="CDept" size="1" id="CDept">
<option value="Unknown">Select</option>
<option value="Unknown">-----</option>
<option value="XRay">XRay</option>
<option value="Computing">Computing</option>
<option value="Renal">Renal</option>
<option value="Cardio">Cardio</option>
<option value="Heart Center">Heart Center</option>
<option value="Medical Health">Medical Health</option>
<option value="Diabetes">Diabetes</option>
<option value="Histology">Histology</option>
<option value="Ward 1-12">Ward 1-12</option>
<option value="Ward 13-20">Ward 13-20</option>
</select>
<br>
<br>
<input type = "submit" value="Click To Submit">
<input type = "reset" value="Reset">
<?php
//$Home_Page='Welcome back';
session_register('Home_Page');
?>
</p>
</blockquote>
</blockquote>
</form>
<div align="center">
<p><br>
</p>
<p>If you are a new user please click <a href="New User Details/NewUserDetails.php" target="_top">here</a>.
</p>
<p>Administrators log on <a href="Staff&Admin%20Login%20Page/Staff&Admin%20Login%20Page.php">here</a>
</p>
</div>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p><a href="mailto:mkennelly@hotmail.com">Email</a> us here</p>
</body>
</html>
<?php
mysql_free_result($Connect);
?>
Cheers for this as this is a very important section of my site. Thanks!