Category : PHP


How to use DB transactions in laravel 5?

First, Let's undestand why we are use transactions in laravel project. But db transactions is very important concept and very usefull because it securely manage. laravel 5 also provide to transactions commit, rollback etc functions. How to use transactions in my project, so I an going to give you one example, I have a three table "items", "items_city" and "items_count" and i need to add new row same time and "items" table is a main table then "items_city" and "items_count" is a child table of "items" table. so bassically why we nee to use transactions because if when i was add new records in d.....

By Hardik Savani | March 6, 2016 | | 3245 Viewer | Category : PHP
READ MORE

PHP Image upload without refreshing page using jquery example

In this post i show you how to image upload without page reload using jquery ajax. jquery ajax through you can upload image and store record into database in php. i use jquery.form plugin for image uploading. So you can do by following few step of file uploading ajax jquery. <strong>Preivew</strong> <img width="100%" style="border:2px solid red" src="/upload/imageupload.png"> <br/> First you have to create index.php file as i do in following file, so create index.php file and put bellow code. <strong>index.php</strong> <pre class="code language-html"> <html lang="en"> <head> <ti.....

By Hardik Savani | March 4, 2016 | | 12727 Viewer | Category : PHP
READ MORE

How to create middleware for XSS protection in laravel 5?

XSS(Cross Site Scripting) protection must need in your site because if you do not XSS protection then your site is not secure. XSS filter through you can remove html tag from your input value and it is very important to remove html tag for security. in your laravel 5.2 application you can implement by using middleware concept in your project. so how to create XSS filter middleware in your laravel application by using following step. First fire following command and create middleware: <strong class="step">Create Middleware</strong> <pre>php artisan make:middleware XSS</pre> Now, you can see new.....

By Hardik Savani | March 4, 2016 | | 5600 Viewer | Category : PHP
READ MORE

How to generate random alphanumeric string in PHP?

In this example i am going to show you how to generate randomly alphanumeric string OR number in PHP. when you need you generate random alphanumeric string for your unique field then you can easily create using substr(), md5(), rand(), uniqid(), mt_rand(), time() and str_shuffle() php function you can create several way unique code using following example: <strong>Example</strong> <pre class="language-php"> Example 1 $generated = substr(md5(rand()),0,5); print_r($generated);<br/> Example 2 $generated = rand(10000,99999); print_r($generated);<br/> Example 3 $generated = substr(md5(uniqid(rand(.....

By Hardik Savani | March 4, 2016 | | 1742 Viewer | Category : PHP
READ MORE

Laravel 5 create Custom Validation Rule example.

Custom Validation Rule is very usefull and interesting concept of laravel 5 because custom validation throught we can re-use validation and use it easily by just name as like laravel core validation(required,same,in etc.). So, In this post i am going to show you how to create custom validation rules in laravel 5.2. you can create very simple way and use too. you can create custom validation rules by few following step and you can see preview of example that give for add custom validation rule. In this example you are creating <strong class="path">is_odd_string</strong> custom validation rule. .....

By Hardik Savani | March 3, 2016 | | 46584 Viewer | Category : PHP
READ MORE

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 | | 1191 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 | | 5765 Viewer | Category : PHP
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 | | 32751 Viewer | Category : PHP
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 | | 3609 Viewer | Category : PHP
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 | | 4655 Viewer | Category : PHP
READ MORE

    Laravel 5 - How to prevent browser back button after user logout?

    Laravel 5 - How to prevent browser back button after user logout?

    Open Post

    CRUD (Create Read Update Delete) Example in Laravel 5.2 from Scratch

    CRUD (Create Read Update Delete) Example in Laravel 5.2 from Scratch

    Open Post

    Solved Issue - "/usr/bin/env: ‘node’: No such file or directory"

    Solved Issue - "/usr/bin/env: ‘node’: No such file or directory"

    Open Post

    Laravel 5 - create quick backend admin panel tutorial

    Laravel 5 - create quick backend admin panel tutorial

    Open Post

    Laravel 5 - How to create custom error page with example

    Laravel 5 - How to create custom error page with example

    Open Post

    Laravel 5 - Twitter API using thujohn/twitter composer package tutorial

    Laravel 5 - Twitter API using thujohn/twitter composer package tutorial

    Open Post