I have this $order array and want to store the data in a mysql database.
I need to sort out the products ([type] => physical) and put the key values in one mysql table, and put the other types ([type] => discount and [type] => shipping_fee) in two other tables.
[cart] => Array
(
[items] => Array
(
[0] => Array
(
[type] => physical
[name] => Apple iPhone
[quantity] => 2
[reference] => ABC61
[tax_amount] => 329
[unit_price] => 5490
)
[1] => Array
(
[type] => shipping_fee
[name] => FedEx Express
[quantity] => 1
[reference] => SHIPPING
[tax_amount] => 58
[unit_price] => 290
)
[2] => Array
(
[type] => physical
[name] => IBM Laptop
[quantity] => 1
[reference] => XYZ10
[tax_amount] => 700
[unit_price] => 8000
)
[3] => Array
(
[type] => discount
[name] => Discount Coupon
[quantity] => 1
[reference] => DISCOUNT
[tax_amount] => 0
[unit_price] => -650
)
)
)
Something like this, but I don't know how to properly search the array and retrive the sibling key values:
if ([type] == 'physical') {
get key values for [name] and [quantity] .. insert them into table products
} elseif ([type] == 'shipping_fee') {
get key values for [name] and [quantity] .. insert them into table shipping
} elseif ([type] == 'discount') {
get key values for [name] and [quantity] .. insert them into table discounts
}