nicht angemeldet
Ich habe diesen Code, jedoch will er die DB nicht updaten.
Es ist die add.php
<?php
include 'head.php';
if($_POST['submit'])
{
$name = mysql_real_escape_string($_POST["name"]);
$headline = mysql_real_escape_string($_POST["headline"]);
$content = mysql_real_escape_string($_POST["content"]);
$adden = mysql_query("UPDATE pagecontent
SET
headline='$headline', content='$content' WHERE name='$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 type="submit" value="Save" /></td>
<td><input type="hidden" name="'.$name.'"></td>';
?>
</form>
<td><tr><a href="/admin.php"><b>Back</b></a></tr></td>
</body>
<!-- end content -->
</div>
<!-- end page -->
</div>
<?php
include 'navi.php';
include 'footer.php';
?>
</html>