All Food in DB

Result: SQL executed.

SELECT * FROM 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] => 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
                )

        )

    [3] => 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
                )

        )

    [4] => 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
                )

        )

    [5] => 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
                )

        )

    [6] => 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
                )

        )

    [7] => 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
                )

        )

    [8] => 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
                )

        )

    [9] => 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
                )

        )

    [10] => 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
                )

        )

    [11] => 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
                )

        )

    [12] => 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
                )

        )

    [13] => 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
                )

        )

    [14] => 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
                )

        )

    [15] => 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
                )

        )

    [16] => 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
                )

        )

    [17] => 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
                )

        )

    [18] => 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
                )

        )

    [19] => 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
                )

        )

    [20] => 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
                )

        )

    [21] => 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
                )

        )

    [22] => 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
                )

        )

    [23] => 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
                )

        )

    [24] => 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
                )

        )

)