Topic: reikia pagalbos php
sveiki visi,
stai turiu toki prisijungimo koda, duombazej esu sukures lentele 3eiluciu (uid,username,password), kai bandau prisijunti prie jos su siuo kodu,jis prisijungia bet negauna informacijos,nors duombazej duomenis ivesti .kai suvedu i laukelius varda ir slaptazodi raso kad , neteisingas vartotojo vardas slaptazodis,nors duombazei viskas taspats tiek paswordas tiek vardas .kame beda,ce pirmieji bandymai susyje su php,todel labai nesmerkit.
<?php
if(isset($_GET['logout']))
{//logout
$expire=time()-60*60*24*30;//1 month
setcookie("uid", "", $expire);
}
if(isset($_POST['user']))
{
$user = $_POST['user'];
$pass = md5($_POST['pass']);
//Connect to server
$con = mysql_connect("localhost", "------", "-----");
if(!$con){die('Could not connect: '. mysql_error());}
//select db
mysql_select_db("-------", $con);
//check or exist
if(mysql_num_rows(mysql_query("SELECT * FROM vartotojai where username = '$user' AND password = '$pass'")))
{//User exist.
$result = mysql_query("SELECT * FROM vartotojai where username = '$user' AND password = '$pass'");
while($row = mysql_fetch_array($result))
{
$expire=time()+60*60*24*30;//1 month
setcookie("uid", $row['uid'], $expire);
$userID = $row['uid'];
echo "prisijunges kaip <b>".$row['username']."</b><br>";
}
}else{
//wrong username or password
echo "<b>neteisingas vartotojo vardas slaptazodis</b><br><br>";
}
mysql_close($con);
}
if(isset($_COOKIE['uid']))
{
$userID = $_COOKIE['uid'];
}
if(isset($userID))
{
//check or not in logout page if is he do not says hello, shows form instead that, (cookie stays alive 1 refresh after delete)
if(!isset($_GET['logout'])){
echo "sweiki atvyke(<a href='?atsijunkti'>atsijunkti?</a>)";
}else{
echo "<form method='post' action='index.php
'>
Username<br><input type='text' name='user'><br>
Password<br><input type='password' name='pass'><br>
<input type='submit' value='prisijunkti'>
</form>";
}
}else{
echo "<form method='post' action='index.php'>
vardas<input size='10' type='text' name='user' >
slaptazodis<input size='10' type='password' name='pass'>
<input type='submit' value='prisijunkti'>
</form>";
}//---
?>