更新用户详细信息jquery模式时检查唯一的用户名

Question

i'm using jQuery modal for user create and update for my laravel project. when creating new user im checking the username availaibilty. but that function doesnot support with update , when user save data without changing username it gives usernam availble error . please advice how to fix

my controller,

public function checkUsernameAvailability()
{
$user = DB::table('users')->where('username', Input::get('username'))->count();

if ($user > 0) {
    $isAvailable = FALSE;
} else {
    $isAvailable = TRUE;
}

echo json_encode(
    array(
        'valid' => $isAvailable
    ));

}


jQuery modal
                        username: {
                            validators: {
                                notEmpty: {
                                    message: 'The Username field is required'
                                },
                                rules : {
                                    username : { alphanumeric : true }
                                },
                                remote: {
                                    url: "{{ URL::to('/checkUsername') }}",
                                    data: function (validator) {
                                        return {
                                            username: validator.getFieldElements('username').val()
                                        }
                                    },
                                    message: 'The Username is not available'
                                },
                                stringLength: {

                                    max: 100,
                                    message: 'The Username must be  less than 100 characters long'
                                }
                            }
                        },

Answer 1

Try this code :

New Code To Be Added

$(document).ready(function(){
    $('#username').data('actval',$('#username').val());
});

Changes In Your Code Javascript

username: {
                        validators: {
                            notEmpty: {
                                message: 'The Username field is required'
                            },
                            rules : {
                                username : { alphanumeric : true }
                            },
                            remote: {
                                url: "{{ URL::to('/checkUsername') }}",
                                data: function (validator) {
                                    return {
                                        username: validator.getFieldElements('username').val(),
-----------------------                     actusername: $('#username').data('actval')
                                    }
                                },
                                message: 'The Username is not available'
                            },
                            stringLength: {

                                max: 100,
                                message: 'The Username must be  less than 100 characters long'
                            }
                        }
                    },

Changes in PHP code

public function checkUsernameAvailability()
{
    $user = 0;
    if(Input::get('username') != Input::get('actusername')){
       $user = DB::table('users')->where('username', Input::get('username'))->count();
   }


if ($user > 0) {
    $isAvailable = FALSE;
} else {
    $isAvailable = TRUE;
}

echo json_encode(
    array(
        'valid' => $isAvailable
    ));

}