tommykent1210
10-29-2009, 10:39 PM
Ok, im quite new to php. I have a tutorial booklet that helped me code this, however it wont work, its supposed to redirect me to admincp.php when i successfully login, and redirect back to index when login fails. However it only ever redirects to index.
here:
index:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>mysite</title>
<script language="javascript">
function Validate(){
var username = document.frmLogin.txtUsername.value;
var lenusername = username.length;
var password = document.frmLogin.txtPassword.value;
var lenpassword = password.length;
if(username <1) {
alert("Please enter your username.");
document.frmLogin.txtUsername.value = "");
return false;
}
else if(lenpassword <1) {
alert("Please enter your passowrd.");
document.frmLogin.txtPassword.value = "");
return false;
}
else {
frmLogin.Submit.disabled = true;
return true;
}
}
</script>
// ----------------------------------------------------------------------\
// Tom's Website |
// Copyright 2009 GFX-Core |
// |
// Redistribution prohibited without written permission |
// ______________________________________________________________________/
</head>
<body>
<H3>My Website</h3>
<br/>
<table>
<form name="frmLogin" action="login.php" method="post" onSubmit="return Validate()">
<input type="hidden" value="agentlogin" />
<tr>
<td><input name="txtUsername" type="text" id="txtUsername" maxlength="30" />
Username</td>
</tr>
<tr>
<td><input name="txtPassword" type="password" id="txtPassword" maxlength="10" />
Password </td>
</tr>
<tr>
<td><input type="submit" name="submit" value="Login" /></td>
</tr>
</form>
</body>
</html>
Login.php:
<?php
include("inc/config.php");
session_start();
header("Cache-control: private");
$username = trim($_POST['txtUsername']);
$password = trim($_POST['txtPassword']);
if ($username != "" && $password != "") {
//Connect to Database
$db = mysql_connect("$dbhost, $dbuser, $dbpass");
mysql_select_db("$dbname, $db");
$sql = "SELECT * FROM users WHERE username ='" .$username."'AND password ='" .$password."'";
$result = mysql_query($sql);
//Count number of records
$num=mysql_num_rows($result);
if($num==0){
//close DB
mysql_close();
//then redirect to index
header("Location: index.php");
}
else {
//login ok!
$_SESSION['ID'] = mysql_result($result,0,"ID");
//go to menu
header("Location: admincp.php");
}
//close database
mysql_close();
}
else{
$_SESSION['ID'] ="";
header("Location: index.php");
}
?>
Herlp would be appreciated :)
here:
index:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>mysite</title>
<script language="javascript">
function Validate(){
var username = document.frmLogin.txtUsername.value;
var lenusername = username.length;
var password = document.frmLogin.txtPassword.value;
var lenpassword = password.length;
if(username <1) {
alert("Please enter your username.");
document.frmLogin.txtUsername.value = "");
return false;
}
else if(lenpassword <1) {
alert("Please enter your passowrd.");
document.frmLogin.txtPassword.value = "");
return false;
}
else {
frmLogin.Submit.disabled = true;
return true;
}
}
</script>
// ----------------------------------------------------------------------\
// Tom's Website |
// Copyright 2009 GFX-Core |
// |
// Redistribution prohibited without written permission |
// ______________________________________________________________________/
</head>
<body>
<H3>My Website</h3>
<br/>
<table>
<form name="frmLogin" action="login.php" method="post" onSubmit="return Validate()">
<input type="hidden" value="agentlogin" />
<tr>
<td><input name="txtUsername" type="text" id="txtUsername" maxlength="30" />
Username</td>
</tr>
<tr>
<td><input name="txtPassword" type="password" id="txtPassword" maxlength="10" />
Password </td>
</tr>
<tr>
<td><input type="submit" name="submit" value="Login" /></td>
</tr>
</form>
</body>
</html>
Login.php:
<?php
include("inc/config.php");
session_start();
header("Cache-control: private");
$username = trim($_POST['txtUsername']);
$password = trim($_POST['txtPassword']);
if ($username != "" && $password != "") {
//Connect to Database
$db = mysql_connect("$dbhost, $dbuser, $dbpass");
mysql_select_db("$dbname, $db");
$sql = "SELECT * FROM users WHERE username ='" .$username."'AND password ='" .$password."'";
$result = mysql_query($sql);
//Count number of records
$num=mysql_num_rows($result);
if($num==0){
//close DB
mysql_close();
//then redirect to index
header("Location: index.php");
}
else {
//login ok!
$_SESSION['ID'] = mysql_result($result,0,"ID");
//go to menu
header("Location: admincp.php");
}
//close database
mysql_close();
}
else{
$_SESSION['ID'] ="";
header("Location: index.php");
}
?>
Herlp would be appreciated :)