Database query relationships
Query a product
>>> $p=\App\Product::find(1)
=> App\Product {
id: "1",
ean_code: "0693804125002",
name: "Cloud Star Buddy Biscuits Dog Treats, Peanut Butter Madness, 16-Ounce Boxes (Pack of 6)",
brand: "Cloud Star",
description: "Cloud Star (R) Original Buddy Biscuits Cloud Star (R) Original Buddy Biscuits are as wholesome as
they are delicious and are guaranteed to have your best friend begging for more. Made with all natural ingredients, t
hese delectable crunchy dog biscuits are perfect for dogs with food allergies and sensitivities. Original Buddy Biscu
its contain no artificial colors, flavors, or preservatives and are free of corn, yeast sugar, salt, and soy. Packed
with pure simple wholesome ingredients, Original Buddy Biscuit...",
image_url: "http://pics2.ds-static.com/prodimg/73062/300.JPG",
views: "0",
lowest_recorded_price: "2.25",
category_id: "9",
created_at: "2017-06-03 14:55:39",
updated_at: "2017-06-03 14:55:39",
}
Query product characteristics
>>> $p->characteristics
=> Illuminate\Database\Eloquent\Collection {
all: [
App\Characteristic {
id: "1",
name: "color",
created_at: "2017-06-03 14:55:39",
updated_at: "2017-06-03 14:55:39",
pivot: Illuminate\Database\Eloquent\Relations\MorphPivot {
characterizable_id: "1",
characteristic_id: "1",
cvalue: "Peanut Butter",
cvotes: "3",
},
},
App\Characteristic {
id: "2",
name: "size",
created_at: "2017-06-03 14:55:39",
updated_at: "2017-06-03 14:55:39",
pivot: Illuminate\Database\Eloquent\Relations\MorphPivot {
characterizable_id: "1",
characteristic_id: "2",
cvalue: "16-oz box",
cvotes: "7",
},
},
App\Characteristic {
id: "3",
name: "dimension",
created_at: "2017-06-03 14:55:39",
updated_at: "2017-06-03 14:55:39",
pivot: Illuminate\Database\Eloquent\Relations\MorphPivot {
characterizable_id: "1",
characteristic_id: "3",
cvalue: "2 X 6.5 X 9 inches",
cvotes: "0",
},
},
App\Characteristic {
id: "4",
name: "weight",
created_at: "2017-06-03 14:55:39",
updated_at: "2017-06-03 14:55:39",
pivot: Illuminate\Database\Eloquent\Relations\MorphPivot {
characterizable_id: "1",
characteristic_id: "4",
cvalue: "1 Pounds",
cvotes: "4",
},
},
],
}
Query saved for later products
>>> $u = \App\User::find(1)
=> App\User {
id: "1",
name: "Adrian Harabulă",
email: "[email protected]",
created_at: null,
updated_at: null,
}
>>> $u->products
=> Illuminate\Database\Eloquent\Collection {
all: [
App\Product {
id: "1",
ean_code: "0693804125002",
name: "Cloud Star Buddy Biscuits Dog Treats, Peanut Butter Madness, 16-Ounce Boxes (Pack of 6)",
brand: "Cloud Star",
description: "Cloud Star (R) Original Buddy Biscuits Cloud Star (R) Original Buddy Biscuits are as wholesome as they are delicious and are guaranteed to have your best friend begging for more. Made with all natural ingredients, these delectable crunchy dog biscuits are perfect for dogs with food allergies and sensitivities. Original Buddy Biscuits contain no artificial colors, flavors, or preservatives and are free of corn, yeast sugar, salt, and soy. Packed with pure simple wholesome ingredients, Original Buddy Biscuit...",
image_url: "http://pics2.ds-static.com/prodimg/73062/300.JPG",
views: "0",
lowest_recorded_price: "2.25",
category_id: "9",
created_at: "2017-06-03 14:55:39",
updated_at: "2017-06-03 14:55:39",
pivot: Illuminate\Database\Eloquent\Relations\Pivot {
user_id: "1",
product_id: "1",
},
},
],
}