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 | | 11210 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 | | 68254 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 | | 3817 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 | | 5833 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 | | 11533 Viewer | Category : PHP Laravel MySql

Scout Package encrypter Master PHPUnit Elasticsearch chmod Percentage Facebook API Bootstrap Tokenfield Plugin Allow Excel X-editable Plugin Object to Array mysqld.sock CSS WHERE Query File Count Sortable Bootstrap maxlength plugin whitespace Null Popup Box Solve Mediafıre API bootstrap tagsinput Behance API Parsleyjs Ajax Request scrollTop CASE_LOWER Recursive SUM() Laravel 5.2 Calculate IP FadeIn Laravel Builder COUNT() toSql Cache Switchery JS Nodejs Interface mac stevebauman/location composer package Datepicker Autocomplete Controller gulp AngularJS Directive Mailgun API JS Each Loop Codeigniter 3 response() Backup Export laravel-elixir Dynamic Dependant Dropdown xoxco tags input Timepicker is_null array_map Laravel 5.5 Chart.js helper Path Where In Query Laravel 5.4 Highchart Laravel 5 Convert Element New Features Protection Undefined Request Laravel Eloquent Linux AngularJS TrustAsHTML Filter Log Vue.JS PostgreSQL datatables Page Technology Tracking Import Zoho mail Prompt modal socket Instagram API Interfaces User Agent Middleware Lightbox Cordova getQueryLog Laravel 4 basename() Laravel Snippet Request Method Bootstrap Notify Plugin Gmail Authentication Join Phonegap ppa execute query Link Laravel Passport Sublime Image Upload Codeigniter XML Index Enable Connection Repo Twitter OAuth Input GuzzleHttp Client side validation MassAssignmentException Jquery Plugin Sql Typeahead JS PayPal Lavacharts ServiceProvider Class Upgrade DATE_SUB Letter Failed MVC Current enableQueryLog chumper/zipper lowercase public_path strtolower Permission Node JS milon/barcode Pixel RSS