Tag: tutorial

In this tutorial, I will share with you guys how to create a room booking system using Laravel 6. I will also use AdminLTE 3 as the dashboard design.

Laravel 6 just release last September 2019 and the latest version now is Laravel 6.3. AdminLTE 3, on the other hand, is only available in the release candidate (RC) version.

You can check this demo site for the final version. You may register for an account to experience a normal user role, or login as superadmin at pisyek dot com with password to see the admin functionalities.

Please note that there also will be an email verification function to validate the registered user account against bots. An email will be sent to newly registered users. Only verified users can access the dashboard page.

As you may notice, the Laravel 6 Room Booking System support multi-role. We will have the Booking Management module, Room Management module, User Management module, and Role Management module.

Without further ado, let’s get to it.

I recently work on data analytics and is required to do a lot of ETL from OLTP to OLAP database. I found that this PHP-ETL package can be easily integrated into Laravel 5 application.

You may wonder what is ETL?

ETL is a type of data integration that refers to the three steps (extract, transform, load) used to blend data from multiple sources. It’s often used to build a data warehouse.

During this process, data is taken (extracted) from a source system, converted (transformed) into a format that can be analyzed, and stored (loaded) into a data warehouse or other system (source: Sas.com).

So how to do CSV ETL with Laravel 5?

Continue reading “How to do CSV ETL using Laravel 5 and PHP-ETL”