Amitav Roy

Blog on web and travel

Creating CSV output from database query result in Laravel 4

Posted on 4 Sept 2014 by Amitav Roy

Generating a CSV file from some records in the database is a very common requirement which a web developer will come across. It will be nice and handy to have a generic function which will take some basic parameters and generate this for us. In this tutorial I will show how we can write a function inside a common utility class which will take a necessary parameters and generate a CSV file output.

Working with workbench and building packages in Laravel 4

Posted on 3 Aug 2014 by Amitav Roy

I come from the world of Drupal where every code that we write is part of a module. This is very useful because over time I am able to develop modules which I can re-use in all of my projects. Codeigniter has this feature using HMVC which I showed in the tutorialHMVS architecture with Codeigniter. The same approach can be followed in Laravel 4 using workbench to create packages. This way we can make an independent piece of code (or some dependent on other modules) and once we plug it in, the module is ready to do what it is supposed to do. In this tutorial I will start with a blog module which will be independent; it will have its own migrations, controllers, models, views and its own routes.

Laravel 4 Swift Mailer with dynamic config to send mail through Gmail

Posted on 18 Jun 2014 by Amitav Roy

Laravel 4 comes with the Swift Mailer library which works great in sending emails from your application. Just set the mail.php configuration file with the required variables and you are good to send emails. Inline images, attachment are like one line code. But the problem with a config file is that the parameters are fixed. I had a requirement where user would send email using their Gmail username and password. So, in this tutorial I will show you how to create a Swift Mailer instance and send a mail with a dynamic username, password and other parameters.

Laravel 4 forms, retain data, default and custom validations

Posted on 15 Jun 2014 by Amitav Roy

Working with forms in Laravel 4 is really fun and there is hardly any PHP application which doesn’t have a form. So, in this tutorial, I will demonstrate how to create a simple registration form using the Laravel’s form library. Then we will validate the data when the form is submitted. We will use the validation library which comes with Laravel 4 out of the box and also our custom validation rule.

Laravel 4 Multiple segment route and Blog post page

Posted on 15 Feb 2014 by Amitav Roy

In this tutorial, I will show how we would define a route with multiple segments in Laravel 4 so that we can use the URL alias of a Drupal node and then take the user to the individual node’s page. Also, we will see how we can override a view section’s content to set the page title to the blog’s title inside the head tag.

Laravel 4 Debug bar and Caching

Posted on 30 Jan 2014 by Amitav Roy

Caching of data is very important for any application and if we can save SQL queries, then it is always a bonus. In my last tutorial, I created the node object which was fetching its data from multiple tables and in different queries. In this tutorial I will cache the node object and save the SQL queries.

Working with XML in Angular JS

Posted on 4 Aug 2013 by Amitav Roy

In this tutorial I will show you how to use the X2JS javascript library to parse XML and turn that into an AngularJS object. This is one of my RND project where I am using XML files along with HTML to create an e-learning shell.

HTML5 local storage with Angular JS

Posted on 6 Jul 2013 by Amitav Roy

In this tutorial, I will use the HTML5 browser local storage along with Angular JS. This storage is very useful for making applications work in offline mode and quickly shift to online mode. This ensures that the application will work without fail even if the internet connectivity is not available.

Angular JS auto update factory sharedObject on database update

Posted on 10 Jun 2013 by Amitav Roy

Getting notifications about a new comment or new activity on Facebook without page reload, or even new mail notification on Gmail is a very important functionality to support the single page app. In this tutorial, I will show how we can call the Angular JS factory method at fixed intervals and update shared data if there is any change in the database.

AngularJS using factory method, post data and saving to DB

Posted on 19 Mar 2013 by Amitav Roy

In the last tutorial, I showed how we can use the factory method to share an object (in our case the list of books) and then we displayed those books in our view. The next step is to post data so that we can add another book to the database and that will also update the main listing. So, in this tutorial I will show you how to do that.