I have a form where user can add products with unique product name.I want to check live product name availability using ajax.Iam having problem
Route::group(['prefix'=>'admin','middleware'=>['auth','validIp']],function(){
Route::resource('product','Product\ProductController');
});
my from
{!! Form::text('name', null, ['class' => 'form-control','id'=>'name']) !!}
my controller http://localhost:8000/admin/product
public function store(Request $request)
{
$product= new Product;
$name = $request->get('name');
$product->name = $request->get('name');
$query = \DB::table('products')->select('name')
->where('name','!=',$name)
->get();
if($query)
{
return"Username not available!";
}
return "Username available!";
//......
$product->save();
js
<SCRIPT type="text/javascript">
$(document).ready(function(){
$("#name").change(function() {
var usrN = $("#name").val();
if(usrN.length >= 4)
{
$("#statuspass").html('<img src="images/loadingAnimation.gif"> Checking ...');
$.ajax({
type: "POST",
url : base_url+"/admin/product",
data: "name="+ usrN,
success: function(msg){
$("#statuspass").ajaxComplete(function(event, request, settings){
if(msg == 'OK')
{
$("#name").removeClass('object_error');
$("#name").addClass("object_ok");
$(this).html('<img src="images/success.png" align="absmiddle"> OK<');
}
else
{
$("#name").removeClass('object_ok');
$("#name").addClass("object_error");
$(this).html(msg);
}
});
}
});
}
else
{
$("#statuspass").html('<font color="red" style="margin-left:125px;">something went wrong <strong></strong> .</font>');
$("#name").removeClass('object_ok');
$("#name").addClass("object_error");
}
});
});
</SCRIPT>
In Plain PHP i used to do something like this
say checking.php
<?php
$conn = mysql_connect("localhost", "root", "");
mysql_select_db("videobox", $conn);
if(isSet($_POST['email']))
{
$email = $_POST['email'];
$sql_check = mysql_query("select id from users where email='".$email."'") or die(mysql_error());
if(mysql_num_rows($sql_check))
{
echo '<font color="red" style="margin-left:105px;"><STRONG>'.$email.'</STRONG> is not available.</font>';
}
else
{
echo 'OK';
}
}
?>
and in js i just used to do url: "checking.php",
How can i achieve this in laravel