I belong to the reader gang and this happens to be my first question on SO. Pls, pardon me for mistake
I was trying to validate request in register function. Here is the code.
JavaScript
x
public function register(Request $request)
{
$validator = Validator::make($request->all(), [
'name' => 'required',
'email' => 'required|email|unique:user',
'password' => 'required',
'c_password' => 'required|same:password',
]);
if($validator->fails()) {
return $this->sendError('Validation Error.', $validator->errors());
}
$input = $request->all();
$input['password'] = bcrypt($input['password']);
$user = User::create($input);
$success['token'] = $user->createToken('MyApp')->accessToken;
$success['name'] = $user->name;
return $this->sendResponse($success, 'User registered successfully.');
}
This is sendResponse method
JavaScript
public function sendResponse($result, $message)
{
$response = [
'success' => true,
'data' => $result,
'message' => $message,
];
return response()->json($response, 200);
}
This is sendError method
JavaScript
public function sendError($error, $errorMessages = [], $code = 404)
{
$response = [
'success' => false,
'message' => $error,
];
if(!empty($errorMessages)) {
$response['data'] = $errorMessages;
}
return response()->json($response, $code);
}
Response I am getting
JavaScript
IlluminateDatabaseQueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nvrd_test.user' doesn't exist (SQL: select count(*) as aggregate from `user` where `email` = email@yahoo.com) in file /home/vagrant/code/nvrd/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 669*
Note: I have also tried to use public $table='users'
to no avail.
I hope someone will come to rescue.
Also if i remove
JavaScript
if($validator->fails()) {
return $this->sendError('Validation Error.', $validator->errors());
}
it works good but not validation message is being returned
Advertisement
Answer
Tables are plural in Laravel
by design. The unique rule is not based on a model, but the parameter you pass to it is the table name. So that parameter should be plural and therefor the validation should look like this.
JavaScript
'required|email|unique:users'