MySQL + PHP Account system problem

Community Forums/General Help/MySQL + PHP Account system problem

Arska

(Posted 2011) [#1]

And another problem with MySQL.

I created fully working login and register system. But problem is that, when 2 accounts is logged in same time, it says that both are using same account. Here is some code to take look.

login.php

<html>
<head>
<title>Login</title>
<link rel="stylesheet" type="text/css" media="All" href="css/style.css" />
</head>
<body>

	<div id="wrap">

		<?php 

		mysql_connect("localhost:3306", "arska134", "********") or die(mysql_error());
		mysql_select_db("arska134") or die(mysql_error());

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


			// Haetaan tekstikenttien arvot
			$email = mysql_escape_string($_POST['email']);
			$password = md5($_POST['password']);

			// Yhdistetään MySQL tietokantaan
			$gUser = mysql_query("SELECT * FROM users2 WHERE email='".$email."' AND password='".$password."' LIMIT 1") or die(mysql_error());
			$verify = mysql_num_rows($gUser);

			// Jos tiedot täsmäävät päästetään sisälle
			if($verify > 0){

				include 'userarea.php';
				
				
			// Jos tiedot ovat väärin
			}else{
				echo '<h3>Login Failed</h3>
		  		<p>Login details are incorrect.';
			}



		}else{
		?>
	
		<!-- Koodin HTML osuus alkaa. Lomake osa --> 
		<h3>Login</h3>
		<p>Please enter your login credentials. <a href="register.php">Register account</a> </p>
		<p><a href="search.php">Search account</a> </p>

		<form method="post" action="" >
			<fieldset>
				<label for="email">Email:</label><input type="text" name="email" value="" />
				<label for="password">Password:</label><input type="password" name="password" value="" />
				<input type="submit" value="Login" />
			</fieldset>
		</form>

		<?php
		}
		?>

	</div>

</body>
</html>

userarea.php (included in login.php)

<?php 

	// Haetaan tiedot käyttäjästä
	$data = mysql_query("SELECT * FROM users2") or die(mysql_error());
	$info = mysql_fetch_array( $data ); 

	echo "Current date and time: ".date("d.m.y : H:i:s", time());

	echo '<h3>Login Complete</h3>
	<p>Welcome!</p>';
	echo "Hello ".$info['name']." ".$info['surname'];
	
	if (filesize("activity.txt") > 1000) {
		unlink('activity.txt');
	}
	
	$activity = fopen("activity.txt", 'a');
	fwrite($activity, date("d.m.y : H:i:s", time())." - ".$info['name']." ".$info['surname']." has reguested refresh! ");
	fclose($activity);
	
	?>
	<p> </p>
	<?php

	echo "You are logged in with email ".$info['email'];	

	?>
	<p> </p>
	<h4>News</h4>
	<p> </p>
	<?php		


	$fh = fopen("news.txt", "r");

	while(!feof($fh)) { 
		$lines = trim(fgets($fh));
     		
		echo $lines;
     		break;
	}

	
	fclose($fh);

	
	?>
	<p> </p>
	<h4>Recent activity</h4>
	<p> </p>
	<?php
	
	$activity = fopen("activity.txt", "r");

	while(!feof($activity)) { 
		$actlines = trim(fgets($activity));
     		
		echo $actlines.'<br />';
     		break;
	}

	
	fclose($activity);	
	
	?>
	<p> </p>
	<?php
	
	echo "activity.txt ".filesize("activity.txt")." / 1000 bytes";
	
	?>
	<p> </p>
	<h4>Stream</h4>
	<p> </p>

	<form method="post" action="" >
			<fieldset>
				<label for="comments">Comment:</label><input type="text" name="comments" value="" />
				<input type="submit" value="Submit" />
			</fieldset>
	</form>

	<p> </p>
	<fieldset>
	<?php
	
	$stream = fopen("stream.txt", "r");

	while(!feof($stream)) { 
		$strelines = trim(fgets($stream));
     		
		echo $strelines;
     		break;
	}

	
	fclose($stream);	
	?>
	</fieldset>
	<?php
?>

and after this problem is solved someone can tell me why this "stream" thing isn't working. Submit button returns to login screen.

And here is screenshot of userarea

Arska

(Posted 2011) [#2]

Some update to problem.

So i did some testing and i realize that it always takes first account from MySQL database.

CGV	(Posted 2011) [#3]

It's been a while since I've done any PHP/MySQL but it looks to me that the problem is in the first line in 'userarea.php'.

$data = mysql_query("SELECT * FROM users2") or die(mysql_error());

You're grabbing the entire user2 table and your not iterating through it to find the user in question, so naturally you're just displaying the first entry.

Off hand I think you need to just use $verify in 'userarea,php' rather than re-fetch the data anew. Since you're including this file inside 'login.php' the $verify variable should be within it's scope.

Hope this helps, Bye!

Last edited 2011

Arska

(Posted 2011) [#4]

Oh it was that simple. Now it's working just like i wanted. :)

Thanks CGV