Login Script wont work....

hoogeebear

Hi,

Ive created a log in script throught php, but I cant get it to accept the username and password that i have stored in my database. Any help would be greatly appreciated. Here's my code.

insert.php

<?php
/*CONNECT TO THE DATABASE BELOW */

$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("survey", $con);


/*$sql="INSERT INTO users (username, password)
VALUES
('$_POST[usernamein]','$_POST[passwordin]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";*/

while($row = mysql_fetch_array($username))
  {
  $retUsername = $row['username'];
    }

while($row = mysql_fetch_array($password))
  {
  $retPassword = $row['password'];
    }
$inputtedUsername = $_POST[usernamein];
$inputtedPassword = $_POST[passwordin];

if($inputtedUsername == $retUsername && $inputtedPassword == $retPassword)
include("welcomescreen.php");
else
include("userlogin.php");
mysql_close($con)
?>

userlogin.php

<html>
<head>
<title>User Login</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<font face="Verdana, Arial, Helvetica, sans-serif">
<body bgcolor="black">
<font size=+4></font>
<center>
  <font color="red" size="+6" face="Verdana, Arial, Helvetica, sans-serif"><b><i><kbd>Welcome to the NCI-An Indepth Analysis Survey </kbd></i></b></font>
</center>
<font color="#FFFFFF" face="Verdana, Arial, Helvetica, sans-serif"></font><font face="Verdana, Arial, Helvetica, sans-serif"><br>
</font>
<center>
  <font face="Verdana, Arial, Helvetica, sans-serif"><img src="images/nci1.jpg" width="300" height="200">
    </font>
</center>
<font face="Verdana, Arial, Helvetica, sans-serif">

<form action = "insert.php" method="post">
</form>
<font size=+1>
<div align="center"><font color="#FFFFFF" face="Verdana, Arial, Helvetica, sans-ser<MM:BeginLock type="mmdate" format="fEn2a" orig="<!-- #BeginDate format:fEn2a -->
  <p><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Wednesday 28-Nov-2007 3:04 PM<em><strong><MM:EndLock></strong></em></font></p>
  </font>
  </div>
  <center><p><font size = "0" font color ="white">(Please enter the username and password in the fields below)</font></center>
  <center><strong><b><font color = "white"><font size="+2">Username:</font></strong><font size="+2"><b>
  <input type="text" name="usernamein" size="20">
  <br>
  <br>
  <center>
  <font color =white><b>	<strong>Password: </strong><b>
  <input type="password" name="passwordin" size="20">
  <br>
      </font><br>
  <center>
    <input type="submit" value="Enter Site" name="login">


</form>
  </font></p>
</body>
</html>

bradmasterx

Insert.php -

<?php 
/*CONNECT TO THE DATABASE BELOW */ 

$con = mysql_connect("localhost","root",""); 
if (!$con) 
  { 
  die('Could not connect: ' . mysql_error()); 
  } 
mysql_select_db("survey", $con); 

mysql_query("INSERT INTO users (username, password) 
VALUES 
('$_POST[usernamein]','$_POST[passwordin]')");

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }


if (!mysql_query($sql,$con)) 
  { 
  die('Error: ' . mysql_error()); 
  } 
echo "1 record added";

while($row = mysql_fetch_array($username)) 
  { 
  $retUsername = $row['username']; 
    } 

while($row = mysql_fetch_array($password)) 
  { 
  $retPassword = $row['password']; 
    } 
$inputtedUsername = $_POST[usernamein]; 
$inputtedPassword = $_POST[passwordin]; 

if($inputtedUsername == $retUsername && $inputtedPassword == $retPassword) 
include("welcomescreen.php"); 
else 
include("userlogin.php"); 
mysql_close($con) 
?>

hoogeebear

Hi,

Tanx for the reply. Can u please state why you made the changes and where I was going wrong, so i can maybe learn from my mistakes.

Tanx.