shembulli show.php -- metadata
<?php
require("start.php");
require("myconfig.php");
require("db.php");
require("mylib.php");
require("kontrollo.php");
require("datavalidation.php");
if (!isset($_REQUEST["tbl"]))
{
exit("emri i tabeles?");
}
$tblname=$_REQUEST["tbl"];
$qry="select * from ".$tblname;
$res=mysql_query($qry) or die(mysql_error());
?>
<html>
<head>
<title>Showing <?php echo $tblname; ?> </title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php
echo ' <table border="1">
<tr>';
$fields=mysql_num_fields($res);
$pkname='code';
for($i=0;$i<$fields;$i++)
{
echo '<th>'.mysql_field_name($res,$i).' '.
mysql_field_type($res,$i).' '.mysql_field_flags($res,$i);
if (is_primary_key(mysql_field_flags($res,$i)))
{
echo '<br>eshte celes primar<br>';
$pkname=mysql_field_name($res,$i);
}
echo '</th>';
}
echo '<th> </th>';
echo '</tr>';
$rows=mysql_num_rows($res);
while($rec=mysql_fetch_array($res))
{
echo '<tr>';
for($j=0;$j<$fields;$j++)
{
$fieldname=mysql_field_name($res,$j);
echo '<td>'.$rec[$fieldname].'</td>';
}
echo '<td>';
echo '<a href="delete.php?tbl='.$tblname.'&code='.$rec[$pkname].'">delete</a>';
echo '</tr>';
}
echo'</table>';
?>
</body>
</html>
shembulli 2 -- delete.php
<?php
require("start.php");
require("myconfig.php");
require("db.php");
require("mylib.php");
require("kontrollo.php");
require("datavalidation.php");
if (!isset($_REQUEST["tbl"]))
{
exit("emri i tabeles?");
}
$tblname=$_REQUEST["tbl"];
if (!isset($_REQUEST["code"]))
{
exit("vleren e celesit primar");
}
$pkvalue=$_REQUEST["code"];
$pkname=pk_name($tblname);
$qry="delete from ".$tblname." where ".$pkname."=".$pkvalue;
$res=mysql_query($qry) or die(mysql_error());
?>
<script language="JavaScript">
window.location="show.php?tbl=<?php echo $tblname ?>";
</script>
modulimi i kodit - mylib.php
<?php
function is_primary_key($fld_flags) // string with flags
{
$result=false; // as a default it is not primary key
if (strpos($fld_flags,'primary_key '))
{
$result=true;
}
return $result;
}
function pk_name($tblname)
{
$qry='select * from '.$tblname. ' limit 0,1';
$res=mysql_query($qry) or die(mysql_error());
$fields=mysql_num_fields($res);
$celesi='no primary key';
for($i=0;$i<$fields;$i++)
{
$fld_flags=mysql_field_flags($res,$i);
if (is_primary_key($fld_flags))
{
$celesi=mysql_field_name($res,$i);
}
}
return $celesi;
}
?>