I'm learning Laravel and have a few questions
I am looking to build a relationship between 2 databases Is there any good tutorials for this? In the documentation it says this is not the best idea?
What is the difference between the Relationship and the Join? Do you need to make the relationship in order to do the join or are these 2 different methods? Can I build the relationship in PhpMyAdmin and then do the Join?
Thanks
Please see http://www.w3schools.com/sql/sql_join.asp for information on what a join is.
The join combines two tables to return a common results set based a column that exists in both tables - ie, the tables have a relationship.
Why do you want to build a relationship between two databases instead of two tables?
You should take advantage of migrations when making changes to your database. See the docs for more - http://laravel.com/docs/4.2/migrations
Hi Thanks for your reply.
I am working with an Expedia database, which will fetch updated data frequently. It recommends not adding to its structure but I would like to build my own content onto various locations so its a bit of a mashup.
I think I just need joins as I don't need to integrate data. I just want to get a region or city Id and cross reference my data with it to show further information when the region or city ID is queried from the expedia database
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community