Autocomplete textfield in Drupal.

Dear Friends, Last week I got a chance to work on drupal and had to add autocomplete functionality to textfields. I had to fetch/search data from database and show in text field.

Example: Suppose I want to make autocomplete text field for ‘author’ table:

CREATE TABLE `author` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT ;

Steps to achieve this are:

1. Create a menu hook in your .module file as below:

$items['search/get_author'] = array(
   'title'  => 'text matching',
   'page callback'  => 'author_autocomplete',
   'access arguments' => array('view keyword autocomplete'),
   'type'  => MENU_CALLBACK,
);

Here we are using existing search functionality.

2. Create function that we call for search from database as below:

function author_autocomplete($string='') {
  $matches = array();
   if($string) {
     $result = db_query_range("SELECT * FROM {author} WHERE first_name LIKE '%s%%' OR last_name LIKE '%s%%'", array($string, $string), 0,     variable_get('keyword_autocomplete_matches', 10));
       while ($data = db_fetch_object($result)) {
         $matches[$data->first_name . ' '. $data->last_name] = check_plain($data->first_name) . ' ' .check_plain($data->last_name);
       }
  }
  drupal_json($matches);
}

3. Now create a textfiled with ‘autocomplete_path’ parameter using Drupal form API as below:

$form['Author'] = array(
  '#type' => 'textfield',
  '#title' => t('Author'),
  '#default_value' => $object['Author'],
  '#size' => 60,
  '#maxlength' => 64,
  '#autocomplete_path' => 'search/get_author',
);

Now, Let me explain the concept how it works.

When you type something to Author textfield autocomplete_path callback the ‘search/get_author’ -> Drupal menu hook look for page callback function ‘author_autocomplete’  -> Now function author_autocomplete generate the drupal_json data to autocmplete.js which is automatically included when you work under ‘search’ module.

Hope this will help new drupal developers and some experienced who did not work on this functionality.

Thanks and Regards,

Mahesh Salaria

Windows 7

I just finished testing of Windows 7 on my laptop (Acer Aspire 4520). It runs flawlessly and much better than Vista. Everything is very neat and clean and easy to access.

Lots of improvements in Task bar and other parts of Windows access. Main thing lots of people concerned about performance on Windows Media Center and its very much improved than Vista, You can feel the effects of Zune with it 😉

Windows media player is also improved and optimized to use low memory.

To know about more changes and improvements check on Microsoft Web Site

Here are some screen shots of Windows 7:

But Windows 7 crashes some of the applications and I reported them to Microsoft and I’m Sure they will fix them in Stable build and we are looking for more stable and smooth build.

Credits to Microsoft who provide us rock solid Operating System year after year. 😉

Live Example of Distributed Computing (World Community Grid)

World Community Grid’s mission is to create the largest public computing grid benefiting humanity. Our work is built on the belief that technological innovation combined with visionary scientific research and large-scale volunteerism can change our world for the better. Our success depends on individuals – like us – collectively contributing their unused computer time to this not-for-profit endeavor.

I’m also contributing to this community and my computer is generating good results to help humanity. I proud to be a part of this project and will continue my services on this community.

You can also join the World Community Grid by clicking following link or directly from their website http://www.worldcommunitygrid.org

How to become a good Software Developer/Programmer

1. Learn Promramming instead of Languages.

– Everyone is behind the computer programming languages, computer courses etc. but very few of them try to understand basic concepts of programming and develop logic. In my views if you are good in logic, you know how things work in programs then you can work on any language. But you should learn programming ethics then languages.

2. Learn to debug and removing errors.

– Debugging skill in very important for every programmer, a good programmer write a code to report errors properly for easy debugging and helps removing errors. Need thinking up to end user.

3. Always stay motivated and keep learning new skills and technology.

– Always stay motivated, don’t think you are typing a code line. Think you writing a poem in your language in well structured form 🙂 . Always keen to learn new techniques, develop new skill in you.

4. Write good quality code with proper comments so that everyone can understand what you did.

– Good quality code here is reusable code, properly commented and structured so that others can understand what you did and you can work in a team in proper manners.

5. Remove impossible from dictionary, its your duty to make things happen.

– Don’t say this is not possible to develop. Everything is possible, some thinks take time, Some times you have to work hard to do impossible things, its your duty to make things happen.

Everything is fair/possible in War, Love and Programming. So have fun and love to code.