Un vel dazi jautajumi...
Sobrid uzspiezot ok datubaze tiek saglabats tikai lietotaja vards un parole ka pareizi panakt to lai tiek saglabats ari limenis un speletaja "stati"?
Un otrs ka pareizi ievadot login informaciju izsaukt parbaudi no datubazes pa speletaja limeni un "statiem" un atcereties izmainas?Pagaidam lietoju sadu kodu.
LOGIN.PHP
<?php
mysql_connect("localhost","root","") or die();
mysql_select_db("datubaze") or die();
$check = mysql_query("SELECT * FROM users WHERE username = '".$_POST['username']."'")or die();
$check2 = mysql_num_rows($check);
if ($check2 == 0) {
print "words=User doesn't exist.&checklog=3";
die();
}
while($info = mysql_fetch_array( $check ))
{
if ($_POST['pass'] != $info['password']) {
print "words=Incorrect Password.&checklog=4";
die();
}else
{
print "words=You are logged in.&checklog=5";
die();
}
}
?>
REGISTER.PHP
<?php
mysql_connect("localhost","root","") or die();
mysql_select_db("datubaze") or die();
$usercheck = $_POST['username'];
$check = mysql_query("SELECT username FROM users WHERE username = '$usercheck'")
or die();
$check2 = mysql_num_rows($check);
if ($check2 != 0) {
print "words=Username already exists.&checklog=1";
die();
}
$insert = "INSERT INTO users (username, password)
VALUES ('".$_POST['username']."', '".$_POST['pass']."')";
$add_member = mysql_query($insert);
print "words=You are registered.&checklog=2";
die();
?>