Ybierling

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....

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....

It can be tricky to install a module in PrestaShop, especially for beginners, as the installation module is not fully automatized, like you could be used to see in WordPress or other online content management systems....

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....

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. ...

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. ...

It is sometimes easier to work on some data in Excel, before importing in a MySQL database. In order to do so, here are a few simple steps. In short : export the Excel file to CSV, and import the CSV in a new table using the PHPMyAdmininterface....

After having created your shop, on Prestashop 1.6, you might want to get a new domain name, or change it at some point. In that case, you need to go in the database to change the shop base URL. In my case, going from a subfolder, http://www.wcido.com/maleraffine/ to a specific domain name, http://www.maleraffine.com ...

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. ...

Google products language can usually be changed to any language within the Google available ones by going into Google account > data and personalization > general preferences for the web > language > default language, and changing the default language to the preferred one....

The option to extract subtitles from YouTube videos actually is a standard option in YouTube, provided that the video owner has allowed for its viewers to access and copy subtitles from their YouTube videos....

In order to create an addon domain in cPanel and assign, first of all login to your cPanel. There, locate the domain names menu, where it will be possible to assign new external domains to the current hosting, and point them to a chosen local folder....

When changing host, or wanting to switch to a new domain, there are a few of acions to do on a wordpress installation in order to have it functioning again with the new configuration. However, following this guide, it should be pretty easy to migrate wordpress site to new domain ! ...

The first step is to install xampp, which is one of the best ways to code with PHP on Windows. Composer php requirements are met by the latest versions of xampp in windows 10. Then, download Composer for Windows, which offers an executable for installation. Composer is a library that handles dependencies for PHP....

There are many ad exchange networks available to monetize your web site or blog. The best way to monetize it? Register at Ezoic mediation partner, which will select for yourself the highest paying ads for your website based on an auction system....

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....

Enabling gzip compression on your script / webserver will not only help you achieving a greater score on Google PageSpeed "Enable compression" [1] test, but also allow a faster rendering time on your visitors browser....

Want to create a map chart to share, either by putting it online on your website like below, or sharing a picture ? And, on top of that, an interactive map? This is very easy with Google Sheets. Start by going on your Drive, and select NEW > Google Sheets:...

In order to render your web pages faster from WordPress, and to score higher on Google PageSpeed Insights, especially on the Enable Compression test, you should activate Gzip compression. You can check if that's the case for your website on gidnetwork....

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....

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....

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)....

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....

Getting this issue when trying to start Apache PHP on XAMPP server ? The reason might be that the apache port you are using is already in use and windows could not start apache 2.2 on local computer, so you cannot use it for your Apache web server. You must change apache port....

It is possible, and even very easy, using Notepad++ software as an XML editor, to indent an HTML file, using the Notepad++ XML plugin called XML Tools, directly available in the Plugin Manager, which is built in Notepad++ - a great XML viewer by the way....

Looking for movies to download locally, in order to be able to watch them on the go ? It is actually pretty easy with a small trick on your favorite search engine : simply use the following code, replacing [Title] by the title you are looking for :...

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....

After having setup your shop, you might to have friendly URLs, meaning readable links to your content, for Prestashop 1.5 and 1.6. Non readable default URL : http://www.maleraffine.com/index.php?id_product=8&controller=product...

A domain name bought and administered on GoDaddy can easily redirect to another website, hosted at another registrar. See below how to configure your account to have a domain name from the GoDaddy auction redirected to another server....

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....

In order to get the list of links from your Wordpress websites - which you might need for example to get all links from a website to share it, or create a list or redirection pages after a Wordpress change site URL, install the plugin All In One SEO Pack....

In order to have a website URL showing properly in a Twitter card, some extra meta tags are necessary, with the publisher handle, the page title, the content description up to 200 characters, the creator content handle, and an image, that must be larger than 120x120 pixels....

When you have a Google AdSense account, which is how to earn money from adsense and how to add google ads to your website, you might want to change the adsense payment threshold, which is how often does adsense pay....

Setting up a newsletter for your audience, and looking for an HTML newsletter template that is responsive, easy to use, and works on both GMail and MSOutlook, and an easy way to manage the subscription and sending in PHP?...

Deleting a database in phpMyAdmin is pretty easy and straightforward, but also very dangerous. Make sure that a backup is available before doing so, and that the right database has been selected ! Using SQL, this syntax will do the trick, by replacing the database name for the one on the local MySQL server : ...

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....

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....

In order to have a website URL showing properly in the Facebook Open Graph, some extra meta tags are necessary, with the page title, the page type, the page URL, the image URL, the page description, the site name, the article publication and modification dates, the article section, the article tag, and the Facebook administrator ID....

To go back to the previous editor of WordPress, go to plugins > add new > classic editor, install and activate the classic editor plugin. With the latest update of WordPress 5.0, a new WordPress content editor is included, called Gutenberg, which have a radically new user interface....

If you want to share or include a Facebook page on your WordPress blog, or on any website, it is pretty simple. First of all, go to the Facebook page you'd like to share, for example MI Morena Beachwear, and copy the URL from the browser's address bar....

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....

It is possible in Google Analytics to show or hide domains and subdomains by using filters for a specific view, in Admin > View > Filters > Add filter. Adding or removing a filter will however not change existing data, but will be applied on the future visits that will happen on the site....

The error comes from Skype already using the port. In order to solve it, simply exit Skype, start XAMPP, and afterwards start Skype again if necessary. Getting this error when trying to start Apache with XAMPP ?...

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....

It is possible to increase the FTP upload speed with FileZilla by increasing the number of simultaneous connections. It will also improve the download speed for the same reasons. This trick will especially work well with many small files to upload, however, it won't help much with large FTP file transfer....

Having been using the plugin Media File Renamer for quite some time with great success, it seems like with one of the latest updates, it cannot generate thumbnail anymore. The solution to solve the missing pictures when Wordpress media library doesn't show images, is to find a way to regenerate thumbnails for Wordpress....

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....

When FTP websites connections are set up in FileZilla connection manager, it is possible to retrieve the password, along other connections information, and even pass it to an other FileZilla installation. ...

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. ...

By default, posts created in WordPress and scheduled for future publication, are not visible to users not logged in - both for the article, and for the preview. In order to allow visitors to review one post, for example in case an article has been written in collaboration with an external party, two solutions are offered :...

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....

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....