PHP issues >.>

Code:

<?php
require "connect.php";
session_start();
$username = $_POST['username'];
$password = $_POST['password'];
$result = mysql_query("SELECT * FROM `users` WHERE `username` = '".$username."' AND `password` = '".$password."'");
if(mysql_num_rows($result) > 0) {
$_SESSION['username'] = $username;
} else {
die("Lol");
}
?>
<?php
header("Pragma: no-cache");
$gDate = time();
$gClockShowsSeconds = false;
function getServerDateItems($inDate) {
return date('Y,n,j,G,',$inDate).intval(date('i',$inDate)).','.intval(date('s',$inDate));
}
function clockDateString($inDate) {
return date('l, F j, Y',$inDate);
}
function clockTimeString($inDate, $showSeconds) {
return date($showSeconds ? 'g:i:s' : 'g:i',$inDate).' ';
}
?>
<html>

<head>
<title>Home.</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" type="text/css" href="style/style.css" />
<link rel="stylesheet" type="text/css" href="style/purple.css" />
<meta name="template" content="none">
<script language="JavaScript" type="text/javascript">

</script>
<script language="JavaScript" type="text/javascript">

</script>
</head>
<body onload="clockInit(clockLocalStartTime, clockServerStartTime);clockOnLoad();" onunload="clockOnUnload()">
<div id="main">
<div id="logo"><h1>Welcome! ( this will be changed later )</h1></div>
<div id="menu">
<ul>
<li><a id="selected" href="http://cyberinfections.frih.net/">home</a></li>
<li><a href="I-told-you.php">I told you</a></li>
<li><a href="#">Main Link</a></li>
<li><a href="#">Main Link</a></li>
<li><a href="#">Main Link</a></li>
</ul>
</div>
<div id="content">
<div id="column1">
<div class="sidebaritem">
<h1>Log in!</h1>
<?php
if(isset($_POST['login'])){
echo "You're logged in as: $username\n\n\n\n";
echo "<a href='index.php?logout=true'>Logout?</a>";
}else{
echo "<form method=\"post\"> Username: <input type=\"text\" name=\"username\"><br>Password: <input type=\"password\" name=\"password\"><br><input type=\"submit\" name=\"login\" value=\"Log In\"></form>\n\n";
echo "<a href=\"register.php\">Register!</a>";
}
if ($_POST['logout'] == true) {
unset($_SESSION['username']);
}
?>
</div>
<div class="sidebaritem">
<div class="sbilinks">
<li>
<ul>
<div id="ClockTime" onclick="clockToggleSeconds()">
<?php echo(clockTimeString($gDate,$gClockShowsSeconds));?>
</div>
<div id="ClockBkgnd">
<?php echo(clockDateString($gDate)); ?>
</div>
</ul>
</li>
</div>
</div>
<div class="sidebaritem">
<h1>Staff</h1>
<p>
Admin: Joshua Houde (Admin)<br>
Admin: Caleb Smelser(Smelserdude1)<br>
Admin: Hunter (last name)(hunter612)<br>
Mod/Site Helper: Patrick McKenna(Patrick)
</p>
</div>
</div>
<div id="column2">
<h1>Stuff</h1>
<p>
Content
</p>
</div>
</div>
<div id="footer">
Copyright © 2006 Joshua Houde
</div>
</div>
</body>
</html>

Well, that's my whole index page....Im having a problem with the log in...Instead of giving a person a chance to log in, it automatically dies with the failed login error...Any idea how to stop this?

ALostSoul

Anyone?

Clever_As_Sin

I've rewrited 1st block of your code, it's not hte same, but you'd see the main idea: a **if ($_POST)** check up.

Code:

<?php
session_start();

$username = $_POST['username'];
$password = $_POST['password'];
$result = ($username == 'user' && $password == '1') ? true : false;

if ($_POST)
{
if($result)
{
$_SESSION['username'] = $username;
}
else
{
die("Lol");
}
}
?>

You should check if login form has POSTed user's name and password, actually just POST something. If it does not, than just show the entire page with login form.

ALostSoul

Well, it worked, but now its saying every username/password is wrong when i login.

DjinniFire

Mine is similar.
I cut back everything that didn't pertain to form and login. Here's what I got that should work.

Code:

<?php
require "connect.php";
session_start();

if(isset($_POST['username']) && isset($_POST['password'])) {

$username = $_POST['username'];
$password = $_POST['password'];
$result = mysql_query("SELECT * FROM `users` WHERE `username` = '".$username."' AND `password` = '".$password."'");
   if(mysql_num_rows($result) > 0) {
      $_SESSION['username'] = $username;
   } else {
      die("Lol");
   }
}
?>

<?php
if(isset($_SESSION['username'])){
$username=$_SESSION['username'];
   echo "You're logged in as: $username\n\n\n\n";
   echo "<a href='index.php?logout=true'>Logout?</a>";
}
else{
echo "<form method=\"post\"> Username: <input type=\"text\" name=\"username\"><br>Password: <input type=\"password\" name=\"password\"><br><input type=\"submit\" name=\"login\" value=\"Log In\"></form>\n\n";
echo "<a href=\"register.php\">Register!</a>";
}
if ($logout == true) {
unset($_SESSION['username']);
}
?>

Place where needed. Also I noticed you did index.php?logout=true
$_POST['logout'] is not the same as logout=true for the URL. but it does set a variable called $logout as true. So I think it should work now.

ALostSoul

Fire, I love you forever for this! Although, you didn't need the $ before the logout section of the code Wink

thank you SO much *hugs*

hitzonline

If any of you guys need help with PHP/MySql i am here, i have an expert knoweledge in the coding. So - if you need help gimme a shout, craiganderson-1@hotmail.co.uk

Regards,

Craig Anderson