How can i save the tinyMCE editor content to mysql

Question

I am using tinyMCE editor to create posts in my app,once i format text and text alignments, create post or update post i need to click save. and when i click save, the tinyMCE content should get saved to mysql database. how can i do that with php?

  tinymce.init({
    entity_encoding : "raw",
    selector: '#mytextarea',
    plugins: "table print textcolor colorpicker anchor link searchreplace media emoticons lists visualblocks preview wordcount hr contextmenu",
    mediaembed_service_url: 'SERVICE_URL',
    mediaembed_max_width: 450,
    toolbar: "save print forecolor backcolor anchor link searchreplace emoticons visualblocks preview",
  });

HTML code

<form method="post">
            <label name="post-title" for="post-title">Post title</label>
            <input type="text" name="post-title" id="post-title"><br>                   
            <label name="post-content" for="post-title">Post Content</label>
            <textarea id="mytextarea"></textarea>
            <br><br>            
            <!-- <input type="submit" class="btn btn-beautuful-blue" name="submit" value="CREATE POST"> -->
        </form>

Simply get it after post and insert into database like you do simple insert — Passionate Coder, Dec 27 '16 at 07:07
are you asking us to write the code for you? if not, can you please update your post and include something that you've tried? — But those new buttons though.., Dec 27 '16 at 07:16

Mayank Pandeyz · Accepted Answer · 2020-12-18T10:32:46.807

3

Make following changes:

<textarea id="mytextarea"></textarea>

to 

<textarea id="mytextarea" name="mytextarea"></textarea>

// provide a name so that we can get its content by using its name

And to get its value

$content = $_REQUEST['mytextarea'];

Now save the content of variable $content to database

edited Dec 18 '20 at 10:32

answered Dec 27 '16 at 07:07

Mayank Pandeyz

25,704
4
40
59

1

You should add that you must validate the input to avoid HTML injection. There is a very good topic about it: https://stackoverflow.com/questions/1205889/how-to-prevent-code-injection-attacks-in-php – Diverti May 31 '22 at 14:32

score 2 · Answer 2 · answered Dec 27 '16 at 07:17

You have to add an action to your form element, let's say you want to post it to the file "post.php" you'll get <form method="post" action="post.php">. After that you'll need a name attached in your textarea field, I am calling it "mytextarea" since you are using the same name in your ID (<textarea id="mytextarea"></textarea>). In the file "post.php" you need to have an MySQL connection, I always make them with the PDO object, there are other possibilities. Besides that you'll need a check or the post content is set.

post.php

// Checking or there is a post request, and checking or the "mytextarea" field is set
if($_SERVER['request_method'] == 'POST'
&& !empty($_POST['mytextarea']))
{
    // Creating the database connection
    $dsn = 'mysql:dbname=databasename;host=127.0.0.1';
    $user = 'username';
    $password = 'password';

    try {
        $dbh = new PDO($dsn, $user, $password);
    } catch (PDOException $e) {
        echo 'Connection failed: ' . $e->getMessage();
    }

    // Getting the variables from the form
    $title = isset($_POST['post-title']) : $_POST['post-title'] ? '';
    $content = $_POST['mytextarea'];

    // Executing the query
    $query = $dbh->prepare('INSERT INTO tablename (item_title, item_content) VALUES (:item_title, :item_content)');
    $query->execute([':item_title' => $title, ':item_content' => $content]);
}

Links

http://php.net/manual/en/pdo.construct.php

http://php.net/manual/en/pdo.prepare.php

http://php.net/manual/en/reserved.variables.server.php

How can i save the tinyMCE editor content to mysql

2 Answers2