Latest Post

Laravel 5 - whereIn and whereNotIn with subquery example using query builder

As you know laravel is very popular php framework in today. So every point will be require for database related and that important. In this post i would like to share with you how to use subquery with whereIn and whereNotIn clause from scratch. We may sometimes require to use select query with where in or where not in clause. we can simply make query using MySQL. But we don't know how to use it on laravel query builder. However, In this example we will learn how to convert mysql query into laravel query builder of wherein with subquery. This example is from scratch, so i will give you first m.....

By Hardik Savani | March 23, 2017 | | 574 Viewer | Category : Laravel MySql

Laravel Jquery Ajax Pagination Example From Scratch

Today, I am going to share with you how to make easy jquery ajax pagination example in Laravel Application from scratch tutorial. As you know Pagination is a very basic requirement of Any Admin Panel, ERP or back-end Panel. Pagination help us to load few records every time, that way can not broken web page due to lots of data. If you are making pagination and do it using jquery ajax then it more beautiful. Ajax Pagination load only your table data instead of whole page. So ajax pagination is very helpful. In this post i am making very simple example of ajax pagination in Laravel 5.4 applicat.....

By Hardik Savani | March 21, 2017 | | 1344 Viewer | Category : PHP Laravel Bootstrap jQuery Ajax

PHP - How to compress PNG image using pngquant?

Today, In this tutorial, we will learn how to reduce png image size while uploading in core PHP. You can simply use this script in other PHP framework like Laravel, codeigniter, cake PHP etc. compress file size is very important for our server. If you have 4MB image then you have take large memory space to store and another thing it take time to load when you display on web page or application. But If you reduce image size then it more better for it take lass memory space and it take lass time to load image or file on web. Here we are going to use "pngquant" command-line utility and library f.....

By Hardik Savani | March 19, 2017 | | 409 Viewer | Category : PHP

How to upload image with validation in PHP Codeigniter?

In this post, we learn step by step codeigniter image uploading from scratch. Image Upload functionality is a very basic require to all most back-end project for like user profile picture upload, product image upload, category photo upload etc. So in this tutorial, i am going to share with you small example of image uploading with validation from scratch. So you can simply identify how upload image or file with validation, we can simply use validation for mime type, file max size etc. In this example i will use <strong class="path">"upload"</strong> library of Codeigniter. codeigniter provide.....

By Hardik Savani | March 18, 2017 | | 869 Viewer | Category : PHP Codeigniter

How to use Select with MySQL DATE_FORMAT() in Laravel?

We sometimes require to use MySQL pre-define function like sum(), date_format(), year(), month(), group_concat() etc. But laravel query builder not provide to directly use with select statement. However, we can use all the pre-define function of Mysql using DB::raw(). So, In this post i am going to share with you how to use date_format() in Laravel 5 Query Builder. date_formt() help us to change date format. We may sometimes require to change date format using mysql date_format(). In this example i have simple "users" table and there are some dummy users with created_at row with current time.....

By Hardik Savani | March 16, 2017 | | 2569 Viewer | Category : Laravel MySql

Automatically RSS jQuery Source Code Homepage Access Language File dompdf response() Linkedin API pngquant Multi Auth Excel KCFinder Confirm Box User pop() Contact US Form Manual Undefined Gravatar Image DATEDIFF() PHPUnit Search Setup Botdetect Captcha file_exists Month Variable Hard API Cross DB Mysql Concat Determine Record View Google Map Config daterangepicker Authentication Notification datatables HTML to PDF Facade Dropbox API Path Site AngularJS TrustAsHTML Filter xoxco tags input array_change_key_case Timepicker MVC mac Xampp 500 error page POST Ajax Accordion preg_match Bootstrap Notify Plugin Paging Control Page Command bplist-parser chumper/zipper Phonegap Subscription scrollTop milon/barcode PingPong typed.js plugin Null ANDROID_HOME voyager package Progress Bar HTML Parameters Codeigniter inner join Div Package Key Constraint Facebook API Update Join Numeric Login With FB Ubuntu gmaps.js XML Rewrite Animate Location laravel-elixir New Features Captcha code Bootstrap-lightbox Plugin Image Google API QR Code Scout Package Import AngularJS Directive Demo nl2br filter_var DATE_SUB length PHP Codeigniter 3 Repository Pattern socket date_format() php.ini MySql Laravel 5 Autocomplete upload_max_filesize Foreach whitespace REST Scratch orderBy Subscribe bootstrap-growl Parsley Laravel 4 FadeIn Popup Box React JS Components & Slots Element thujohn/twitter package MassAssignmentException Socialite thomaswelton/laravel-gravatar str_random() PostgreSQL Elasticsearch characters marker file_exists() Data bootstrap-multiselect plugin csrf_token Percentage Email Verification chmod