02-01-2011, 15:53
Witam, mam taki panel który edytuje z bazy danych wpisy w tabeli 'podstrony', mam tam 7 podstron, każda ma przypisane ID, ale coś panel nie edytuje wpisów, wszystkie które edytuje kasuje i pozostawia puste, oto kod:
Kod PHP:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<meta http-equiv="Content-type" content="text/html; charset=utf-8">
<link rel="stylesheet" type="text/css" href="style.css">
<meta name="Author" content="Mausik">
<script type="text/javascript" src="tiny_mce/tiny_mce.js"></script>
<script type="text/javascript">
tinyMCE.init({
// General options
mode : "textareas",
theme : "advanced",
plugins : "pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template,wordcount,advlist,autosave",
// Theme options
theme_advanced_buttons1 : "save,newdocument,|,bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,styleselect,formatselect,fontselect,fontsizeselect",
theme_advanced_buttons2 : "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,cleanup,help,code,|,insertdate,inserttime,preview,|,forecolor,backcolor",
theme_advanced_buttons3 : "tablecontrols,|,hr,removeformat,visualaid,|,sub,sup,|,charmap,emotions,iespell,media,advhr,|,print,|,ltr,rtl,|,fullscreen",
theme_advanced_buttons4 : "insertlayer,moveforward,movebackward,absolute,|,styleprops,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,template,pagebreak,restoredraft",
theme_advanced_toolbar_location : "top",
theme_advanced_toolbar_align : "left",
theme_advanced_statusbar_location : "bottom",
theme_advanced_resizing : true,
// Example content CSS (should be your site CSS)
content_css : "css/content.css",
// Drop lists for link/image/media/template dialogs
template_external_list_url : "lists/template_list.js",
external_link_list_url : "lists/link_list.js",
external_image_list_url : "lists/image_list.js",
media_external_list_url : "lists/media_list.js",
// Style formats
style_formats : [
{title : 'Bold text', inline : 'b'},
{title : 'Red text', inline : 'span', styles : {color : '#ff0000'}},
{title : 'Red header', block : 'h1', styles : {color : '#ff0000'}},
{title : 'Example 1', inline : 'span', classes : 'example1'},
{title : 'Example 2', inline : 'span', classes : 'example2'},
{title : 'Table styles'},
{title : 'Table row 1', selector : 'tr', classes : 'tablerow1'}
],
// Replace values for the template plugin
template_replace_values : {
username : "Some User",
staffid : "991234"
}
});
</script>
<title>Panel administratora: XXX.PL</title></head>
<body>
<table cellpadding="0" cellspacing="0" border="0" align="center">
<tr>
<td align="left" width="800px">
<?
include "config.php";
if(isset($_GET['prezenterzy']) && $_GET['prezenterzy']=='pokaz')
{
echo '<b>Prezenetrzy w twoim radiu:</b><br>';
$link=mysql_query('SELECT * FROM podstrony ORDER BY id desc');
while($wiersz=mysql_fetch_array($link))
{
echo '<b>'.$wiersz['nazwa'].'</b>';
echo ' - ';
echo '<a href="prezenterzy.php?prezenterzy=edytuj&id='.$wiersz['id'].'">Edytuj</a>';
echo ' - ';
echo '<a href="prezenterzy.php?prezenterzy=usun&id='.$wiersz['id'].'">Usuń</a>';
echo "<br>\n";
}
}
elseif(isset($_GET['prezenterzy']) && $_GET['prezenterzy']=='edytuj' && isset($_GET['id']))
{
$id=$_GET['id'];
$link=mysql_query("SELECT * FROM podstrony WHERE id='$id'");
$wiersz=mysql_fetch_array($link);
echo '<b>Edytuj prezenterów</b><br>';
echo '
<form method="POST" action="prezenterzy.php?prezenterzy=wyedytuj&id='.$wiersz['id'].'">
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td>Nick</td>
<td><input name="nazwa" type="text" maxlength="255" value="'.$wiersz['nazwa'].'" /> </td>
</tr>
<tr>
<td>Pass</td>
<td><input name="tresc" type="text" maxlength="255" value="'.$wiersz['tresc'].'"/> </td>
</tr>
<tr>
<td colspan="2"><input id="saveForm" class="button_text" type="submit" name="Zapisz" value="Submit" /></td>
</tr>
</table>
</form>
';
}
elseif(isset($_GET['prezenterzy']) && $_GET['prezenterzy']=='wyedytuj' && isset($_GET['id']))
{
$nazwa = addslashes($nazwa);
$tresc = addslashes($tresc);
$id=$_GET['id'];
mysql_query("UPDATE podstrony SET nazwa='$nazwa', tresc='$tresc' WHERE id='$id'");
echo 'Pomyślnie wyedytowałem prezentera! <br> Jego nazwa to: <b>'.$nazwa.'</b><br>
<a href="prezenterzy.php?prezenterzy=pokaz"><img src="images/wstecz.png" alt="wstecz" border="0"/></a> ';
}
else echo '';
?>
</td>
</tr>
</table>
</body>
</html>
