Sunday, December 4, 2011

SQLYOG | Wrong results are returned for FOUND_ROWS().


I am getting wrong results are returned for FOUND_ROWS(). I found easy fix from sqlyog forum.. they have given some steps to fix this problem..

"The problem with FOUND_ROWS() is that it is conflicting with the Query Profiler as Profiler will SELECT .. FROM INFORMATION_SCHEMA ... To use FOUND_ROWS() you will have to turn Query Profiler OFF. If you don't FOUND_ROWS() will return a rowcount for the ´profiling´ table in Information_Schema and not a rowcount for the table where user executed his query. We are considering how we could at least warn about this, of course."

I have attached screent shot where to change to fix this issue...

Google maps api: https security error coming in IE

my web page having google direction map using javascript api and I have got https error whenever try to loading graph into my web page in IE.. I have fixed that problem by small code change...

With HTTS ERROR:
<script type="text/javascript" src="https//maps.googleapis.com/maps/api/js?v=3&sensor=false"></script>



FIXED BY: I have removed "https" from the source URL
<script type="text/javascript" src="//maps.googleapis.com/maps/api/js?v=3&sensor=false"></script>

Tuesday, November 8, 2011

php large number or integer problem converting its adding some plus symbol

php large number or integer problem converting its adding some plus symbol


example:
$var = 100000179860794

echo $var;
output => 1.0000017986079E+14

Using number_format function

$modified = number_format($var, 0, "", "");
output => 100000179860794

Mysql query float value in where condition is giving empty result set for google latitue and longitude values

Mysql query float value in where condition is giving empty result set for google latitue and longitude values

SELECT lat, lon FROM googletable WHERE ABS(TRIM(lat)) = ABS(TRIM(51.5137));

Wednesday, July 6, 2011

Google translate api version 2 curl problem fix

curl_setopt($ch, CURLOPT_HTTPHEADER, array('X-HTTP-Method-Override: PUT') );

Monday, June 13, 2011

File upload download from windows to linux or linux to windows

Local server windows to linux server file upload or linux server to window through PSCP steps are follow,

Requriement.
1. pscp.exe (288 kb this size file working)
2. putty.exe (may needed)

1. open DOS prompt
2. set environment variable path
eg: c:>set PATH=%PATH%;"D:\pscp-path\" and enter
3. d:>pscp-path>pscp enter you can see the option of pscp
4. upload/downlod to server
eg:
pscp yourfile root@yourhost:/serverfolder
pscp root@yourhost:/fromserverfolder d:\your path

Monday, May 16, 2011

copy folder sub folder with symbolic links in dos

XCOPY xampp\htdocs\lifein\eflifein\*.* d:\rajendram_aptana_workspace\lifein\eflifein\*.* /e /s /B