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


GROUP_CONCAT with different SEPARATOR in laravel Example

Whenever, you need to use GROUP_CONCAT with differente separator(I mean default separator is ',', But you want to change '@','#','&' etc as you want). then you have to use use SEPARATOR keyword in GROUP_CONCAT(). If you are working on laravel then you have to also use DB::raw() for write GROUP_CONCAT() inside the this function. So, Basically how to change seprator in group_concat(), In following example i change ',' separator into '@'.you can use the following example how to use in laravel 4 and 5. <strong>Example:</strong> <pre class="language-php"> $items = DB::table('items') -.....

By Hardik Savani | January 20, 2016 | | 21955 Viewer | Category : Laravel MySql
READ MORE

Laravel after login, redirect back to previous url ?

If you are working on laravel and you want to do like: How to redirect back to previous url, After login. after login user you can redirect his previous page as he was before. you can do this, i would like to give you two example. first example is using intended() and second one is using session but i don't know more but i think intended() is not working proper in laravel 5 but you can try in laravel 4. but i am sure i gave you example with session that work well in both. So, you can try any one and get your solution, 1. using intended() and 2. session. <strong>Example 1:</strong> <pre class.....

By Hardik Savani | January 15, 2016 | | 22028 Viewer | Category : Laravel
READ MORE

How to count unique domains from email address field in MySQL ?

you want to count domain from your email address field in mysql. if you are working on PHP then you could do easily by using explode function and counting domains, but that way is a very bad logic and it take max time on execution when you have lot of data. But we can do easily in MySQL by using SUBSTRING_INDEX(). SUBSTRING_INDEX() take a three arguments string, delimeter and number.string is a source of string, the delimeter to search for in the string and the number parameter will search for delimeter.If pass negative in third argument then it will everything from the left of the targeted .....

By Hardik Savani | January 14, 2016 | | 5561 Viewer | Category : PHP MySql
READ MORE

How to count number of files in folder and remove all files in folder example in Laravel 5 ?

you are working on laravel framwork and you want to count how many image or files in folder and print of front then you can do with laravel "File" class.you can also count in core PHP by using glob() but if you are working on laravel then you have to use 'File' class library and it is easy and more flexible to use. If you also want to remove all the files Or images in specific folder then you can delete by using "File" class function. sometimes we need to delete files in the folder. that way: <pre class="language-php"> use Input; use File; class HomeController extends AdminController { .....

By Hardik Savani | January 13, 2016 | | 9158 Viewer | Category : Laravel
READ MORE

How to check undefined, empty and null in JavaScript/JQuery ?

If you are working on jquery and However you want to check variable is undefined or not then you can easily check by typeof operator, which is simple, fast and cross-platform: <pre class="language-javascript"> if(typeof i == "undefined"){ alert('undefined'); } </pre> If you are working on jquery and However you want to check variable is empty or not then you can easily check by compare with empty string: <pre class="language-javascript"> if(i == ''){ alert('Empty'); } </pre> If you are working on jquery and However you want to check variable is null or not then you can easily che.....

By Hardik Savani | January 12, 2016 | | 11455 Viewer | Category : Javascript jQuery
READ MORE


AngularJS Filter Route KCFinder MassAssignmentException Behance API Scout Package Service Provider Recursive Redirect Homepage Bootstrap maxlength plugin Library Jquery Modal INTERVAL array_combine Issue execute query popupMultiSelect plugin roumen/feed package Composer croppie.js XML Timepicker gulp Backup ID Ubuntu Variable Sublime Mailchimp API Linkedin API Null apache2 Folder Origin Socialite voyager package Laravel Factory Switchery JS Image Upload Data asgardcms Specific Automatically Pixel str_random() Laravel 5.4 Twitter OAuth Record Array Log Activity Instagram API Nodejs Top file_exists() JWT Snippet Modal Special Socket.io DB ANDROID_HOME Loop Control Empty strpos Jquery UI Path node.js SweetAlert Plugin league/flysystem-dropbox Form JS Plugin User ixudra/curl composer package setInterval() Pagination ZipArchive Excel Pull helper Laravel Eloquent php.ini Date Format Jquery Plugin Scroll Vue.JS Redis array_map Localization filter_var milon/barcode Captcha code API X-editable Plugin typed.js plugin Paytm php_ini_loaded_file URL Git Form Validation Javascript Tutorial Axios CASE_LOWER Example Delete Opencart Link DB Statement Database jQuery chmod Zip jquery.email-autocomplete.min.js Force Migration FadeIn select2.js Components & Slots Application Enable Remote Popup Box dompdf Cordova Executed Upgrade Subscribe Google OAuth Access Cache Toggle Manual auth() Capitalize 500 error page bootstrap-fileinput plugin Validation Gmail groupBy() Google Chart select box search php artisan serve Middleware hasTable Message ajaxStart Chart.js ServiceProvider nl2br