Laravel Popular Post


Laravel ajax render view with data example

Sometimes, we use get html view layout from ajax request. At that you have to first render view file and then you need to store view in varibale and then we can return that varibale. In bellow example i render view with pass data you can see how i did: <strong>Example:</strong> <pre class="prettyprint lang-php"> $data = $this->semester->getSemesterName($input); $type = "Subject"; $options = view("home.ajax",compact('data','type'))->render(); <br/> return $options; </pre>

By Hardik Savani | May 6, 2016 | | 1624 Viewer | Category : Laravel
READ MORE

How to check column exists or not in table Laravel 5

When i was working my laravel application at that time i need to remove column from database. But i am not sure that column is exists or not in tables. So i was thinking, but i found solution from Laravel Database Migration Schema. we can check column is exists or not in tabales using hasColumn. If you also need to remove if column is exists then you can use bellow example. <strong>Example:</strong> <pre class="prettyprint lang-php"> if (Schema::hasColumn('subscriptions', 'stripe_id')) { Schema::table('subscriptions', function ($table) { $table->dropColumn('stripe_id'); }); } <.....

By Hardik Savani | May 4, 2016 | | 1619 Viewer | Category : Laravel
READ MORE

Laravel 5 - whereIn and whereNotIn with subquery example using query builder

As you know laravel is very popular php framework in today. So every point will be require for database related and that important. In this post i would like to share with you how to use subquery with whereIn and whereNotIn clause from scratch. We may sometimes require to use select query with where in or where not in clause. we can simply make query using MySQL. But we don't know how to use it on laravel query builder. However, In this example we will learn how to convert mysql query into laravel query builder of wherein with subquery. This example is from scratch, so i will give you first m.....

By Hardik Savani | March 23, 2017 | | 1607 Viewer | Category : Laravel
READ MORE

How to create middleware with parameters in Laravel 5?

Laravel is the best framework in PHP todays. Laravel framework provide saveral functionality and you can also find from this site. But now in this post you can learn how to create custom middleware with passing parameters in laravel 5 example and how to use middleware with route parameters in laravel 5. In this example you can learn how to add middlware with check user have access role for this route from scratch in your laravel application. I also added how to create middleware in my previous post, you can see that also. In this example i added middleware for check use have role access for .....

By Hardik Savani | June 8, 2016 | | 1597 Viewer | Category : Laravel
READ MORE

Laravel 5 - How to get route parameters in your route middleware?

Sometimes we may require to get route parameters value in our middleware like if you want to check permission etc. You can get easily using request object, that provide route method and you can get it. I also added small example that way you can undestand very well. In this bellow route i have id and userid two route and i want to get value of that parameters in my "check-route-param" middleware so first i have route like: <strong>Example Route:</strong> <pre class="prettyprint lang-php"> Route::group(['middleware' => ['web','check-route-param']], function () { Route::get('{id}/myroute/{.....

By Hardik Savani | May 14, 2016 | | 1530 Viewer | Category : Laravel
READ MORE

Laravel 5 - How to implement gravatar image using thomaswelton/laravel-gravatar package

Gravatar is a service that provide unique globally avatars and integrated it into their WordPress.com blogging platform. If you don't have avatar image then you can get Gravatar src image from thier email if it register on WordPress.com. So if you want to implement in your laravel application then it is very easy. There are several package for Gravatar image for laravel, but we will use thomaswelton/laravel-gravatar package that is i think better. First fire following command on your terminal. <strong>Installation Package</strong> <pre>composer require thomaswelton/laravel-gravatar</pre> Aft.....

By Hardik Savani | May 11, 2016 | | 1508 Viewer | Category : Laravel
READ MORE

Laravel 5 - "syntax error or access violation 1055 in group by" Solved

Yesterday i was working on my Laravel 5.4 application and when i use group by statement in query builder I found error like as bellow: <br/> <strong> SQLSTATE[42000]: Syntax error or access violation: 1055 'admin.products.name' isn't in GROUP BY (SQL: select `products`.*, SUM(products_stock.stock) from `products` inner join `products_stock` on `products_stock`.`product_id` = `products`.`id` group by `products`.`id`) </strong> I was thinking what will be error and why it comes. i thought maybe it comes from mysql. i just add following query using laravel builder as like bellow: <strong>Laravel.....

By Hardik Savani | February 15, 2017 | | 1503 Viewer | Category : Laravel
READ MORE

Laravel - How to search with comma separated values using Query Builder ?

Sometimes, we require to manage to take single column for multiple integer ids, for example if we have "posts" table and require to set multiple tags on each post, so at that time we can take just single column and store selected tags ids. this way will use less memory. It is simple to store data into row, but as you think how we can search or find specific tag id data from comma separated column value using laravel query builder. However, It is possible using <strong class="path">"find_in_set()"</strong> of MySql predefine function, We can use find_in_set() using whereRow() of laravel query .....

By Hardik Savani | March 2, 2017 | | 1488 Viewer | Category : Laravel
READ MORE

Solve - Installation request for guzzle/guzzle in laravel

When i was working on my updated ubuntu version, i did fetch this problem. I had ubuntu 14.04 then i updated ubuntu 16.04, at that time i think PHP version also updated PHP 5 from PHP 7. Ubuntu 16 updated successfully but when i was trying to composer install or update on my project i was found guzzle package error and to enable extensions php 7 extensions as like bellow: <strong>Error</strong> <pre> Problem 1 - Installation request for guzzle/guzzle v3.8.1 -> satisfiable by guzzle/guzzle[v3.8.1]. - guzzle/guzzle v3.8.1 requires ext-curl * -> the requested PHP extension curl is missing from .....

By Hardik Savani | August 15, 2016 | | 1457 Viewer | Category : Laravel
READ MORE

How to use foreach object in Nodejs ?

Normally, we does use foreach loop in PHP, JS etc, but when i was working on socket programming at that time i require to use foreach of object in server.js. I did also search on google and try to how to use foreach in Node JS. At last i found to use forEach and solve it. so, let's see following example. <strong >Example</strong> <pre class="prettyprint lang-php"> socket.on("newmessage", function(obj) { obj = JSON.parse(obj); obj.forEach(function(items) { console.log(items.userid); var e = "notify-"+items.userid; io.sockets.emit(e, 1); }); }); </pre>

By Hardik Savani | March 31, 2016 | | 1392 Viewer | Category : Laravel
READ MORE


    Solved Issue - "/usr/bin/env: ‘node’: No such file or directory"

    Solved Issue - "/usr/bin/env: ‘node’: No such file or directory"

    Open Post

    Laravel - How to make subquery in select statement?

    Laravel - How to make subquery in select statement?

    Open Post

    How to create custom helper in Laravel 5?

    How to create custom helper in Laravel 5?

    Open Post

    PHP - How to make dependent dropdown list using jquery Ajax?

    PHP - How to make dependent dropdown list using jquery Ajax?

    Open Post

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

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

    Open Post

    How to implement Email Verification with Activation Code example from Scratch in Laravel 5.2 ?

    How to implement Email Verification with Activation Code example from Scratch in Laravel 5.2 ?

    Open Post