This is the solution to the last SQL exercise from the series covering the students/disciplines field. The Third one from the series featured a WITH AS and GROUP BY clause, today we are working more on SQL aggregations such as : MIN MAX AVG Same Context Solution Here is what you should obtain as a […]

We will explore a bit the PDO Library (Php Data Objects) provided by Php. Context The code base includes the following features : PSR4 autoloading with Composer Typed properties Mysql DB with 2 tables A controller and 2 entities following the tutorial (following the MVC Pattern) A default endpoint (homepage displaying all data from an […]

Let’s produce a docker-compose file to let a full website run from on any of your machines ! Actually more precisely we will prepare a docker compose file so we can test some web resources real quick and not only WordPress, Drupal, Magento… ! Checkout the features covered : Docker Compose Apache Mysql Php Virtualhosts […]

This it the first DBA (DataBase Administrator) exercise of a long series, in my opinion to be a better programmer, you need to practice regularly and the same affirmation stands for a DBA so I decided to introduce a new training exercise every week. Before I implement a fully working interface to make you benefit […]

Sometimes you need to access your WordPress database in order to modify things quickly and “dirtily” you could use a plugin but when you enjoy dealing with source code without worrying about installing any third part applications, why not just doing it ! Where are our posts inside our WordPress Database ? Get yourself onto […]

When you are working on a large project like a CMS system, you provide different kind of modules and you allow the end user to enable or disable certain modules depending on his needs. There are different way of achieving this : You create the whole database with all tables in it, giving the possibility […]

Let’s say we need to create a database on the fly and use it within our Zend 3 project. Typically you will create the database then store the credentials within your global or local php config file in your autoload directory. But this time we do need to create a second database which name depends […]

Sometimes, you need to update a whole list of products at once and to achieve this in Magento 2, you can come up with the following ideas : using a module, exporting/importing updated products, any manual method hitting through the right Mysql tables Now depending on your skills, you might choose one option over another […]