Working on Drupal 7.54
I am using a custom PHP/SQL Rules to synchronize Drupal field values with an external database.
I am trying to export a text field value but sometimes I have single quotes in these values.
Consequently, when I try to use a field token in my SQL query, it fails because of this single quote that is not escaped.
I have read a few things about replacing strings and escaping quotes but I did not manage to get my query working (replace? str_replace? addslashes? htmlspecialchars? decode_entities?...).
Here is an example :
Let's say I have a Drupal field called "Text-Drupal" in a content type A.
Each time a content of type A is updated, I need to export the Text-Drupal value in an external database in the column text_database
The little code :
db_set_active('database_local'); db_query("UPDATE table SET text_database=NULLIF('[node:field-text-drupal]','') WHERE title=[node:title]"); db_set_active();
This code works fine with any text without special characters but each time I have a single quote, it fails (and I guess it would be the same with double quotes).
I am quite sure this is something really simple for experienced users so I hope someone could point me to the right direction. Thanks.