<?
include "config.php";
$query=mysql_query("SELECT * FROM `pozdravi` ORDER BY `id`") or die(mysql_error());
while($row=mysql_fetch_array($query))
{
$ot=$row['ot'];
$id=$row['id'];
$pesen=$row['pesen'];
$izp=$row['izp'];
echo "<a href='edit.php?page=edit&id=$id'>$ot : $izp-$pesen</a><br />";
}
$page=htmlspecialchars(addslashes($_GET['page']));
if ($page == "edit")
{
$id=htmlspecialchars(addslashes(trim($_GET['id'])));
$query1=mysql_query("SELECT * FROM `pozdravi` WHERE `id` = '$id'") or die(mysql_error());
while($row=mysql_fetch_array($query1))
{
$ot1=$row['ot'];
$pesen1=$row['pesen'];
$izp1=$row['izp'];
echo '
<form method="POST" action="">
От : <input type="text" name="ot" value="'.$ot1.'"><br />
Изпълнител : <input type="text" name="izp" value="'.$izp1.'"><br />
Песен : <input type="text" name="pesen" value="'.$pesen1.'"><br />
<input type="submit" name="submit" value="Редактирай"></form>
';
if (isset($_POST['submit']))
{
$ot2=$_POST['ot'];
$izp2=$_POST['izp'];
$pesen2=$_POST['pesen'];
$ref=mysql_query("UPDATE `pozdravi` SET `ot` = '$ot2', `izp` = '$izp2', `pesen` = '$pesen2' WHERE `id` = '$id'") or die(mysql_error());
if ($ref)
{
echo "Успешно редактирахте поздрава !";
}
else
{
echo "Грешка !";
}
}
}
}
?>
