All FoodType with its Food list in DB
Result: SQL executed.
SELECT *, food_type.id AS _food_type__id, food.id AS _food__id, food_type.name AS _food_type__name, food.name AS _food__name,
food_type.id AS _food_type__id,
food.food_type_id AS _food__food_type_id
FROM food_type
LEFT OUTER JOIN food
ON food_type.id = food.food_type_id
Array
(
[0] => FoodType Object
(
[id] => 1
[name] => Noodles
[_table] => food_type
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
)
[Food] => Array
(
[0] => Food Object
(
[id] => 6
[name] => Wan Tan Mee
[description] => Wonton noodle or wantan mee is a Cantonese noodle dish which is popular in Hong Kong, Malaysia, and Singapore.
[location] => Malaysia
[food_type_id] => 1
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
[1] => Food Object
(
[id] => 5
[name] => Asam Laksa
[description] => Sour & spicy noodles
[location] => Malaysia
[food_type_id] => 1
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
[2] => Food Object
(
[id] => 14
[name] => Ban Mian
[description] => A type of delicious noodles which is popular in KL
[location] => Malaysia
[food_type_id] => 1
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
[3] => Food Object
(
[id] => 15
[name] => apple
[description] => DESC
[location] => Home
[food_type_id] => 1
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
[4] => Food Object
(
[id] => 21
[name] => %D0%A5%D0%BB%D0%B5%D0%B1
[description] => 1
[location] => Asia
[food_type_id] => 1
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
[5] => Food Object
(
[id] => 25
[name] => MyName
[description] => MyDesc
[location] => Norway
[food_type_id] => 1
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
[6] => Food Object
(
[id] => 27
[name] => cake
[description] => awesome
[location] => spain
[food_type_id] => 1
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
)
)
[1] => FoodType Object
(
[id] => 2
[name] => Bread
[_table] => food_type
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
)
[Food] => Array
(
[0] => Food Object
(
[id] => 16
[name] => bigmac
[description] => this stuff will make you fat
[location] => macdonalds
[food_type_id] => 2
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
[1] => Food Object
(
[id] => 24
[name] => sourandcream
[description] => test
[location] => dontknow
[food_type_id] => 2
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
)
)
[2] => FoodType Object
(
[id] => 3
[name] => Meat
[_table] => food_type
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
)
[Food] => Array
(
[0] => Food Object
(
[id] => 7
[name] => Bak Kut Teh
[description] => A Chinese soup popularly served in Malaysia, Singapore originated in Klang valley. Usually served with pork but sometimes seafood & even vegetarian style
[location] => Malaysia
[food_type_id] => 3
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
[1] => Food Object
(
[id] => 22
[name] => Meat of Beast
[description] => meat
[location] => Russia
[food_type_id] => 3
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
[2] => Food Object
(
[id] => 26
[name] => test
[description] => delicious food
[location] => sweden
[food_type_id] => 3
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
[3] => Food Object
(
[id] => 31
[name] => :foodname
[description] => :desc
[location] => :location
[food_type_id] => 3
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
[4] => Food Object
(
[id] => 32
[name] => :foodname
[description] => :desc
[location] => :location
[food_type_id] => 3
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
[5] => Food Object
(
[id] => 33
[name] => :foodname
[description] => :desc
[location] => :location
[food_type_id] => 3
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
)
)
[3] => FoodType Object
(
[id] => 4
[name] => Rice
[_table] => food_type
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
)
[Food] => Array
(
[0] => Food Object
(
[id] => 4
[name] => Nasi Lemak
[description] => A kind of rice made with coconut milk
[location] => Malaysia
[food_type_id] => 4
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
[1] => Food Object
(
[id] => 17
[name] => :foodname
[description] => :desc
[location] => :location
[food_type_id] => 4
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
[2] => Food Object
(
[id] => 18
[name] => :foodname
[description] => :desc
[location] => :location
[food_type_id] => 4
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
[3] => Food Object
(
[id] => 19
[name] => Fried Rice
[description] => good food
[location] => Asia
[food_type_id] => 4
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
[4] => Food Object
(
[id] => 20
[name] => Fried Rice
[description] => good food
[location] => Asia
[food_type_id] => 4
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
[5] => Food Object
(
[id] => 23
[name] => banana
[description] => this is a nice piece of fruit
[location] => house
[food_type_id] => 4
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
[6] => Food Object
(
[id] => 28
[name] => juanc
[description] => probando_orm
[location] => caracas
[food_type_id] => 4
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
[7] => Food Object
(
[id] => 29
[name] => juanc
[description] => :desc
[location] => caracas
[food_type_id] => 4
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
[8] => Food Object
(
[id] => 30
[name] => juanc
[description] => :desc
[location] => caracas
[food_type_id] => 4
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
[9] => Food Object
(
[id] => 34
[name] => Nasi_Goreng_Kampung
[description] => Mamak
[location] => KL
[food_type_id] => 4
[_table] => food
[_primarykey] => id
[_fields] => Array
(
[0] => id
[1] => name
[2] => description
[3] => location
[4] => food_type_id
)
)
)
)
)
BACK TO LAST PAGE