CODEWITHSUNDEEP
phphtmlmysqlpdox-editable
iamthestreets
iamthestreets

Reputation: 773

Update 1 row at a time and each row has a different value when using x-editable for the same user

I have a HTML table with, for this example, 2 rows (could be more). The middle column is editable and each row in the HTML table is a different column in the database. When I edit row 1 and refresh the page row 2 now has the same value as row 1. I do not want this. The user id (pk) will be the same for each row. The documentation about creating a new record says this would work with updating existing, but does not really help me. I am looking for as much help as I can get.

Here is an image of my table: enter image description here

How do I get each row to keep its value and not update all other rows?

For example if I update the column in row 1, I want only row 1's column to be updated.

Please help!

Here is my code:

HTML Code:

<td><a class="myeditable" data-name="fb_url"  data-type="text" data-pk="<?php echo ($userid);?>" title="Edit"><?php echo ($result['fb_url']);?></a></td>                    
<td><a class="myeditable" data-name="tw_url" data-type="text" data-pk="<?php echo ($userid);?>" title="Edit"><?php echo ($result['tw_url']);?></a></td>

Post.php Code

require("config.php");

$pk = $_POST['pk'];
$name = $_POST['name'];
$value = $_POST['value'];

    if(!empty($value)) {
            try // save user selection to the database
              {
                $stmt = $db->prepare("UPDATE social_preferences SET fb_url = :fburl, tw_url = :twurl WHERE user_id = :userID AND ");
                $stmt->bindParam(":userID", $pk, PDO::PARAM_INT);
                $stmt->bindParam(':twurl', $value);
                $stmt->bindParam(':fburl', $value);
                $stmt->execute();
               }  catch(PDOException $e) { echo 'Connection failed: ' . $e->getMessage(); }
    }else {
        echo 'No value...';
    }

JS Code:

$(document).ready(function() {
//toggle `popup` / `inline` mode
$.fn.editable.defaults.mode = 'inline';       


    $('.myeditable').editable({
            url: 'post.php',
            ajaxOptions: {
                type: 'post',
            },
            success: function(data, config) {
                if(data && data.id) {
                     //set pk
                    $(this).editable('option', 'pk', data.id);                 
                }
            }
    });
});

When I check the network tab in Chrome dev tools I see this: Method: POST Status: 302 Moved Temporarily

Upvotes: 0

Views: 1083

Answers (3)

arialvan
arialvan

Reputation: 1

in fact , you just need to follow the documentation of the X - table in here X-Table

Ok, this is a information tag. data-name="your field column in database" data-pk="your primary key" in data pk you can input multiple PK.

Now please try this example.

HTML:

<td>
   <a class="myeditable" data-name="fb_url"  data-type="text" data-pk="<?php echo $userid;?>" data-url="post.php" title="Edit"><?php echo ($result['fb_url']);?></a>
</td>

JS Code: 

<script>  
        $(document).ready(function() {
            $('.myeditable').editable();
        });
    </script>

Post.php Code

if(!empty($_POST['name'])) {
 $pk = $_POST['pk']; // post from data-pk
     $name = $_POST['name']; // post from data-name
     $value = $_POST['value']; // this is your value
            $stmt=$db->prepare("UPDATE social_preferences SET $name= '".$value."' WHERE your_id= '".$pk."'");
            $stmt->execute();
}else {
    header($_SERVER['SERVER_PROTOCOL'] . ' 422 Unprocessable entity');
}

Upvotes: 0

Gervs
Gervs

Reputation: 1397

OP is talking about rows, but in fact it are columns.

$accepted_names = array('fb_url', 'tw_url');
if (in_array($_POST['name'], $accepted_names)) {
    if(!empty($_POST['value'])) {
        $value = $_POST['value'];
        $id = $_POST['pk'];
        try {
            $stmt = $db->prepare('UPDATE social_preferences SET ' . $_POST['name'] . ' = :value
                                  WHERE user_id = :id');
            $stmt->bindParam(':id', $id, PDO::PARAM_INT);
            $stmt->bindParam(':value',$value);
            $stmt->execute();
        }
        catch (PDOExeption $e) {
            echo json_encode(array('status' => 'failed', 'msg' => $e->getMessage()));
            exit;
        }
        echo json_encode(array('id' => $id, 'status' => 'oké', 'msg' => $value));
    }
    else {
         echo jsonencode(array('status' => 'failed', 'msg' => 'No value ....'));
    }
}
else {
    header($_SERVER['SERVER_PROTOCOL'] . ' 422 Unprocessable entity');
}

Upvotes: 1

Marcus Rommel
Marcus Rommel

Reputation: 1294

I assume that you use oracle SQL.

Put all the users you want to update in an array and use foreach to iterate over them.

Execute your update statement for every one.

I don't know if it is possible to run multiple updates in one statement, but I don't think so.

EDIT:To be sure that only one row is affected use unique identifiers such as user ids if possible.

Upvotes: 0

Related Questions