Hi guys, I'm trying to make a website quickly for a local charity. They have asked me to make a content managment system for the site. I have added inline editors to each block of texts on the page i would like to be edited, however at the moment all fields are posting to a single field in my mysql database (called message) rather to their individual fields. I haven't used ckeditor before, so I'm slighlty lost. I was wondering whether you could please show me quickly how to script my files so that each block of text can be edited indididually and saved into their own fields in my mysql database.
So far my code for the page being edited is:
<form id="form" name="form" method="post" action="page_edit_parse.php" onsubmit="return validate_form ( );">
<div id="Maincontentedit" contenteditable="true">
<textarea class="editor" id="editor" name="editor"><?php echo strip_tags($message); ?></textarea>
</div>
<div id="message-container" ></div></form>
<form id="form2" name="form2" method="post" action="page_edit_parseHomepicdesc1.php" onsubmit="return validate_form ( );">
<div id="picdesc01" contenteditable="true"><textarea class="ckeditor" name="editor2"><?php echo strip_tags($picdesc01); ?></textarea>
</div> </form>
<form id="form3" name="form3" method="post" action="page_edit_parseHomepicdesc2.php" onsubmit="return validate_form ( );">
<div id="picdesc02" contenteditable="true"><textarea class="ckeditor" name="editor3"><?php echo strip_tags($picdesc01); ?></textarea>
</div> </form>
continued
my page_edit_parse is below:
<?php //Start session session_start(); //Include database connection details require_once('config.php'); //Array to store validation errors $errmsg_arr = array(); //Validation error flag $errflag = false; //Connect to mysql server $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); if(!$link) { die('Failed to connect to server: ' . mysql_error()); } //Select database $db = mysql_select_db(DB_DATABASE); if(!$db) { die("Unable to select database"); } $message = $_POST['data']; $qry = "UPDATE messages SET message='$message' WHERE id='1'" or die (mysqli_error($myConnection)); $result = @mysql_query($qry);continued 2
my page_edit_parseHomepicdesc01.php is below:
<?php //Start session session_start(); //Include database connection details require_once('config.php'); //Array to store validation errors $errmsg_arr = array(); //Validation error flag $errflag = false; //Connect to mysql server $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); if(!$link) { die('Failed to connect to server: ' . mysql_error()); } //Select database $db = mysql_select_db(DB_DATABASE); if(!$db) { die("Unable to select database"); } $picdesc01 = $_POST['data']; $qry = "UPDATE messages SET picdesc01='$picdesc01' WHERE id='1'" or die (mysqli_error($myConnection)); $result = @mysql_query($qry);my page_edit_parseHomepicdesc02.php is below:
<?php //Start session session_start(); //Include database connection details require_once('config.php'); //Array to store validation errors $errmsg_arr = array(); //Validation error flag $errflag = false; //Connect to mysql server $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); if(!$link) { die('Failed to connect to server: ' . mysql_error()); } //Select database $db = mysql_select_db(DB_DATABASE); if(!$db) { die("Unable to select database"); } $picdesc01 = $_POST['data']; $qry = "UPDATE messages SET picdesc02='$picdesc02' WHERE id='1'" or die (mysqli_error($myConnection)); $result = @mysql_query($qry);ultimately I want the editor from "form" to post into the "message" field on my mysql database, the "form2" editor to post into the "picdesc01" field of my database and "form3" to post into the "picdesc02" field of my database.
I really appreciate any help. If there is anything else you need just ask and I'll post it or email you.
pluginjs
my java file attached. sorry about multiuple posts, the spam filter kept getting me.
https://github.com/kailas198/pluginjava.githi
I also have this problem, has anyone found a solution yet?
hi
has anyone got any ideas about this sorry? I really want to get this part done by the end of this weekend and can't find any help on google.