Skip to main content


Showing posts from May, 2012

auto detect PDA/mobile and forward url

<  php
if(preg_match('/android.+mobile|avantgo|bada\/|blackberry|blazer|compal|elaine|fennec|hiptop|iemobile|ip(hone|od)|iris|kindle|lge |maemo|midp|mmp|netfront|opera m(ob|in)i|palm( os)?|phone|p(ixi|re)\/|plucker|pocket|psp|symbian|treo|up\.(browser|link)|vodafone|wap|windows (ce|phone)|xda|xiino/i',$useragent)||preg_match('/1207|6310|6590|3gso|4thp|50[1-6]i|770s|802s|a wa|abac|ac(er|oo|s\-)|ai(ko|rn)|al(av|ca|co)|amoi|an(ex|ny|yw)|aptu|ar(ch|go)|as(te|us)|attw|au(di|\-m|r |s )|avan|be(ck|ll|nq)|bi(lb|rd)|bl(ac|az)|br(e|v)w|bumb|bw\-(n|u)|c55\/|capi|ccwa|cdm\-|cell|chtm|cldc|cmd\-|co(mp|nd)|craw|da(it|ll|ng)|dbte|dc\-s|devi|dica|dmob|do(c|p)o|ds(12|\-d)|el(49|ai)|em(l2|ul)|er(ic|k0)|esl8|ez([4-7]0|os|wa|ze)|fetc|fly(\-|_)|g1 u|g560|gene|gf\-5|g\-mo|go(\.w|od)|gr(ad|un)|haie|hcit|hd\-(m|p|t)|hei\-|hi(pt|ta)|hp( i|ip)|hs\-c|ht(c(\-| |_|a|g|p|s|t)|tp)|hu(aw|tc)|i\-(20|go|ma)|i230|iac( |\-|\/)|ibro|idea|ig01|ikom|im1k|inno|ipa…

reasons for power shortage/powercut

so many new industries and apartments are comesmore rechargeable products came like mobile phone, emergency light, ups it consumes 6hrs charge and deliver for 1hr energy onlyseparate house for each family (just like thanikudithanam) so 2 tv and 2 motors works for one familyNumber electric trains increased

my social media profiles

SQL tips

Use EXPLAIN to profile the query execution plan Use Slow Query Log (always have it on!) Don't use DISTINCT when you have or could use GROUP BY Insert performance Batch INSERT and REPLACE Use LOAD DATA instead of INSERT LIMIT m,n may not be as fast as it sounds. Learn how to improve it and read more about Efficient Pagination Using MySQL Don't use ORDER BY RAND() if you have > ~2K records Use SQL_NO_CACHE when you are SELECTing frequently updated data or large sets of data Avoid wildcards at the start of LIKE queries Avoid correlated subqueries and in select and where clause (try to avoid in) No calculated comparisons -- isolate indexed columns ORDER BY and LIMIT work best with equalities and covered indexes Separate text/blobs from metadata, don't put text/blobs in results if you don't need them Derived tables (subqueries in the FROM clause) can be useful for retrieving BLOBs without sorting them. (Self-join can speed up a query if 1st part finds …

UI problems and solutions

full image background for html/body tag used is not supported in all resolutions
solution: .bg {
    width: 100%;
    height: 100%;
    position: absolute;
    top: 0;
    left: 0;
   z-index: -5000;
Side fixed skyscraper ads affect in multi browser and multi resoultion In side drop down menu cannot able to give scrollbar, but we can give pagingIn sqlyog table import is csv formatwindows server hosting not support Fast CGI and wifi router static IPkeyword use in filename for seo is affect the breadcrumbsin big website we classify folders as company, products etc. is affect include path in css/js files

consumer awareness

Get Rs. 300 Mobile Recharge Complete The Following Three Steps and Get Your Mobile Recharge Now:-

STEP 1: Click on "Like" Buttons below.

STEP 2: Click on "Share" Button and Share this onto your wall.

STEP 3: Then copy and paste the message below TEN different "Groups"or on "Friends Wall":

STEP 4:Enter Your Name:Enter Your Email:Enter Your Mobile Numer:
Select Your Op