Autentimise näide php sessiooniga - Redigeerimiste ajalugu

Tammet – 9. detsember 2014, kell 12:09

2014-12-09T12:09:16Z

←Vanem redaktsioon		Redaktsioon: 9. detsember 2014, kell 14:09
31. rida:		31. rida:


	$con = ~~mysql_connect~~("localhost","~~fstudent~~","~~student~~");		$con = mysqli_connect("localhost","st2014","progress","st2014");
	if (!$con) {		if (!$con) {
	die('Could not connect: ' . mysql_error());		die('Could not connect: ' . mysql_error());
	}		}

	$~~sex~~ = "X";		$email = "X";
	$auth=0;		$auth=0;

	~~mysql_select_db("facebook", $con);~~

	if (isset($_REQUEST['username'])) {		if (isset($_REQUEST['username'])) {
47. rida:		45. rida:
	$password = $_REQUEST['password'];		$password = $_REQUEST['password'];
	}		}
	if (isset($_REQUEST['~~sex~~'])) {		if (isset($_REQUEST['email'])) {
	$~~sex~~ = $_REQUEST['~~sex~~'];		$email = $_REQUEST['email'];
	}		}

	$aq = "select username from ~~users~~ where username='$username' and password='$password'";		$aq = "select username from tt1v1_users where username='$username' and password='$password'";

	$result = ~~mysql_query~~($aq);		$result = mysqli_query($con,$aq);
	if (! ~~mysql_fetch_array~~($result)) {		if (! mysqli_fetch_array($result)) {
	$auth=0;		$auth=0;
	echo('<p>wrong username, try again!!<p>');		echo('<p>wrong username, try again!!<p>');
72. rida:		70. rida:
	</form>		</form>
	<p>		<p>

	<?php		<?php
	echo "tere " . $username . "<p>";		echo "tere " . $username . "<p>";

	$q="SELECT * from ~~users~~ where ~~sex~~='$~~sex~~'";		$q="SELECT * from tt1v1_users where email='$email'";

	echo "query: $q <br>";		echo "query: $q <br>";
	$result = ~~mysql_query~~($q);		$result = mysqli_query($con,$q);

	echo "leitud:<p>";		echo "leitud:<p>";
	while($row = ~~mysql_fetch_array~~($result)) {		while($row = mysqli_fetch_array($result)) {
	echo $row['username'] . " " . $row['~~name~~'];		echo $row['username'] . " " . $row['fullname'];
	echo "<br />";		echo "<br />";
	}		}
	}		}

	~~mysql_close~~($con);		mysqli_close($con);

	?>		?>
98. rida:		97. rida:
	<input type="text" name="username"><p>		<input type="text" name="username"><p>
	parool: <input type="password" name="password"><p>		parool: <input type="password" name="password"><p>
			otsitav email: <input type="text" name="email" autocomplete="off"><br>
	<?php		<?php
	} else {		} else {
	?>		?>
	<p>		<p>
	~~otsitav sex <input type="text" name="sex" autocomplete="off"><br>~~
	<?php		<?php
	}		}
112. rida:		111. rida:
	Lopp.		Lopp.
	</body>		</body>

	</pre>		</pre>

Tammet – 8. detsember 2010, kell 00:31

2010-12-08T00:31:26Z

←Vanem redaktsioon		Redaktsioon: 8. detsember 2010, kell 02:31
1. rida:		1. rida:
	Töötavana vt http://dijkstra.cs.ttu.ee/~tammet/k18.php		Töötavana vt http://dijkstra.cs.ttu.ee/~tammet/k18.php (proovi kasutaja tanel parool lenat)

	<pre>		<pre>

Tammet – 8. detsember 2010, kell 00:25

2010-12-08T00:25:52Z

Uus lehekülg

Töötavana vt http://dijkstra.cs.ttu.ee/~tammet/k18.php

<pre>
<?php
session_start();
// Use $HTTP_SESSION_VARS with PHP 4.0.6 or less
if (!isset($_SESSION['count'])) {
$_SESSION['count'] = 0;
} else {
$_SESSION['count']++;
echo $_SESSION['count'];
echo '<p>';
}
$username="X";
$password="X";
if (isset($_REQUEST['logout'])) {
session_destroy();
die("Head aega!");
}
if (isset($_SESSION['username']) && isset($_SESSION['password'])) {
$username=$_SESSION['username'];
$password=$_SESSION['password'];
}
?>

Algus.
<p>

<?php

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

$sex = "X";
$auth=0;

mysql_select_db("facebook", $con);

if (isset($_REQUEST['username'])) {
$username = $_REQUEST['username'];
}
if (isset($_REQUEST['password'])) {
$password = $_REQUEST['password'];
}
if (isset($_REQUEST['sex'])) {
$sex = $_REQUEST['sex'];
}

$aq = "select username from users where username='$username' and password='$password'";

$result = mysql_query($aq);
if (! mysql_fetch_array($result)) {
$auth=0;
echo('<p>wrong username, try again!!<p>');
} else {
$auth=1;
$_SESSION['username']=$username;
$_SESSION['password']=$password;
}

if ($auth) {
echo "Tere $username!"
?>

<form>
<input type="hidden" name="logout" value="yes">
<input type="submit" value="Logi valja">
</form>
<p>
<?php
echo "tere " . $username . "<p>";

$q="SELECT * from users where sex='$sex'";

echo "query: $q <br>";
$result = mysql_query($q);

echo "leitud:<p>";
while($row = mysql_fetch_array($result)) {
echo $row['username'] . " " . $row['name'];
echo "<br />";
}
}

mysql_close($con);

?>

<form method="post">
<?php
if(!$auth) {
?>
sinu kasutajatunnus:
<input type="text" name="username"><p>
parool: <input type="password" name="password"><p>
<?php
} else {
?>
<p>
otsitav sex <input type="text" name="sex" autocomplete="off"><br>
<?php
}
?>
<input type="submit">
</form>

<p>
Lopp.
</body>

</pre>