Unique Validation on update in laravel
Create below rule to check the unique on update in laravel
$rules = array('email' => 'required|unique:users,email,[Enter Id here]');
$validator = Validator::make(Input::all(), $rules);
$rules = array('email' => 'required|unique:users,email,[Enter Id here]');
$validator = Validator::make(Input::all(), $rules);
Get column name and its information from table in mysql
Please write below query:
select COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH,
NUMERIC_PRECISION, DATETIME_PRECISION,
IS_NULLABLE
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='tablename'
select COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH,
NUMERIC_PRECISION, DATETIME_PRECISION,
IS_NULLABLE
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='tablename'
Subscribe to:
Posts (Atom)