Mysql function to soundex match a word in a multi word string
soundex is a very useful mysql function when we try to compare 2 words if they sounds similar. Here is the official manual for the function. Soundex is pretty easy to use when we are comparing 2 words. For example, check the following query:
select if(soundex(‘Rösle’)= soundex(‘rosle’), 1, 0);
It’ll return 1 as both the [...]
Hover effect on input element in IE6
Posted by Imran in Browser Compatibility, HTML, Javascript on March 17th, 2010
If you have ever tried to put a hover effect on any input element (submit, button etc) using css you must have faced the problem when you tested on IE6. Generally following is the css code we use to add the hover effect:
input.inputClass{background-color:#cccccc;color:#000000;}
input.inputClass:hover{background-color:#000000;color:#ffffff;}
This would change the background color and text color of any input field [...]
Back to my world after long
Posted by Imran in Miscellaneous on January 24th, 2010
Childhood, originally uploaded by Lazy Fellow.
Have been too busy with family activities and completion of my MBA. At last the marathon family programs have been ended and the MBA(YAHOO!!!!) as well.
Simple Javascript Validation for Checkbox
Posted by Imran in Javascript on January 22nd, 2010
There are times when we need to add javascript validation to check if at least one of a group of checkbox options has been checked. Here is a simple function that’ll solve the problem and works in most of the browsers.
<html>
<head>
<title>Imran’s checkbox validation</title>
<script language=”javascript”>
//frm is the form element
function checkForm(frm){
var destCount = frm.elements['dest[]‘].length;
var destSel [...]
Bird at my window
Posted by Imran in Photography on October 9th, 2009
The place I live is not a very quiet one. A typical populated area in the city with people screaming, street dogs barking, hawkers shouting everywhere. The place is always lively.
Among all these chaos, I found this little baby bird sitting quiet on the mango tree right beside my window.
Mysql rounding for currency format
Most of the time we are used to format float numbers into currency format by PHP (or any front end language) using functions like fprintf(). If we could grab the result formatted from the db, we won’t need to use front end formatting. Mysql function format() is the function we need.
Lets say we have a [...]
Build dropdown from Mysql SET or ENUM fields
Posted by Imran in Mysql, PHP, Programming on September 5th, 2009
We need to populate dropdown fields from Mysql SET or ENUM fields pretty often. So here is how I use to do it.
Lets say ‘test’ is a table that has a field, ‘agree’ of type ‘SET’ having values ‘Yes’ and ‘No’. On the front end of my application I want to show a dropdown/select field [...]
Javascript – Ajax file upload using Yahoo API
Posted by Imran in AJAX, Javascript on July 26th, 2009
Web user interfaces have been very dynamic after the introduction of AJAX. People are now more used to with pages that do not refresh on every click. For developers it has been a challenge to build sites that are more user friendly and to achieve that file upload without refreshing the page is a big [...]
Show pound sign in input field by Javascript
Posted by Imran in Javascript on June 30th, 2009
If you have ever tried to put pound sign (or any special character) in any input fields by Javascript, you know that it is not that straight forward.
If we write code like this,
document.getElementById(‘input_field_id’).value = ‘£1000′;
It’ll display some question mark(unrecognized character) instead of the pound sign.
So we need to put character’s unicode [...]
My Photo Stream @ Flickr