It Solution Stuff provide a collection of tutorials about PHP, Laravel Framework, Codeigniter Framework, Mysql Database, Bootstrap Front-end Framework, Jquery, Node JS, Ajax Example, APIs, CURL Example, Composer Packages Example, AngularJS etc. You will find the best example an article about PHP Language. So you can also search tutorial from bellow search box.

Please Subscribe Your Email Address, We Will Notify When Add New Post:

Latest Post

How to add multiple markers in google map

In this post we have to learn hoe to add a multiple location marker in google map. add following code for add multiple location marker. <img width="100%" style="border:2px solid cadetblue" src="/upload/Google map.png"> <strong>Add Google map canvas HTML code</strong> <pre class="prettyprint lang-html"> <div id="map_wrapper"> <div id="map_canvas" class="mapping"></div> </div> </pre> <strong>Add Google map canvas CSS code</strong> <pre class="prettyprint lang-css"> #map_wrapper { height: 400px; } #map_canvas { width: 100%; height: 100%; } </pre> <st.....

By Hardik Savani | March 9, 2016 | | 26898 Viewer | Category : Google Map jQuery HTML

Laravel 5 export to pdf using maatwebsite example

In this post i will show you how to export or download pdf file from database table by maatwebsite. maatwebsite packages throught you can easily generate pdf file. so now i show you simple example of items table data, you can donwload in pdf formate. In following few step you can implement export both function in your project. we have to also need to use dompdf package for pdf generater. let's follow step. <strong class="step">Step 1: Installation</strong> Open your composer.json file and add bellow line in required package. <strong>Laravel 5</strong> <pre>"maatwebsite/excel": "~2.1.0"</pre> <.....

By Hardik Savani | March 9, 2016 | | 97112 Viewer | Category : Laravel

How to use where clause with mysql function in Laravel 5?

When you are working on laravel projects and you need to use mysql function in where clause then you can easily use that using DB::raw() and whereRaw(). In this example you can show how to i use mysql function in where clause. In this example i want to compare with year of created_at field but not whole date, that's whay i use mysql function Year(), this function will return only year from timestamp and compare with given value. I add two example of how to use sql function in where cause. let's See both example. <strong class="example">Example 1:</strong> <pre class="prettyprint lang-sql"> $da.....

By Hardik Savani | March 9, 2016 | | 15259 Viewer | Category : Laravel MySql

How to get latitude longitude from mysql in laravel 5?

Whenever you need to get nearest posts from lat and long and if you are working on laravel query builder. then you can get distance easily using DB::raw(), so you can learn from following example how to get nearest value from mysql laravel. <strong>Example:</strong> <pre class="prettyprint lang-php"> $lat = 1; $lon = 1; DB::table("posts") ->select("" ,DB::raw("6371 * acos(cos(radians(" . $lat . ")) * cos(radians( * cos(radians(posts.lon) - radians(" . $lon . ")) + sin(radians(" .$lat. ")) * sin(radians( AS distance")) ->groupBy("") ->ge.....

By Hardik Savani | March 8, 2016 | | 17823 Viewer | Category : Laravel MySql

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 | | 27541 Viewer | Category : PHP Laravel MySql