Category Archives: Laravel

How to do Ajax form validation In Laravel

Below code shows simple form entry in laravel using Ajax. It uses the server side validation as well as client side validation Code for Routes.php,view and controllers are defined here.. Routes.php

<?php
Route::get('/mypage', 'MyPageController@index');
Route::post('checkAndSavedata','MyPageController@checkAndSavedata');

?>

<?php

Route::get('/mypage', 'MyPageController@index');

Route::post('checkAndSavedata','MyPageController@checkAndSavedata');

MypageController.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Http\Requests;
use Response;
use Validator;
class MypageController extends Controller
{
        
    public function index()
    {
        return view('mylistpage');
    }
    
    public function checkAndSavedata(Request $request)
    {
            
            $rules = array('input_val' => 'Required|Min:3|Max:50');
            $messsages = array('input_val.required' => 'This field is required.',
            'input_val.min' => 'This field must be at least 3 characters.',
            'input_val.max' => 'This field may not be greater than 50 characters.'
        );
            
          $validator = Validator::make($request->all(), $rules, $messsages);
            if ($validator->fails()) {
            return Response::json(array(
                        'status' => false,
                        'errors' => $validator->getMessageBag()->toArray()
                            ), 200);
        } else {   
            $input_val=$request->input('input_val');
            //db insertion and other checking comes here
        ///check the db data and return result       
        return Response::json(array('status'=>true));
    }
    }
}
?>

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Http\Requests;

use Response;

use Validator;

class MypageController extends Controller

{

public function index()

{

return view('mylistpage');

}

public function checkAndSavedata(Request $request)

{

$rules = array('input_val' => 'Required|Min:3|Max:50');

$messsages = array('input_val.required' => 'This field is required.',

'input_val.min' => 'This field must be at least 3 characters.',

'input_val.max' => 'This field may not be greater than 50 characters.'

);

$validator = Validator::make($request->all(), $rules, $messsages);

if ($validator->fails()) {

return Response::json(array(

'status' => false,

'errors' => $validator->getMessageBag()->toArray()

), 200);

} else {

$input_val=$request->input('input_val');

//db insertion and other checking comes here

///check the db data and return result

return Response::json(array('status'=>true));

}

View page:mylistpage.blade.php

<!DOCTYPE html>
<html lang="en">
<head>
  <title>Bootstrap Example</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <meta name="csrf-token" content="{{ csrf_token() }}" />
  <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
  <script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
    <div class="row">
        <div class="col-md-10 col-md-offset-1">
            <div class="panel panel-default">
                <div class="panel-heading">Welcome</div>

                <div class="panel-body">
<input type="text" name="mydata" id="mydata">
        <button id="savbutton">Save Data</button>
        <span id="msg" style="color:red;"></span></div>
            </div>
        </div>
        
    </div>
</div>
</body>
</html>
<script>
    $(document).on('click','#savbutton',function(){
        
        var mydata_input=$.trim($('#mydata').val());

        if(mydata_input=="")
        {
            $('#msg').html('please enter the value');
            $('#mydata').focus();
            return false;
        }
        else
        { 
            var input_parameter='input_val='+mydata_input;
            $.ajax({
                url:'{{url("checkAndSavedata")}}',
                async:true,
                type:"POST",
                data:input_parameter,
                dataType:"JSON",
                success:function(data){
                   if(data.status==false)
                   {
                        var errorsHtml = '';
                    var errors = data.errors;
                    $.each(errors, function (key, value) {
                        errorsHtml += '<span>' + value[0] + '</span><br>';
                    });

                    
                    $("#msg").html(errorsHtml);
                    return false;
                   }
                   else  if(data.status==true)
                   {
                   $("#mydata").val('');
                   $("#mydata").focus();
                   var successMessge="<span>Data Entered Successfully</span>";
                   $("#msg").html(successMessge);
                }
                }        
            });
            
        }
    });
   

    $.ajaxSetup({
        headers: {
            'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
        }
    });
    </script>

<!DOCTYPE html>

<head>

<title>Bootstrap Example</title>

</head>

<body>

<div class="panel-heading">Welcome</div>

</div>

</body>

</html>

$(document).on('click','#savbutton',function(){

var mydata_input=$.trim($('#mydata').val());

if(mydata_input=="")

{

$('#msg').html('please enter the value');

$('#mydata').focus();

return false;

}

else

{

var input_parameter='input_val='+mydata_input;

$.ajax({

url:'{{url("checkAndSavedata")}}',

async:true,

type:"POST",

data:input_parameter,

dataType:"JSON",

success:function(data){

if(data.status==false)

{

var errorsHtml = '';

var errors = data.errors;

$.each(errors, function (key, value) {

errorsHtml += '<span>' + value[0] + '</span><br>';

});

$("#msg").html(errorsHtml);

return false;

}

else if(data.status==true)

{

$("#mydata").val('');

$("#mydata").focus();

var successMessge="<span>Data Entered Successfully</span>";

$("#msg").html(successMessge);

}

});

}

});

$.ajaxSetup({

headers: {

'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')

}

});

</script>

Appending javascript variable to php variable in laravel

For example adding a $employee_id (php variable) to a link with javascript variable

 var display_url='{{url("$employee_id/emplist/")}}';
 var next_department='Accounts';
 var final_display_url=display_url+'/'+next_department;

var display_url='{{url("$employee_id/emplist/")}}';

var next_department='Accounts';

var final_display_url=display_url+'/'+next_department;

Response::download() laravel not working-shows error-Unable to guess the mime type as no guessers are available (Did you enable the php_fileinfo extension?)

In the previous blog entry i explained force download in laravel http://mydoubts.in/blog/force-download-in-laravel-file-download-in-laravel/ if you are getting the below error Unable to guess the mime type as no guessers are available (Did you enable the php_fileinfo extension?) No need to change the php.ini settings -php_fileinfo extension below code will works using the header information

<?php
$path=public_path()."/upload_image/mypic.jpg";
$file_name = 'mypic.jpg';
$headers = array('Content-Type' => 'application/octet-stream');
return response()->download($path, $file_name, $headers);
?>

<?php

$path=public_path()."/upload_image/mypic.jpg";

$file_name = 'mypic.jpg';

$headers = array('Content-Type' => 'application/octet-stream');

return response()->download($path, $file_name, $headers);

Force Download in laravel-file download in laravel

In this Blog i m written the code for force download option in a webpage using laravel. Please check the routes.php,controller and view files In this example one image file is stored inside the folder-public/upload_image/mypic.jpg Routes.php

Route::get('filelist', 'fileListController@filelist');
Route::post('filedownload', 'fileListController@filedownload');

1 2	Route::get('filelist', 'fileListController@filelist'); Route::post('filedownload', 'fileListController@filedownload');

fileListController.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Http\Requests;
use Response;
class fileListController extends Controller
{
    public function filelist()
	{
		return view('filelist.filelist');
				
	}
	
	public function filedownload()
	{
		 $path=public_path()."/upload_image/mypic.jpg";
             return( Response::download( $path ) );
	
     
	}
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Http\Requests;

use Response;

class fileListController extends Controller

{

public function filelist()

{

return view('filelist.filelist');

}

public function filedownload()

{

$path=public_path()."/upload_image/mypic.jpg";

return( Response::download( $path ) );

}

filelist.blade.php

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
	

<div class="container">
    <div class="row">
        <div class="col-md-10 col-md-offset-1">
            <div class="panel panel-default">
                <div class="panel-heading">Welcome</div>
                <div class="panel-body">
				<form action="filedownload" method="post">
				 <input type="hidden" name="_token" value="<?php echo csrf_token(); ?>">
                   <button>Download file</button>
				   </form>
                </div>
            </div>
        </div>
    </div>
</div>

</head>
</html>

<!DOCTYPE html>

<head>

<div class="panel-heading">Welcome</div>

<button>Download file</button>

</form>

</div>

</head>

</html>

undefined variable error in laravel

In the Foolowing scenario you will get the undefined variable error.

create a blade called sub.balde.php. create variable called $test

sub.blade.php

<?php
$test='welcome to laravel training';
?>

create one more balde called main.php

main.blade.php
@include('sub')
<?php
echo $test;
?>

create a blade called sub.balde.php. create variable called $test

sub.blade.php

<?php

$test='welcome to laravel training';

create one more balde called main.php

main.blade.php

@include('sub')

<?php

echo $test;

in this case we will get the error as ErrorException in c8b54f60da9fa9e08371cc15bab47dba58b6f7b3.php line 3: Undefined variable: test Ans:solution for this error is as below please assing the test varable as $this->test=’some text’;

getClientOrginalName() in Laravel file upload not working

getClientBadMethodCallException in Macroable.php line 81: Method getClientOrginalName does not exist. If you are getting the Above error in laravel while doing file upload. Usualy this error will come because of some fields missing in the form So please add files=true in the form field

Ans:<form id="send_my_data" name="send_my_data" method="post"  enctype="multipart/form-data" files="true">

1	Ans:<form id="send_my_data" name="send_my_data" method="post" enctype="multipart/form-data" files="true">

Public static usage in Laravel

If we are not using the public static keyword in the model.below error.

For example you will get if you trying to access getempEmail() model function from the Myinputcontroller.

ErrorException in Myinputcontroller.php line 34: Non-static method App\Models\emprManagement::getempEmail() should not be called statically, assuming $this from incompatible context

inorder to avoid this error please use the function in model as like below

public static  function getempEmail($user_id)
{

}

If we are not using the public static keyword in the model.below error.

For example you will get if you trying to access getempEmail() model function from the Myinputcontroller.

ErrorException in Myinputcontroller.php line 34: Non-static method App\Models\emprManagement::getempEmail() should not be called statically, assuming $this from incompatible context

inorder to avoid this error please use the function in model as like below

public static function getempEmail($user_id)

{

}

Insert into a table using laravel/get the last inserted value.

see the below statement for inserting records and to find out last inserted id of the record

$mydataInsert = emp::create(['my_fav_id' => $my_fav_id,

'age'=>$age]);


To get the last insert id, suppose Id is the primary key. then we can use the below code to get last inserted auto id

last inserted id= $mydataInsert >Id;

$mydataInsert = emp::create(['my_fav_id' => $my_fav_id,

'age'=>$age]);

To get the last insert id, suppose Id is the primary key. then we can use the below code to get last inserted auto id

last inserted id= $mydataInsert >Id;

Different type of Query usage in laravel

Below are the two methods to fetch the result from laravel controller from the table called “emp”

$myrecords = DB::table('emp')->where('emp.email',$emp_email)
           
$myrecords = emp::where('emp.email',$emp_email)

$myrecords = DB::table('emp')->where('emp.email',$emp_email)

$myrecords = emp::where('emp.email',$emp_email)

Laravel Pagination using Ajax call/Onclick not working in laravel pagination using ajax

Issue:onclick not working in laravel5 if we use external js

Solution:$('.pagination a').on('click', function (event) { --- change this to as like below

$(document).on('click', '.pagination a', function() {

Solution:$('.pagination a').on('click', function (event) { --- change this to as like below

$(document).on('click', '.pagination a', function() {