我正在使用 Laravel 8 和 Vue 3 撰寫注冊表。后端是一個 API。
在users表遷移檔案中，我有：
class CreateUsersTable extends Migration {
public function up()
{
Schema::create('users', function (Blueprint $table) {
$table->id();
$table->string('first_name');
$table->string('last_name');
$table->string('email')->unique();
$table->timestamp('email_verified_at')->nullable();
$table->string('password');
$table->unsignedInteger('country_id')->nullable();
$table->foreign('country_id')->references('id')->on('countries');
$table->rememberToken();
$table->timestamps();
});
}
// More code here
}
如上可見，表中的id是countries表中的外鍵users。
我在AuthController中有這段代碼來注冊一個新用戶：
class AuthController extends Controller {
public function countries()
{
return country::all('id', 'name', 'code');
}
public function register(Request $request) {
$rules = [
'first_name' => 'required|string,',
'last_name' => 'required|string',
'email' => 'required|email|unique:users,email',
'password' => 'required|string|confirmed',
'country_id' => 'required|exists:countries',
'accept' => 'accepted',
];
$customMessages = [
'first_name.required' => 'First name is required.',
'last_name.required' => 'Last name is required.',
'email.required' => 'A valid email is required.',
'email.email' => 'The email address you provided is not valid.',
'password.required' => 'A password is required.',
'password.confirmed' => 'The passwords do NOT match.',
'country_id.required' => 'Please choose a country.',
'accept.accepted' => 'You must accept the terms and conditions.'
];
$fields = $request->validate($rules, $customMessages);
$user = User::create([
'first_name' => $fields['first_name'],
'last_name' => $fields['last_name'],
'email' => $fields['email'],
'password' => bcrypt($fields['password']),
'country_id' => $fields['country_id']
]);
$token = $user->createToken('secret-token')->plainTextToken;
$response = [
'countries' => $this->countries(),
'user' => $user,
'token' => $token
];
return response($response, 201);
}
}
在前端，我有：
const registrationForm = {
data() {
return {
apiUrl: 'http://myapp.test/api',
formSubmitted: false,
countries: [],
fields: {
first_name: '',
last_name: '',
email: '',
password: '',
country_id: null,
},
errors: {},
};
},
methods: {
// get Countries
async getCountries(){
try {
const response = await axios
.get(`${this.apiUrl}/register`)
.catch((error) => {
console.log(error.response.data);
});
// Populate countries array
this.countries = response.data.countries;
} catch (error) {
console.log(error);
}
},
registerUser(){
// Do Registrarion
axios.post(`${this.apiUrl}/register`, this.fields).then(() =>{
// Show success message
this.formSubmitted = true;
// Clear the fields
this.fields = {}
}).catch((error) =>{
if (error.response.status == 422) {
this.errors = error.response.data.errors;
}
});
}
},
async created() {
await this.getCountries();
}
};
Vue.createApp(registrationForm).mount("#myForm");
在 Vue 模板中：
<form id="myForm">
<div v-if="formSubmitted" class="alert alert-success alert-dismissible">
<button type="button" class="close" data-dismiss="alert">×</button>
Your account was created :)
</div>
<div class="form-group" :class="{ 'has-error': errors.first_name }">
<input type="text" hljs-string">" placeholder="First name" v-model="fields.first_name">
<span v-if="errors.first_name" hljs-built_in">error-message">{{ errors.first_name[0] }}</span>
</div>
<div hljs-string">" :hljs-string">'has-error': errors.last_name }">
<input type="text" hljs-string">" placeholder="Last name" v-model="fields.last_name">
<span v-if="errors.last_name" hljs-built_in">error-message">{{ errors.last_name[0] }}</span>
</div>
<div hljs-string">" :hljs-string">'has-error': errors.email }">
<input type="email" hljs-string">" placeholder="Enter email" v-model="fields.email">
<span v-if="errors.email" hljs-built_in">error-message">{{ errors.email[0] }}</span>
</div>
<div hljs-string">" :hljs-string">'has-error': errors.password }">
<input type="password" hljs-string">" placeholder="Enter password" v-model="fields.password">
<span v-if="errors.password" hljs-built_in">error-message">{{ errors.password[0] }}</span>
</div>
<div hljs-string">" :hljs-string">'has-error': errors.password_confirmation }">
<input type="password" hljs-string">" placeholder="Confirm password" v-model="fields.password_confirmation">
<span v-if="errors.password_confirmation" hljs-built_in">error-message">{{ errors.password_confirmation[0] }}</span>
</div>
<div hljs-string">">
<select hljs-string">" v-model="fields.country_id">
<option value="0">Select your country</option>
<option v-for="country in countries" :value="country.id">{{ country.name }}</option>
</select>
</div>
<div hljs-number">1" :hljs-string">'has-error': errors.accept }">
<input type="checkbox" name="accept" v-model="fields.accept">
<p>I accept <a href="#" >The Terms and Conditions</a></p>
<span v-if="errors && errors.accept" class="error-message">{{ errors.accept[0] }}</span>
</div>
<div class="form-group mb-0">
<button @click.prevent="registerUser" type="submit" class="btn btn-sm btn-success btn-block">Register</button>
</div>
</form>
問題
由于我無法弄清楚的原因，該應用程式在瀏覽器（網路選項卡）中拋出此錯誤，狀態代碼為422 Unprocessable Content：
給定的資料無效
問題
我究竟做錯了什么？
uj5u.com熱心網友回復：
該country_id欄位將不存在于countries表中。默認情況下，Laravel 將根據要驗證的欄位名稱在資料庫中查找列。所以你應該使用這個：
'country_id' => 'required|exists:countries,id'
https://laravel.com/docs/8.x/validation#specifying-a-custom-column-name
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/415977.html
標籤：