Feb 1, 2021 | Web Application
To reduce Internet threat (i.e. being hacked) against your WordPress, you may consider to Backup your WordPress (files + database) regularly Keep WordPress (core , theme , plugin) are updated Use Strong password for admin users Use Two Factor Authentication (2FA) Use...
Sep 23, 2020 | PHP/MySQL Database
Starting from MariaDB 10.2 and MySQL 5.7, the default SQL Mode will be changed – From the original default “NO_ENGINE_SUBSTITUTION”, Change to “ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO,...
Feb 13, 2020 | Web Application, Web Hosting
In some circumstance, we would like to delete cookies for particular site inside Google Chrome (If we delete ALL cache/cookies, it will affect other site operation (e.g. auto login session) ) Inside Google Chrome, goto “Settings” Search – “site...
Mar 26, 2019 | Web Application, Web Hosting
If user installed SSL, and wants the entire website redirect from HTTP to HTTPS, users can add the following to .htaccess. (Before modifying, if there is an existing .htaccess file, remember to backup first) RewriteEngine On RewriteCond %{HTTPS} off RewriteRule (.*)...
Sep 7, 2018 | PHP/MySQL Database, Web Hosting
In some circumstance, customer PHP website may use PHPMailer to send email Below is a basic PHPMailer configuration example for your reference – (You need to adjust Host, Username, Password , and your email content) <?php # # Based on PHPMailer v6.0.5 # ref.:...
Aug 4, 2016 | PHP/MySQL Database
We will gradually replace MySQL database with MariaDB database. According to Wikipedia MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. It is notable for being led by the original...