Latest Post

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 | | 28443 Viewer | Category : PHP Laravel
READ MORE

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 | | 4515 Viewer | Category : HTML CSS
READ MORE

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 | | 215248 Viewer | Category : Laravel Maatwebsite Pingpong
READ MORE

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 | | 3356 Viewer | Category : PHP MySql
READ MORE

How to remove empty values from array in PHP?

you have array with empty value and you want to remove all empty value from that array without loop. you can remove your all empty value from array without loop. PHP array_filter function through you can remove all empty value, you can do both way try and see following example how to do this : <strong>Example:</strong> <pre class="language-php"> $example = array(100, "hari", "","hey", "", 77, "hello"); $result = array_filter($example, function($value) { return !empty($value); }); print_r($result); <br/> $resultDirect = array_filter($example); print_r($resultDirect); </pre> <strong>Out.....

By Hardik Savani | February 28, 2016 | | 4572 Viewer | Category : PHP
READ MORE


Mediafıre API Attribute Express ppa Lavacharts Blocked AngularJS Directive bplist-parser Master DB::raw() Field Jquery UI XSS Undefined lowercase Datepicker toastr js GET Ajax array_combine Parsleyjs Package 500 error page Date Format Jquery Modal Paytm RAND() Grayscale Image Count ACL Array Autocomplete gravatar PHP Login With FB Google Map popupMultiSelect plugin Request Method roumen/feed package orderBy Config Remove Tutorial Auth clipboard.js str_replace FILTER_VALIDATE_URL Scroll filter_var Failed clearbit API Botdetect Captcha Codeigniter Library league/flysystem-dropbox refspec hasColumn Ajax Authentication Example CORS Laravel 5.3 DB Statement Laravel 5.4 Global Variable Chart Zoho mail Page Subscribe glob Captcha code Add After Laravel Cashier inner join MSSQL PHPExcel toArray() Jquery Plugin laravel-elixir Jquery Dialog Box MVC JS Number CURL refs Admin Panel array_change_key_case Twitter API gulp read more Socket.io Apache Controluser mac AngularJS WHERE Query Control Eloquent-Sluggable Package MassAssignmentException Fullcalendar JS csv away() Function Paypal Integration Protection jquery.email-autocomplete.min.js Migration Dynamic Dependant Dropdown 404 error page Bootstrap-lightbox Plugin CASE_LOWER hasTable Force Pagination virtual host Configuration ANDROID_HOME Sitemap validator.js Paypal Payment Gateway Chat Last Typeahead JS Laravel Builder Manual CRUD Link Service Provider Permission Delete Event DB Google Chart PayPal apache2 ID SweetAlert Plugin File Letter Dialog box Now Setup RSS Feed Commit Rewrite Determine enableQueryLog Application Backup Terminal