Category : Laravel

ItSolutionStuff.com have tutorials for Laravel, here you can study articles of Laravel, Laravel posts collection, most popular and useful tutorials of Laravel, here you can find list of all relevant posts and example about Laravel, we have lists of tutorials and examples about Laravel.very simple and quick example collection of Latest Laravel category.



How to add mysql trigger from migrations in Laravel 5?

Sometimes you require to add trigger in your mysql database of laravel 5. but you think how to create trigger using laravel migration because laravel not provide special function like insertTrigger and something so it problem to create direclty, But laravel DB::unprepared() through we can create trigger for database. In Following example you can see how to create migration and create trigger code and how to write drop trigger code, so let's do it this way. <strong class="step">Create Migration:</strong> <pre>php artisan make:migration add_trigger</pre> <strong class="step">Migration:</stron.....

By Hardik Savani | March 8, 2016 | | 22790 Viewer | Category : Laravel
READ MORE

How to confige Elasticsearch in our local system

In this tutorials we have learn how to configer a Elastic search in our local system. follow this step and easily configer an Elastic Search. <strong class="step">1) Step 1 — Installing Java :</strong> -Before installing OpenJDK with APT, update the list of available packages for installation on your Ubuntu Droplet by running the command: <pre class="prettyprint lang-php prettyprinted"> <span style="color:#FFFFFF;font-weight:900;">$ sudo apt-get update</span> </pre> -After that, you can install OpenJDK with the command: <pre class="prettyprint lang-php prettyprinted"> <span style="color:#.....

By Hardik Savani | March 7, 2016 | | 15160 Viewer | Category : Laravel
READ MORE

Laravel 5 query builder where exists example

you use sql where exists clause in laravel. whereExists through you can use sql where exists clause in your laravel project. It is very easy to use and you can easily undestand. You can give SELECT statment in where condition. you can see bellow example and you can learn how to use whereExists in your app. <strong>SQL Query</strong> <pre class="prettyprint lang-sql"> SELECT * FROM `items` WHERE EXISTS (SELECT `items_city`.`id` FROM `items_city` WHERE items_city.item_id = items.id) </pre> <strong>Using Laravel Query Builder</strong> <pre class="prettyprint lang-php"> DB::table('it.....

By Hardik Savani | March 7, 2016 | | 19720 Viewer | Category : Laravel
READ MORE

How to resolve laravel 5 blank page on server?

When i was created my laravel 5.2 application and i upload application on live GoDaddy server. But i found blank page. I think First you have to check php version on live server. if you run laravel 5+ application then make sure your PHP version at least <strong class="path">PHP 5.5</strong>. But, again i don't know why it was blank page and i checked permission of storage folder 777. so basically when you found blank page on your shared hosting the first make sure permission on <strong class="path">storage Directory 777 Permission</strong>. But if you can't solve and found again then also ch.....

By Hardik Savani | March 6, 2016 | | 18392 Viewer | Category : Laravel
READ MORE

How to use DB transactions in laravel 5?

First, Let's undestand why we are use transactions in laravel project. But db transactions is very important concept and very usefull because it securely manage. laravel 5 also provide to transactions commit, rollback etc functions. How to use transactions in my project, so I an going to give you one example, I have a three table "items", "items_city" and "items_count" and i need to add new row same time and "items" table is a main table then "items_city" and "items_count" is a child table of "items" table. so bassically why we nee to use transactions because if when i was add new records in d.....

By Hardik Savani | March 6, 2016 | | 14184 Viewer | Category : Laravel
READ MORE

How to create middleware for XSS protection in laravel 5?

XSS(Cross Site Scripting) protection must need in your site because if you do not XSS protection then your site is not secure. XSS filter through you can remove html tag from your input value and it is very important to remove html tag for security. in your laravel 5.2 application you can implement by using middleware concept in your project. so how to create XSS filter middleware in your laravel application by using following step. First fire following command and create middleware: <strong class="step">Create Middleware</strong> <pre>php artisan make:middleware XSS</pre> Now, you can see new.....

By Hardik Savani | March 4, 2016 | | 19938 Viewer | Category : Laravel
READ MORE

Laravel 5 create Custom Validation Rule example.

Custom Validation Rule is very usefull and interesting concept of laravel 5 because custom validation throught we can re-use validation and use it easily by just name as like laravel core validation(required,same,in etc.). So, In this post i am going to show you how to create custom validation rules in laravel 5.2. you can create very simple way and use too. you can create custom validation rules by few following step and you can see preview of example that give for add custom validation rule. In this example you are creating <strong class="path">is_odd_string</strong> custom validation rule. .....

By Hardik Savani | March 3, 2016 | | 113980 Viewer | Category : Laravel
READ MORE

Example of unionAll in Query Builder Laravel 5

Sometimes you need to bind multimple query then you can use unionAll in laravel. If you use union all then laravel query builder provide unionAll method for mysql union. when you are doing big project or ERP level project then mostly you require to use union for getting data from database with multiple table. In Following example you can see how to use union all in Laravel 5. <strong>Example:</strong> <pre class="language-php"> $silver = DB::table("product_silver") ->select("product_silver.name" ,"product_silver.price" ,"product_silver.quantity"); $gold = DB::table("product_g.....

By Hardik Savani | March 2, 2016 | | 20898 Viewer | Category : Laravel
READ MORE

Laravel 5 Join with subquery in Query Builder Example

In this post i want to show you how to use subquery with join in laravel query builder. Whenever you need to use subquery in your laravel project you can use following example and learn hot to use subquery. In bellow example you can see we add subquery using DB::raw(), DB::raw() throught we can select our subtable and after in second argument i added compare your field. That way you can easily fire subquery with laravel 5.2 query builder. <strong>Example:</strong> <pre class="language-sql"> $data = DB::table("items") ->select("items.*","items_count.price_group","items_count.quantity_group") .....

By Hardik Savani | March 2, 2016 | | 73563 Viewer | Category : Laravel
READ MORE

Laravel 5 import export to excel and csv using maatwebsite example.

In this post i will show you how to import excel or csv to store in database and how to export or download excel or csv file from database table by maatwebsite. maatwebsite packages throught you can easily get data, also you can group by data, also create more then one sheet etc. so now i show you simple example of items table data, you can donwload in xls, xlsx and csv formate and also you import data in xls, xlsx and csv formate file. In following few step you can implement import and export both function in your project. First see your browser preview will become like this: <strong>Preivew:.....

By Hardik Savani | February 29, 2016 | | 544139 Viewer | Category : Laravel
READ MORE