Latest Post



How to get maximum key value of array in PHP?

Sometimes, you need to get maximum key value of your array but you try to get with loop and any function etc, but in bellow example you can see we can get biggest key value from our php array by using max() and array_keys(). So, let's try to use in your code this way: <strong>Example:</strong> <pre class="language-php"> $myArray = ['2'=>'Hey','4'=>'Hello','1'=>'Hi','3'=>'GH']; $new_key = max(array_keys($myArray)); $new_val = $myArray[$new_key]; print_r($new_val); </pre>

By Hardik Savani | March 2, 2016 | | 17291 Viewer | Category : PHP
READ MORE

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.name" ,"product_silver.price" ,"product_silver.quantity"); $gold = DB::table("product_g.....

By Hardik Savani | March 2, 2016 | | 31306 Viewer | Category : PHP Laravel
READ MORE

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 | | 84986 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 | | 27546 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:<div class="conte.....

By Hardik Savani | February 29, 2016 | | 555464 Viewer | Category : Laravel Maatwebsite Pingpong
READ MORE