Latest Post


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 | | 1281 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 | | 2751 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 | | 1361 Viewer | Category : Javascript jQuery
READ MORE

How to get last executed mysql query in laravel ?

If you are working on laravel framwork and you use query builder of laravel 5. but you want to get last executed mysql query from laravel. If you are working on laravel 5 then you have to first enable query log that way it can be store query log. At last getQueryLog() through you can get last executed query. I give you example of how to get last executed mysql query. you can use example as following example. <pre class="language-php"> public function querylog() { DB::enableQueryLog(); $item = Item::find(2); $last_query = DB::getQueryLog(); print_r($last_query); } </pre> Try this......

By Hardik Savani | January 11, 2016 | | 1836 Viewer | Category : Laravel MySql
READ MORE

Mysql procedure with pagination in laravel 5?

You are working on laravel with mysql database. you had created mysql procedure for get data and you want to call procedure with pagination in laravel 5 then you can not directly make pagination as laravel document.If you are using directly MySQL stored Procedure in your controller, model or repository and you want to give pagination like this way : <pre class="language-php"> $data = DB::select(DB::raw('CALL hardik("hari")'))->paginate(5); </pre> This way you found error in your Laravel 5 website. we can't give directly this way pagination because your procedure will get all the data fr.....

By Hardik Savani | January 11, 2016 | | 5849 Viewer | Category : Laravel MySql
READ MORE


HTML Excel Parsley Form Validation Character Stripe Specific Artisan Page Array Magento Cache chumper/zipper Laravel Factory meta http-equiv tag Facade mac word-wrap marker screenshotmachine.com API GuzzleHttp Remote User Scratch Interface Laravel Builder csv Lightbox Custom Grayscale Image Pull stevebauman/location composer package Send Recursive tree view PHP artisan Progress Bar Xampp array_change_key_case Form Jquery X-editable Plugin ajaxStart split gmaps.js CASE_LOWER Billing Client side validation Database Seeder Mailgun API Top Column SweetAlert Plugin getQueryLog response() filter Migration Object SUM() toastr js Paypal Payment Gateway auth() select box search Script KCFinder Clear Admin Panel daterangepicker phpmyadmin Twitter Bootstrap jQuery CloudConvert API Div Moment JS Base URL filter_var Sublime text 3 jquery.email-autocomplete.min.js Node JS Snippet Percentage Inserted Id Command Class Link Controller Google API Payment Gateway Prompt modal php artisan serve Chosen JS phpword filesize() Email Codeigniter Join croppie.js validator.js Laravel 5 Laravel 5.4 - Markdown Mailables CURL laravel-elixir mysqld.sock Foreign Key Key AngularJS TrustAsHTML Filter Sublime text 2 file_exists() View Segment Links DB::raw() Redis ixudra/curl composer package Notification FadeIn length Manual Accordion Ubuntu Express virtual host Ajax Request XSS ServiceProvider Sub-Domain Collapse softDeletes Autocomplete summernote Ubuntu 14.04 Datepicker QR Code webpatser/laravel-uuid Module Bootbox.js typed.js plugin Multiple maatwebsite Middleware Now 500 error page MySql Input Delete Current Page Month First XML Fullcalendar JS Log Activity