Force https and www using htaccess
To force a website domain with https and www, simply add this line to your www root htaccess file RewriteEngine On RewriteCond %{HTTPS} off [OR] RewriteCond…
Replace table string with SQL Query
Fastest way to replace a table field string with SQL statement. UPDATE [THETABLENAME] SET [THEFIELDNAME] = REPLACE(THEFIELDNAME, ‘string_to_replace’, ‘new_string’)
How to check duplicate records in MySQL database?
SQL query statement to find duplicate records in a database table. SELECT fieldname1, fieldname2, COUNT(duplicatefieldname) FROM tablename GROUP BY duplicatefieldname HAVING COUNT(duplicatefieldname) > 1
Change MySQL timezone during MySQL Connect
If you are using NOW() at your MySQL query, you may have problem when you hosted the file at different timezone server. The easier way to…
Change server timezone with htaccess file
This is the code use to change server timezone to Malaysia Time. Simply create a .htaccess file in the root folder, and put in this code….
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…
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