"MySQL"

How to import data from external MySQL database to Magento 2

Magento 2 mysql data import

Often it is necessary to import products, customers, orders, or other data types to Magento 2 from a third-party MySQL database. However, Magento 2 doesn’t let you do that. Although the default tools don’t support such file sources as external databases, there are several ways to synchronize Magento 2 with external databases

In the following post, we shed light on how to achieve this goal in two different ways. Firstly, we describe a common approach that involves the default Magento 2 import solution. It requires tons of manual work and cannot be automated. You need to run a CSV export from your MySQL database, match third-party attributes to ones used in Magento 2, and import your MySQL table into your e-commerce website.

On the contrary, you will find out how to avoid numerous unnecessary chores while importing data to Magento 2 from a MySQL database. This approach involves the Improved Import & Export extension. The module combines MySQL database connection and other data import activities within a single interface right in your Magento 2 admin.

After that, we shed light on several MySQL facts as well as describe the core features of the Improved Import & Export extension. To make the long story short, let’s see how to import data from an external MySQL database to Magento 2.
Continue Reading

Tame The PHP Monster With The Best PHP Books

- Fire development

The Best PHP Books

A new server-side scripting language was introduced in 1994. Its name was PHP, and it was designed for web development. Nowadays, the language is used on more than 2 million web servers and 244 million websites. During last twenty years, numerous PHP books have been publish to help developers better master it. In below, you will find the best PHP books which could help you a lot with learning PHP. Continue Reading

PHP 7 – features, release date, rumors

- E-Commerce, Fire development, PHP 7

The 7th version of PHPPHP 7 has been finally released!!! You can download the source code here: php-7.0.0. We describe how to install PHP 7 here: Installing PHP 7.

Lack of a native Unicode support was one of the biggest PHP drawbacks. In 2005, developers decided to change this. The newly formed project was designed to provide a native Unicode support to PHP. To achieve this goal, developers decided to use the ICU library (International Components for Unicode). Another significant feature of the project was representing UTF-16 text strings. It was planned to release the project as version 6.0, but we can see only PHP 5.3 and PHP 5.4, both without Unicode integration. As of 2015, there is an ongoing work on a new major version of PHP PHP 7. The PHP 6 with its unicode experiment had never been released, so the name was abandoned.

The Best PHP 7 Books to Read

The Best PHP 7 Tutorials and Tools to Start With

How to Get Ready for PHP 7

UPD (23.06.15): PHP 7 – release date, performance, features, changes

UPD (13.07.15): Interview with Dmitry Stogov

UPD (25.08.15): PHP 7 on Magento EE

UPD (27.08.15): Deprecated functionality which will be removed in PHP 7

UPD (01.09.15): PHP 7.0.0 RC 1

UPD (07.09.2015): PHP 7.0.0 RC2 has been released. PHP 7 will be available on the 12th of November.

UPD (15.09.15): PHP 7 and WordPress, Return types, Scalar types, Threading for PHP, PHP7 Reference, php7cc

UPD (22.09.15): Backwards compatibility issues, PHP 7 screencasts, and a new overview

UPD (29.09.15): PHP 7 tutorial

UPD (26.10.2015): The Acquisition of Zend and PhpStorm 9

UPD (07.11.2015): PHP 7 Hidden Features

UPD (24.11.15) PHP 7 Docker Image for Magento 2

UPD (24.11.15) PHP 7 vs HHVM

UPD (01.12.15): PHP 7 RC 8 has been released

UPD (03.12.15): PHP 7 HAS BEEN RELEASED!!!

PHP 7

Continue Reading

Magento 2 Nginx Configuration

- Magento 2

magento2-nginx-configuration

Nginx is a reverse proxy server for different protocols, such as HTTPSHTTP,  POP3SMTP, and IMAP, as well as an HTTP cache, a load balancer,  and an origin web server. Being an open source project, Nginx has been started with a strong focus on high performance, high concurrency,  and low usage of memory. Nginx runs on Mac OS XLinux, BSD variants, Solaris, HP-UX, AIX, and other *nix flavors. In addition, you can find a proof of concept port for Windows. The project is licensed under the 2-clause BSD-like license, and below we will shade light on Magento 2 Nginx Configuration.

Everything about Magento 2 on Firebear

Magento 2 Demo

Continue Reading

The Complete Guide To Magento Debugging

How to Debug Magento

Integration of new solutions into different systems can become a headache without the knowledge of correct debugging.  In case of Magento, such simple constructions as print_r() or var_dump() , var_export() don’t work. Because of heavyweight constructions, you need to investigate the new effective ways to find intermediate values or broken places. Fortunately, there are a lot of tools and methods designed to turn the debugging into a developer friendly process. Continue Reading

How To Become A PHP Developer (Guide, Learning Platforms, Books)

- E-Commerce, Fire development

How To Become A PHP Developer (A Guide, Learning Platforms and Books)

PHP is a web development language, which is also used for a general-purpose programming. It is installed on more than 2.1 million web servers and 240 million websites. PHP can be mixed with HTML and used in combination with various frameworks and templating engines. The code itself is usually processed by an interpreter. The PHP interpreter is implemented as a native module of a web server or as a Common Gateway Interface executable (CGI). After the interpretation and execution, the PHP code is sent in a form of resulting output to its client by a web server. Usually, it is a part of the generated web page. PHP code can generate an HTML code of a web page, an image, etc. The canonical PHP interpreter is a free software, which is released under the PHP License. It can be deployed on most web servers and works with almost every operating system. In addition, PHP can be used in standalone graphical applications, because it supports a command-line interface capability. Continue Reading