save divs content to database

Question

I am using Aloha Editor and loving it. I am stuck with saving data from different divs on the page to database. I found a tutorial called contentEditable at: http://gazpo.com/2011/09/contenteditable/ It saves 1 div to database, however I have multiple divs on my web page and I can't work out the logics. I would really appreciate if you could help? I have the following php/Javascript/Ajax on my index.php: ```

Accepted Answer

First you setup you javascript to pass the values of both div`s as content1 and content2

```
var content1 = $('.editable1').html();  
var content2 = $('.editable2').html();

$.ajax({
                url: 'save.php',
                type: 'POST',
                data: {
                content1: content1, content2: content2
                },       
                success: function(data) {
                   .......       
```

Then on your php side you adjust the code to handle both input parameters.

```
include("db.php");
    $content1 = $_POST['content1']; //get posted data
    $content1 = mysql_real_escape_string($content1);  //escape string

$content2 = $_POST['content2']; //get posted data
    $content2 = mysql_real_escape_string($content2);  //escape string

$sql = "UPDATE content SET text = '$content1' WHERE element_id = '1' ";
     mysql_query($sql);

$sql = "UPDATE content SET text = '$content2' WHERE element_id = '2' ";
    if (mysql_query($sql))
    {
        echo 1;
    }
```

save divs content to database

Solution

Problem