1 year, 3 months ago
In any big project where composer is used, there is one problem sooner or later. In a framework, or in its some separate packet correct an error or add functionality, and the developer does not hurry to accept pull request. At the same time there is a wish to use temporarily updated packet, and then when pull request after all accept, to return to the official version. The situation is also complicated by the fact that the packet can be specified in dependences of other packets therefore just to replace one packet with another in composer.json it will not turn out.
Get acquainted: Pagekit is the new modular CMS from the German studio vendor of the YOOtheme templates based on Symfony components, and also Vue.js, Webpack, Doctrine and other modern technologies. Pagekit reflected as a simplicity combination in management to flexible opportunities for development — what is not enough for the known CMS based on PHP and having a set of anachronisms.
1 year, 3 months ago All hi. There came new 2016, so it is time to update tools for simplification of boring mechanical work. Departments of analytics, marketing, sales often face the following difficulties when updating the reporting: 1. Data should be aggregated from several sources. 2. Reports are formed in Excel that imposes considerable restrictions for volume of the processed data. 3. Modification of the unloadings which are in advance configured by developers business as a rule not the faster.
If reports need to be updated weekly or even daily, then this procedure becomes very napryazhny even for the most patient. By means of a superstructure of Excel Power Query and data record in MySQL it is possible to reduce updating of the majority of reports before simple clicking of the Update button: 1. Data from any quantity of sources are imported through SQL queries to the normal tables Excel. 2. Even from big base it is possible to write in Excel only small part of data (for example, total sums for the necessary range of dates with grouping only on the necessary columns). 3. Changes can be made to the report just having changed the SQL query. Further we create the necessary report standard means of Excel.
I will show how to configure and autocomplete the simple MySQL databases (on the example of unloading of statistics of all key word from Metrics Yandex) in this article, and then one button to update reports in Excel, using Power Query superstructure. Power Query has very strange features of work by drawing up SQL queries (especially dynamic) which we will sort in the second part of article.
Following tradition, we decided to sum up the results of the expiring year and to select the most significant events in the world of PHP which, fortunately, there was much. And of course, a selection with links to fresh materials for the last three weeks.
1 year, 4 months ago
I as much as possible will try to write without "water". A minimum of the excess distracting information and verbalizations. Maximum of useful information and working code. I will not bring up a question why to someone own torrent search engine based on RuTracker. And I do not consider myself the guru of programming. We will just make this website together. Let's use Apache+PHP, MySQL and Sphinx. At once I will warn that the website will work at the minimum virtual hosting absolutely not quickly.
And now we will be focused on system of mentors. In fact, this my personal opinion which formed for years which I spent in this sphere, but nevertheless I would advise everyone to read article and to learn how many people will agree and will not agree with me.
1 year, 4 months ago
Comet — any model of work of a web application at which permanent HTTP connection allows the Web server to send (push) given to the browser without additional request from the browser.
On the scheme the place of comets of the server in the course of work is represented.
1 year, 4 months ago
Everything began when I customized a security system of one CRM. As it often happens, in it there were users with the different permission access levels to a specification (we will call them entities). They had an identical type of the main grid, customizability of access to entities was necessary. At first I thought of ACL, but …
During quite long time about it there were no news, but, after long waiting, PHP 7 at last left on December 3, 2015. We decided to test the most popular CMS based on PHP to check as they work with PHP 7.