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 | | 36164 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 | | 7071 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 | | 298449 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 | | 3875 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 | | 4851 Viewer | Category : PHP
READ MORE


Path unicodeveloper/laravel-password Draggable preg_match Google Map Login With FB Month POST Ajax SUM() Enable strpos Bootbox.js voyager package Ubuntu 14.04 PingPong Location hasTable DATE_SUB Express ixudra/curl composer package read more Redirect ACL Demo Website bootstrap-multiselect plugin Database Seeder Key Service Provider CRUD Laravel Resource Command uppercase Loop Artisan Command LIKE Query Particular Data Migration Run Project Tutorial Chosen JS Bootstrap Tokenfield Plugin JS dompdf Global Variable Recursive npm FIND_IN_SET() PostgreSQL Join MySQL Subquery Timepicker DB nl2br hasColumn PayPal Column Laravel 5.3 Artisan split ANDROID_HOME Accordion Function Query Builder Gravatar Image PHP artisan Permission Windows Attribute Database refspec AngularJS TrustAsHTML Filter mysqld.sock Update Contact US Form Attr Special ajaxComplete Paging Strip Tags auth() Notification Protection Behance API Paypal Payment Gateway PHPUnit Laravel 5 upload_max_filesize apache2 Laravel Passport Ubuntu encrypter New Features SMTP Twitter API XML Scratch Email Verification Pixel Backup QR Code Parameters Laravel Cashier Flash Message Confirm Box Snippet Components & Slots Laravel 4 Composer tree view Sort Div Pull Botdetect Captcha User Image Upload Parsley RAND() phpmyadmin filter_var select2.js setInterval() RSS Tooltip JSON Sitemap Capitalize MassAssignmentException Select Paypal Integration bootstrap tagsinput File Upload Fullcalendar JS Magento 2 Facade Subscription Form JS Plugin Limit is_null Custom mod_rewrite Manual XSS Remember me Linkedin API Cache Jquery UI Determine View