Kód: Vybrať všetko

<?php
mysql_connect("localhost");
mysql_select_db("romanko");
$query="select * from team where obsadeny='0'";
$result=mysql_query($query);

mysql_close();
?>
<form action="odosli.php" method="POST">
	Nick:
	<input type="text" name="login" maxlength="12">
	<br>
	Vyber si svoj tím, za ktorý budeš hrať:
	<select name="team" size="1">
<?php
while ($array=mysql_fetch_array($result)){
	echo "<option value=\"".$array['tym']."\">".$array['nazov'];
}
?>
	</select>
	<BR>
	Kontakt -ICQ:
	<input type="text" name="icq" maxlength="12">
	<br><br>
	<input type="submit" value="Zaregistrovať sa">
</form>

Kód: Vybrať všetko

<?
$login=$_POST["login"];
$team=$_POST["team"];
$icq=$_POST["icq"];
$obs="1";
mysql_connect("localhost");
mysql_select_db("romanko");

$query1="insert into users values (0,'$login','$team','$icq')";
$result1=mysql_query($query1);

$query2="update team set obsadeny='$obs' where tym='$team'";
$result2=mysql_query($query2);
if ($result2) {
	echo "Údaje boli úspešne pridané.";
}
else { echo "Niečo zblblo";}
mysql_close();
?>

Kód: Vybrať všetko

CREATE TABLE team (
  tym char(3) NOT NULL default '',
  nazov varchar(20) NOT NULL default '',
  obsadeny tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (tym)
);

INSERT INTO team VALUES ('ANA', 'Anahaim', 0);
INSERT INTO team VALUES ('ATL', 'Atlanta', 0);
INSERT INTO team VALUES ('BOS', 'Boston', 0);
INSERT INTO team VALUES ('BUF', 'Buffalo', 0);
INSERT INTO team VALUES ('CLG', 'Calgary', 0);
INSERT INTO team VALUES ('CAR', 'Carolina', 0);
INSERT INTO team VALUES ('CHI', 'Chicago', 0);
INSERT INTO team VALUES ('COL', 'Colorado', 0);
INSERT INTO team VALUES ('CLB', 'Columbus', 0);
INSERT INTO team VALUES ('DAL', 'Dallas', 0);
INSERT INTO team VALUES ('DET', 'Detroit', 0);
INSERT INTO team VALUES ('EDM', 'Edmonton', 0);
INSERT INTO team VALUES ('FLO', 'Florida', 0);
INSERT INTO team VALUES ('LAK', 'Los Angeles', 0);
INSERT INTO team VALUES ('MIN', 'Minessota', 0);
INSERT INTO team VALUES ('MTL', 'Montreal', 0);
INSERT INTO team VALUES ('NSH', 'Nashville', 0);
INSERT INTO team VALUES ('NJD', 'New Jersey', 0);
INSERT INTO team VALUES ('NYI', 'New York Islanders', 0);
INSERT INTO team VALUES ('NYR', 'New York Rangers', 0);
INSERT INTO team VALUES ('OTT', 'Ottawa', 0);
INSERT INTO team VALUES ('PHI', 'Philadelphia', 0);
INSERT INTO team VALUES ('PHO', 'Phoenix', 0);
INSERT INTO team VALUES ('PIT', 'Pittsburgh', 0);
INSERT INTO team VALUES ('SJO', 'San Jose', 0);
INSERT INTO team VALUES ('STL', 'ST. Luis', 0);
INSERT INTO team VALUES ('TPB', 'Tampa Bay', 0);
INSERT INTO team VALUES ('TOR', 'Toronto', 0);
INSERT INTO team VALUES ('VAN', 'Vancouver', 0);
INSERT INTO team VALUES ('WAS', 'Washington', 0);

CREATE TABLE users (
  id int(10) NOT NULL auto_increment,
  nick varchar(12) NOT NULL default '',
  tym char(3) NOT NULL default '',
  icq varchar(12) NOT NULL default '',
  PRIMARY KEY  (id)
);

Kód: Vybrať všetko

Subor loginz.php
<?
mysql_connect("localhost","username","password");
mysql_select_db("database");

$query1="(SELECT '$login','$pass')";

$result1=mysql_query($query1);

if ($result1) {
echo "<title>";
echo "Uspesne prihlasenie, transfering to the index page...";
echo "</title>";
echo "<meta http-equiv='refresh' content='2;url=http://slayter.over.cz/index.php'>";
echo "Presmerujem, cakajte prosim.";
 }
 else { echo "Chyba v skripte";}
?>

Kód: Vybrať všetko

mysql_query("SELECT * FROM `users` WHERE `login`='".addslashes($_POST['login'])."' AND `pass`='".addslashes($_POST['heslo'])."'");

Kód: Vybrať všetko

mysql_query("SELECT * FROM `users` WHERE `login`='".addslashes($_POST['login'])."' AND `pass`='".addslashes($_POST['pass'])."'");

$result1=mysql_query;

if ($result1) {
echo "<title>";
echo "Uspesne prihlasenie, transfering to the index page...";
echo "</title>";
echo "<meta http-equiv='refresh' content='2;url=http://slayter.over.cz/index.php'>";
echo "Presmerujem, cakajte prosim.";
 }
 else { echo "Chyba v skripte";}
?>