· 9 years ago · Dec 23, 2016, 02:56 PM
1SQL Struktúra:
2-- phpMyAdmin SQL Dump
3-- version 4.2.12deb2+deb8u2
4-- http://www.phpmyadmin.net
5--
6-- Hoszt: localhost
7-- Létrehozás ideje: 2016. Dec 23. 15:26
8-- Szerver verzió: 5.5.53-0+deb8u1
9-- PHP verzió: 5.6.29-0+deb8u1
10
11SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
12SET time_zone = "+00:00";
13
14
15/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
16/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
17/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
18/*!40101 SET NAMES utf8 */;
19
20--
21-- Adatbázis: `help`
22--
23
24-- --------------------------------------------------------
25
26--
27-- Tábla szerkezet ehhez a táblához `felhasznalok`
28--
29
30CREATE TABLE IF NOT EXISTS `felhasznalok` (
31`ID` int(11) NOT NULL,
32 `Nev` varchar(24) NOT NULL DEFAULT 'Nincs',
33 `Jelszo` varchar(24) NOT NULL DEFAULT 'Nincs',
34 `Pont` int(11) NOT NULL DEFAULT '0'
35) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
36
37--
38-- A tábla adatainak kiÃratása `felhasznalok`
39--
40
41INSERT INTO `felhasznalok` (`ID`, `Nev`, `Jelszo`, `Pont`) VALUES
42(1, '1', '1', 0);
43
44--
45-- Indexes for dumped tables
46--
47
48--
49-- Indexes for table `felhasznalok`
50--
51ALTER TABLE `felhasznalok`
52 ADD PRIMARY KEY (`ID`);
53
54--
55-- AUTO_INCREMENT for dumped tables
56--
57
58--
59-- AUTO_INCREMENT for table `felhasznalok`
60--
61ALTER TABLE `felhasznalok`
62MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
63/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
64/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
65/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
66
67
68
69
70
71PHP: index.php
72
73<?php
74mysql_connect("localhost","root","JELSZOOOOOOO");
75mysql_select_db("help");
76
77
78if(isset($_GET["belepes"]) == "check")
79{
80 echo "SELECT * FROM felhasznalok WHERE Nev='".mysql_real_escape_string($_POST["fh"])."' AND Jelszo='".mysql_real_escape_string($_POST["pw"])."'";
81 $el = mysql_fetch_array(mysql_query("SELECT * FROM felhasznalok WHERE Nev='".mysql_real_escape_string($_POST["fh"])."' AND Jelszo='".mysql_real_escape_string($_POST["pw"])."'"));
82 if($el["ID"] != 0)
83 {
84 session_start();
85 $_SESSION["ID"] = $el["ID"];
86 header("Location: belepve.php");
87 }
88 else
89 {
90 echo "<center>Helytelen felhasználónév/jelszó kombináció</center>";
91 }
92}
93
94?>
95<form action="help.php?belepes=check" method="POST">
96<table style="text-align: center; border-collapse: collapse; border: 2px solid black;" width="" align="center">
97 <tbody>
98 <tr>
99 <td style="border: 2px solid black;">FelhasználóNév</td>
100 <td style="border: 2px solid black;"><input type="text" name="fh" size="15" maxlength="" value="" /></td>
101 </tr>
102 <tr>
103 <td style="border: 2px solid black;">Jelszó</td>
104 <td style="border: 2px solid black;"><input type="password" name="pw" size="15" maxlength="" value="" /></td>
105 </tr>
106 </tbody>
107</table>
108<div style="text-align: center;"><input type="submit" name="Belepes" value="Login" /><br /></div>
109</form>
110
111
112PHP: BELEPVE.php
113<?php
114mysql_connect("localhost","root","JELSZOOOOOOO");
115mysql_select_db("help");
116session_start();
117if($_SESSION["ID"] == 0)
118{
119 unset($_SESSION["ID"]);
120 header("Location: help.php");
121 exit();
122}
123$ID = $_SESSION["ID"];
124$q = mysql_fetch_array(mysql_query("SELECT * FROM felhasznalok WHERE ID='$ID'"));
125echo "ID:".$q["ID"];
126echo "<br>FelhasználóNév:".$q["Nev"];
127echo "<br>Jelszo:".$q["Jelszo"];
128echo "<br>Pont:".$q["Pont"];
129?>