Copy Text From Command prompt and Paste it in Word

Copy Text From Command prompt and Paste it in Word  First you need to select the text in command prompt. To select the text Right click on command prompt and select Mark,then select the desired text,it will highlight the text. Then press Enter to copy the content. Then open Notepad or Word ,press ctrl+v to paste the conten...

Read More

Change Font color in DOS

Change Font color in DOS   You can make DOS as graphic environment using colors for the text and background in DOS.   To change the text-color in DOS,You can use the following   COLOR attr   attr        Specifies color attribute of console output Color attributes are specified by TWO hex digits -- the first corresponds...

Read More

Remove autorun.inf Using Command Prompt

Remove autorun.inf Using Command Prompt   Here is a simple way to delete autorun.inf using command prompt using windows. The function attrib is used to check whether autorun.inf is present in the drive.   Try the following in command prompt. Open command prompt Go to the destination drive using cd destination path and press enter Type...

Read More

Extract Zip File using Php

Extract Zip File using Php:   You can use Php language to unzip a zip file.   Here is a simple code to unzip a zip file using php. Php has ZipArchive class to do this. = new ZipArchive; $zipfile->open('zipfilename.zip'); $zipfile->extractTo('./destination'); $zipfile->close(); ?>...

Read More

Set Multiple Homepages for Internet Explorer

Set Multiple Homepages for Internet Explorer Now Internet Explorer 7.0 also allow you to set the multiple home pages like other browsers.You can open all home pages at the same time. You can set your favorite sites and open it at same time. Follow the given steps to set multiple home pages in Internet Explorer. ·         First...

Read More

PHP - Check if browser cookies are enabled

PHP - Check if browser cookies are enabled. At first php reads the cookie data to see if there is already any data saved in them. If not, upon attempting to store some test data, the script refreshes the page. If no result has been returned; it is an obivous indication that cookies are disabled. if (isset($_COOKIE['stuff'])) {  echo "cookies...

Read More

Grant permission to user to execute a Stored Procedure - Mysql

Grant permission to user to execute a Stored Procedure - Mysql If you want to allow user to execute Store procedure then use GRANT EXECUTE keyword Allow user to execute all stored procedure GRANT EXECUTE ON *.* TO 'user'@'localhost'; Allow user to execute all stored procedure attached with a single database GRANT EXECUTE ON db_name.* TO 'user'@'localhost'; Allow...

Read More

Mysql - Delete duplicate rows based on column value

Mysql - Delete duplicate rows based on column value.  Mysql - Delete duplicate rows based on column value by below query. CREATE TABLE temp_name AS SELECT * FROM tab WHERE 1 GROUP BY colname;  DROP TABLE tab;  RENAME TABLE temp_name TO ta...

Read More

Mysql - Get the record randomly

Mysql - Get the record randomly  RAND() function is used to get the random record from table. For Example: select * from tab_name orderby RAND() limit 0,5;...

Read More

How to use the OFFSET function in MS Excel.?

OFFSET function to return the value of a cell that is a specified number of rows and columns away from a cell or range of cells that you referenced in an adjacent range. Enter the following data into a blank Excel worksheet. You will use this data for all sample formulas in this article. A1: Name    B1: Dept   ...

Read More

PHP - Setting session timeout

Session timeout setting is necessary For high-security sites . Php default session timeout time is 20 minutes. There is 2 functions for change the session timeout. 1. Sets the timeout of a current session and 2. Verifies whether the session is still valid given the specified timeout variable set in above function . function check_login() { @session_start(); $expiration_time...

Read More

Facebook flike and fshare combined in single button

In this new flike code we can like and share in same flike button. After click on this like button popup box will appear and ask “Add comments” option. If you need to share your url means you should enter some comments and click “post to facebook” button. If you didn't give the comment it will store in your facebook activity. It'll also shows the...

Read More

Set Time limit for a php script.

Set Time limit for a php script. If you want to extend the execution time of the script you can use set_time_limit on the page. The default time limit is 30 seconds <?php // script dies after 180 secs set_time_limit(180); ?> /**********************************************/ Get random values from database. SELECT * FROM test_table ORDER...

Read More

Javascript to create zip file

 The Zip file format is very useful for compress the any type of data. we can generate the zip file by using some programming language. Let us see how to create zip file by using javascript. 1. First we need javascript package jszip. 2. import jszip package in HTML document. 3 use the below code :       <script...

Read More