'x gets stored as \'s

  • Resolved sgervais71

    (@sgervais71)


    10 years, 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://www.ads-software.com/plugins/edit-any-table/

Viewing 8 replies - 1 through 8 (of 8 total)
  • Thread Starter sgervais71

    (@sgervais71)

    I just found this, it describes the problem and may give you the solution.
    https://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.

    Plugin Author redeyedmonster

    (@redeyedmonster)

    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

    Thread Starter sgervais71

    (@sgervais71)

    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.

    Plugin Author redeyedmonster

    (@redeyedmonster)

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

    Thread Starter sgervais71

    (@sgervais71)

    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”.

    Plugin Author redeyedmonster

    (@redeyedmonster)

    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?

    Thread Starter sgervais71

    (@sgervais71)

    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

    Plugin Author redeyedmonster

    (@redeyedmonster)

    No problem, feel free to leave a review ??

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘'x gets stored as \'s’ is closed to new replies.