Validation of a field that can be either a string or an integer?

Question

Laravel

if (!is_numeric($request->get('search_text'))) {
            $this->validate($request, [
                'search_text' => 'required|filled|string|min:1|max:55|',
            ]);
        } else {
            $this->validate($request, [
                'search_text' => 'required|filled|integer|min:1|max:55|',
            ]);
        }

You cannot add string|integer . And if you send in the query where id == '9' PostgreSQL gives an error. There is no such thing in Mysql, it itself leads to the desired type there, and yet. The query can be where title == 9 , must be converted to (string).
So what's the best way to validate a field that can be either int or str?

Answer 1

$this->validate($request, [
                'type' => 'required|filled|string|min:2|max:15|',
                'order' => 'required|filled|string|min:3|max:4|',
                'search_text' => 'required|filled|string|min:1|max:55|',
            ]);

Post::whereRaw("CAST(id AS TEXT) ILIKE '%$search_text%'")->get()

Answer 2

Validate always as a string, and pass the value cast to the required type into the query.

$this->validate($request, [
    'search_text' => 'required|filled|string|max:55',
]);

if (preg_match('/^\d+$/', $search)) {
    // find_by_id ((int)$search)
} else {
   // find_by_name ($search)
}

Well, the min rule is redundant here, because there are required and filled rules.

Answer 3

It is necessary not to edit the validation, but to bring the line to the integer before using it.
The validation rule 'integer'will pass and 42and '42', and the rule string|min:1|max:55is a string from 1 to 55 characters long.