Lid |
|
hallo allemaal,
Ik ben bezig met het maken van een soort tekstverwerker.
Deze slaat zijn informatie op in een mysql database.
Nu wil ik echter zorgen dat als ik iets wil bewerken hij de informatie uit mijn mysql database haalt en in een formulier plakt. Ik werk met tinymce. Wat is gebaseerd op een html formulier met extra opties, de tekst word als html weggeschreven in een database. Helaas kan ik geen php variabel in het formulier zetten, omdat elke keer als ik hem dan bewerk de tekst wordt verdubbelt omdat het php variable wordt meegeschreven als het in de tekstarea staat.
dit is de code van tiny mce die ik een beetje heb aangepast:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Oliviercloud | Office | tekst</title>
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<!-- TinyMCE -->
<script type="text/javascript" src="./tiny_mce.js"></script>
<script type="text/javascript">
tinyMCE.init({
// General options
mode : "textareas",
theme : "advanced",
plugins : "autolink,lists,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,visualblocks",
// Theme options
theme_advanced_buttons1 : "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,visualblocks",
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>
<!-- /TinyMCE -->
</head>
<body role="application">
<form method="post" action="./tinymce.php">
<div>
<!-- Gets replaced with TinyMCE, remember HTML in a textarea should be encoded -->
<div>
<textarea id="elm1" name="elm1" rows="15" cols="80" style="width: 80%">
</textarea>
</div>
<!-- Some integration calls -->
<a href="javascript:;" onclick="tinyMCE.get('elm1').show();return false;">[weergeef]</a>
<a href="javascript:;" onclick="tinyMCE.get('elm1').hide();return false;">[verberg]</a>
<a href="javascript:;" onclick="tinyMCE.get('elm1').execCommand('Bold');return false;">[vetgedrukt]</a>
<br />
Naam van het document;<input name="docnaam" type="text" class="textfield" id="docnaam" />
<input type="submit" name="save" value="Opslaan" />
<input type="reset" name="reset" value="Leegmaken" /><br />
<p>Als u het bestand heeft bewerkt, geef dan in het bovenstaande veld de zelfde naam op als die van het origineel.</p>
</div>
</form>
<script type="text/javascript">
if (document.location.protocol == 'file:') {
alert("The examples might not work properly on the local file system due to security settings in your browser. Please use a real webserver.");
}
</script>
</body>
</html>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <meta http-equiv="X-UA-Compatible" content="IE=edge" /> <!-- TinyMCE --> <script type="text/javascript" src="./tiny_mce.js"></script> <script type="text/javascript"> tinyMCE.init({ // General options mode : "textareas", theme : "advanced", plugins : "autolink,lists,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,visualblocks", // Theme options theme_advanced_buttons1 : "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,visualblocks", 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" } }); <!-- /TinyMCE --> <body role="application"> <form method="post" action="./tinymce.php"> <!-- Gets replaced with TinyMCE, remember HTML in a textarea should be encoded --> <textarea id="elm1" name="elm1" rows="15" cols="80" style="width: 80%"> <!-- Some integration calls --> <a href="javascript:;" onclick="tinyMCE.get('elm1').show();return false;">[weergeef] </a> <a href="javascript:;" onclick="tinyMCE.get('elm1').hide();return false;">[verberg] </a> <a href="javascript:;" onclick="tinyMCE.get('elm1').execCommand('Bold');return false;">[vetgedrukt] </a> Naam van het document; <input name="docnaam" type="text" class="textfield" id="docnaam" /> <input type="submit" name="save" value="Opslaan" /> <input type="reset" name="reset" value="Leegmaken" /><br /> <p>Als u het bestand heeft bewerkt, geef dan in het bovenstaande veld de zelfde naam op als die van het origineel. </p> <script type="text/javascript"> if (document.location.protocol == 'file:') { alert("The examples might not work properly on the local file system due to security settings in your browser. Please use a real webserver."); }
en dit is de code om de output in mijn db te zetten:
<?php
require_once('../auth.php');
require_once('../config.php');
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
die('Failed to connect to server: ' . mysql_error());
}
$db = mysql_select_db(DB_DATABASE);
if(!$db) {
die("Unable to select database");
}
if(mysql_num_rows(mysql_query("SELECT docnaam FROM tinymce WHERE docnaam = '$_POST[docnaam]'"))){
mysql_query("DELETE FROM tinymce WHERE docnaam='$_POST[docnaam]'");
}
$eigenaar = $_SESSION['SESS_LOGIN'];
$qry = "INSERT INTO tinymce(eigenaar, docnaam, html) VALUES('$eigenaar', '$_POST[docnaam]', '$_POST[elm1]')";
$result = @mysql_query($qry);
//Check whether the query was successful or not
if($result) {
header("location: ./documenten.php");
exit();
}else {
die("opslaan mislukt");
}
?>
<?php require_once('../auth.php'); require_once('../config.php'); if(!$link) { } if(!$db) { die("Unable to select database"); } mysql_query("DELETE FROM tinymce WHERE docnaam='$_POST[docnaam]'"); } $eigenaar = $_SESSION['SESS_LOGIN']; $qry = "INSERT INTO tinymce(eigenaar, docnaam, html) VALUES('$eigenaar', '$_POST[docnaam]', '$_POST[elm1]')"; //Check whether the query was successful or not if($result) { header("location: ./documenten.php"); }else { } ?>
alvast bedankt voor mensen die mij kunnen helpen.
ik zou het liefst als iemand iets aanpast ofzo er uitleg bij hebben. Ik ben namelijk pas 12.
groeten, Olivier12
|