ybierling.com

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

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

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

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

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

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

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

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

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

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

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