Sometimes we will have a list of string delimited by comma, e.g., a,b,c,d, and we would like to add quote or single quote around each element, e.g., 'a','b','c','d'. It is possible to do so in a line.

There are so many hash. SHA1 is one of them which is widely used in recent years even though it is not safe to use right now. By the way, it is still the default hash function for storing password in LDAP especially OpenLDAP. In order to develop a website with LDAP authentication manually against POSIX account, SSHA hash function or SHA1 is the easiest solution.

In the example, i want to select data from table VBAK by created date as '20050105'. In the selected fields, i will choose them and append those fields into internal table 'it_fldtab'.

By default, Drupal will have only username and password for such a user. Whenever username is displayed, it will try to call a theme funtion namely username by specified $node. If you want to display user's fullname instead, you have to customize a little bit.

I found a good question regarding PHP snippet for Drupal. Usually, we will list nodes in multiple taxonomies using OR operator. However, you might need to list using AND operator which nodes must be in all specified taxonomies instead. It is not easy to do so using plain SQL. The straightforward solution is to use subquery.

Drupal provides powerful and flexible built-in table sort functionality. However, it will only work with database query through standard db_query() and pager_query(). In many cases, rows are fetched from external system, e.g., mailbox. We may add a few lines to get the same behavior.