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,...
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...
Jun 23, 2016 | PHP/MySQL Database
You may login to phpMyAdmin, and use the following example SQL to change your MySQL user password SET PASSWORD = PASSWORD( ‘?????????????’ ) Remember to replace ????????????? with your own password. ref.:...
Nov 18, 2015 | PHP/MySQL Database, Web Application
Magento is one of the famous open source E-Commerce web application software. In Magento official site, it will inrregularly release some custom patch to fix software vulnerability https://www.magentocommerce.com/download If customer would like to apply those patch...
Oct 16, 2015 | PHP/MySQL Database, Web Application
When upgrading PHP version (e.g. from PHP 5.4 to 5.5) PHP.net (the official site) may remove some old functionalities. Before removal, it may generate some DEPRECATED messages. For example – In PHP 5.3, deprecated functions includes magic_quote and...