Level 1
anyone can help me?
Oct 25, 2022
21
Level 1
How to use Relationship.
So i have 2 tables with items.
In first table have items that i own.
public function up()
{
Schema::create('items', function (Blueprint $table) {
$table->id();
$table->string('name');
$table->string('icon_url');
$table->string('tradable');
$table->timestamps();
});
}
In second have items that got from an api.
public function up()
{
Schema::create('bp_items', function (Blueprint $table) {
$table->id();
$table->string('name');
$table->string('classid');
$table->decimal('price', 9, 3);
$table->string('color');
$table->timestamps();
});
}
What i want is to get is compare ex MYITEM from first table an search for that item in second table by MYITEM (name ) and i want to get the item ->price from that table.
Level 27
Your question is titled “How to use relationship[s]”, but you have no relationship at all between these two tables.
The only thing your tables have in common is that they both have a name column, and that’s not a relationship – half your tables probably have a name column without having anything to do with each other. So basically, they’re completely unrelated tables.
So what you really want is just to retrieve records from the second table based on the name column. That’s a simple Eloquent query:
$item = Item::find(1234);
$bp_items = BpItem::where('name', $item->name)->get();
Level 1
@kokoshneta what i want to find ex Product 1 in second table by (name ) and get the price of item.
Level 27
@emilpapelas4@gmail.com So do that, then. I don’t understand what’s not clear.
Have you learned the basics of Laravel? Do you know how Eloquent works?
In the code I gave you above, let’s say row in the items table with ID 1234 has the name MyItem1234. In that case, $bp_items will be a collection of all bp_items whose name is MyItem1234. For each of those, you can simply add ->price to get the price.
If this is not clear to you, you need to learn how the basics of Laravel work before you start coding larger projects.
Level 1
@kokoshneta Ya know laravel
have done this
$skins=Items::where('tradable',1)->get();
$pbi=BpItems::where('name',$skins->name)->get();
dd($skins);
return view('user.skins' , compact('skins'));
but error Property [name] does not exist on this collection instance.
Level 75
@emilpapelas4@gmail.com You lied in the first line.
You don't know how Laravel works...
Level 1
@MichalOravec what i want is still not work with @kokoshneta example becuse i want to show Only the items from table 1 , table 2 is to get the price of the items only.
Level 75
@emilpapelas4@gmail.com Then join tables by name and select what you need.
Level 1
Let me show my db
On items table have an item ,also same item on bp_items table difference is that item contain the price ,color etc. Only want to use the items table to get the item because this is the item that i own , but alos i need the price and i need to get them from pb_items table .
I hope are u understand what i want to get.
Level 27
@emilpapelas4@gmail.com As I said, you need to get more acquainted with how Laravel, or at least Eloquent, works. Using get() will return a collection of items, since there may be more than one. Unless you only have one item which is tradable, there will in fact definitely be more than one.
Obviously, there is no name property on a collection. That property belongs to the item, not to the collection.
Level 75
@emilpapelas4@gmail.com Again:
Join tables by name and select what you need.
1 like
Level 1
@kokoshneta ya but as u send me the example above i can't use
$item = Item::find(1234);
because this will return me only the specific item. But i want all the item to be shown from that Item List
Level 1
$it=DB::table('Items')->select('name')->join('items','name')->join('bpitems','name');
I do this , i know is not correct , but i dont use DB and join until now. maybe please correct my code
Level 75
@emilpapelas4@gmail.com Sorry, I will not.
Here is the documentation.
Level 27
@emilpapelas4@gmail.com Well, that is definitely not correct, for several reasons:
- There is no
Itemstable; the table is calleditems - You’re joining the
itemstable to itself (DB::table('items')->join('items')) - You’re only selecting the name, nothing else
- You’re not specifying how to join the tables – you need a condition
This is all explained very clearly in the documentation.
Level 27
If you always want to get most info from items + price from bp_items and you KNOW that the name column is always unique in both tables, then, as @michaloravec says, use a join clause to get the price column from the BP table.
Item model
use Illuminate\Database\Eloquent\Builder;
class Item extends Model {
public function scopeWithPrice(Builder $builder) {
$builder->join('bp_items', 'items.name', '=', 'bp_items.name')
->select('items.*', 'bp_items.price')
;
}
}
Controller
$skins = Items::where('tradable', 1)->withPrice()->get();
return view('user.skins', compact('skins');
1 like
Level 1
@kokoshneta Thank you Works :)
Level 75
@emilpapelas4@gmail.com I hope that this is the last time when somebody helped you on Laracasts...
Level 1
@MichalOravec May I know why?
Level 75
@emilpapelas4@gmail.com You didn't stop asking for the code until you got the whole solution without any effort.
Level 5
@emilpapelas4@gmail.com we guiding you, not working for you, so we provide a path, a hint, a document link, you have to read it, understand it and work with it
You clearly have no idea how database work AND how ORM work, without that knowledge, you will get nowhere, the only thing you could do is ask a question and wait for someone to return the whole solution
1 like
Please or to participate in this conversation.