login.php
<html>
<head>
<title>Login</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form name="loginfrm" action="checklogin.php"
method="post" >
username :<input type="text" name="username"><br>
password :<input type="password" name="password"><br>
<input type="submit" name="login" value="login"><br>
</form>
</body>
</html>
checklogin.php
<?php
session_start();
mysql_connect('localhost','root','') or die('gabim');
mysql_select_db('webi') or die('gabim2');
$u=$_REQUEST['username'];
$p=$_REQUEST['password'];
$qry="select * from users
where username='".$u."' and password='".$p."' ";
$res=mysql_query($qry)
or die(mysql_error());
$n=mysql_num_rows($res);
if($n==0) // nuk ka user me kete username dhe password
{
echo '<font color="red">
<p>
username dhe/ose password jane te pasakte
</p>
</font>';
include('login.php');
exit();
}
// $n>0 pra ka usera me keto kredenciale
// ruaj ne sesion username e perdoruesi qe u logua
$_SESSION['loguar']=$u;
include('listusers.php');
?>
listusers.php
<?php
//include('start.php');
session_start();
//include('kontrollo.php');
if(!isset($_SESSION['loguar']))
{
echo '<p>
<font color="red">
This page requires you to login
</font>
</p>';
include("login.php");
exit();
}
include('db.php');
//include('mylib.php');
$q2="select code from users";
$res2=mysql_query($q2) or die('gabim2');
$totalrows=mysql_num_rows($res2);
$start=0;
$pagesize=4;
if(isset($_REQUEST['start']))
{
$start=$_REQUEST['start'];
$start=$start+0;
}
$qry=" select * from users limit ".$start.",".$pagesize." ";
$res=mysql_query($qry) or die('gabim');
$kollona=mysql_num_fields($res); // numerin e kollonave qe ktheu query
echo '<p align="center"><a href="adduser.php">Add a new user </a></p>';
echo '<p>tabela users ka '.$kollona.' kollona</p>';
// si i kapim vlerat nga rezultati
echo '<table>';
echo '<tr bgColor="lightgray">';
echo '<td>';
echo 'code';
echo '</td>';
echo '<td>';
echo 'username';
echo '</td>';
echo '<td>';
echo 'password';
echo '</td>';
echo '<td>';
echo 'firstname';
echo '</td>';
echo '<td>';
echo 'lastname';
echo '</td>';
echo '<td>';
echo 'accountstatus';
echo '</td>';
echo '<td>';
echo '--------';
echo '</td>';
echo '<td>';
echo '--------';
echo '</td>';
echo '</tr>';
while($rresht=mysql_fetch_array($res))
{
echo '<tr>';
echo '<td>';
echo $rresht['code'];
echo '</td>';
echo '<td>';
echo $rresht['username'];
echo '</td>';
echo '<td>';
echo $rresht['password'];
echo '</td>';
echo '<td>';
echo $rresht['firstname'];
echo '</td>';
echo '<td>';
echo $rresht['lastname'];
echo '</td>';
echo '<td>';
echo $rresht['accountstatus'];
echo '</td>';
echo '<td>';
echo '<a href="edituser.php?id='.$rresht['code'].'">edit</a>';
echo '</td>';
echo '<td>';
echo '<a href="deleteuser.php?id='.$rresht['code'].'">delete</a>';
echo '</td>';
echo '</tr>';
}
echo '</table>';
$n=mysql_num_rows($res); // numri i rreshtave maksimalisht eshte 4
if($n==$pagesize)
{
?>
<p>
<a href="listusers.php?start=<?php echo $start+$pagesize;?>">
Forward
</a>
</p>
<?php
}
if(($start-$pagesize)>=0)
{
?>
<p>
<a href="listusers.php?start=<?php echo $start-$pagesize;?>">
Backward
</a>
</p>
<?php
}
$page=0;
$currentrow=0;
while(($currentrow+$pagesize)<=$totalrows)
{
echo '<a href="listusers.php?start='.$currentrow.'">';
echo 'Faqa '.($page+1);
echo '</a>';
echo ' ';
$page++;
$currentrow=$currentrow+$pagesize;
}
?>