PHP Technical Blog
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>
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
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));
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
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
Subscribe to:
Posts (Atom)