USE INFORMATION_SCHEMA;
SELECT
table_name, table_rows, round((data_length / 1024 / 1024/ 1024),1) “DB Size in GB”
FROM
TABLES
where
table_schema = ‘database_name’
ORDER BY data_length DESC
Use Facebook to Comment on this Post
Sometime we need to load some content when that element is visible on browser. So first we need to find whether that element is visible on the browser or not.
Below is the demo example :
Javascript function :
function isVisible(elem)
{
var TopView = $(window).scrollTop();
var BotView…
Its quite simple to find the status of the cookies enabled in browser.
We can get the status of cookies enabled using below statment:
window.navigator.cookieEnabled
Use Facebook to Comment on this Post
A pretty simple solution is to check for mobile device is the screen width. Almost all mobile devices have a max screen width of 480px.
We can get the screen width using below statement:
var screen_width = window.screen.availWidth;
The only exceptions are tablet pc’s like the ipad….
We can decode any string encoded using base-64 encoding.
The atob() method of window object used to to a decode data encoded using base-64 encoding.
Example :
window.atob(‘SGVsbG8gV29ybGQgISEh’);
Output : Hello World !!!
Use Facebook to Comment on this Post
We can encode any string to a encoded data (using base-64 encoding) string.
The btoa() method of window object used to to a encoded data (using base-64 encoding) string.
Example :
window.btoa(‘Hello World !!!’);
Output : SGVsbG8gV29ybGQgISEh
Use Facebook to Comment on this Post
…
A cookie can be set either for a specific domain or a domain and its subdomain. Cookie for a specific domain: When you set a cookie from a web server in php using setcookie() function then this function accepts some parameters. Some parameters are required and some are optional. In those parameters there is one…
How iowait impacts System performance System or any server’s performance heavily depends on IOPS. And if MySql is running on the System, it requires disk of high IOPS. Lots of select queries running simultaneously cause high iowait if disk dont have high IOPS. High iowait means cpu is waiting for I/O access. That increase the…
As APC is used for speeding up php sites it by caching php. But many times we face caching problem. We need to clear php cache. It is easy to clear cache from web url but many of us dont know that apc cache can not be cleared from CLI mode. For command line ,…
Always use PHP standard tags i.e. <?php ?> . To ensure the future version support, Please use standard tags for PHP. Always follow a consistent naming standards. Always use Indent and white spaces in codes. It helps to read and understand the code. Always turn on the full error reporting for development. It will show…
Output buffering is used by PHP to improve performance and to perform a few tricks. Without output buffering (the default), your HTML is sent to the browser in pieces as PHP processes through your script. With output buffering, your HTML is stored in a variable and sent to the browser as one piece at the…
This operator takes three arguments – a condition, a result for true, and a result for false. It is a shortcut of doing if statements. Here’s an example: $result = ($a < 16) ? 'true' : 'false'; if ($a < 16) { $result = 'true'; } else { $result = 'false'; }
A regular expression is a powerful way of specifying a pattern for a complex search. Below is a simple example. select email from foo where email REGEXP ‘foo.com$’; In the above example, It will list all the email which ends with foo.com. “$” sign is used to denote the end of the string.
“default” used to set a default value for a variable. If the variable is unset or an empty string, then the default would be display. This modifier accepts one parameter which is the default value to show. {$foo|default:’Default text’}
We can count number of characters in a string through the smarty. Smarty provide a modifier called “count_characters”. {$str|count_characters} Above statement will display the number of characters in the string excluding the white-spaces. {$str|count_characters:true} Above statement will display the number of characters in the string including the white-spaces.
Coding Help 