如何在数据库中存储员工体验数据

Question

I want to store employee experience data in database ,employee can i add multiple experience at a time .

Array :

Array
(
    [start_date] => Array
        (
            [0] => 2016-07-12
            [1] => 2016-09-16
        )

    [end_date] => Array
        (
            [0] => 2016-09-09
            [1] => 2017-01-20
        )

    [total_month] => Array
        (
            [0] => 2
            [1] => 4
        )

    [firm_name] => Array
        (
            [0] => sadsadasd
            [1] => 34343
        )

    [turnover] => Array
        (
            [0] => 343443434
            [1] => 443434
        )

    [student_experiece] => Array
        (
            [0] => 343434
            [1] => 343434
        )

    [orderof_supply_food] => Array
        (
            [0] => 343443
            [1] => 434343434
            [2] => 34334
            [3] => 34343
        )

    [payment_against_bill] => Array
        (
            [0] => 3434343
            [1] => 434343
        )

    [vat] => Array
        (
            [0] => 3434343
            [1] => 3434343434
        )

)

What i do is convert array in to string and than store in database like this:

[start_date] = 2016-07-12,2016-09-16,
[end_date] =2016-09-09,2016-01-20

Database Structure :

i thing this not a right way .Please any suggestion?

Answer 1

You can use json_encode() to encode your PHP-Array to a JSON-String. When you get the JSON-String back from Database, you can decode it with json_decode() into an PHP-Array. Then you can modify it and store it back to database.