Sometimes we have to store it as it is to keep the clients /user happy. But its pain when you want to verify the number or do a search with number by entering entirely a different format.  Following MySQL query helps you do it with ease.

It strips off all symbols and spaces from the data which is there in entire phone number data in your db and matches it with the query text you enter.

Here is the MySQL query to find formatted phone number by a differently formatted search text.

SELECT * FROM bizz_business_user
WHERE 
TRIM(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(phone,
          ' ',   '' ),
          '-',   '' ),
          ',',   '' ),
          '/',   '' ),
          '(',   '' ),
          ')',   '' ),
          '+46', '0')
        ) = '2403473649'

Hope this helps you to do awesome things with phone numbers.

One of his project called Easy Malayalam Software reached 2 million downloads. Yes, that’s a big number considering the number of computer users who use Malayalam on their computers. The application was built on 2008, when I don’t even remember what I was doing that time. He did a whole application to type Malayalam when technology was not yet there to type in Malayalam.

Now, lets gear up and go to SourceForge project and download Easy Malayalam software. Its amazing and easy to use like its mentioned on the name. Download Easy Malayalam Software.

Incoming search terms:

type easy malayalam software, www malayalam remix com, Www malayallam Rimex com

There were suggestions around the web to copy the rows in to new table and then copy back to original table to avoid duplicate key issue for indexed ID ( primary key ). But I just have a simple idea.  Just below query will do the job of cloning entire rows in to the same table without conflicting primary key

INSERT INTO `TABLENAME` (`field2`, `field3`,… ) SELECT `field2`, `field3`,… FROM TABLENAME

Replace TABLENAME with your table’s name. Care that I kept field2 as the first column name which means, you should not insert in to ID column or select data from it. Just copy the rest and ID will auto increment.

There is one more thing

To get the complete field names within a table, you can just export the table with only one row in it. Again remember to delete primary key field name.

Incoming search terms:

mysql copy table row to another table

If you know me for last 8 years, only thing I never changed is my personal mobile number. I was Airtel fan since I started using mobile. Their extended support for not just calls and SMS but data plans attracted a lot of youth. But good people are not always good. And now it’s Airtel who turned bad ass. If you need more clarity they have turned worst than Indian post office!

It’s not the time people had to stick with one cellular company like it was once. I brought Airtel sim when it costed near a thousand rupees. Now any sim is free of cost and plans and offers are everywhere the way you need it. Now I use one personal and another private sim, one for iPad and three landlines as in two offices and one at home besides my Vodafone mobile which is used for business. Ohh yea, last month I cancelled one Airtel broadband with landline and switched to MTS Mblaze, which gives me better stability. I believe it’s time to move on the rest as well. Here is why.

Airtel is in loss, so they are trying to juice existing customers and regain stability. If you get crappy SMS alerts which give you no use, remember you are being charged. Even if you don’t activate it, Airtel automatically does it for you! And not every customer care executives can find what’s active on your account. So keep calling them every day to see if anything is activated. Ohh wait, they will charge you for calling customer care too. That is, to solve an issue created by them, you need to spend your time and money! WTF!! It’s my personal experience. Listen to conversations I had two times with Airtel CC. First guy didn’t know what’s active on my number. On Second time call they says SMS alert was active for a long time and they refuse refund. Dear Airtel, you lost the first balls here.

Now it’s Airtel broadband. If you check my twitter timeline, you can see every month at least twice I tweet my Airtel broadband is down. Every time they say different reasons. Mostly being cable cut. Why don’t they fucking get some good shit to replace the poor quality cables? They have a reason. It’s outsourced. Bengali daily waged people are the once who aligns the connection. They do it like it’s just rope! Now another argument is that modem malfunction. When we took connection, we brought it from Airtel. Now that’s too outsourced. So if you have a complaint for modem, you better replace it with new one without telling anyone. Because nobody at Airtel knows where to complain or what to do when modem is not working. Recently I brought MTS Mblaze, which gives me better speed than 2mbps Airtel ever gave. So I recommend it than Airtel BB and specially Mblaze is wireless so no hassle with Bengalis who don’t know Malayalam or how to cable properly.

Airtel Landline is fun. They can give you connection. But won’t provide a phone! Last year, I brought 7 Tata Indicom landlines with zero upfront payment and APBX with automated call routing. Airtel wasn’t capable of proving single landline connection that time because they didn’t have free sockets available. They asked for 20 days time more time after I waited for one week hearing their promise. But later I took one connection with BB and phone. Now, they don’t provide phone when you take a new connection. The same phone device that TATA gave last year, Airtel is charging for it. I said fuck it; I’ll buy a good one from store.

Customer care people are worst than post office people. It’s not that I have any personal enmity with anyone at post office. When I was kid, I used to go post office for paying my home BSNL bills. They were treating people like we are in some refugee camp begging for food form their home. May be its just that post officers or may be it’s that it is the only Govnt office I walked in several times. I haven’t been in post office for years now. Not sure if I will ever walk in again. Post offices are so dead for me. Now everything is online and courier services are good at speed. Now back to Airtel customer care.

Last week I was traveling through Ernakulam – Kannur – Chennai – Bangalore – Kannur. I use Airtel sim on my iPad so that I can access on Demand 3G when I’m away from wifi. It worked fine till I reached Chennai. Then all of a sudden data is not available. I thought it’s because of Roaming. But everyone offers free 3G data roaming. It was not sorted when I came back home. So I tried USSD query to see if it connects. It failed with no response. Then I called to its number from another phone. It said my number is temporarily blocked!! Time for another WTF!!

I called customer care, one Mr. Yasser tried to help me and said someone reported sim missing on this number and so my sim was blocked! I asked who reported and when? He didn’t have answer and I asked to connect me to seniors. He said ok, and I waited few minutes then he came back and said top teams aren’t available. He promised to fix it in an hour and I asked him to send confirmation on my personal number as iPad can’t receive SMS and calls. He said he don’t have its facility to call another number even if it’s the number I’m calling to complain! I asked him to call me manually from his phone. He said he can’t call. (WTF!) I belied it will fix that night. Because I had to book tickets next morning at 8 when the IRCTC Tatkal opens. Bullshit happened next day, it was still blocked. As I don’t plan for an alternative connection, I got one hour delayed to book ticket and my mom and I had to travel in Chennai Mail general coach from Kannur. We got wait listed AC reservation only due to the delay in booking. A sleep less journey! (WTF). I called customer care for 3rd time to solve the block issue, this time a lady said she just unblocked my number and it will be active in an hour. It didn’t happen for now when I’m writing this, which is 24+ hours after that call. Now I’m in Chennai, I can’t call Customer Care. It gives no option to talk to them. Just IVR. But
I just got one advertising call from Airtel comedy while I’m roaming. No comments on it than WTF!

Later that day, I got two calls from Airtel saying they saw my complaints on twitter and they are checking what the reason it got blocked is. Anyways, I’m going to buy new sim from BSNL for iPad. Fuck Airtel.

Incoming search terms:

Airtel private number, airtel company review, airtel is very costly, you are temporarily blocked airtel

Now, Google has added it in the stable release of Chrome, which will be downloaded masses. Now, as developers, how can we utilize this wisely and still save bandwidth.

First, we need to tell Chrome which links to prerender. For this, you just need to add this line on your HEAD tag.

<link rel="prerender" href="http://example.org/nextpage.html" />

Here is a WordPress plugin which does this out of the box for you.

Negative effects if you enable Prerendering

No questions, its so cool for the visitors to get pages load faster. But it eats up their bandwidth uselessly unless they want to click on another link.
Now whats bad for the developer / site owner ?

1. It loads pages un-necessarily, which wastes server resource and band width.
2. Users may see not so updated page if you have real time data on your page. Because what user will see is data already loaded
3. DOM based JS layouting may have trouble ( atleast for now, some websites may break )
4. Analytics Data may get messed – Google says that any page Analytics may count prerendering as a pageview. It was a small amount earlier, but now Prerendering is spread through Chrome stable release. Lets hope Google Analytics Team will come up with a solution.
5. Be prepared with a good web hosting packages to get more visits on to your site. I mean just hists, not visits though

Keep watching this space to get updated on this matter.

Another quick way is to use iframes. Just put following code in your index.html of new domain.

 <iframe src="http://originalsite.com" height="100%" width="100"></iframe> 

But if visitor clicks a link on the page, it wont update the url on the address bar and user fill feel fishy

Here is the simple script which makes the masking work. It has two portions a php file and one htaccess file.

What php file does is, it opens the original website and grab the content to bump it back to the browser. In the process, it replaces any text with source site url to your new url. So that links on the site and all resource are called from your new domain itself. Smart! isn’t it?

# index.php
<?php
// enter your site names here. Just the core url no http or tail slashes 
$wc_source = "originalsite.com";
$wc_mirror = "yourawesomedomain.com";
/*
Look hard under this line. But dont try to change unless you are above 18 and know how to read awasthakiyoguyiomonstia
*/ 
$sql = $_GET['sql'];
$URL = "http://".$wc_source."/".$sql;
$fullPath = $URL;
$base = '<base href="'.$URL.'">';
$host = preg_replace('/^[^\/]+\/\//','',$URL);
$tarray = explode('/',$host);
$host = array_shift($tarray);
$URI = '/' . implode('/',$tarray);
$content = '';
$fp = @fsockopen($host,80,$errno,$errstr,30);
if(!$fp) { echo "Unable to open socked: $errstr ($errno)\n"; exit; } 
fwrite($fp,"GET $URI HTTP/1.0\r\n");
fwrite($fp,"Host: $host\r\n");
if( isset($_SERVER["HTTP_USER_AGENT"]) ) { fwrite($fp,'User-Agent: '.$_SERVER["HTTP_USER_AGENT"]."\r\n"); }
fwrite($fp,"Connection: Close\r\n");
fwrite($fp,"\r\n");
while (!feof($fp)) { $content .= fgets($fp, 128); }
fclose($fp);
if( strpos($content,"\r\n") > 0 ) { $eolchar = "\r\n"; }
else { $eolchar = "\n"; }
$eolpos = strpos($content,"$eolchar$eolchar");
$content = substr($content,($eolpos + strlen("$eolchar$eolchar")));
$content = str_replace($wc_source,$wc_mirror,$content);
// replaces paths with / in the begining without full url. not required unless you are in subfolder
$content = str_replace('href="/','href="http://'.$wc_mirror.'/',$content);
$content = str_replace('src="/','src="http://'.$wc_mirror.'/',$content);

// $fsize = filesize($fullPath); 
    $path_parts = pathinfo($fullPath); 
    $ext = strtolower($path_parts["extension"]); 
    
    // Determine Content Type 
    switch ($ext) { 
      case "pdf": $ctype="application/pdf"; break; 
      case "exe": $ctype="application/octet-stream"; break; 
      case "zip": $ctype="application/zip"; break; 
      case "doc": $ctype="application/msword"; break; 
      case "xls": $ctype="application/vnd.ms-excel"; break; 
      case "ppt": $ctype="application/vnd.ms-powerpoint"; break; 
      case "gif": $ctype="image/gif"; break; 
      case "png": $ctype="image/png"; break; 
      case "jpeg": $ctype="image/jpg"; break; 
      case "jpg": $ctype="image/jpg"; break;
      case "js": $ctype="text/javascript"; break;	 
      case "css": $ctype="text/css"; break;
    } 

    header("Pragma: public"); // required 
    header("Expires: 0"); 
    header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); 
    header("Cache-Control: private",false); // required for certain browsers 
    header("Content-Type: $ctype"); 
    header("Content-Transfer-Encoding: binary"); 
//    header("Content-Length: ".$fsize); 
	

if( preg_match('/<head\s*>/i',$content) ) { echo( preg_replace('/<head\s*>/i','<head>'.$base,$content,1) ); }
else { echo ( str_replace($wc_source,$wc_mirror,preg_replace('/<([a-z])([^>]+)>/i',"<\\1\\2>".$base,$content,1) )); 
}
?>

Now its true that you don’t have any other resource / files on the new domain server. Here comes the htaccess to play its role. htaccess sends all requests to index.php with full path so that index.php can return content for corresponding files from Original website.

#htaccess file
<IfModule mod_rewrite.c>
    RewriteEngine On
    RewriteBase /
    #Checks to see if the user is attempting to access a valid file,
    #such as an image or css document, if this isn't true it sends the
    #request to index.php
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteRule ^(.*)$ /index.php?sql=$1 [L]
</IfModule>

Implementation is very straight forward. You just need to put in the source and mirror urls in the php file. Everything works out of the box.

Once the files are set with proper urls, when you go to newdomain.com , it will show you content from originalsite.com and all links will word as of newdomain.com/link.html

Incoming search terms:

url masking htaccess, url masking, url masking in php, url masking html, htaccess url masking, url masking using htaccess, php code for url masking, mask url php, htaccess domain masking, iframe generator to mask url php cloaking

For last few days, I have been looking towards high stored buildings. If you know me in person, it’s not me who stare at large buildings often. I usually don’t care height, age and the language you speak and that applies to any object not just human. But why I now began to look for large buildings now days? It has a solid reason behind it. I know for sure it’s the only thing which can save my life tomorrow. Yes, if the Mullapperiyar Dam collapses tomorrow, I will be one of the 35 lack people who will go underwater. I’m not afraid of dying I know it will happen a day and I always believed myself that mine will be sooner. What I want my readers is to make sure that we know we were gonna die before we actually do.

35 lack people are going to die not because of a natural disaster. But the laziness and ignorance of a major part of us and shattered groups of people who know it’s going to happen and didn’t care. I don’t understand the logic of renting a 50 years lifetime guaranteed dam for 999 years with rent of 30 rupee per acre. And it’s been more than 116′years. Couple of tens of years ago, the agreement was renewed by officers of both Kerala and Tamil Nadu and nobody was known about it in public.

You can read more about the issues and the history behind the funny Mullaperiyar dam agreements here. But what I’m Noreen interested is ignoring the history considering it as a story and find a solution.

• Ministry of Water resources
• IS MULLA PERIYAR DAM SAFE? by Prof.T.Shivaji Rao, Director, Centre for Environmental Studies, GITAM, Visakhapatnam

As the case is between two states Kerala and Tamil Nadu things are little complicated here. Only question Kerala has is about life of 35lack people in five districts including Idukki, Ernakulam and Alappuzha.
For Tamil Nadu, it’s main source of their revenue in terms of electricity which Tamil Nadu produces from Mullaperiyar which was not agreed in the Dam agreement with Kerala. What Kerala agreed was that the water can be used for serving water supply to seven districts in Tamil Nadu.

Solution #1: Build a large parallel Dam within secure distance from current dam and break current one.
Flaws: It will take at least ten years to build a similar capacity dam and current dam can’t stay for more than an year as it is now. Keep in mind that yesterday there was fourth miner earthquake of this month. So either Tamil Nadu will have to suffer ten years without less water which may cause major financial lose to the state specially who depends on agriculture. But keeping watter level in low while the other Dam is build will solve 70% of water availability issue. Kerala Govnt even agreed to spend 600 crores for new Dam for sake of people security. Kerala is not using water from Mullaperiyar Dam at present. So with investment of money in, Kerala is expecting to get water benefits.

Solution #2: Build more smaller Dams and lower water level of Mullaperiyar and distroy Mullaperiyar securely after all Dams are built. Water can still be used by Tamil Nadu, but they wont be able to make 30,000 crore per year which they are making now by electricity which was not agreed in the initial agreement with Kerala. Tamil Nadu will not agree to such a lose ignoring life of millions of people in Kerala.

Solution #3: This is my favorite. The more I grow, Im losing my pride as Indian. Politics, Language barriers and unwanted criticism and overtaking of rules my human is making me nervous these days. I dont find a meaning in being one country with numerous states that fights each other. The Central government system has no power when it comes to warn or act against these states. Corruption is leading the country to its higher levels.

So lets talk about the solution. Shuffle the state boundary structure. A lot of people in Idukki District are Tamil speaking people and the range fixing of states in India was not done properly when we got Freedom in 1947. So shuffle state borders in a way that there is no more inter state fights.

So to wrap, let me write this too… If we die tomorrow we are not going to complaint no more about it. News papers and TV channels may live broadcast us drinking water and die. You may see us dead after few days like fishes on the shore. But people who watch this wont feel anything special humanly about it. Because we died because we didn’t had voice to talk, or those who had voice, they didn’t talk. So we die…

iSSH

Though it smells greeky to have ssh client on top of the list, it is really a life saver for me.

Air Display

Ever wished if your monitor had touch screen? Now that dream has come true. Now you can use iPad/iPhone as additional display for your Windows and Mac with touch capability. Close your mouth and start touching your desktop icons and Paint brush with your fingers in Photoshop

Skyfire Web Browser for iPad

I love Chrome to be on my iPad as well. But for now Safari is my main browser on iPad. Skyfire is awesome because you wont miss flash videos anymore.

Phone Drive

Storing files on iDevices are still pain in Ass as unless you use iFiles. Now there are a lot of Apps which lets you use iPad as Wifi Hard Disc so that you can store files and sync files using iTunes. Photo Drive also lets you access through FTP client, which is awesome.

NAVIGON MobileNavigator

The Awesome most GPS tracking App for iPad. I know there are several other apps. But this one got almost all roads in India covered. This one got voice over feature which helps when you are driving. But dont trust machines on Indian roads yet

Reeder

Google Reader Client with minimal UI and faster Syncing for Offline reading. Best app when you wake up and go out for a long day with spare time. Sync feeds in the morning and read whole day.

Talkatone

Who said iPad cant be used as Phone? Call me on my Google voice number and I will answer you from my iPad. I can also make calls from my Google Voice number using GV Connect. It just works like a Charm.

Real Piano HD Pro

Dont worry about the name HD and Pro, its Free! . A Beautiful music app with amazing features and simple interface. Just fell in love with it though Guitar was my favorite music instrument.

VLC

You know her very well, so do I. You will need to jailbreak to install this now a days. Apple removed her from AppStore coz its opensource.

Installous

If you know about this app, you already have it installed. Jailbreakme your iPad with a reason. This is it.

I hope you love these apps as well. Tell me if you have some awesome app on your iPad which I havent mentioned here. I love to try all of them

Incoming search terms:

awesome ipad apps, best indian ipad apps, top 10 ipad apps, top ten ipad apps, Top Indian iPad apps, top ipad apps for india, best ipad apps in india, useful apps for ipad india

As said, most people including me don’t always have wifi connected. Specially when we are on road and that’s where phone is mostly gonna get disappeared. And I keep cellular data turned off on iPhone because it drains battery easily and costs me even if I don’t do anything. (It keeps checking mails and updates)

Then I came across a jaw dropping featured iPhone app for tracking location. iLocalis. It has everything that Find iPhone app promises, and does a lot more.

• Track phone using remote SMS commands
• Notify friends nearby
• Initiate Call remotely ( You can make phone calls from iPhone to any number from a web interface )
• Remote backup ( Never lose your data even if you lose your phone )
• Alert Zones ( Know when ever they come to your area )
• Remote audio recording – A real spy on your phone who send you Thief’s secret talk to your email
• Remote iPhone lock

Another very cool feature is that, you can update your location data to Google Latitude in real time. This helps users with old iPhone to use Google Latitude functionality as official app requires latest iOS.

Wait no more, download iLocalis from cydia. Here is how to do that. Tell me about your lost phone story

Incoming search terms:

track iphone 3g, track iphone remotely, how to track iphone 2g, track iphone location using 3g, iphone remote off on tracker, iphone 2g apps how to lose my phone, i lost my apple 3g phone what to do, how to track iphone using 2g, how to track iphone 2g if stolen, how to track an iphone if stolen