PHP - To Check Query Process

PHP - To Check Query Process:  Here i will explain how to check the mysql query processing by using php. This function shows you which threads are running. Here i'm using "SHOW FULL PROCESSLIST" mysql command. This command is very useful if you get the "too many connections" error message and want to find out what is going on. The output...

Read More

PHP to get yesterday(previous) date

PHP to get yesterday(previous) date: Here are some methods to get the previous date using php. i.e.,) yesterday date. Here date() function is used and "D d-M-Y" format is used, it will return the date format like "MON 29-Jul-2013". Let we go to some examples to get the yesterday date in php. 1. echo date("D d-M-Y", time() - 60 * 60 * 24); 2....

Read More

Increase Import Maximum file size in phpmyadmin

Increase Import Maximum file size in phpmyadmin                    Here are the steps to increase the import file size in phpmyadmin. Usually phpmyadmin allows to import sql files maximum of 2M (i.e 2,048kb). To increase the maximum file size do the...

Read More

Replace MS Word single quotes in PHP

Replace MS Word single quotes in PHP:  The following function is used to replace Microsoft-encoded quotes in PHP. function replaeQuotes($str)  {      $str1 = array(chr(145),chr(146), chr(147), chr(148), chr(151));      $str2 = array("'", "'",'"','"','-');      return str_replace($str1, $str2,...

Read More

Remove MS Word special character symbol in html

Remove MS Word special character symbol in html :  To remove the MS Word special character in html page or website page you just add the bellow header meta tag in your header field. <META http-equiv="Content-type" content="text/html; charset=iso-8859-1"> Note: In some case the above meta tag will work individually, ie.,) No need to add...

Read More

PHP Remove HTML tags from a String

PHP Remove HTML tags from a String :  The following code is used to remove the html tags from string. <?php $input="Hi this is <b>TechniqZone</b>"; $text = strip_tags($input, ""); echo $text; ?> Output is Hi this is TechniqZone. The above code remove all html tags from string. Here strip_tags() function is used to...

Read More

Display Current Indian Standard Time using PHP

Display Current Indian Standard Time using PHP :  The following code is used to get the current indian standard time using php. here the default_timezone_set() function is used to set the country to set the particular time or date of that country. <?php date_default_timezone_set('Asia/Calcutta'); echo date("h:i a"); ?> Output of...

Read More

Php to convert UTC time to local time

Php to convert UTC time to local time  Here is a simple code to convert UTC time to local time in php. The $dateInLocal displays the UTC time as localtime. $time = strtotime($dateInUTC.' UTC'); $dateInLocal = date("Y-m-d H:i:s", $time); echo $dateInLocal;...

Read More

Attachment in mail using PHP

Attachment in mail using PHP In the previous post, I described HTML content in mails. In this post we can see how attachment in mails can be done using PHP . $to = 'youraddress@example.com'; //define the subject of the email $subject = 'Test email with attachment'; //create a boundary string. It must be unique //so we use the MD5 algorithm...

Read More

PHP to Determine Page Execution Time

PHP to Determine Page Execution Time : The below code is used to find the php page execution time. Just paste the below code in header portion in php page. <?php     $time = microtime();     $time = explode(" ",$time);     $time = $time[1] + $time[0];     $starttime = $time;  ;?>  after...

Read More

Sending Nice HTML Email with PHP

Sending Nice HTML Email with PHP :    Everyone wishes to include Html content in their mails. Here is a sample code to send a mail with HTML content. You can edit the HTML content as you prefer. $to = 'sample@example.com'; $subject = 'Sample HTML content'; $headers = "From: " . strip_tags($_POST['req-email']) . "\r\n"; $headers...

Read More

PHP Get Last 12 Months

PHP to get last 12 months :   The following coding is used to get previous 12 months by using PHP. <?php for ($t = 1; $t <= 12; $t++) {     echo date("F Y m", strtotime( date( 'Y-m-01' )." -$t months"));     echo "<br />"; } ?>  Output of this code is : June 2013 06May 2013 05April 2013...

Read More