Shembull 1
Faqa login.html
<html>
<head>
<title>Login Form</title>
<script language="JavaScript">
function kontrollo()
{
if (document.loginfrm.user.value=='')
{ // begin
alert('Futni username');
document.loginfrm.user.focus();
return false;
} //end
if (document.loginfrm.pass.value=='')
{
alert('Futni password');
document.loginfrm.pass.focus();
return false;
}
return true;
}
</script>
</head>
<body>
<form name="loginfrm" method="post" action="checklogin.php" onSubmit="return kontrollo();" >
<p> Username
<input name="user" type="text" id="user">
</p>
<p>Password
<input name="pass" type="password" id="pass">
</p>
<p>
<input type="submit" name="Submit" value="---LOGIN---">
<input type="reset" name="Submit2" value="---CLEAR---">
</p>
</form>
</body>
</html>
faqa checklogin.php
<?php
$u=$_REQUEST['user'];
$p=$_REQUEST['pass'];
echo ' <p>
Ju futet username:<i>'.$u.' </i>
</p>';
echo ' <p>
Ju futet password:<i>'.$p.'</i>
</p>';
?>
Komandat SQL dinamike.
shembulli checklogin
<?php
$u=$_REQUEST['user'];
$p=$_REQUEST['pass'];
$sql=" SELECT * FROM users
where username='".$u."' and
password='".$p."'";
// te lidhemi me serverin
mysql_connect('localhost','root','')
or die('nuk lidhem dot me serverin');
mysql_select_db('mydb')
or die('nuk zgjedh dot db');
// te ekzekutojme SQL dinamike
$res=mysql_query($sql)
or die('gabim komande');
$n=mysql_num_rows($res);
if($n==0)
{
echo 'username ose password jane futur gabim';
}
else
{
echo 'mire se erdhe ne sistem '.$u;
}
?>
4 versione te komandes
include( )
include_once( )
require( )
require_once( )
shembulli i login
<?php
$u=$_REQUEST['user'];
$p=$_REQUEST['pass'];
$sql=" SELECT * FROM users
where username='".$u."' and
password='".$p."'";
// te lidhemi me serverin
mysql_connect('localhost','root','')
or die('nuk lidhem dot me serverin');
mysql_select_db('mydb')
or die('nuk zgjedh dot db');
// te ekzekutojme SQL dinamike
$res=mysql_query($sql)
or die('gabim komande');
$n=mysql_num_rows($res);
if($n==0)
{
echo 'username ose password jane futur gabim';
include('login.html');
}
else
{
echo 'mire se erdhe ne sistem '.$u;
}
?>