View difference between Paste ID: SUaeZn8D and XZ8z6KZR
SHOW: | | - or go back to the newest paste.
1
<?php session_start(); ?>
2
<html>
3
<head>
4
<title>Prihlásenie</title>
5
</head>
6
<body>
7
<?php
8
	$tlacitko = $_POST['tlacitko'];
9
	if ($tlacitko) 	{
10
		$nick = $_POST ["nick"];
11
		$heslo= $_POST ["heslo"];
12
		$heslo= md5(md5($heslo));
13
		$con=mysqli_connect("localhost","root","ruzafans","databaza");
14
		//check connection
15
	
16-
 $pripojenie= mysqli_query($con, "SELECT * FROM uzivatelia WHERE nick=$nick''AND heslo='$heslo'  ;");
16+
 $pripojenie= mysqli_query($con, "SELECT * FROM uzivatelia WHERE nick='$nick' AND heslo='$heslo';");
17
				
18
				
19
				while ($vystup= mysqli_fetch_object($pripojenie))
20
			{  
21
     $id= $vystup -> id;
22
     $nickDB= $vystup -> nick;
23
	 $hesloDB= $vystup -> heslo;
24
	 $emailDB= $vystup -> email;
25
	 $opravnenia= $vystup -> opravnenia;
26
  
27
			}
28-
if ($nick == $nickDB AND $heslo == $hesloDB)   {
28+
if (isset($nickDB) && $nick == $nickDB AND $heslo == $hesloDB)   {
29
	$_SESSION ["id"]= $id;
30
	$_SESSION ["nick"]= $nick;
31
	$_SESSION ["email"]= $email;
32
	$_SESSION ["opravnenia"]= $opravnenia;
33
	echo "Bol si prihlásený ako $nick";
34
35
     	}
36
 
37
 
38
39
40
	}
41
42
?>
43
<p>
44
	<form action="<?php $PHP_SELF; ?>" method="post">
45
	<table>
46
	 <tr><td>
47
	  Nick: <input type="text" name="nick" /> <br>
48
	  Heslo:<input type="password" name="heslo" /> <br>
49
	        <input type="submit" name="tlacitko" value="Prihlásiť sa" />
50
	</tr></td>
51
	</table>	
52
	</form>
53
</p>
54
</body>
55
</html>
56
57
----------------------------------------------------------------------------------------------------------------------------------
58
Errors:
59
Warning: mysqli_fetch_object() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\prihlasenie.php on line 19
60
61
Notice: Undefined variable: nickDB in C:\xampp\htdocs\prihlasenie.php on line 28