A quick check for DNS TXT record using Mac Terminal
Below are the quick command to check a domain name TXT DNS record using Mac OSX terminal. dig -t txt example.com
Prepend a string value of a field using SQL Statement
Sometime we would like to add a string in the beginning of a string value, an example is to add a “6” in front of all…
Find current folder physical path?
Simple way to display current folder physical path in PHP. echo dirname(__FILE__);
cPanel Cron Job to execute external URL
A simple code to schedule cron job to call or execute an external URL without creating the log. wget -q -O – http://thedomainname.com/thefilename.php >/dev/null 2>&1
Force website HTTPS with .htaccess
Adding this code above all other code in .htaccess file will force visitor to https instead of http. RewriteEngine On RewriteCond %{HTTP_HOST} ^domain.\.com [NC] RewriteCond %{SERVER_PORT}…
SQL Statement to find duplicate data
Sometime we just want to find any duplicate data in the table, this simple statement will help to get the list of duplicate data. SELECT field1,…
SQL Statement to update one table field with another table field
A simple statement to update one table field with another table field value. UPDATE theUpdateTable INNER JOIN theValueTable ON (theUpdateTable.matchValueField =theValueTable.matchValueField) SETtheUpdateTable.valueToUpdate =theValueTable.valueToUpdate
Way to compare 2 Tables data using SQL statement
Sometime we just need to compare left and right table to ensure the data are tally. There’s 2 SQL statement we can use to achieve this….
Setting Time Zone in PHP
Working on an oversea project lately which required to host the web application on different time zone server. It’s too troublesome to update every single PHP…
How to create batch file to Flash DNS
Sometime we need to flush the computer DNS record due to some changes of domain pointing. Instead of going to every computer and running the same…