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 | | 2699 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 | | 13493 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 | | 2731 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 | | 87865 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 | | 2273 Viewer | Category : PHP MySql

Issue Linux Chart.js Bootstrap Tokenfield Plugin softDeletes Particular Object tagsinput.js Express Value filter Attr pngquant Element upload_max_filesize Elasticsearch SUBSTRING_INDEX() Data ppa Letter Date Format Div Dropzone.js Page Artisan Command Codeigniter 3 Special gulp Mysql Concat Laravel 5.3 php.ini CRUD Exists CloudConvert API Gravatar Image Jquery UI Now bootstrap-progressbar.js Index Route thomaswelton/laravel-gravatar Sort Listener Jquery Plugin CURL hasColumn Apache Send Technology DATE_SUB Google Chart Ajax Request Admin Panel Message COUNT() Request ServiceProvider Typeahead JS Setup Remember me Current SUM() Application MSSQL away() Interfaces Update file_exists() Laravel Cashier array_combine Null DATEDIFF() FILTER_VALIDATE_URL Cache word-wrap Top Check Cross Foreign Key bplist-parser PayPal Email Verification Dropbox API Library milon/barcode Function Package Scroll User mod_rewrite Trans Helper Laravel 5.2 Snippet POST Ajax Service Provider Script SEO clipboard.js Controluser After intervention/image PHP Path MySQL Subquery Inserted Id Autocomplete Add preg_match Auth chmod Ionic php_ini_loaded_file Import Tutorial maatwebsite Chat PostgreSQL Clear Billing Facade Animate RAND() marker Login With FB AngularJS Laravel 5 Undefined whitespace Modal Determine roumen/sitemap Executed Ip Address Location Language Tracking Laravel 4 Bootstrap show password Plugin Botdetect Captcha Database hasTable Zoho mail php artisan serve bootstrap-growl Javascript oauth length REST