Skip to main content

Special characters and text fields

Yesterday I was fixing a bug in one of our customization projects. There was a web form with some input fields. The bug was, when you enter some text in a text field with double quotes (“) data is not saving properly. Actually, the problem was in updating the records. All the characters that is there after the first double quote is truncated. Actually, the fix was very simple. This is something that you may find in any HTML based user interface, and you can fix this within few seconds if you know the exact reason for the bug. The reason for the bug is explained bellow.

In a text field for example, say, we enter a value like – abc”de. Then, you save the form and send this to the data base. Now the value – abc”de – is in a row of a database table, that's okay. After that, if you go to edit the same record, you can see that value in the text field as – abc. The part after the double quote is missing. Usually, in a text box, value is kept in the “value” attribute within double quotes. After we keep some value that contains double quotes, within the value attribute of a input tag, it should looks like given below.






This thing happens only when you get the value from a database table. If you type it manually in the text box, there will be the relevant HTML entities for the double quotes. That should looks like given below.








or






To fix the bug, what we should do is to replace the special characters such as double quotes from the values taken from database. In languages like PHP, this is really simple. You can just use a function such as “htmlentities()”. See the code given below.



















Labels:






























Comments











Post a Comment



















Popular posts from this blog





















How to create a new module for vtiger...




























Recently, I had to create a new module for vtigerCRM for my client in current working place. I did search in many places including the official vtiger sites, but couldn’t find a better documentation for my purpose. The latest vtiger version at that time was 5.0.3. Because I had some experience doing lots of core modifications for this system, I did decide to read the source code and find how to add a new module. Finally, I could create a new module and started the project. So, I thought it will be a good thing to write some thing on my blog about this topic, so that others who want to do this thing can read. Given below is a brief description about how to create a new module for vtiger CRM 5.0.3. Source code of this example module is also available to Download .  Step 01: Creating the module directory and minimum required files.  Create a directory called “newModule” inside your vtiger modules directory, or any other name that you prefer. Now, module index file should be created. Creat




















49 comments









Read more




























How to create a waveform animation with HTML and JavaScript




























Recently, for a pet project, I wanted to create an animation of a waveform based on the varying decibel level of the microphone input. I was thinking about a really simple way to accomplish this with SVG and JavaScript. Given below is the first sample code I did on the Codepen. You can change this code to use with any framework of your choice.   For this sample code, I am using a random number as the microphone input. You can replace it with any other time based input.   Code Pen : https://codepen.io/nadeeth/pen/vmaYXw   For this example, you need an HTML code snippet like the one given below. It’s just an SVG with a Polyline element inside.    <div style="text-align:center">   <svg height="150" width="400" id='svg'>     <polyline id="polyline-id" fill="none" stroke="#005c66" stroke-width="1" />   </svg> </div>  And then the plain Javascript code to animate the polyline. You can 




















14 comments









Read more




























De Morgan's Laws in Programming




























Recently, while I was reviewing some codes, I saw there were some conditional statements that check for the same condition but written in different ways. Most of these statements were written with common sense without using any mathematical analysis, since those are too simple to go for a more formal approach. The two identical conditional statements that has been written in different ways are given below.   01)   if ($comment['deleted'] == '1' || $comment['approved'] == '0') {                  unset($conversationsArray[$key]);  } else {                 ++$count;  }   02)   if ($comment['deleted'] == '0' && $comment['approved'] == '1') {                 ++$count;               } else {               unset($conversationsArray[$key]);  }   Obviously, the above lines say that the inverse of the first condition is equals to the second condition and vice versa. That is...    ($comment['deleted'] == '1' |




















12 comments









Read more