how to block editing of the same text for a few users

Question

I need to prevent users from simultaneously editing the same text or article on tinymce.

How can I block other users from editing while one user is editing text in the admin panel?

Answer 1

Well many ways actually.. but just of the top of my head while I sit in the John is to

1. When someone within your application begins the edit you then send a update query to the database top update the row "editing"

2. Now if the next user tries to edit the same post redirect then to a error message.

3. If the first user is done then send another query to update the row "editing". Now the second ist can edit what ever they want...

Something like this will work :

If($_POST['startedit'] ) { 
     ............... // start your editing and then also send a query to a database

} else { 
   If($_POST['finished']){ 
       .............// send the update query and send them some where like homepage
   }
}

Any questions please ask

Edit 1

Alright so you asked how would you get the editing time? Well there are plethora ways to get it simple you could just use the database in fact to do the time stamps for you and I'll show you have that is possible.

Step 1) create a table in a database consisting of all the fields you need, and then at the end of the table a time stamp field that is set to update when the row is updated. (this can be done easily use PHPmyadmin if you do not know any sql)

Step 2) when a user clicks on the "startedit" button

you would send a query like so :

$query = $pdo->prepare("UPDATE `yourtable` SET `editing` = '1' WHERE `text_id` = ':id'"); //Using PDO you prepare a update query to dynamically update any ID based on what form a user is using.

$query->bindParam(':ID', $form_id); // Bind your value of the form to the parameter being passed to the PDO query

$query->execute() // Run the PDO query.

now you can do a conditional if on $query to check if it executed, if it did it will return true... so we do it like this :

if($query) {
    Redirect(to the form that he / she wants to work on) // Redirect (obviously lol)
} else { 
............ What ever? ...........
}

Now your asking yourself well crap how do I check if some one is currently editing this form?

Well then we need to run a query when along side of to see if the form is being edited.

so we do :

$query = $pdo->prepare("SELECT * from `yourtable` WHERE `editing` = `1` and `form_id` = :ID"); // Retrieve all forms that are being edited

$query->bindParam(':ID', $form_id); // Bind the parameter 

 $query->execute();

 if ($query->rowCount() > 0 ) {
     die("OOOPS! Some one is editing this form!! - Sorry to late!")
 } else {
   echo "Have fun editing punk!"; 
 }

There you go, that is pretty much the gist of it. I will not code all of it for you. But this is a rudimentary way for you to get this done. Now of course you want to add if a time out has occurred kick the user from editing and what not. And if the user finishes then update editing to = 0. and so on.

This will help you build up your work.

I am also using PDO so if your not accustomed to it read this and this.

• Enjoy

Answer 2

Probably the most friendly solution is to let users edit articles simultaneously. In case of a conflict - say the article gets saved by different users in a given timespan - one could choose wich version of the article to use. This would require versioning though and is probably harder to implement then @Rixhers Ajazi solution.