Beginning

 
One accounting and reporting system supported by our company began to grow very quickly in the amount of data stored. The system is written in PHP using the Yii2 framework. Initially, the reports were built through the library PhpSpreadsheet, which replaced the already long deprecated, PhpExcel.
 
 
Among the different types of reporting was one very large - in fact the complete set of all data stored in the database should be uploaded into one excel table. At the initial stage, there were no problems, but when the volume began to exceed many hundreds of thousands of records, the ...[/h]

Recently VPNBook began to publish the password instead of direct text in the form of an image. "Well, it's like that," I thought, and began to look for ways to solve this problem. Recognize the "picture" VPNBook password in PHP. And, of course, the script for Mikrotik.
 
Customize the automatic obtaining of a password for VPN on Mikrotik ". Prior to the problem, the password for VPNBook could simply be extracted from the html page, for example, as:
 
 
preg_match ('/Password:
([^<]+) /', $ homepage, $ matches);
print ($ matches[1])
 
And recently the password has become a "picture". And ...

There was an online store and a b2b platform from one company on the 1c-Bitrix system. The company grew and its warehouses appeared and added warehouses of partners that needed to be displayed. There was a need to display balances in several warehouses.
 
And what does Bitrix tell us: Please go to the editorial office of "Business" and everything will be fine and immediately. The editorial board went over and it turned out that the multi-value and multi-folding in 1C-Bitrix live a separate life. The first is needed to display different prices for different user groups, and the second one is used ...

Translator's note:
I also thought that the time of the articles "What is faster - double or single quotes?" passed 10 years ago. But here is a similar article ("What performance tricks actually work") recently gathered on Reddit a relatively high rating and even got in PHP digest on Habré. Accordingly, I decided to translate the article with a critical analysis of these and similar "tests".
 
There are many articles (and even entire sites) devoted to launching a variety of tests comparing the performance of various syntactic constructions, and claiming on this basis that one is faster than ...

About a year ago, our company set a course for the separation of a huge monolith on Magento 1 for microservices. As a basis, only the Symfony 4 released was released. During this time I developed several projects on this framework, but I found it particularly interesting to develop bundles, re-used components for Symfony. Under the step, a step-by-step guide to developing the HealthCheck Bundle to obtain the status /health of the micro service under Syfmony 4.? in which I tried to touch on the most interesting and complex (for me at one time) moments.
...

 
I remembered the site of an old buddy who had one hip-hop in the site tape, about 6 years ago he spit on the speed of loading pages: "Yes, yes, yes, I need to remake, but there's nothing complicated there " but went now - everything is as before :-) Despite simple technical solutions, I admit that not only do I have such a friend. So this is a small technical note.
 
 
stackoverflow.com/questions/10066638/get-youtube-information-via-json-for-single-video-not-feed-in-jаvascript/23253789#23253789 ...

 
 
In the TDD community there is a council that says that We should not use mock objects for types that do not own . I think this is good advice, and I try to follow it. Of course, there are people who say that we should not use mock objects at all. Regardless of what opinion you hold, the advice "not to imitate what is not yours" - also contains a hidden meaning. People often miss him by seeing the word "mock" and falling into a rage.
 
Guzzle HTTP client , instead of using Guzzle directly.
 
 
Why? Well, to begin with, Guzzle has a much more powerful ...

Hello! We present to your attention the next open lesson "Basic concepts of databases", which we conducted within the framework of the course "Backend developer on PHP" . The webinar was led by the second teacher of the course - Oleg Kozintsev , who analyzed in the lesson the description of the conceptual schemas of the domain using the ER-model, the history of SQL, its standards and compatibility and analyzed the relational model in detail.
 
 

Most likely some parts of this article are already familiar to many hobblers, but in connection with the purchase of a new working laptop I decided to collect all the grains together and organize a convenient tool for development. I often have to work with a lot of small projects, with different versions of PHP, often translate old projects into new versions. In the distant past, when I was a Windows user, I used OpenServer. But with the transition to Linux, I lacked the simplicity of creating hosts and switching versions that were in it. Therefore, we had to make an even more convenient solution ...