WordPress.org

Ready to get started?Download WordPress

Forums

Edit Any Table
[resolved] 'x gets stored as \'s (9 posts)

  1. sgervais71
    Member
    Posted 7 months ago #

    Hi I love your plugin.
    But when i want to add or modify a record that has a single quote like this: "Sally's Bag"
    It gets stored like this: "Sally\'s Bag".

    so when we look at the record after the edit we get : Sally\'s Bag AND NOT Sally's Bag
    For now we have to go in PHPmyadmin to fix it manually.

    https://wordpress.org/plugins/edit-any-table/

  2. sgervais71
    Member
    Posted 7 months ago #

    I just found this, it describes the problem and may give you the solution.
    http://fearlessflyer.com/getting-rid-of-unwanted-backslashes-in-wordpress-form-input/

    I tried putting the code in my functions.php but it did not work.

  3. redeyedmonster
    Member
    Plugin Author

    Posted 7 months ago #

    Hi, sorry can't help you much at the moment as I'm camping in the middle of nowhere with limited data. Edit Any Table adds a backslash prior to some special character's to protect against malicious attacks. This was part of the criteria for it being accepted as a plugin on the WordPress site. You will need to handle the output in your code and unescape the special characters. When I'm back from my adventures I'll post some example code. HTH

  4. sgervais71
    Member
    Posted 7 months ago #

    Thank You!
    I will wait for your return to civilization ;-)
    If you give me your code examples and tell me where to put it it will certainly do the thing.

  5. redeyedmonster
    Member
    Plugin Author

    Posted 4 months ago #

    This is now resolved with an example added to the FAQ.

  6. sgervais71
    Member
    Posted 4 months ago #

    It seems you found the solution. But I read the FAQ and I dont know what to do with it.

    Where must I put this code to be able to fix the problem?

    Probleme:
    In the anytable interface, when i want to add or modify a record that has a single quote like this: "Sally's Bag"
    It gets stored like this: "Sally\'s Bag".

  7. redeyedmonster
    Member
    Plugin Author

    Posted 4 months ago #

    how are you outputting the data, in a post or are you just looking at it in the database? Are you editing values in the WordPress database?

  8. sgervais71
    Member
    Posted 4 months ago #

    I go in the wp-admin / Dashboard / Edit Any Table
    Using your interface I search for entries in my database and when i find the good entry i modify it.
    But I just did a test with the updated version of your plugin and I as far as I can see the bug is fixed.

    Thank You very much

  9. redeyedmonster
    Member
    Plugin Author

    Posted 4 months ago #

    No problem, feel free to leave a review :)

Reply

You must log in to post.

About this Plugin

About this Topic

Tags

No tags yet.