vendredi 10 avril 2020

Retrieve array object in a table from another table data id using a where clue in laravel

Question: I have two tables how to fetch a customer's data using order's table user_id

  "order": [
    {
        "id": 1,
        "user_id": 4
    },
    {
        "id": 2,
        "user_id": 5
    }
  ],


  "customers": [
        {
            "id": 5,
            "name": "Mohamed Raazi",
            "phone": "777",
        }
    ],

Following code will return only the last object of an array, i need to display all the objects from user table using a where condition in customers table

        for ($x=0; $x<count($orders); $x++){
            $customer = User::where('id',$orders[$x]->user_id)->get(); 
        }


via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire