nicht angemeldet
Trotzdem ist dies kein Grund. Aber darum soll es ja jetzt nicht gehen.
Ist klar, es wird dann einfach nicht abgesendet. Habe es geändert und jetzt ist es so, dass alle Zeilen der Tabelle bis auf die erste geupdated werden.
Dabei soll er es nur dort tun, wo name = admin.php?edit=name
if ($_POST['submit'])
{
$adden = mysql_query("UPDATE pagecontent
SET headline = '".mysql_real_escape_string($_POST['headline'])."', content = '".mysql_real_escape_string($_POST['content'])."' WHERE name = '".mysql_real_escape_string($_POST['name'])."'") or die (mysql_error());
if($adden)
{
echo 'Successfully added.';
}
else {
echo 'Could not be added.';
}
}
?>
<!-- start page -->
<div id="page">
<!-- start content -->
<div id="content">
<script language="javascript" type="text/javascript" src="../tinymce/jscripts/tiny_mce/tiny_mce.js"></script>
<script language="javascript" type="text/javascript">
tinyMCE.init({
// General options
mode : "textareas",
theme : "advanced",
plugins : "safari,spellchecker,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,imagemanager,filemanager",
// 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,spellchecker,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,template,blockquote,pagebreak,|,insertfile,insertimage",
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/example.css",
// Drop lists for link/image/media/template dialogs
template_external_list_url : "js/template_list.js",
external_link_list_url : "js/link_list.js",
external_image_list_url : "js/image_list.js",
media_external_list_url : "js/media_list.js",
// Replace values for the template plugin
template_replace_values : {
username : "Some User",
staffid : "991234"
}
});
</script>
<body>
<!-- form sends content to ... -->
<form method="post" action="add.php">
<tr><p>Headline:
<?php
if ($_GET['edit'])
{
$name = mysql_real_escape_string($_GET['edit']);
}
$select = ("SELECT name, headline, content FROM pagecontent WHERE name='$name'");
$query = mysql_query($select) or die (mysql_error());
$ds = mysql_fetch_object($query);
echo '<td><input type="text" maxlength="50" name="headline" value="'.$ds->headline.'"></td>
</tr>
<tr><td><textarea name="content" cols="5" rows="20" >'.$ds->content.'</textarea></td>
</tr>
<td><input name="submit" type="submit" value="Save"></td>
<td><input type="hidden" name="'.$name.'"></td>';
?>
</form>
<td><tr><a href="/admin.php"><b>Back to Admin Panel</b></a></tr></td>
</body>
<!-- end content -->
</div>
<!-- end page -->
</div>
<?php
include 'navi.php';
include 'footer.php';
?>
</html>
Wenn ich den Quellcode öffne, zeigt er jedoch, dass das hidden-Feld den richtigen Name-Input hat.