Insert Array values, multiple rows

Question

I'm trying to record some information on a database. My post looks like this:

  Array
(
[Action] => 1000

[Date_Stat] => 07/02/2013
[Date_Final] => 07/02/2013
[Product_Id] => Array
    (
        [0] => 2
        [1] => 6
        [2] => 1
    )

[Conversion] => Array
    (
        [0] => 1,20
        [1] => 1,00
        [2] => 2,03
    )

[ValueMin] => Array
    (
        [0] => 2,00
        [1] => 1,58
        [2] => 2,70
    )

[ValueMax] => Array
    (
        [0] => 2,50
        [1] => 1,98
        [2] => 2,90
    )

[ValueMedio] => Array
    (
        [0] => 2,20
        [1] => 1,68
        [2] => 2,80
    )

  )

HOW can I insert all this on database the right way?

I'm not sure about the best way to design the tables and store the information. I'm using this to make a PRICE TABLE with starting date, final date and list all products with prices.

Also I'm thinking what is the best method. There are 2 possibilities I think about

Date_Start | Date_End   |Product_Id | ValueMin | ValueMax | ValueMedio | Conversion
02-02-2013   02-03-2013  1            1.00       2.00       3.00         4.00
02-02-2013   02-03-2013  2            1.00       2.00       3.00         4.20
02-02-2013   02-03-2013  3            1.00       2.00       2.00         4.40

OR (using implode and putting all values on the same row)

Date_Start  | Date_End   |Product_Id | ValueMin | ValueMax | ValueMedio | Conversion
02-02-2013    02-03-2013  1,2,3        1,1,1      2, 2,2     3,3,2        4, 4.3, 4.4

Thanks a lot!

DYN · Accepted Answer · 2013-02-07 22:23:45Z

1

Choose the option mentioned first. Selecting Rows will become much easier if you do it that way.

To insert the records, use a simple prepared Statement (PHP Manual) and use a for-Loop.

answered Feb 7, 2013 at 22:23

DYN

363 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Muc · Accepted Answer · 2013-02-07 22:28:51Z

0

I'd suggest a little tweak over the first option. If you create a separate table (Something along the lines of "Prices") like this:

id|DateStart|DateEnd|
1|02-02-2013|02-02-2013|

And then, in the table you suggested, you'd replace the date range for the PriceId (Foreign Key to this table). That way it'll be easier for you to maintain the consistency over changes on date ranges.

answered Feb 7, 2013 at 22:28

Muc

1,5262 gold badges13 silver badges32 bronze badges

Collectives™ on Stack Overflow

Insert Array values, multiple rows

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related