It Solution Stuff provide 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 best example and article about PHP Language. So you can also search tutorial from bellow search box.

Latest Post


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

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("posts.id" ,DB::raw("6371 * acos(cos(radians(" . $lat . ")) * cos(radians(posts.lat)) * cos(radians(posts.lon) - radians(" . $lon . ")) + sin(radians(" .$lat. ")) * sin(radians(posts.lat))) AS distance")) ->groupBy("posts.id") ->ge.....

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

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 | | 14008 Viewer | Category : PHP Laravel MySql
READ MORE

Multi select autocomplete jquery example with code

In this post i show you how to use autocomplete with multiple select option by jquery. I think you will did autocomplete for single option using jquery ui plugin. but in this post you can learn multi selection autocomplete using jquery ui. In bellow preview you can see how will output of your multiselect autocomplete because its like choose js or something like plugin. But for layout i just add my own css. this example i use jquery ui js file and one more multiselect js file that file through we can do multi select and one more thing you can also customization of autocomplete.multiselect.js fi.....

By Hardik Savani | March 8, 2016 | | 43726 Viewer | Category : PHP Javascript HTML jQuery
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 | | 8384 Viewer | Category : PHP Laravel Elasticsearch
READ MORE


scrollTop screenshotmachine.com API String Windows ixudra/curl composer package Modal AngularJS Limit node.js Attr Dropbox API SEO Convert whitespace Laravel Resource Contact US Form clearbit API Switchery JS DB::raw() Ubuntu 14.04 Rewrite Executed Bootstrap maxlength plugin Field croppie.js Object to Array Sort Site Permission Mail Draggable Ionic framework Google Chart Schema Repo Bootbox.js AngularJS Directive Now Form Jquery Access Sortable Behance API Remember me Solve Authentication Modular Migration Bootstrap Confirmation js plugin php_ini_loaded_file Special IP Magento Amazon S3 Chat Login With FB ANDROID_HOME sven/artisan-view package Control Mediafıre API XSS Terminal Google OAuth COUNT() Blade inject Bootstrap Plugin RAND() Paypal Payment Gateway Axios array_change_key_case basename() Element Thumbnails Paging Select Query Composer Xampp Add More JQuery Paytm Form Validation strtolower Datepicker Bootstrap-lightbox Plugin Linkedin API Log Activity Sublime clockface plugin Download Validation Parsley apache2 Parsleyjs Last Jquery UI inner join Kyslik/column-sortable package Version softDeletes Tag Manager plugin Facade pop() Blocked jquery.email-autocomplete.min.js PHP ajaxStart Email Laravel 5.5 select box search Dialog box Scroll thomaswelton/laravel-gravatar Pagination popupMultiSelect plugin Client side validation Master Old Loop xoxco tags input Image Upload DATEDIFF() Key json() preg_match Sublime text 2 Queue SUBSTRING_INDEX() Message Effect Export Event Failed ZipArchive JSON select2.js parse Each Laravel 5.2 Particular Javascript Subscription Interfaces Query Builder Array league/flysystem-dropbox Bootstrap show password Plugin DB Statement bootstrap tagsinput unicodeveloper/laravel-password KCFinder read more voyager package