Category : Laravel


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 | | 5793 Viewer | Category : Laravel
READ MORE

Laravel Jquery Ajax Pagination Example From Scratch

Today, I am going to share with you how to make easy jquery ajax pagination example in Laravel Application from scratch tutorial. As you know Pagination is a very basic requirement of Any Admin Panel, ERP or back-end Panel. Pagination help us to load few records every time, that way can not broken web page due to lots of data. If you are making pagination and do it using jquery ajax then it more beautiful. Ajax Pagination load only your table data instead of whole page. So ajax pagination is very helpful. In this post i am making very simple example of ajax pagination in Laravel 5.4 applicat.....

By Hardik Savani | March 21, 2017 | | 10188 Viewer | Category : Laravel
READ MORE

Laravel 5 notification alert using bootstrap notify plugin example

We always require to notification alert after some action like if you remove items then notification popup will open with message like "Item removed successfully", same as on every action like create, update, listing or others. As specially we are working on admin panel, it's mandatory. So, i would like show you how to add bootstrap notify js plugin notification popup in Laravel 5.4 from scratch. bootstrap notify plugin provide us success message notification, info message notification, warning message notification, error message notification that way we can add notification with good layout .....

By Hardik Savani | March 11, 2017 | | 9450 Viewer | Category : Laravel
READ MORE

Laravel 5 - Custom Helper Facade Class Example from scratch

Today, In this post i am going to share with you how to create custom global helper functions using Helper Facade in our Laravel 5 application. We always need to define some global functions for our application because that way we can access that helper functions from every file of our project. In this tutorial i am going to share with you how we can make global helper function in Laravel framework from scratch. It is very important to create custom helper functions we have before start our projects. In this post we learn how to create custom Helper facade, i also posted few days ago <a href=.....

By Hardik Savani | March 5, 2017 | | 9466 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 | | 2899 Viewer | Category : Laravel
READ MORE

Laravel 5 - Simple user access control using Middleware

We always require to built user access control in our application, when we start. I posted <a href="http://itsolutionstuff.com/post/laravel-52-user-acl-roles-and-permissions-with-middleware-using-entrust-from-scratch-tutorialexample.html" target="_blank">User ACL Roles and Permissions using entrust</a> for laravel 5 application. But as you can see on my post it is very useful and fantastic, But if you have big application or like e-commerce application. Because User ACL is take a time to implement. Yes, if you have small or medium level application and you don't require to make permission with.....

By Hardik Savani | February 26, 2017 | | 30272 Viewer | Category : Laravel
READ MORE

Laravel 5 - Example of Database Seeder with insert sample data

We should know what is database seeder in laravel and why we should use before start example of database seeding. Laravel provides a tool to add sample or dummy data to our databases automatically. that is call it database seeding. Laravel database seeder through we can add simply testing data on our database table. Database seed is extremely useful because testing with various data allows you to likely detect bugs you otherwise would have overlooked. We have to simple make one time seeder with some dummy data, that way we can simply reuse when you deploy project first time. We can make seede.....

By Hardik Savani | February 23, 2017 | | 7692 Viewer | Category : Laravel
READ MORE

How to integrate stripe payment gateway in Laravel 5.4 Application ?

Today, I am going to show you How to integrate stripe payment gateway in our Laravel application. In this tutorial i explain step by step example code of How to integrate stripe payment gateway. Here i give you full example of How to integrate stripe payment gateway step by step like create laravel project, migration, model, route, blade file etc. So you have to just follow few step as listed bellow. <strong class="step">Follow Bellow Few Step:</strong> <strong>1)Install Laravel Application</strong> <strong>2)Database Configuration</strong> <strong>3)Install Required Packages</strong> <stron.....

By Hardik Savani | February 18, 2017 | | 15644 Viewer | Category : Laravel
READ MORE

How to get keys name from array using array helper in PHP Laravel ?

Few days ago, I was working on my new Laravel 5.4 application and i require to get keys name from my array. i was thing how we can get it and laravel provide us for to do it. Finally i found array helper function in Laravel docs. There are several array helper function available for array. I found array_keys() helper for getting keys name from our array. array_keys() will return array of keys. It could be easy to work with keys name in array. So in this example i want to share with you small example using array_keys() helper. I created one route "myarraykeys" with my $myArray variable, and .....

By Hardik Savani | February 18, 2017 | | 1206 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 | | 2165 Viewer | Category : Laravel
READ MORE

    Laravel 5.3 - import export csv and excel file into database

    Laravel 5.3 - import export csv and excel file into database

    Open Post

    Jquery Select2 - Select box with search example code

    Jquery Select2 - Select box with search example code

    Open Post

    PHP - How to Convert file(image, audio, video) extension using CloudConvert API?

    PHP - How to Convert file(image, audio, video) extension using CloudConvert API?

    Open Post

    Mailgun setup with Laravel 5 example

    Mailgun setup with Laravel 5 example

    Open Post

    Laravel 5.3 - How to create SEO friendly sluggable URL

    Laravel 5.3 - How to create SEO friendly sluggable URL

    Open Post

    Codeigniter 3 - select2 ajax autocomplete from database example with demo

    Codeigniter 3 - select2 ajax autocomplete from database example with demo

    Open Post