Best cheap web hosting

Best web hosting 2018 selection : With plenty of competition, and offers that are not always comparable, it is very difficult to find the right website hosting, should it be for a single website, a wordpress blog hosting, a frontpage web hosting, a multi domain hosting, on a shared hosting or a cloud hosting....
Read more

Amazon Associates OneLink - universal Amazon affiliate link

Amazon just launched Amazon OneLink affiliate, its own way to build global links for products on Amazon affiliate international traffic. Before, users had to manually provide links per Amazon international site to the website visitors, or provide a list of links and let the user choose which one to click on....
Read more

PHP GD generated image The image cannot be displayed because it contains errors in Firefox

When generating an image with PHP, for example adding a watermark to a server stored picture, using below code, or similar one with JPEG instead of PNG, image might not be generated at all and throw an error, directly visible on Firefox, but not on Chrome....
Read more

Fix Google PageSpeed Eliminate render-blocking JavaScript and CSS in above-the-fold content

The Google PageSpeed [1] test “Eliminate render-blocking JavaScript and CSS in above-the-fold content” propose you to delivers your site’s JS and CSS files after the HTML is fully loaded – and, therefore, do not pause your HTML loading to download them. ...
Read more

mySQL created and updated timestamp

Creating fields with time stamps that contains the creation and / or the last modification dates in MySQL using PHPMyAdmin is straightforward. No need for specific SQL code in latest versions, as it is now possible to have two different fields in the same table with current timestamp as default, and therefore no need to use triggers anymore for this purpose. ...
Read more

How to change ownership of a Facebook page

A page ownership on Facebook can easily be transferred from one Facebook account to another. It is not possible to change the page owner, but switching from one admin to another one does the trick. In order to do so, another Page Admin has first to be defined for the page, and then the other Admin has to be removed, even when it is oneself. ...
Read more

Solve the tag 'amp-ad extension .js script' is missing

When implementing AMP pages, and getting the error the tag 'amp-ad extension .js script' is missing or incorrect, but required by 'amp-ad'. This will soon be an error, in Google Search Console with Google AMP ads or over advertisement network, it simply means that a specific AMP script for ads has been forgotten in the web page....
Read more

Prestashop Google Analytics tracking

In order to analyze your Prestashop website with Google Analytics, all you have to do is to install the module ganalytics. See below an example of how to proceed with www.maleraffine.com: First of all, go to the administration panel, in Modules and Services. Search for Analytics or ganalytics, until the following module is displayed - make sure the filters shows non installed modules in case of no result. Click on Install....
Read more

Prestashop how to create discount and voucher codes (percentage, fixed amount, ...)

Creating a percentage discount code, meaning the customer enters a specific character string at the end of order process, and gets ABC% discount on his order, is pretty easy - and it is even a standard functionality of Prestashop, called a Cart Rule in latest 1.6 version....
Read more

Google PageSpeed Insights solve issues and get green

Google PageSpeed Insights [1] is a great tool to see how your website perform. In case you got a poor score, here is a series of articles with easy to implement solutions to solve most of the issues. This allowed me to go green on the Google PageSpeed Insights [1], going up from a score of 17 on mobile (Fig 1) to 89 (Fig 14), and up from 35 (Fig 3) to 89 on desktop (Fig 16)....
Read more

How to add a foreign key in phpMyAdmin

Adding a foreign key in phpMyAdmin is pretty simple, but the option might be difficult to find. Open the table in which you want to add the foreign key. Go to the tab Structure, in which you will find a sub menu called Relation View. There, select to column which will hold the foreign key, and the table and column referenced by this key....
Read more

Wordpress bulk rename images for SEO optimisation

For a better WordPress SEO website optimization, but also not to share your local files names, especially for pictures / images media, and avoid sharing bad names like 11-finalresult.png in the example, but having a nicer ms-excel-2013-how-to-make-a-table-look-good-resize-columns-to-fit-content.png instead, an easy solution is to use an image renamer plugin for WordPress....
Read more

Setup Gmail with GoDaddy domain or another own domain

Setup Gmail to send emails from myemail@mydomain.com, instead of the myaccount@Gmail.com, with a quick and easy configuration, and centralize your emails on your Gmail account. It is important to setup personal email addresses, such as contact@mydomain.com, with an own domain name....
Read more

PHPMyAdmin repair table

After an operation on the MySQL database with PHPMyAdmin, for example complicated search queries that didn't bring any result and crashed, it might happen that the database isn't accessible anymore. At this point, when trying to open a table, no content is displayed. The error behind it is most likely MySQL table is marked as crashed and should be repaired....
Read more

cPanel add new domain

Adding a new domain in cPanel is pretty easy, in Addon Domains > Create an Addon domain. When having a website hosting at one provided, and a domain name registered at another provider – for example gandi.net or godaddy.com – it is necessary to add the domain name to the list of Addon Domains (or external domains), in order to have requests from that URL addressed to defined hosting....
Read more

Turn on or off Facebook page reviews

By default, the visitors review on Facebook business page are not activated. In order to activate or deactivate them, go to Settings > Templates and Tabs > Add a Tab > Reviews. Start by opening a business page for which you are administrator, or at least Editor. If you don't have the right role, ask your administrator to grant you a sufficient access level....
Read more

PHPMyAdmin display description in foreign key drop down selection

It is possible in PHPMyAdmin to display the description of a foreign key, instead of the identifier field. For example, with a table of cities referencing a table of countries, where the identifier is a unique incremental number, display the country description instead of the number....
Read more

Move Wordpress from subdomain to root

In order to move your WordPress installation to another directory, you need to execute a few steps. This will allow for example to move the WordPress installation from a subfolder to the root folder, or the way to move it a new domain, but moving the files to the folder corresponding to this new domain name....
Read more

Fix Google PageSpeed leverage browser caching in htaccess

To optimize browser caching in htaccess, simply add the following code inspired by a Stack Overflow thread [1] in your htaccess file : It will allow you not only to pass the Google PageSpeed Leverage browser caching test, but most importantly to speed up your website access time. ...
Read more

WordPress Polylang missing links

When managing a multilingual Wordpress blog, and having posts in several languages, it might happen that some posts that have been translated are not linked between each other, with PolyLang plugin. See below example, this published Polish version of a post is not linked to any other language, there are missing language links....
Read more

Import a large SQL file in PHPMyAdmin

When wondering how to be able to import a larger SQL file in PHPMyAdmin, the solution is pretty easy, to allow it through the standard phpMyAdmin sql import - which can also be used to import a csv in phpMyAdmin, or even to import an OpenDocument Spreadsheet in phpMyAdmin, simply by changing the input format in import menu....
Read more