@tykus it doesn't display any errors

@Mim check the Network tab in the browser’s devtools; is there a Request being made?

@tykus The error says , Failed to load response data: No content available because this request was redirected.

@peterl38 it's not an asynchronous request; the code simply submits the form although it is not clear why this particular jQuery is necessary:

$('#sub-assign-btn').click(function(){
    $('#assign-form').submit();
});

@peterl38 +request: Symfony\Component\HttpFoundation\InputBag {#44 ▼ #parameters: array:5 [▼ "_token" => "nZLj6dVgNbad4Qhfeuupww2ZqXB006Wx0zyzxMJ3" "patient_id" => "8" "bed_id" => "1" "assign_date" => "2022-08-29" "discharge_date" => "2022-08-31" ]

i get it in the request

@Mim your validation rule expects assigned_date and discharged_date, but the request gives assign_date and discharge_date. So, as mentioned at the top... validation failure. Although this is not consistent with the mark-up you posted earlier 🤷‍♂️

@tykus yes i realized and changed all

  $request->validate([
        'assign_date'=> 'required|date',
        'discharge_date'=> 'date',
        'patient_id' => 'required|exists:patients,id',
        'bed_id' => 'sometimes|exists:beds,id',             
       ]);

    $bed_assigns = new BedAssign;

    $bed_assigns->assign_date = $request->input('assign_date');
    $bed_assigns->discharge_date = $request->input('discharge_date');
    $bed_assigns->status =  'Available';
    $bed_assigns->patient_id =$request->input('patient_id');
    $bed_assigns->bed_id = $request->input('bed_id');

but is the same issue

@Mim so, now we have the correct validation rules, but still you are redirected back without validation errors? Where did you place <pre>@json($errors->all())</pre> in the page?

@tykus In my form

@Mim but that form is in the Modal, which doesn't display after you're redirected back, right? I meant for you to add that into the showBedAssig view template so you can see any validation errors after submitting the form

@tykus it says ["The selected patient id is invalid."]

@Mim FFS... typed a reply to your earlier it's just printing an empty array response.

So The selected patient id is invalid. tells you the problem, right? This is the validation error mentioned at the outset of this thread. What value does it have, and why is it not existing on the patients table?

@tykus the patients table is a foreign key connected to users with usertype 0 .

@Mim not exactly the question I asked... You have a collection/array of Patients which is used to populate the patient_id select input:

<select class="form-select form-select-sm" id="patient_id" name="patient_id">
    <option>--Select Patient--</option>
    @foreach($patients as $patient)
        <option value="{{$patient->id}}" class="form-control">{{$patient->name}}</option>
    @endforeach
</select>

So what is $patient->id representing exactly, is this an ID on the patients table, or an ID on the users table? Your exists validation rule is checking the patients table

@tykus is an id on the patients table

@Mim I don't understand your database schema.

the patients table is a foreign key connected to users with usertype 0

What does this mean? Can you share the table schema for users and patients please?

@tykus

  public function up()
  {
    Schema::create('patients', function (Blueprint $table) {
        $table->unsignedBigInteger('user_id');
        $table->id();
        $table->foreign('user_id')->references('id')->on('users');
        $table->string('date')->nullable();
        $table->string('payment_method')->default(1)->comment('1 = Cash');
        $table->timestamps();
    });
}

and users

public function up()
{
    Schema::create('users', function (Blueprint $table) {
        $table->id();
        $table->string('name');
        $table->string('email')->unique();
        $table->string('phone')->nullable();
        $table->string('address')->nullable();
        $table->string('usertype')->default(0);
        $table->timestamp('email_verified_at')->nullable();
        $table->string('password');
        $table->rememberToken();
        $table->foreignId('current_team_id')->nullable();
        $table->string('profile_photo_path', 2048)->nullable();
        $table->timestamps();
    });
}

and this is my patient model

  class Patient extends Model

{ protected $fillable = [ 'user_id','payment_method' ];

public function doctor()   {
    return  $this->belongsTo(Doctor::class);
 }

 public function user() {
     return $this->belongsTo(User::class);
 }


 
use HasFactory;

}

@Mim okay, I don't know why this needed a separate table - it adds no value that I can see???

Anyway, you have a Collection of patients (for the select options); it has a name property which I suppose comes from the users table. It also has an id property which comes from where exactly - i.e. is it the id from the users table or from the patients table? How do you assign to the $patients property?

@tykus okay so im building an online hospital management system that's why the users and patients have different tables . I don't really get the question about how I assign the $patients property , sorry. But if I do dd($request); the patient_id comes from the users table .

@Mim well that is why your validation rule is failing - make sure it is checking the correct table/column, for example, checking the user_id on the patients table

'patient_id' => 'required|exists:patients,user_id',

or, the id on the users table with the additional constraint on usertype column:

'patient_id' => ['required', Rule::exists('users', 'id')->where('usertype', 0)]

@tykus yes i tried all that before and now but I got an SQLSTATE[23000]: Integrity constraint violation:

@Mim what does the reset of the error message say?

I assume the problem is a foreign key constraint that requires you to use a valid patients.id and not a users.id? Which goes back to (i) the unnecessary decision to separate the users and patients table and (ii) using the wrong data to populate the select input in the form.

// controller action that returns the view with the form 
$patients = Patient::query()
    ->join('users', 'users.id', 'patients.user_id') // join to get `name` from users table
    ->pluck('users.name', 'patients.id');

// the view with the form
<select class="form-select form-select-sm" id="patient_id" name="patient_id">
    <option>--Select Patient--</option>
    @foreach($patients as $id => $name)
        <option value="{{$id}}" class="form-control">{{$name}}</option>
    @endforeach
</select>

// `upload` Controller action
'patient_id' => ['required', Rule::exists('patients', 'id')]

@tykus SQLSTATE[42S22]: Column not found: 1054 Unknown column 'patient_id' in 'where clause' (SQL: select count(*) as aggregate from patients where patient_id = 1)

thats the error i got after using that

@Mim typo:

'patient_id' => ['required', Rule::exists('patients', 'id')]

@tykus Thank you so much , it finally worked

@Mim do you understand the changes that were made here?

@Mim The patient table should not contain a patient_id, it should contain an id and a user_id since you decided to store the same information in two places.

@Tray2 it doesn't the query was incorrect because of the exists Rule being written incorrectly.

@tykus yes please

@Tray2 the patients table doesn't have a patient_id , the bed_assigns table rather have a patient_id because patient is a foreign key there

@tykus Saw that when I had submitted my reply :)

@tykus but the problem is now the patient name doesn't display, although the other entity shows

@Mim yes, see my reply to Tykus

@Mim the patient name doesn't display where?

@tykus in my table

@Mim what does the patient relationship look like on the BedAssign model?

@tykus

   public function patient() {
      return $this->belongsTo(Patient::class);
  }