Veprimet ne bazat e te dhenave
Vazhdim
Faza edituser.php
<?php
require('start.php');
//require('kontrollo.php');
//require('db.php');
$code=$_REQUEST['id'];
$code=0+$code;
if ($code==0)
{
exit('kujdes se po te shoh1');
}
// te marrim te dhenat e userit
// formulojme konmanden
function displayaslink()
{
$sql="select * from users";
$res=mysql_query($sql)
or die('gabim');
echo '<table>
<thead>
<tr>
<th>Kodi</th>
<th>Perdoruesi</th>
<th> </th>
<th> </th>
</tr>
</thead>
<tbody>
';
while($rresht=mysql_fetch_array($res)
{
echo '<tr>';
echo '<td>'.$rresht['code'].'</td>';
echo '<td>'.$rresht['username'].'</td>';
echo '<td>
<a href="edituser.php?id='.$rresht['code'].'">edit</a>
</td>';
echo '<td>
<a href="deletesql.php?id='.$rresht['code'].'">delete</a>
</td>';
echo '</tr>';
}
echo '</tbody>';
echo '</table>';
}
$komande="select * from users where code=".$code;
$res=mysql_query($komande)
or die(mysql_error());
if(mysql_num_rows($res)==0)
{
displayaslink();
exit();
}
$rresht=mysql_fetch_array($res);
$username=$rresht['username'];
$password=$rresht['password'];
$fn=$rresht['firstname'];
$ln=$rresht['lastname'];
$em=$rresht['email'];
$ac=$rresht['accountstatus'];
?>
<html>
<head>
<title>Registration form</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form action="editusersql.php" method="post" name="editfrm" id="editfrm">
<p><strong>Registration form</strong></p>
<input type="hidden" name="code" id="code" value="<?php echo $code; ?>" >
<p>Username:
<input name="username" type="text" id="username" size="20" maxlength="20" value="<?php echo $username; ?>" >
</p>
<p>Password:
<input name="password" type="password" id="password" size="20" maxlength="20" value="<?php echo $password ?>">
</p>
<p>Firstname:
<input name="firstname" type="text" id="firstname" size="20" maxlength="20" value="<?php echo $fn; ?>">
</p>
<p>Lastname:
<input name="lastname" type="text" id="lastname" size="20" maxlength="20" value="<?php echo $ln; ?>" >
</p>
<p>Email:
<input name="email" type="text" id="email" size="30" maxlength="30" value="<?php echo $em; ?>">
</p>
<p>Account status:
<input type="text" name="accountstatus" size="5" id="accountstatus" value="<?php echo $ac; ?>">
</p>
<p>
<input type="submit" name="Submit" value="Register">
</p>
<p> </p>
</form>
<p> </p>
<p><a href="register.php">register new user</a><br>
<br>
<?php
displayaslink();
?>
</p>
</body>
</html>
Faqa editusersql.php
<?php
require('db.php');
// te kontrollojme qe eshte postuar nje username
if(!isset($_REQUEST['username']))
{
echo 'mungon username';
exit();
}
// te kontrollojme qe eshte postuar nje passowrd
if(!isset($_REQUEST['password']))
{
echo 'mungon passowrd';
exit();
}
// te kontrollojme qe eshte postuar nje firstname
if(!isset($_REQUEST['firstname']))
{
echo 'mungon firstname';
exit();
}
// te kontrollojme qe eshte postuar nje lastname
if(!isset($_REQUEST['lastname']))
{
echo 'mungon lastname';
exit();
}
// te kontrollojme qe eshte postuar nje email
if(!isset($_REQUEST['email']))
{
echo 'mungon email';
exit();
}
// te kontrollojme qe eshte postuar nje account status
if(!isset($_REQUEST['accountstatus']))
{
echo 'mungon accountstatus';
exit();
}
// te kontrollojme qe eshte postuar nje code
if(!isset($_REQUEST['code']))
{
echo 'mungon accountstatus';
exit();
}
$code=$_REQUEST['code'];
$u=$_REQUEST['username'];
$p=$_REQUEST['password'];
$fn=$_REQUEST['firstname'];
$ln=$_REQUEST['lastname'];
$em=$_REQUEST['email'];
$ac=$_REQUEST['accountstatus'];
if(strlen($u)<5)
{
echo 'username nuk mund te jete me i shkurter se 5';
exit();
}
// mund te kontrollojme edhe te tjeret
$komande=" UPDATE users
SET username='".$u."',
passowrd='".$p."',
firstname='".$fn."',
lastname='".$ln."',
email='".$em."',
accountstatus=".$ac."
where code=".$code;
echo $komande;
mysql_query($komande)
or die(mysql_error());
echo '<p><h2>te dhenat u modifikuan!</h2></p>';
?>
<script language="JavaScript">
window.location="edituser.php?id=<?php echo $code ?>";
</script>
Faqa deletesql.php
<?php
require('db.php');
// te kontrollojme qe eshte postuar nje code
if(!isset($_REQUEST['code']))
{
echo 'mungon kodi';
exit();
}
$code=$_REQUEST['code'];
$komande=" DELETE from users
where code=".$code;
echo $komande;
mysql_query($komande)
or die(mysql_error());
?>
<script language="JavaScript">
window.location='edituser.php?id=<?php echo $code; ?>';
</script>