faqet me poshte bazohet ne tabelen users qe kemi marre si shembull edhe me pare.
Per te marre te dhenat e tabeles Users, mund te shkoni ne seksionin lidhja-me-db
Faqa ndrysho.php
<?php
require_once("start.php");
require_once("db.php");
//require_once("kontrollo.php");
//require_once("mylib2.php");
//the table
if (!isset($_REQUEST["tablename"]))
{
exit("thetable");
}
$tablename=$_REQUEST["tablename"];
//Kodi celesi primar
if (!isset($_REQUEST["thekeyname"]))
{
exit("thekeyname??");
}
$thekeyname=$_REQUEST["thekeyname"];
//Vlera e celesit
if (!isset($_REQUEST["thekeyvalue"]))
{
exit("thekeyvalue??");
}
$thekeyvalue=$_REQUEST["thekeyvalue"];
//Kollona qe duhet ndryshuar
if (!isset($_REQUEST["thecolumnname"]))
{
exit("thecolumnname??");
}
$thecolumnname=$_REQUEST["thecolumnname"];
//Vlera e re qe do marre kollona
if (!isset($_REQUEST["thenewvalue"]))
{
exit("thenewvalue??");
}
$thenewvalue=$_REQUEST["thenewvalue"];
$sql=" update ".$tablename." set ".$thecolumnname."='".$thenewvalue."' where ".$thekeyname."='".$thekeyvalue."'";
//echo $sql;
mysql_query($sql)
or die(mysql_error());
echo $thecolumnname." has changed.";
?>
Faqa edituser.php
<?php
include('start.php');
include('db.php');
include('mylib.php');
include('kontrollo.php');
if(!isset($_REQUEST['id']))
{
exit('cilin perdorues doni te fshini?');
}
$code=$_REQUEST['id'];
$code=$code+0;
if($code==0)
{
exit('kodi i pasakte');
}
$q="select * from users where code=".$code;
$res=mysql_query($q) or die(mysql_error());
$n=mysql_num_rows($res);
if($n==0) exit('nuk ka perdorues me kete kod');
$rresht=mysql_fetch_array($res);
$code=$rresht['code'];
$username=$rresht['username'];
$password=$rresht['password'];
$firstname=$rresht['firstname'];
$lastname=$rresht['lastname'];
$email=$rresht['email'];
$accountstatus=$rresht['accountstatus'];
?>
<html>
<head>
<title>Add a new user</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript">
function ndrysho(tabela,celesi,vleracelesit,kollona,vleraere)
{
var xmlhttp;
if (window.XMLHttpRequest)
{
// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else if (window.ActiveXObject)
{
// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
else
{
alert("Your browser does not support XMLHTTP!");
}
xmlhttp.onreadystatechange=function()
{
if(xmlhttp.readyState==4)
{
ekran.innerHTML=xmlhttp.responseText;
//ekran.innerHTML=" e field has been updated";
}
}
//ndrysho(tabela,celesi,vleracelesit,kollona,vleraere)
url='ndrysho.php?tablename='+tabela+'&thekeyname='+celesi+'&thekeyvalue='+vleracelesit+'&thecolumnname='+kollona+'&thenewvalue='+vleraere;
//alert(url);
xmlhttp.open("GET",url,true);
xmlhttp.send(null);
}
</script>
</head>
<body>
<form name="form1" method="post" action="editusersql.php">
<p>code :
<input type="text" name="code" value="<?php echo $code; ?>" readonly>
</p>
<p>username :
<input type="text" name="username" value="<?php echo $username; ?>" >
</p>
<p>password :
<input type="password" name="password" value="<?php echo $password; ?>">
</p>
<p>emri:
<input type="text" name="emri" value="<?php echo $firstname; ?>">
</p>
<p>mbiemri:
<input type="text" name="mbiemri" value="<?php echo $lastname; ?>">
</p>
<p>email:
<input type="text" name="email" value="<?php echo $email; ?>">
</p>
<p>account status:
<input type="text" name="accountstatus" value="<?php echo $accountstatus; ?>" >
</p>
<input name="Ruaj" type="submit" value="SAVE">
</form>
</body>
</html>