Ad:

PHP Discussion Thread
Marked Solved
Views: 589

Feb 5th, 2010

Login Script

Expand Post »

Ok, so l am new to php ... sort of, now l have managed to throw this together:

PHP Syntax (Toggle Plain Text)
<?php
 
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
 
mysql_select_db("test_database", $con);
 
	if(isset($_POST['Login']))
	{
		if($_POST['username']!='' && $_POST['password']!='')
		{
			//Use the input username and password and check against 'users' table
			$query = mysql_query('SELECT ID, username, Active FROM persons WHERE username = "'.mysql_real_escape_string($_POST['username']).'" AND password = "'.mysql_real_escape_string(md5($_POST['password'])).'"');
 
			if(mysql_num_rows($query) == 1)
			{
				$row = mysql_fetch_assoc($query);
				if($row['Active'] == 1)
				{
					$_SESSION['user_id'] = $row['ID'];
					$_SESSION['logged_in'] = TRUE;
					header("Location: members.php");
				}
				else {
					$error = 'Your membership was not activated. Please open the email that we sent and click on the activation link';
				}
			}
			else {		
				$error = 'Login failed !';		
			}
		}
		else {
			$error = 'Please enter both your username and password to access your account';
		}
	}
?>
<?php

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

mysql_select_db("test_database", $con);

	if(isset($_POST['Login']))
	{
		if($_POST['username']!='' && $_POST['password']!='')
		{
			//Use the input username and password and check against 'users' table
			$query = mysql_query('SELECT ID, username, Active FROM persons WHERE username = "'.mysql_real_escape_string($_POST['username']).'" AND password = "'.mysql_real_escape_string(md5($_POST['password'])).'"');
			
			if(mysql_num_rows($query) == 1)
			{
				$row = mysql_fetch_assoc($query);
				if($row['Active'] == 1)
				{
					$_SESSION['user_id'] = $row['ID'];
					$_SESSION['logged_in'] = TRUE;
					header("Location: members.php");
				}
				else {
					$error = 'Your membership was not activated. Please open the email that we sent and click on the activation link';
				}
			}
			else {		
				$error = 'Login failed !';		
			}
		}
		else {
			$error = 'Please enter both your username and password to access your account';
		}
	}
?>

Here is my html:

PHP Syntax (Toggle Plain Text)
<form action="login.php" method="get">
			Username: <input type="text" name="username" /> <br>
			Password: <input type="password" name="password" /> <br><br>
			<input type="submit" value="Login" />
			<input type="reset" value="Reset" /> <br>
		</form>
<form action="login.php" method="get">
			Username: <input type="text" name="username" /> <br>
			Password: <input type="password" name="password" /> <br><br>
			<input type="submit" value="Login" />
			<input type="reset" value="Reset" /> <br>
		</form>

Now, this is not working, when l try it it displays a blank white page, anyone know what l have done wrong?

Similar Threads

PHP Login Script in PHP
login script not checking password in PHP
Secure PHP Login Script in PHP
very simple login script (checking 2 variables before writing cookie) in PHP
login script is not working in PHP

dlannetts

Reputation Points: 10

Solved Threads: 4

Junior Poster in Training

Offline

83 posts
since Jan 2010

Permalink

Feb 5th, 2010

Re: Login Script

PHP Syntax (Toggle Plain Text)
ob_start();
session_start();
ob_start();
session_start();

fix above code at top of page
and replace

PHP Syntax (Toggle Plain Text)
mysql_fetch_assoc($query);
mysql_fetch_assoc($query);

with

PHP Syntax (Toggle Plain Text)
mysql_fetch_array($query);
mysql_fetch_array($query);

and in form

PHP Syntax (Toggle Plain Text)

<form action="login.php" method="post">

replace method="get" with method="post " as like above.
try it .

rajabhaskar525

Reputation Points: 12

Solved Threads: 27

Junior Poster

Offline

179 posts
since Nov 2009

Permalink

Feb 5th, 2010

Re: Login Script

mmm, this didn't work, still displays a white page, due to my script it should open the file members.php if it logged in successfully shouldn't it? before it was adding extra stuff into my url bar too, what you have done has gotten rid of that, so that is good l guess...

Added a picture of the wampserver screen db, click image for larger view...

Attached Thumbnails

Click image for larger version

Name: WampServer.JPG
Views: 16
Size: 15.7 KB
ID: 13517

Last edited by dlannetts; Feb 5th, 2010 at 7:09 am.

dlannetts

Reputation Points: 10

Solved Threads: 4

Junior Poster in Training

Offline

83 posts
since Jan 2010

Permalink

Feb 5th, 2010

Re: Login Script

Does your page members.php have some code that checks the session variable is set? If so can you post that code?

Hangfire

Reputation Points: 14

Solved Threads: 12

Junior Poster in Training

Offline

62 posts
since Mar 2009

Permalink

Feb 5th, 2010

Re: Login Script

and also

PHP Syntax (Toggle Plain Text)
<input type="submit"  name="Login"value="Login" />
<input type="submit"  name="Login"value="Login" />

fix it. you forgot to write name="Login" in submit botton.

rajabhaskar525

Reputation Points: 12

Solved Threads: 27

Junior Poster

Offline

179 posts
since Nov 2009

Permalink

Feb 6th, 2010

Re: Login Script

Click to Expand / Collapse Quote originally posted by rajabhaskar525 ...

and also
PHP Syntax (Toggle Plain Text)
<input type="submit"  name="Login"value="Login" />
<input type="submit" name="Login"value="Login" />
fix it. you forgot to write name="Login" in submit botton.

Yep, done this, forgot about that, this is my members.php file:

PHP Syntax (Toggle Plain Text)
<?php
 
session_start();
 
?>
 
<html>
<body>
help...
<?php

session_start();

?>

<html>
<body>
help...

AZnythiong wrong here? thanks for everyones help so far, yous have been great...

dlannetts

Reputation Points: 10

Solved Threads: 4

Junior Poster in Training

Offline

83 posts
since Jan 2010

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: How to create a link in php

Next Thread in PHP Forum Timeline: easy url variable example please

DaniWeb Message

Cancel Changes

User Name
Password