January 12 2013

Mysql lpad() function

Tagged Under : ,

MySQL
Using Mysql function add asterisk (*) in front of the string.

Example Output:
********MyTestString
*******MyTestString2
**********TestString

January 10 2013

Mysql instr() Function

Tagged Under : ,

MySQL
Find the string position. I think most of the Software Engineer will use server side script to do it. I also is the one. For PHP, I will use strpos to get the position.

January 10 2013

Mysql find_in_set() Function

Tagged Under : ,

MySQL
Generally, we stores various values of choices in 1 column of database. For example, we store user’s preferred categories in user table’s. value stored in this field will be like this 1,2,12,22,4

January 09 2013

Using .htaccess Protect Your Site

Tagged Under : , ,

Except from apache you can let your .htaccess file tighten up your site’s security and give extra level of protection.

I am going listing out few example and show you how to use it or where to use it. You don’t have to use every single one, just whatever you feel would help you improve your site security.

January 08 2013

Jquery Date Range Picker

Tagged Under : ,

jquery
Following last post Javascript Date Range Picker it was using pure javascript without using any framework.

Now we built another with JQuery.

January 08 2013

Javascript Date Range Picker

Tagged Under :

javascript
I think a lot of people looking how to use javascript built the date picker with start date and end date. Normally how we did is just create 2 field with START DATE and END DATE. but the END DATE still can choose early then START DATE.

And we only can using javascript code to solve it.