Category : Laravel



Laravel - How to make subquery in select statement?

Sometimes we require to make subquery inside the select statement in Laravel. At that time we are thinking how to select from subquery using in Laravel Query Builder. In this post i will give you example of subquery in select statement in Laravel 5 application from scratch. For subquery in select statement we are going to use <strong class="path">DB::raw()</strong>. DB raw function through we can simply make suquery join in Laravel Eloquent Query Builder. Here as bellow full example, i have three tables as listed bellow: <strong>1)products</strong> <strong>2)products_stock</strong> <strong.....

By Hardik Savani | February 6, 2017 | | 40637 Viewer | Category : Laravel
READ MORE

Laravel 5.4 - send email using Markdown Mailables

Some days ago release Laravel 5.4 framework new version with new features and many upgrade. Laravel also provide documentation for Laravel 5.4 on their website. There are several update in Laravel 5.4 like in collections, Markdown Mailables for send mail, factory helper, Bootstrappers etc. In this tutorial we will learn how to send email using new feature Markdown Mailables in Laravel 5.4 version. Laravel 5.4 introduce new feature Markdown Mailables for Mail facade. Markdown Mailables provide us pre-built templates and components of mail notifications. they render beautiful, responsive HTML t.....

By Hardik Savani | January 28, 2017 | | 121995 Viewer | Category : Laravel
READ MORE

Laravel 5.4 New Feature - Add new Components & Slots in Blade Template

Some days ago release Laravel 5.4 new version with new features and many upgrade. Laravel also provide documentation for Laravel 5.4 on their website. There are several update in Laravel 5.4 like in collections, mail, factory helper, Bootstrappers etc. In this article we are going to explain laravel 5.4 new feature Components and Slots in blade template engine with example. Components and slots provide us very similar benefits to sections and layouts. however, it is better way to use Components and Components for reusable template layout like for alert. So in this post, we are going to see h.....

By Hardik Savani | January 26, 2017 | | 22629 Viewer | Category : Laravel
READ MORE

laravel 5.4 New Feature - Add eloquent whereKey method

Yesterday release Laravel 5.4 new version with new features and many upgrade. Laravel also provide documentation for Laravel 5.4 on their website. There are several update in Laravel 5.4 like in collections, mail, factory helper, Bootstrappers etc. In this post we are going to see whereKey method in Laravel Eloquent. whereKey is very simple way to use and pretty interesting feature. laravel provide us where condition with add key(column) name and then value, But in this method you have write Key = name of column. So i am going to give one example for whereKey() that way you can understa.....

By Hardik Savani | January 25, 2017 | | 12268 Viewer | Category : Laravel
READ MORE

Laravel 5 dynamic autocomplete search using select2 JS Ajax - Part 1

Today, I am going to share with you how to make dynamic autocomplete select dropdown from database using select2.js plugin in our Laravel 5 application. Why we have to use autocomplete for our project ?, Sometimes we have more or thousands of records on our tables like users, products, tags etc, so that can not possible to handle in manage from select box. But you must require to make select dropdown for your products tables then you can do it using select2.js plugin. I already post autocomplete with Bootstrap Typeahead Plugin(<a href="http://itsolutionstuff.com/post/laravel-5-autocomplete-us.....

By Hardik Savani | January 19, 2017 | | 27492 Viewer | Category : Laravel
READ MORE

Laravel 5 dynamic autocomplete search using select2 JS Ajax - Part 2

<br/> After complete 4 steps in our Part 1, we have to proceed next step from Part 2. In this part we write code for how to manage controller method and how to give response them. We also write code for view blade layout files. This part is hart of "Laravel 5 dynamic autocomplete search using select2 JS Ajax" article, In this part you will see the logic of database and blade template. So you have to follow this bellow remaining steps. <strong class="step">Step 5: Create Controller</strong> In this point, now we should create new controller as Select2AutocompleteController in this path <stron.....

By Hardik Savani | January 19, 2017 | | 50138 Viewer | Category : Laravel
READ MORE

How to get location information from ip address in Laravel ?

Sometimes, we may require to get user information from ip address in Laravel 5 application at that time this article can help to get info from IP. We can get information from IP Address using "stevebauman/location" composer package for Laravel. "stevebauman/location" through we can get info like country Name, country Code, region Code, region Name, city Name, zip Code, iso Code, postal Code, latitude, longitude, metro Code, metro Code. They will provide bellow following details that they can get from IP. So first we require to install "stevebauman/location" composer package by using followin.....

By Hardik Savani | January 11, 2017 | | 19603 Viewer | Category : Laravel
READ MORE

Laravel 5 - Dynamic Dependant Select Box using JQuery Ajax Example - Part 1

In this Tutorial, I am going to share with you how to make dynamic dependent dropdown box using Ajax like When i select category, then sub category select box value should be change. We can't do this stuff without ajax. So, in this Post i am going to give you full and very simple example of dynamic select box using change event of jquery. This article written in two parts, so it can be easy to understand and if you are beginner then also you can simply perform because this tutorial is from scratch. In this example i created two tables as listed bellow: <strong>1)countries</strong> <strong>2).....

By Hardik Savani | January 8, 2017 | | 27785 Viewer | Category : Laravel
READ MORE

Laravel 5 - Dynamic Dependant Select Box using JQuery Ajax Example - Part 2

<br/> After complete our fist part of Laravel 5 - Dynamic Dependant Select Box using JQuery Ajax Example, Now we have to do main task for Dynamic select box value. In this part we follow two step for create Controller File and Laravel Blade File. In this part we write code for how to manage controller method and how to give response them. So let's follow this bellow remaining two step of change drop down options on change of parent dropdown. So let's follow: <strong class="step">Step 5: Create Controller</strong> In this point, now we should create new controller as AjaxDemoController in th.....

By Hardik Savani | January 8, 2017 | | 54802 Viewer | Category : Laravel
READ MORE

MySql comma separated column join in PHP Laravel 5

If we work in big application or project of Laravel Framework, sometimes we require to manage column value into comma separated because we can save memory of database. But if we store comma separated value in column with ids then it's difficult to inner join or left join and get records from another tables. However, SQL provide FIND_IN_SET() for checking value one by one, that way we can also search from comma separated value. FIND_IN_SET() will help to join with tables and we can simply get data. In this post, I will give you full example of how to get data from comma separated column table.....

By Hardik Savani | January 7, 2017 | | 6924 Viewer | Category : Laravel
READ MORE

    How to integrate paypal payment gateway with laravel 5.4

    How to integrate paypal payment gateway with laravel 5.4

    Open Post

    How to remove # from URL in AngularJS?

    How to remove # from URL in AngularJS?

    Open Post

    Multi select autocomplete jquery example with code

    Multi select autocomplete jquery example with code

    Open Post

    Laravel 5 dynamic autocomplete search using select2 JS Ajax - Part 2

    Laravel 5 dynamic autocomplete search using select2 JS Ajax - Part 2

    Open Post

    Laravel 5 - Multiple Images Uploading using dropzone.js example with demo

    Laravel 5 - Multiple Images Uploading using dropzone.js example with demo

    Open Post

    Jquery - Display a loading gif image before a image loads using Eager ImageLoader plugin

    Jquery - Display a loading gif image before a image loads using Eager ImageLoader plugin

    Open Post