It Solution Stuff provide collection of tutorials about PHP, Laravel Framework, Codeigniter Framework, Mysql Database, Bootstrap Front-end Framework, Jquery, Node JS, Ajax Example, APIs, CURL Example, Composer Packages Example, AngularJS etc. You will find best example and article about PHP Language. So you can also search tutorial from bellow search box.

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 | | 1823 Viewer | Category : PHP

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 | | 10630 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 | | 57196 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 | | 9481 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 | | 483155 Viewer | Category : Laravel Maatwebsite Pingpong

Data GET Ajax Page filter JS Request Method Executed timestamps Gravatar Image Laravel 5.3 Barcode Amazon S3 Image Upload Draggable groupBy() Commit Git ixudra/curl composer package json() Field SEO stevebauman/location composer package ID Nodejs away() Event upload_max_filesize Object php artisan serve Components & Slots Chosen JS Percentage clearbit API Select Datetimepicker File Grayscale Image Ip Address Cross Flash Message Branch virtual host Kyslik/column-sortable package jQuery Update CRUD word-wrap Exists Package Fullcalendar JS response() Dropbox API Date Format str_replace Force php.ini Collapse Old DB Capitalize Image Admin Bootstrap Theme REST clockface plugin ANDROID_HOME Schema ppa Timepicker bootstrap tagsinput Popup Box Animate Where Not In Query Rewrite Typeahead JS Paging Validation Manual Email PayPal Key Constraint array_map chumper/zipper Number Lightbox Chart.js Value str_random() Toggle Excel Contact US Form Reset Upgrade Google Chart Where In Query MySQL Subquery gmaps.js Clear Sortable Link Twitter OAuth roumen/feed package Email Verification Sub-Domain dompdf Twitter Bootstrap Codeigniter setTimeout() pop() Limit MSSQL whitespace Prompt modal Configuration guzzle http client ZipArchive Mail DB Statement thujohn/twitter package Bootstrap maxlength plugin SUBSTRING_INDEX() Chart Accordion Elasticsearch max_file_uploads Bootstrap show password Plugin Multi Auth HTML to PDF Composer Segment XML Blocked sven/artisan-view package Repo Determine Sort helper Eloquent-Sluggable Package Paypal Payment Gateway Connection clearInterval() Service Provider Null intervention/image INTERVAL Failed Interfaces Resize Image Sitemap Remote