Latest Post

Example of unionAll in Query Builder Laravel 5

Sometimes you need to bind multimple query then you can use unionAll in laravel. If you use union all then laravel query builder provide unionAll method for mysql union. when you are doing big project or ERP level project then mostly you require to use union for getting data from database with multiple table. In Following example you can see how to use union all in Laravel 5. <strong>Example:</strong> <pre class="language-php"> $silver = DB::table("product_silver") ->select("" ,"product_silver.price" ,"product_silver.quantity"); $gold = DB::table("product_g.....

By Hardik Savani | March 2, 2016 | | 7850 Viewer | Category : PHP Laravel

Laravel 5 Join with subquery in Query Builder Example

In this post i want to show you how to use subquery with join in laravel query builder. Whenever you need to use subquery in your laravel project you can use following example and learn hot to use subquery. In bellow example you can see we add subquery using DB::raw(), DB::raw() throught we can select our subtable and after in second argument i added compare your field. That way you can easily fire subquery with laravel 5.2 query builder. <strong>Example:</strong> <pre class="language-sql"> $data = DB::table("items") ->select("items.*","items_count.price_group","items_count.quantity_group") .....

By Hardik Savani | March 2, 2016 | | 44396 Viewer | Category : PHP Laravel

How to scrolling table with fixed header in HTML?

Sometimes you require to create scroll table and header must be fixed in your website or project. You can do it easily. I show you two example of scrolling table with fixed header and you can see and implement in your website. Let's see first example : <strong>Example 1</strong> <pre class="code language-html"> <html> <head> <title>Table Scroll with fixed header</title> </head> <body> <table cellspacing="0" cellpadding="0" border="0" width="325"> <tr> <td> <table cellspacing="0" cellpadding="1" border="1" width="30.....

By Hardik Savani | March 1, 2016 | | 8077 Viewer | Category : HTML CSS

Laravel 5 import export to excel and csv using maatwebsite example.

In this post i will show you how to import excel or csv to store in database and how to export or download excel or csv file from database table by maatwebsite. maatwebsite packages throught you can easily get data, also you can group by data, also create more then one sheet etc. so now i show you simple example of items table data, you can donwload in xls, xlsx and csv formate and also you import data in xls, xlsx and csv formate file. In following few step you can implement import and export both function in your project. First see your browser preview will become like this: <strong>Preivew:.....

By Hardik Savani | February 29, 2016 | | 377762 Viewer | Category : Laravel Maatwebsite Pingpong

How to fetch this week records in MySql ?

If you require to get all the records of current week using mysql query. for example you have one table "items" and columns are id, title, description, created_at and update_at, Now you want to get all records of this week. so you can fetch fields value using DATE_SUB and INTERVAL of mysql. In following example you can see how to select data of current week. <strong>Example</strong> <pre class="language-mysql">SELECT * FROM items WHERE created_at > DATE_SUB(NOW(), INTERVAL 1 WEEK);</pre>

By Hardik Savani | February 28, 2016 | | 4697 Viewer | Category : PHP MySql

read more Bootstrap Tokenfield Plugin ACL Message API Tutorial Stripe Laravel Eloquent Flash Message Components & Slots Laravel 4 typed.js plugin setTimeout() league/flysystem-dropbox Express Linkedin API Update Laravel strtolower Server Mailgun API Script Parameters Admin Bootstrap Theme validator.js API mysqld.sock Modular dompdf summernote Packages Contact US Form Control LIKE Query Bootstrap Plugin FadeOut Global Variable Google Map Validation MVC Bootstrap show password Plugin preg_match DATE_SUB Trigger Cordova Grayscale Image Dropzone.js Scratch Limit Client side validation execute query Add PHP Jquery Plugin SEO json() RSS Feed Select Query Popup Box Controller Animation Hard Dialog box Strip Tags 500 error page Strings csv split Email WHERE Query Path stevebauman/location composer package Middleware COUNT() Folder Amazon S3 bootstrap tagsinput Application Ionic framework Lavacharts Modal Custom Command Route Number Base URL Terminal Input CASE_LOWER Empty Highlight JS Captcha code file_exists() Laravel Factory Branch INTERVAL length toastr js Current FadeIn Join Gravatar Image REST hasColumn roumen/feed package Attribute Twitter API Namespace Numeric Carbon ajaxComplete Remote Pixel Facebook API daterangepicker Collapse Event CloudConvert API File Upload away() colorpicker Dropbox API Botdetect Captcha Import Link Database Seeder php_ini_loaded_file Remove ppa HTML to PDF jQuery jquery.lazyload.js SweetAlert Plugin php.ini Executed Current Page timestamps Paging clipboard.js PayPal Determine Resize Image Package Datetimepicker Magento Localization response() whitespace Accordion