PHP how to sort array with user defined keys

Many times, we need to do sort array with some user defined keys. So we can use pre defined php function to make it easier.  We can array_flip function to achieve it, array_flip — Exchanges all keys with their associated values in an array.  array_flip() returns an array in flip order, i.e. keys from array become values and values from array become keys. Note… Read More »

Filter for unique values or remove duplicate values from Excel OR CSV

In Excel, there are several ways to filter for unique values—or remove duplicate values: To filter for unique values, click Data > Sort & Filter > Advanced. To remove duplicate values, click Data > Data Tools > Remove Duplicates. To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab.

How to redirect non www or non https url to www and https

This is very common problem to everyone to redirect non www urls to www with https. You can follow simple .htaccess rules to implement it. RewriteEngine On RewriteCond %{HTTP_HOST} !^www\. [NC] RewriteRule ^(.*)$ http://www.example.com/$1 [L,R=301] RewriteCond %{HTTPS} off RewriteRule ^(.*)$ https://www.example.com/$1 [L,R=301] The only real difference here is that first we redirect from non-WWW to… Read More »

WHM cpanel magento 2 php cli command error

If you saw error php-cli: command not found when running magento command php bin/magento, then you need to run following commands. To fix this error, you need to enable php cli mode. Run following command source /opt/cpanel/ea-php72/enable based on your php version. It will solve your problem. but it will come again when you will… Read More »

SetEnv fails with Apache 2.4

If Apache error logs show below error message Invalid command ‘SetEnv’, perhaps misspelled or defined by a module not included in the server configuration The control of internal environment variables that are used by various Apache HTTP Server modules are controlled by the module mod_env. By default module ‘mod_env’ will not be enabled in apache2.4.… Read More »